Production Support DBA Resume

PROFILE SUMMARY:

me having 4 Years of experience in SQL Server Database Administration Support Services.
Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008R2/2012.
Experience in high availability solutions like Replication, Database Mirroring, Log Shipping and Good Knowledge on Clustering as part of disaster recovery procedures.
Experience in Database administration activities for DB Security (creating & assigning the permission to users and roles, Fixing Orphaned users), backup, restore, and security recovery solutions.
Involved with SQL Server Performance Tuning, Server and Database optimization, Query tuning, indexing and query optimization.
Having experience on rebuilding System/User databases during crash situations and Working on file movement activities as per request with application teams.
Experience in Troubleshooting and maintenance expertise in SQL server issues under production environment.
Good knowledge on ITIL Process Involved to work with Incident/Change/Problem Management.
Experience in providing Production support for Database and Applications on 24/7 support.

PROFESSIONAL EXPERIENCE

Confidential

Production Support DBA

Environment: Sql Server 2005/2008/2008 R2/2012, Query Analyzer, SQL Server Profiler, SQL Server Management Studio, Perfmon on Windows Server 2003 and 2008.

Roles and Responsibilities:

Installation & Configuration of SQL Server 2005/2008/2008R2 on Local System and Remote System.
Involved in the process of up gradation/Migration Sql server 2005 & 2008 and applying latest service packs & hot fixes on standalone and clustered environment.
Experience in Setup and Maintained the Log Shipping, Database Mirroring, and Database Replication making data available to all the resources, administration and troubleshooting.
Monitored Databases for Lock Escalation, Blocking, Deadlock, resource utilization by sessions, capturing long running SQL queries, fine - tuning SQL statements dat better result in efficient SQL statements processing.
Maintenance work on different databases (e.g.: Re-indexing, Update Statistics, freeing up space or adding data/log files etc…).
Implemented database refresh and troubleshooting orphaned users.
Having experience on rebuilding master/msdb databases during crash situations and Working on file moment activities as per request with application teams.
Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database.
Performed administrative activities like creating user logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups
Used DBCC Commands & DMV’s utilities, updated index statistics, monitored database and disk space.
Troubleshooting production Issues, jobs and nightly batch process jobs 24*7.

Confidential

Environment: SQL Server 2000, 2005, 2008, 2008R2.

Production Support DBA

Roles and Responsibilities:

Installing Default/Named instances of SQL servers 2000/2005/2008 on standalone servers.
Upgrading SQL servers by applying Service packs, Security patches and Hot fixes.
Upgrading/Migrating the databases from earlier versions to the latest versions.
Implemented database refresh and troubleshooting orphaned users.
Upgrading the database by using Backup and restore & Attach detach methods.
Database refresh from production to sub production systems.
Implemented in-place migration from SQL server 2005 to 2008 in test environment.
Configuring the SQL Server & SQL Server Agent Properties
Creating Maintenance Plans for taking planned backups, updating statistics, Rebuilding & Reorganizing Indexes.
Creating Jobs, Alerts & Operators for getting mails to the DBA team whenever required.
Creating Server principals and database principals and mapping the logins to the desired databases.
Monitoring and troubleshooting the failure jobs by using job activity monitor.
Transferring the data from one to another server by using import and export wizard.
Backup/Restore activities using SQL Server Management Studio.
Setup and Administration of Log shipping.
Setup and maintain Transactional replication for high availability.
Having Knowledge on implementation of Database mirroring.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship