We provide IT Staff Augmentation Services!

Senior Ms Sql Server Dba/architect Resume Profile

Des Moines, IA

SUMMARY:

  • Senior MS SQL Server DBA / Architect with Extensive knowledge in Managing SQL Server environment
  • Over 8 years of experience in Database Administration, System Analysis and Administration, Design, Development Support of MS SQL Server 2008 R2, 2008, 2005 and 2000 in Production, Development Test Environments
  • Extensive experience in installation, configuration, and maintenance of MS SQL Server 2008 R2/2008/2005, and 2000
  • Good experience in Upgrading and migrating from SQL server 2000/2005 to SQL server 2005/2008/2008 R2
  • Experienced in working with production 24/7 Environment
  • Expert working in Virtual Environment using VMWARE for SQL Server
  • Experienced in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
  • Extensive experience in Maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2008 R2/2005/2000 to provide robust database solutions.
  • Expert in Active/Passive and Active/Active Clustering
  • Expert in implementing log shipping.
  • Expert in implementing database mirroring.
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
  • Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
  • Experience in Managing Security of SQL Server 2000/05/08 by creating Database Users, Roles and assigning proper permissions according to business requirements
  • Experience in Extraction Transformations and Loading ETL tools like SQL Server Integration Services SSIS ,Data Transformation Services DTS , Bulk Insert, and Bulk Copy BCP
  • Experience with Reporting Services SSRS and Analysis Services SSAS .
  • Expert level skills in Clustering, Replication, Data Modeling Physical and Logical , Server Mapping, Installation and Configuration, up gradation form previous versions.
  • Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.
  • Proficient in troubleshooting database issues.
  • Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
  • Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
  • Team player with Good communication, interpersonal and business analysis skills.

TECHNICAL SKILLS: MS SQL Server 2008 R2/2008/2005/2000, Windows Server 2008 R2/2008/2003/2000, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS , Microsoft SQL Server Analysis Services SSAS . Data Modeling, Erwin 4.0/3.5, Star Schema Modeling, Snow Flake Modeling, MS SQL Server 2008/2005, OLAP Tools, SQL, Perl, Visual Basic, TOAD, SQL Loader, IDERA Diagnostic Manager, Apex SQL Monitoring Tools.

PROFESSIONAL EXPERIENCE:

Confidential

Senior MS SQL Server DBA/Architect

Responsibilities:

  • Implemented Database Mirroring on SQL Server 2008 R2 environments for DR/HA.
  • Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for production environments.
  • Created linked server in Production, Development, and QA Environment
  • As a Production support DBA Managed Multiple SQL Servers in Production, Development and QA Environment
  • Installed SQL Server 2008 R2 on windows 2008 R2 and 2003 servers, applied service packs and security fix for production servers.
  • Upgraded server from MS SQL Server 2005 to MS SQL Server 2008 R2
  • Monitoring and scheduled jobs on production and development environment
  • Created the backup schedule for Production, Development, and QA servers.
  • Managed Database backup and restore in Production, Development, and QA environment
  • Maintained / managed database agent jobs, check for failures and resolve failure issues
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Resolved performance related issues like Blocking, Deadlocks and long running queries
  • Experienced with improving SQL Server using windows performance monitor to improve the server performance.
  • Designed robust stored procedure for business continuity
  • Analyzed existing stored procedure, queries, views and processes for performance bottlenecks
  • Deployed SSIS packages to MSDB database and file system in SQL Server 2008 and 2008 R2
  • Created the DTS, and SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
  • Created SSIS packages to Extract and Load data from diverse source flat file, excel, xml and oracle
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
  • Scheduled packages in the SSIS
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Experienced in troubleshooting production servers and fixed the user and application issues.
  • Created, maintained the users, roles and granted appropriate privileges.

Environment: MS SQL Server 2008 R2/2008/2005, SSIS, SSRS, Windows Server 2008 R2, 2008, 2003.

Confidential

Senior MS SQL Server DBA

