SUMMARY

• Over Seven years of experience in IT of which more than Six plus years in MS SQL SERVER 20012/2008R2/2005/2000 Database Administration and Development in Windows environment.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Extensive Knowledge in various states of System Development Life Cycle (SDLC).
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.
• Extensive experience in managing MS SQL Server on Windows 2000, 2003 and 2008 Servers.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and Deadlocks.
• Experience in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager.
• Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Implemented Database Mirroring in SQL server 2005 2008R2 & 2012 with a witness server to configure automatic failover.
• Implemented log shipping for SQL Server 2005 and 2000.
• Expert in implementing different types of Replication Models such as Transactional and Snapshot.
• Extensive knowledge of installation and configuration of SQL Server 2005/2008R2 cluster server in active/passive and active/active mode.
• Expertise in upgrading (In - place Upgrades) and migrating databases from MS SQL Server 2000 to 2005 and SQL Server 2005 to 2008R2.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Expert in working with Third party backup tool like SQL Lite Speed, Idera SQL Safe to improve Performance of backup and recovery.
• Expert level knowledge in Server Consolidation and Data Center migrations.
• Expert in developing Stored Procedures, views, appropriate functions, effective DDL/DML Triggers and views on index to facilitate efficient data manipulation and data consistency.
• Experience in upgrading SQL server software to new versions suggested by Microsoft and applying service pack and hot fixes
• Experience in contacting Microsoft and other vendors for product and technical support.
• Extensively worked on Data extraction using the (SSIS) Microsoft SQL Server integration services.
• Experience on database design for large databases (terabyte databases).
• Good understanding of change control process.
• Available for 24*7 production support in mission critical environment.
• Good interpersonal, analytical and communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server (2012, 2008 R2, 2008, 2005, 2000), MS Access.

Reporting Tools: SQL Reporting Services.

Programming/Scripting Languages: C, C++, T-SQL.

Operating System: Windows Server 2008R2/2003, Windows 2000.

DBA & Others Tools: Idera SQL Safe, Idera SQL Diagnostic Manager, Red Gate SQL Compare, SCOM Monitoring Tool, Quest Lite Speed, Quest Spotlight.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

MS SQL Server DBA

Responsibilities:

• Installed SQL Server 2012/2008R2 on Windows 2008R2 and VMware Servers in Production, Prod-Like, QA and development Environments.
• Active involvement in installing and managing multiple 3-node failover clusters set up in active/active environment as a High Availability mechanism.
• Implemented Database Mirroring from Production instance to DR instance using High Performance Mode.
• Installed SQL Server 2012 on Development and Test environment servers.
• Rebuilding and monitoring the indexes at regular intervals for better performance.
• Resolved Deadlocking, Blocking and locking issues by creating a trace using SQL Profiler.
• Installing, configuring, and maintaining SCOM Monitoring Tool on Database Servers for extensive monitoring, alerting and auditing the application, OS related errors.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Ensured data backup and recovery, maintenance, data integrity and space requirements for the database server environments.
• Worked on ITIL process Ticket handling, Change Management, Problem management, Incident management.
• Created documentation to install SQL Server, apply service pack and hot fix.
• Migrated data from SQL Server 2005 to SQL Server 2008R2/2012.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2008R2/2005 for achieving performance enhancement.
• Monitoring and troubleshooting performance during peak periods with 1000 to 2000 concurrent connections.
• Used Windows Performance monitor-to-monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Documented disaster recovery plans and participated disaster recovery drills.
• Developed & executed several optimized queries, stored Procedure on Production.
• Good Knowledge on Idera SQL Safe a Backup solution for MS SQL Server.
• Experience in contacting Microsoft for product and technical support.
• Provide 24 X 7 support to all Production, QA & Development MS SQL Server Environments.

Environment: Microsoft Windows Server 2012/2008R2/2003 32/64 bit, Microsoft SQL Server 2012/2008R2 Microsoft SQL Server 2005 and Idera SQL Safe, SCOM Monitoring Tool.

Confidential

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2008R2/2008/2005 Servers in Production, QA and UAT Environments.
• Migration of SQL Server 2000 to SQL Server 2005, SQL Server 2005 to 2008R2
• Worked closely with application team, manager and other DBA’s for planning and implementation of the migration.
• Involved with change control board to ensure proper approvals and meet the timeline for database migration.
• Successfully implemented Database Mirroring in SQL Server 2005/2008R2 for high availability on two VMware servers.
• Created databases, Logins, Roles and granted appropriate permissions.
• Configured Database Mail to send out notifications
• Managing SQL server using PowerShell scripts
• Active involvement in installing and managing multiple 2node failover cluster set up in active/passive environment as a ‘High Availability’ mechanism.
• Prepared Estimates for Database, table size growth rate for capacity planning.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL Server 2005 from Primary server to Standby Server to support DR Solution.
• Implement and maintain database security standards, policies and procedures.
• Installed and configured Quest Spotlight for SQL Server Enterprise.
• Configured Transactional Replication from Multiple subscribers for reporting purposes.
• Involved in performance tuning, optimization of stored procedure and queries.
• Upgrade DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
• Managed indexes on tables using various SQL Server Commands to reduce fragmentation.
• Expert in working with Change management and change control procedure.
• Tuned the Production Server to get the performance improvement by using my own DMV’s.
• Support Development Team in deploying and testing the application.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Successfully worked in 24x7 mission critical environment.

Environment: Microsoft Windows Server 2000/2003 32/64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005, spotlight, lite speed.

Confidential, NY

SQL Server DBA/Developer

Responsibilities:

• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor
• Develop backup and recovery strategy
• Configuring Microsoft Cluster on the Servers (4 node Active/Active cluster with 5 instances)
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases
• Involved in replication setup, configuration and maintenance in transactional replication for student scheduling and Grade reporting application
• Troubleshooting Replication Errors and handling Logs
• Manage database users/profiles and security
• Implementing SQL Server and Database security policies
• Creating and managing database objects such as tables, views, clusters, indexes, procedures, triggers .
• Maintaining SQL Script for creation of Database Objects
• Created Stored Procedures and Triggers for the Application
• Optimized SQL queries for efficiency and provided queries and procedures for the front-end application
• Involved in scheduling tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL mail, managing alerts, monitoring and tuning SQL Server, SQL Performance monitoring, monitoring and tuning memory and monitoring locks

Environment: Windows 2003 Server, SQL server 2005, Event Viewer, SQL Profiler, T-SQL.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installation of SQL Server 2005 with latest Service Packs.
• Worked in Active/Passive Clustered Environment.
• Writing stored procedures for report generation in migration process and replication.
• Implemented the migration of SQL Server 2000 to 2005.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Experience in monitoring software tools used to monitor the environment effectively.
• Successfully implemented Database Mirroring in SQL Server 2005 for high availability.
• Maintain both DEVELOPMENT and PRODUCTION server in sync.
• Involved in Log Shipping.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Involved in Monitoring Performance of different production servers.
• Worked in 24x7 production environment.
• Working with the end user gathering requirements for the system.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.
• Creating and Maintaining Database Maintenance Plans.
• Requirements gathering from the end-users.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in analyzing the system for setting up new server and server configuration.

Environment: Windows 2000/2003 server, MS SQL Server 2000/2005.