Sr. DBA Resume

SUMMARY

Working on currently on SQL server 2014/2012/2008 and have worked previously both on SQL 2005/2000 for more than 7 years.
Microsoft Certified Technology Specialist/IT Professional/ MCDBA.
Having vast experience in SQL Installation / Development / Maintenance / Production Support.
Currently working as Consultant - Production Support DBA in Exelon - Baltimore from Nov 2013.
US citizen.
Performance Fine Tuning using Profiler / DTA / PerfMon.
Installation of SQL server and configuring ALWAYS ON / HA / Mirroring in SQL 2012/2014.
Configuring Replications.
Logical and Physical Data Base Design using ERWIN sw.
Trouble Shooting in Procedures / Functions
Writing Complex Logic in Stored Procedures
Review of Business Requirement Document with Clients
Creation of Technical Document for Development
Database Backup & Restore / COPY / Attach & detach jobs
Implementation of Tran and Merge Replication / Log Shipping / Mirroring.
Creation of SSIS / DTS packages using Visual Studio for importing data / exporting data to database or any other destination like XLS / Text files etc.
BCP utility
Team Foundation Server Source Control Software
Optimizing Performance using clustered index / Non clustered index and using SQL 2008 features like Data Compression / Back up Compression / Partition / TDE.
Implementing many SQL 2008 features in Development.
Project Management skills using MS project.

TECHNICAL SKILLS

SQL Database Administration
Performance Tuning & Capacity Monitoring
Data Security, Backup & Recovery
Strong Development skills
SQL 2012/SQL2014 Installation /Configuration..
Logical / Physical Database Design.
Software life cycle methodologies.
MS Project Management
Setting up of Transaction Replication / Merge Replication.

PROFESSIONAL EXPERIENCE

Confidential

Sr. DBA

Responsibilities:

Worked as Sr. Database Administrator from Jul 2012.
Taking care of maintaining all environments ( DEV/SIT/UAT)
Supporting Production environment as POC to the external company which is supporting Production Environment.
Working with Development team for design and performance fine tuning.
Supporting Development team in maintaining various non-prod environments.
Conducted Root Cause Analysis for poor performance in production servers by catching the time consuming DB calls and created missing indexes and suggested improvements in the stored procedures/functions to the third party maintaining the suite of packages for Pharmacy Application.
Created SSIS package to generate 8 hourly order generated reports for top management.
Created SSIS package and automated to send email about the jobs failed across all the production servers.
Migrated all databases from one physical location Ohio to Baltimore in consolidation effort. This was done using Log Shipping technique.
Installation of SQL server 2008 R2 in all the upcoming pharmacies for all the environments.
Supporting deployment of code to UAT/ Production environments thru kits.
Implemented Merge / Transaction Replication for Reporting Application.

Confidential

Lead SYS CSLT

Responsibilities:

Conducted Root Cause Analysis for poor performance in production servers by catching the time consuming DB calls.
Managed and Completed Promotions Module from Design to Implementation and supported on-going requirements and maintenance. Directly involved in clients conference calls to gather requirements.
Supporting 24*7 Production Servers to monitor all the 10 servers by taking proactive steps like creating jobs to monitor Database Space and Drive Space to send alerts.
Designed and coded scripts/SPs for the above implementation.
Lead for a 4 member DBA team for production support as well as in Servers Migration project comprising of totally 65 servers from non-prod to Production environment.
Ensuring that all the production Databases do have regular backups taken without any issues.
Fully supporting Production Deployment in KIT deployment/ post support in production servers.
Managing and Guiding 4-5 DBAs in the team.
Ensuring that all the production Tickets are satisfactorily attended and resolved. This includes both Application and Server related.
All Database activities like creation of Linked Servers/ Logins / Users / Triggers / Jobs / Checking Error Logs etc.
Developed and implemented Log Shipping from Production Environment to Disaster Recovery Environment and to alert when jobs fail either in Backup or in Restore operation.
Designed / Developed Daily Health Check Report Module on Production Databases to report Database wise Space available, Jobs Failed and Failed over Instances. This module is constructed on a separate database with necessary tables / stored procedures.
Improved Performance by Fine Tuning Queries/ Stored Procedures or Creating Necessary Indexes, placement of objects etc.
Introduced new features of SQL 2008 / 2005 in Stored Procedures like Compressed Backup, Merge Statements replacing Update Statements, CDC (change data capture), and Common Table Expression and Try/Catch blocks.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship