SQL SERVER DATABASE ADMINSTRATOR Resume

PROFESSIONAL SUMMARY:

Strongly focused and acknowledgeable Database Administrator with over 5 years of experience in production and application support database administration focusing primarily on MS SQL technologies. My experience covers a wide breadth of software installation and maintenance knowledge. Have an experience in handling critical financial data and sensitive customer data that provides a base for computing statistics. Performed several functions of outlining a design for database and making updates to ensure the database provides faster results to the end user.
Experience in troubleshooting and resolving * High experience in database architecture and
Performance issues, blocking, deadlocking,program design.
Database integrity issues, security issues. * Superior familiarity with all Windows client and
Expertise is various High Availability Server Operating Systems.
Solutions (Log - shipping, Mirroring, Failover * Good communication and interpersonal skills
Clustering, Always ON) * Disaster recovery - Backups and Recovery
SQL server performance tuning

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2017/2016/2014/2012/2008 R2

Languages: T- SQL, SQL

Operating systems: Windows Server 2008/2012.

MSOffice: Word, Excel, Access, Outlook, Outlook Express and Power point.

Monitoring Tools: Idera, SQL Server Profiler, Performance Monitor, SQL Sentry

PROFESSIONAL EXPERIENCE:

Confidential

SQL SERVER DATABASE ADMINSTRATOR

Responsibilities:

Responsible for Performance and tuning of SQL servers and application issues related to migration.
Implemented Database Backup and Restore using Maintenance Plans for Disaster Recovery purposes.
Testing of applications for performance, data integrity and validation issues.
Data Transfers between various servers using BCP.
Wrote stored procedures, checking the code for efficiency.
I work with Development team to review their queries before promotion into production.
Administration and Production support for various applications in all environments.
Interact with various departments for new release and troubleshooting of applications.
Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server.

Confidential

SQL DATABASE ADMINSTRATOR

Responsibilities:

Proactively monitor and ensure high database performance and availability.
Identify and troubleshoot any Blockings, Deadlocks, or hung Jobs.
Identify and troubleshoot any CPU or Memory spikes.
Monitor table and disk utilization and database fragmentation.
Create trace files and validate any issues on the database in question.
Work with team to ensure appropriate hardware resources are allocated.
Worked with users to develop and optimize their SQL Server queries.
Design and perform various disaster recovery procedures and database maintenance.
Perform and automate database backups and restores
Configure and maintain log shipping to maintain data across multiple datacenters for Disaster Recovery
Design, create and schedule various maintenance plans
Created and deleted databases and database objects, when necessary following proper Change process
Created and maintained various Views, Stored Procedures, and Triggers
Grant access and establish permissions to database for users
Conducted SQL Server production database analysis on a regular basis.