SUMMARY

• MS SQL Server Administrator with around 8+ years of experience in the IT industry experience, challenging position in Server administration and technical maintenance with the state of the art technology where my managerial, analytical, problem solving skills and application knowledge can be put in for successful execution of projects.
• Over 8 years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2012, 2008 R2, 2005 and 2000 in Production, Development, UAT and SIT Environments.
• Extensive experience in installation, configuration, and maintenance of MS SQL Server 2012, 2008 R 2/2005/2000.
• Proficient experience in Upgrading and migrating from SQL server 2005/2008/200 R2 to SQL server 2008R2 and SQL server 2012.
• Automated daily, weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing.
• Worked with Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring and SQL server native tool PerfMon. Counters and performance tuning.
• 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 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 2005/2008/200 8R2 to provide robust database solutions. Including SQL Server 2012 Always On High Availability.
• Expert in Active/Passive and Active/Active Clustering
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Expert in implementing log shipping and 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/ 2005/2008/200 8R2/2012 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)
• 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.
• Expert in IDERA and SCOM Monitoring and writing T/SQL scripts.
• 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.
• Provided 24 x 7 Production support for the database and application issues.

TECHNICAL SKILLS

Operating Systems: Windows 2008/2005/2000, Windows 98/ XP/ Professional

RDBMS: SQL Server 2012/2008R2/ 2008/2005/2000, MS Access

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, Business Intelligence Development Studio, and SSIS

Web Technologies: XML, HTML, JAVA Script

Languages: T-SQL, C, and JAVA

Reporting Tools: SQL Server Reporting Services, Crystal Reports Networking TCP/IP, Named Pipes, VIA

Other Tools: Lite Speed, Spotlight

PROFESSIONAL EXPERIENCE

Confidential, Nebraska

Senior MS SQL Server

Responsibilities:

• Installed and configured SQL Server 2012 on clustered (active-active environment) and non-clustered environments.
• Developed PowerShell and T-SQL scripts for pre installation, post installation, pre migration and post migration checks for Data Center migration
• Migrating databases from SYBASE server to SQL server 2012 using the SSMA tool.
• Maintaining databases and schemas, adding users, roles and groups and implementing database security according to project requirements.
• Developed scripts to script out existing replication topology in old data center.
• Recreated the stored procedures from SYBASE server to SQL server.
• Worked with QA on testing procedures and environment setup for testing.
• Schema conversion is performed using the SSMA tool and a timestamp column is been added for each table after the completion of migration.
• Used SQL Profiler, Server side trace to identify performance issues on the server.
• Developed SSIS packages to load data from different source systems in to data warehouse.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.
• Performed online index rebuilds for critical tables and helped in reducing locks, improving query performance and made tables available during index rebuild operations.

Environment: MS SQL Server 2012, SSIS, SYBASE Server, SSMA tool, BCP command.

Confidential, TX

Senior MS SQL Server DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining SQL Servers database servers in prod., Dev, UAT, SIT and QA Environments
• Installed SQL Server 2008 R2 and SQL Server 2012 on windows 2008 R2 and 2012 servers, applied service packs and security fix for all servers.
• Implemented Failover clustering for Active/Active and Active/Passive for High availability and Managed SQL Server Clusters in a SAN environment
• Implemented Database Mirroring on SQL Server 2008/2008R2 in Prod 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 reporting database and 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 2008/2008R2 to MS SQL Server 2012.
• Implemented Always on High Availability on SQL Server 2012 in Prod/ UAT environments. 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)
• Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS
• Developed SSIS packages to load data from different source systems in to the data ware house.
• Expert in IDERA and SCOM Monitoring and writing T/SQL scripts.
• Created the backup schedule for production, test and development servers.
• Involved in database refresh from production to SIT/Dev and QA 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, NEW YORK

Senior MS SQL Server DBA

Responsibilities:

• Managed 100+ Prod. Dev and UAT SQL Servers in Virtual and Physical Environments.
• Installed and configured SQL Server 2012,2008 R2 and SQL Server 2005 on windows 2008 R2 and 2012 servers, applied service packs and security fix for all servers.
• Worked extensively on Data warehouse set up on SQL server 2012 and also involved in warehouse deign using Kimball’s methodology.
• Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING
• Implemented system wide security policies and troubleshooting.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeeded. Maintaining SQL Script for creation of Database Objects.
• Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2
• Installed and configured Sync and Async Mirroring for Production and DR environments
• Setup Log Shipping for production databases to carry out DR and failover
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Scheduled package execution in SSIS and installing packages on multiple servers in SSIS.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Created solid stored procedures for Backup and Recovery process.
• Expert in Idera and Scom Monitoring and writing T/SQL scripts.
• Used extensive SQL Server DMV's for Performance and System Monitoring
• Creating, Scheduling and deploying extensive SSIS packages from Development to Production.
• Performance tuning, and optimization of procedures and queries.
• Used Various third Party tools for monitoring SQL Servers and Backing up Databases

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

Confidential, Herndon, VA

SQL Server DBA

Responsibilities:

• Provided 24/7 on call production support.
• Worked extensively on Data warehouse set up on SQL server 2012 and also involved in warehouse deign using Kimball’s methodology.
• Worked in migration of Non - Clustered instances from physical environment to VM Ware environment.
• Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.
• Worked extensively on installing, configuring and maintaining of SQL Server 2000 and 2005 on Windows server 2003.
• Configured the Log shipping and scheduled jobs to setup log shipping between production servers.
• Implemented and tested the point in time recovery of the production databases.
• Implemented Transactional Replication between Primary Server and Sub Systems.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Created Users and Roles, and managed security and permission of different SQL Server objects.
• Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.
• Running DBCC consistency check, and fixing data corruption in user databases.
• Experience in Tuning Databases using Performance Dashboard.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Maintained stand by servers using log shipping and replication concepts.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.

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

Confidential, Jacksonville, FL

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 2008R2.
• 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 troubleshooting.
• 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.
• 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.
• 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 whenever needed.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot and transactional 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, Boston, MA

MS SQL Server DBA

Responsibilities:

• 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.
• 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.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Interacted with concern application team in fixing the problems whenever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Deployed the SSIS packages on Prod/ UAT/SIT servers.
• Performance tuning, and optimization of procedures and queries.
• Created the backup schedule for production, test and development servers.
• 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.
• Monitoring and scheduled jobs on production and staging environment.
• 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.