SUMMARY

• Having over 7 years of experience in SQL Server Administration on versions 2005/2008&R2/2012.
• MS SQL Server Installation, Configuration, Security, Administration, Applying the latest patches and service packs
• Involved in all environments Production, Staging, QA and Development.
• Experience in supporting mission critical databases in 24/7 365 days environment.
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, Database Security and Database designing.
• Hands on Experience in installing and configuring Active/Passive and Active - Active Cluster on SQL 2000/2005,2008
• Experience in managing MS SQL Server on Windows 2003 and 2008 Servers.
• Experience in maintenance of SQL Server in a VLDB environment (Databases size 1.5 to 2 TB)& experience in troubleshooting and resolving problems.
• Creating Maintenance plans and troubleshooting SQL Server Agent Scheduled jobs like Backup, Integrity, Optimization, and Log Shipping jobs regularly.
• Setup weekly and monthly maintenance plan to optimize the database server.
• Setup rebuild index and update stats maintenance plans on Development, Testing, Staging, and Production Environments.
• Coordinating & Implementing CR’s in production environment.
• Monitoring disk space utilizations, T-Log file size maintenance, and capacity planning.
• Preparing implementation plans and implement as part of release
• High Availability - Log Shipping, Replication, and Database Mirroring
• Implemented Database Mirroring configuration with Witness server to provide automatic failover.
• Implemented different types of Replication models like Transactional and Snapshot.
• Experience in Creating Logins to the Users and giving permissions.
• Experience in Performance Tuning, Query Optimization.
• Preparing DR plans while satisfying SLA requirements and conducted DR tests.
• Creating change request/ trouble management tickets using Test Track.
• Experienced in Upgrading SQL Server from 2005 to 2008, 2008 to 2008 R2 and to 2012.
• Very good experience in using Quest LiteSpeed and Idera SQLSafe to backup and restore the SQL databases.
• Experience in installing, configuring and using RED Gate tools like SQL Compare and SQL Monitor.
• Knowledge of SSIS transformations and Packages.
• Good Knowledge of Software Development Life cycle models like Waterfall and Agile models.

TECHNICAL SKILLS

Databases: SQL Server 2000, 2005, 2008 R2 and 2012.

Database Tools: Idera - SQL Safe, Password Safe, SSMS, SQL Profiler, DTA, MS SQL

Server: 2000 DTS, Toad, Red Gate - SQL Compare.

Version Control Tools: Visual Source safe 6.0, Visual Studio 2010.

Operating Systems: Windows 2000, XP and 2003 Server

Languages: C, C++, SQL

Tracking Tools: Track It, Test Track, Team Track, Silk Radar and Rational Clear Quest

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential, PA

Responsibilities:

• Giving 24/7 support to SQL Server DB in production environment.
• Interacting with development, Release Engineer and App support teams to implement new changes to production.
• Upgrading SQL Server 2008&R2 to 2012.
• Administration and Support for DB.
• Documentation with respect to DBA activities, Application.
• Monitoring and troubleshooting the Jobs, Maintenance Plans, Log Shipping.
• Data files, Log files maintenance and space management.
• Designing and Creating Database for Development, QA, Staging and Production DB
• Taking backups regularly through jobs, restoring databases for other teams whenever required in preparing their environment.
• Fine tuning of jobs.

SQL Server DBA

Confidential, Washington, DC

Responsibilities:

• Giving 24/7 support to SQL Server DB in production environment.
• Responsible for Installing SQL Server on new servers (2008, 2012).
• Upgrading one of the existing 2005 Productions Server to SQL Server 2008 Version
• Interacting with development and Netops team to implement new changes to production.
• Coordinating with client and onsite DBA team.
• Administration and Support for DB.
• Documentation with respect to DBA activities, Application.
• Monitoring and troubleshooting the Jobs, Maintenance Plans, Log Shipping.
• Data files, Log files maintenance and space management.
• Troubleshooting Transactional Replication issues.
• Designing and Creating Database for Development, QA, Staging and Production DB
• Taking backups regularly through jobs, restoring databases for other teams whenever required in preparing their environment.
• Fine tuning of jobs.
• Involved in sending Daily Health Checklist for Important Servers.

SQL Server DBA

Confidential, Norwalk, CT.

Responsibilities:

• Giving 24/7 support to SQL Server DB in production environment.
• Interacting with development, Release Engineer and App support teams to implement new changes to production.
• Coordinating with client and onsite DBA team.
• Administration and Support for DB.
• Documentation with respect to DBA activities, Application.
• Monitoring and troubleshooting the Jobs, Maintenance Plans, Log Shipping.
• Data files, Log files maintenance and space management.
• Designing and Creating Database for Development, QA, Staging and Production DB
• Taking backups regularly through jobs, restoring databases for other teams whenever required in preparing their environment.
• Fine tuning of jobs.

SQL Server DBA

Confidential

Responsibilities:

• Installed and configured SQL Server 2005 in production and development environment.
• Upgraded SQL Server 2000 to SQL server 2005/2008 in 32 and 64 bit environment.
• Active involvement in installing and managing multiple 2 node failover cluster set up in active/passive environment as a High Availability mechanism.
• Successfully implemented database mirroring with high availability mode in SQL Server 2005.
• Implemented log shipping in SQL Server 2005 from primary server to standby server to support DR solution.
• Created documentation to install SQL Server, apply service pack and hot fix.
• Migrated data from SQL Server 2005 to SQL Server 2008R2.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server.
• Customer Support for database issues Performance Related issues,
• Disaster recovery Management, Maintaining Production Database for client (24*7 support),
• Expertise in Backup and Restoration of Database,
• Assist in resolving all problems with production, test and development SQL Server, Troubleshooting the problem and providing the root cause analysis
• Working closely with Wintel (Windows) and Networking Team to resolve the issues.
• Ensure utmost quality process in both design & development of the entire system & guide the client in achieving their business goals
• Providing consultation on SQL Server to our development teams, Educating development teams to writing optimized queries.
• Responsible for creating & maintaining Database files, Transaction log files, Procedures, Daily Maintenance Jobs.
• Troubleshoot database performance issues and tune database objects. Set up traces and profiler to troubleshoot performance issues.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Involved in performance tuning, optimization of stored procedures and queries.
• Expert in working with change management and change control procedure.
• Create and maintain various databases for Production, Development and Testing using SQL Server 2005. Planning the location of data, index, and Transaction log files on the disk.
• Solved issues related to server performance and disk space
• Support Development team in deploying and testing the application.
• Experience in contacting Microsoft and other vendors for product and technical support.