SUMMARY

To achieve a challenging position as an MS SQL Server Database Administrator in a result - oriented company, where my acquired skills and education will be utilized towards continued growth and advancement.

Professional Summary:

• Maintained over 2000 production & non production MS SQL Server 2000/2005/2008/2012/2014 and SQL Cluster Servers in worldwide with 24x7
• Improved and maintained the high availability of 24x7 production servers with disaster recovery management which includes Database Snapshots, Backups, Standby servers (Log shipping), Replication and clustering.
• Good experience on Setting up and Troubleshooting of Log shipping, DB mirroring and Replication for MS SQL Server 2000/2005/2008/2012/2014
• Installing and Configuring SQL Litespeed, a third party tool for SQL server backup and recovery.
• Creating and monitoring jobs for automating daily tasks like backups, checking database integrity and consistency, rebuilding index, updating statistics
• Supporting major customers from USA, EMEA and SINGAPORE
• Handling user requests like point in time restores, Database restore requests from tape Backups
• Creation and Maintenance of Databases, Assigning Roles and managing user permissions.
• Maintaining SLA and implementing Production changes and attending change management calls and Problem management calls

TECHNICAL SKILLS

• Operating systems: Windows 98/NT/2003, UNIX.
• Backup Tools: SQL Litespeed
• Languages : C, C++, Core Java
• RDBMS: MS SQL Server 2000/2005/2008/2008R2/2012
• SQL Server Builds (Includes SQL Server InstallationsService Pack Uprades & Troublehooting the issues if any

PROFESSIONAL EXPERIENCE

Project #1: Confidential

Role: Systems Analyst (SQL DBA)

Team Size: 8.

Environment: Windows 2003, MS SQL Server 2000/2005/2008/2008R2/2012/2014

Responsibilities:

• Escalation DBA and primary point of contact for 150 plus SQL instances
• Working with system architects and application team on migration/upgrades
• Coordinating the day to day activities with offshore team
• Troubleshooting performance issues
• Understanding business criticality and defining the high availability strategies
• Planning and implementing backup strategies considering the Recovery Point Objective
• Database performance/activity monitoring using SQL native tools, Hobbit, SolarWind monitoring tools
• Representing DBA team in DR activities
• Monitoring and maintaining security on databases access and database objects
• Deploy massive SQL Server queries or changes
• Configuring and troubleshooting Transactional Replication and Log Shipping
• Troubleshooting SSIS and SSRS issues
• Experienced in Point-In time Recovery
• Planning Database Maintenances

Project #2: Confidential

Role: Sr. Software Engineer (SQL DBA)

Team Size: 20.

Environment: Windows 2003, MS SQL Server 2000/2005/2008/2008R2/2012 SQL Litespeed

Responsibilities:

• Installing and Configuring of MS SQL 2000 /2005/2008/2008R2/2012.
• Installing Service Packs
• Installing and Configuring SQL Litespeed, a third party tool for SQL server backup and recovery.
• Supporting major customers from USA,EMEA and SINGAPORE,Brazil,Mexico.
• Monitoring Production server with Foglight tool along with Maximo and IPCenter ticketing tools.
• Troubleshooting Log shipping, Database Mirroring, Replication, SQL clustering issues.
• Handling user requests like point in time restores, Database restore requests from tape Backups
• Monitoring Backup jobs and DBCC jobs using Autosys tool.
• Doing regular server health checks before starting the business hours.
• Server maintenance on Weekends like rebuild indexes and updates statistics to improve the Performance.
• Maintaining SLA and implementing Production changes and attending change management calls and Problem management calls.
• Involved in disaster recovery tests for production servers.
• On call support (16 * 7)
• Security Implementation: Administering MSSQL Server by creating user logins with appropriate roles, dropping unwanted logins/roles.

Project #3: Confidential

Role: Sr. Software Engineer (SQL DBA)

Team Size: 24.

Environment: Windows 2003, MS SQL Server 2000/2005/2008, SQL Litespeed

Responsibilities:

• Monitor and troubleshooting SQL Jobs.
• Worked on the space requirement of data, checking the data & log file growth.
• Monitor and managing event viewer.
• Documentation of day to day problems and solutions.
• Working on the alerts generated from various production servers. The basic alerts would be Disk capacity Full, Log Full, Blocking, Deadlock, Server Down, Database suspect, SQL job failures, Logshipping out of sync, Memory Alerts Etc.
• Monitor and troubleshoot SQL Performance using Perfmon, Profiler, and system tables
• Monitor, analyze and troubleshoot SQL server concurrency issues like blocking and deadlocks using system tables and DMVs. Provide feedback on code improvements to app teams where ever applicable.
• Design and Troubleshoot SQL Server high availability using Log Shipping, Database Mirroring, Replication and Clusters.
• Keep the knowledge base updated with new troubleshooting information and procedures
• Security Implementation: Administering MSSQL Server by creating user logins with appropriate roles, dropping unwanted logins/roles.
• Deliver knowledge sharing sessions and Triages across teams.

Project #4: Confidential

Role: Associate Technical Consultant.

Team Size: 5

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

Description: The project is mainly specified for the renovation of existing projects like Quick Contract Creation (QCC) project etc for the company Skillsoft. It is a multi-phased project.

Responsibilities:

Database Administration

• Installing and Configuring of MS SQL 2000 /2005.
• Installing Service Packs & Hot fixes
• Installing MS SQL 2000 Reporting services.
• System Performance monitoring and tuning.
• Server maintenance on Weekends like rebuild indexes and updates statistics to improve the Performance.

Disaster Recovery Management

• Database Backup & restoration and automating them.
• Used SQL LiteSpeed for taking backups and restores

Managing security

• Creating Server and Database users and assigning permissions.
• Maintaining Database security and auditing.