SUMMARY

• Having around 9 Years of IT experience 8 Years in PRODUCTION DBA (SQL Server).
• Involved in troubleshooting the service tickets (ServiceNow/Virtual Tech) and issues come through BMC.
• Regular DATABASE BACKUP monitoring and reporting. Recovering the databases from backups in disaster.
• Expertise in Database Administration on Production Server with server configuration, patch, upgrade, maintain and migrate databases and Monitored appropriate disk storage requirements for the databases.
• Expertise and proficiency in SQL Server Replication with Disaster Recovery Planning and Security Management operations.
• Using Robocopy utility to move DB files to file server.
• Experience with Failover Clustering for high availability in Active/Passive.
• Experience in configuring, administering and maintaining Replication.
• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Configuring, Monitoring and Troubleshooting LOG SHIPPING and DB MIRRORING.
• Having basic knowledge on PowerShell Scripting.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Monitoring SQL Server performance using DMV’s and SQL PROFILER to find deadlocks and blocking. Utilizing the traces for tuning the performance (advisor).
• Updating Statistics and Rebuilding Indexes as a part of maintenance activities by checking the DB consistency.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard to achieve better performance, accessibility and efficiency.
• Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users.
• Troubleshoot system issues, monitored scheduled jobs and setting up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
• Password Audit for SQL Server Logins.
• Resolve database related incidents and requests within SLA’s.
• Experience in Offshore Team management
• Updating and Sanitizing DB weekly in DEV and QA environment and Implemented SQL DEV/QA environment on VMware.
• Generating weekly and Monthly reports as customer needed.
• Providing after hours and 24/7 database maintenance and production support.
• Having good knowledge on implementing disaster Recovery.

TECHNICAL SKILLS

Database: SQL Server (2000/2005/2008 - R2/) and Basic knowledge SQL Server 2012.

Tools: and Utilities: LiteSpeed, UMRDB, BMC Patrol, BMC Remedy, IBM Tivoli, Maestro, Virtual Tech, Service Now.

Operating Systems: Windows XP, Windows server 2000, 2003, 2008 R2.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SR. MSSQL Database Administrator

Environment: Window 2003 Server, SQL 2005/2008/2008 R2/2012.

Responsibilities:

• Installation, Administration and Maintenance of SQL Server Instances.
• Regular DATABASE BACKUP monitoring and reporting. Recovering the databases from backups in disaster.
• Expertise in Database Administration on Production Server with server configuration, patch, upgrade, maintain and migrate databases and Monitored appropriate disk storage requirements for the databases.
• Expertise and proficiency in SQL Server Replication with Disaster Recovery Planning and Security Management operations.
• Using Robocopy utility to move DB files to file server.
• Experience with Failover Clustering for high availability in Active/Passive.
• Experience in configuring, administering and maintaining Replication.
• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Configuring, Monitoring and Troubleshooting LOG SHIPPING and DB MIRRORING.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Monitoring SQL Server performance using DMV’s and SQL PROFILER to find deadlocks and blocking. Utilizing the traces for tuning the performance (advisor).
• Updating Statistics and Rebuilding Indexes as a part of maintenance activities by checking the DB consistency.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard to achieve better performance, accessibility and efficiency.
• Setup Test, Dev, Staging and Production Environments.
• Create Users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, etc.
• Design database Backup and Restoration Strategy.
• Once created the database Backups, monitor those backups are being performed regularly.
• From time to time recover the databases to a specific point of time, as per the requests.
• Setup High-Availability as part Disaster Recovery Strategy for the Databases.
• Troubleshoot various problems that arise in a day-to-day work and fix the issues.
• Monitoring and Performance Tuning; Physical Server Level, Database.
• Documenting major changes to the SQL Servers.
• Apply Service Packs.
• Resolve database related incidents and requests within SLA’s.
• Experience in Offshore Team management
• Updating and Sanitizing DB weekly in DEV and QA environment and Implemented SQL DEV/QA environment on VMware.
• Generating weekly and Monthly reports as customer needed.
• Providing after hours and 24/7 database maintenance and production support.

Confidential

Sr. SQL DBA

Environment: Window 2003 Server, SQL Server 2000/ 2005/2008/2008 R2.

Responsibilities:

• Database Migration from SQL Server .
• Preparing documentation on Database Migration.
• Maintain Backup/Restore policies
• Log Shipping configuration.
• Conducting DR Test.
• Resolving Space Issue of Production, QA, Development and DR Server.
• Managing Logins and Security.
• Daily Health Check of all production servers (300+).
• Database Backup and Restoration.( Lite-Speed & Native Backup)
• Importing, Exporting Data, Shrinking Database.
• Transfer Login, users between Database Servers.
• Implementing Log-Shipping between Primary Server and DR Server.
• Generate Script for Different Objects of the Database.
• Monitoring Replication using Replication Monitor.

Confidential

SQL DBA

Environment: Window 2003 Server, SQL Server 2000, SQL Server 2005.

Responsibilities:

• Log Shipping configuration.
• Conducting DR Test.
• Resolving Space Issue of Production, QA, Development and DR Server.
• Monitoring Daily, weekly and monthly Production, QA, Development and DR Server jobs.
• Managing Logins and Security.
• Daily Health Check of all production servers (120+).
• Database Backup and Restoration.( Lite-Speed & Native Backup)
• Importing, Exporting Data, Shrinking Database.
• Transfer Login, users between Database Servers.
• Implementing Log-Shipping between Primary Server and DR Server.
• Generate Script for Different Objects of the Database.
• Maintain database consistency check using DBCC commands.
• Preparing documentation on Database Growth
• Monitoring Replication using Replication Monitor.

Confidential

BPT Lead

Responsibilities:

• Database installation and administration MS SQL Server 2000
• Designing and implementing Backup & Recovery plans for point in time recovery.
• Creation and maintaining DTS Packages.
• Configuring Linked servers.
• Scheduling Jobs as per the policies.
• Index creation and maintenance.
• Backup and restore on daily, weekly and monthly basis of SQL Servers.
• Finding out poorly performing queries.
• Performing security / Users and their access rights audits across environment.
• Maintain database consistency check using DBCC commands.
• Creating Test environment for the client as per requirement.
• Data provision for clients as per their requirements.
• Creation and maintaining store procedures as per user requirements.
• Applying new release to existing application database.
• Maintaining access rights to the application users.
• Installation of Application and supporting tools.
• Prepare documentation as needed.