Responsibilities:

  • As a Production and development support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments
  • Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
  • Implemented Failover clustering for Active/Active and Active/Passive for HA
  • Managed SQL Server Clusters in a SAN environment
  • Implemented Database Mirroring on SQL Server 2008 environments for DR/HA.
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR.
  • Implemented transactional replication for data refresh
  • Managed and Administered databases in SCOM
  • Managed all Publisher, Distributor and Subscriber database environments for the replication
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
  • Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Created the standard documents for Disaster recovery testing and implemented them.
  • Experienced with database sizing and capacity planning for production servers.
  • Experienced with creating logical and physical database design for development projects.
  • Experienced with improving SQL Server using windows performance monitor to improve the server performance.
  • Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
  • Created SSIS packages to Extract and Load data from diverse source flat file, excel, xml and oracle
  • Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
  • Used containers for repetitive control flow tasks
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
  • Scheduled package execution in SSIS
  • Installing packages on multiple servers in SSIS
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Created extensive reports using SSRS Tabular, Matrix
  • Created the backup schedule for production, test and development servers.
  • Worked with developers to do the database schema changes and database restore requests.
  • Involved in restore operations to refresh the data from production to test servers.
  • Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003.

Confidential

Senior MS SQL Server DBA

Responsibilities:

  • Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
  • Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
  • Interacted with Developers in troubleshooting application and database issues.
  • Identified, tested and resolved database performance issues to ensure data optimization.
  • Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
  • Implementation of system wide security policies and trouble shooting.
  • Involved in installing SQL Server 2005/2008 R2 on Development, Production and WTC Testing machines.
  • Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
  • Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
  • Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS
  • Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
  • Involved in troubleshooting all the performance issues for different database applications.
  • Converting existing DTS Packages to Integration Service SSIS Packages using DTS Xchanger tool.
  • Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Documented all the steps and procedures for future references.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created performance baseline reports using RML tool and documented for future use.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Monitoring and scheduled jobs on production and staging environment.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Provided 24 x 7 Production support for the database and application issues.

Environment: MS SQL Server 2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003.

Confidential

Senior MS SQL Server DBA

Responsibilities:

  • Upgraded most of SQL Server 2000 to SQL Server 2005
  • Involved with upgrade of databases from 2000 to 2005 in a Clustered environment.
  • Worked on SQL Server 2005 with latest Service Packs.
  • Involved in Performance Tuning on Production, QA and Staging servers of the current project.
  • Involved in Monitoring Performance of different production servers.
  • Implemented Database mirroring for disaster recovery.
  • Maintained various databases for Production and Testing using SQL Server 2005.
  • Planning the location of data, index, and Transaction log files on the disk.
  • Performance tuning, and optimization of procedures and queries.
  • Worked with SQL server Profiler.
  • Created the backup and restore strategy for production and development environment.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Using SQL Server Integration Services SSIS tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Experience in creating and executing SQL Server Integration Services SSIS packages.
  • Managing schema objects such as tables, views, clusters, indexes, procedures, triggers maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
  • Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Database and Transaction log backups restoration, backup strategies, scheduling the backups. Backing up system user databases and restoring them.
  • Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • Used BCP and Bulk Insert utilities.
  • Worked with SQL Server Reporting Services SSRS .

Environment: MS SQL Server 2005/2000, SSIS, SSRS, SSAS, Windows Server 2003, 2000

Confidential

MS SQL Server DBA

Responsibilities:

  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
  • Planned and modified the permission issues in the server.
  • Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
  • Fine tuning the Database Settings as well as the Server Settings.
  • Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
  • Creating, maintaining the users, roles and granting privileges.
  • Logical and Physical Data Modeling using AllFusion ERWIN.
  • Configured Snapshot Replication Creating Distribution Databases, updating Publishers, creating managing Publications, managing Replication monitors .
  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
  • Performed analysis and design of the application.
  • Did the database administrative job of Security, Backup/recovery, ODBC connections etc.,
  • Performed Database backups operating system, flat file backups export/import .

Environment: MS SQL Server 2005/2000, SSIS, SSRS, SSAS, Windows Server 2003, 2000.

Confidential

MS SQL Server DBA

Responsibilities:

  • Involved in various stages of SDLC like Design Logical Physical , Development, Implementation and Testing.
  • Involved in creating tables, views, indexes, cursors and stored procedures.
  • Involved in creating data models and designing logical and physical models of database.
  • Designing and validating the forms according to client requirement by using VB.
  • Involved in designing the system models using UML and ER Diagram.
  • Developing the applications using ASP and VB.
  • Involved in designing the database in Access
  • Creating, maintaining the users, roles and granting privileges.
  • Worked closely with the developers' team and the end users while the system is being under development phase.
  • Gave training sessions to the end users for the new product such as using the product.
  • Involved in writing queries and optimizing the performance of the queries.

Environment: MS SQL Server 2000, Windows Server 2003, 2000.

Hire Now