SQL Database Administrator Resume

SUMMARY

Talented Database Administrator with 6 years, Experienced SQL Database Administrator with a demonstrated history of working in the information technology industry.
Skilled in SQL server Capacity Planning, Installation and Configuration of SQL Server (2008/R2, 2012, 2014, 2016, and 2017), Different types of Backup, Security, Performance Monitoring, Designing, and Implementing HADR Solutions (FCL, Always On Availability Group, Log shipping, Replication), Activity monitor, Finding and fixing locks, Blocks and deadlocks, Azure SQL

AREAS OF EXPERTISE

Excellent Communication/ Team building
Implementing security measures
Relational Database Management
Set up, configure, monitor, and troubleshoot High Availability Always On
Database Back - up, Recovery, and Maintenance
Data conversion and migration
SQL Server Database
Performance Tuning, Mirroring, Log Shipping, Replication (Transactional and Snapshot), SP who is active and SP who2
Strong experience in Database Administration in SQL SERVER
Experience with Windows environment, VM
Installation, configuration, and upgrade of Microsoft SQL Server
2008, 2008r2, 2012, 2014, 2016, 2017 and instance patching
Administering Windows Server 2008, 2008r2, 2012, 2014, 2016, 2017 and 2019
Data Migration in SQL and Experience moving data on MICROSOFT AZURE,
Migrating and upgrading from or higher versions
Finding and Fixing Locks, Blocks and Deadlocks
Configuring Log shipping, Replication, Always on

PROFESSIONAL EXPERIENCE

SQL Database Administrator

Confidential

Responsibilities:

Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
Implemented security measures to protect vital business data.
Utilized RDBMS tools and utilities to monitor tune and optimize system performance.
Conducted tests to identify issues and make necessary modifications.
Analyzed business reports for prompt communication, follow-up and ongoing support.
Followed standard practices for migrating changes to test and production environments.
Connectivity, replication, backup/restore, security and continuous improvement.
Documented analysis results and provided performance improvement feedback.
Resolved issues and escalated problems from Service Now ticketing
Maintained security by assigning log ins, server permissions, and database roles, Manage permissions and security
Planned and Implemented database backup/restore and disaster recovery

Database Administrator

Confidential

Responsibilities:

Wrote and maintained technical and functional specifications to document database intentions and requirements.
Managed over 300 databases with over 20 production VLDB across multiple data centers
Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
Designed and developed analytical data structures.
Developed and updated databases to handle customer data.
Created and updated database designs and data models.
Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016
Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
Configuring, Maintaining, and Troubleshooting Log Shipping, Mirroring, Always On Availability Groups. SQL Server Failover
Maintained two different databases: Read-only reporting database and Disaster recovery database
Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication.