SQL Server Database Administrator Resume

PROFESSIONAL SUMMARY:

SQL Server Database Administrator who possesses strong analytical and problem solving skills in database applications for 5 years. My experience includes: SQL Server 2012, 2014, 2016, 2017, 2019 as well as backup, recovery, performance tuning, database Security, Index, maintenance, clustering, high availability solutions, and disaster recovery.

SKILL:

SQL Server Installation and Implementation
Disaster Recovery
Backup & Restore
Replication
High Availability
Database Maintenance
T SQL
SQL Server Performance Tuning
Database Security

EXPERIENCE:

SQL Server Database Administrator

Confidential

Responsibilities:

Develop and create stored procedures, advanced queries, triggers, views, indices, and functions for databases.
Migrated databases from SQL Server 2012, 2014, 2016, 2017.
Responsible for supporting the SQL Server databases and ensuring their performance, availability, and security.
Involved in performance testing and optimization of a 2TB OLTP Database.
Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
Managing SQL Server database security by granting permissions securable to the principals and automate various routine maintenance tasks like backups, index reorganization, index rebuilds on all production databases.
Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Expertise in using DBCC trace flags, handling blocking and deadlock situations.
Using Data availability solutions like Online Restore, Online index operation, Database Snapshot and Fast Recovery.
Pro - actively monitor the database systems to ensure secure services with minimum downtime.
Improve and manage maintenance of the databases to include Deployments and Upgrades.
Responsible for security and non-security patches based on company approved maintenance schedules.
Query optimization and improving overall performance.
Working with tools like Litespeed for Backups and SQL Sentry Tool for monitoring the servers.

Junior Database Administration

Confidential

Responsibilities:

Responsible for the configuration and administration of SQL Server for approximately 50 database servers, and 200+ databases.
Set up and administered SQL Server database security environments using profiles, database privileges androles.
Implemented security policy design for current and new applications to prevent data corruption.
Assisted in establishing standards and schedules for database backups by making sure that the backup schedules meet the recovery requirements on a daily, weekly, and monthly basis.
Tuned transactional SQL and stored procedures.
Oversaw the design and implementation of new applications and changes to existing hardware systems and software packages for customers for high performance.
Used problem solving skills and root cause analysis to resolve and/or mitigate IT operational issues.
Responsible for setting up and scheduling various tasks by creating maintenance plans.
Monitored performance and allocated resources to achieve optimum database performance.
Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
Monitored and maintained appropriate disk storage requirements for the database.
Monitored and modified Performance using execution plans and Index tuning.
Rebuilt and Reorganized indexes at regular intervals for better performance.
Implemented Log shipping and transactional replication.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship