MS SQL Database Administrator Resume

SUMMARY:

Skilled Senior Database Administrator bringing more than 5 years of experience in design and administration of databases, as well as key skills in modeling and warehousing of data, development of enterprise architectures, and strategic collection and use of business intelligence. Proficient in technical software, languages and tools, and learns new strategies quickly. Collaborative and team - oriented with first-rate oral and written communication, complex problem-solving, and decision-making abilities.
Microsoft SQL. High level trouble shooting skills, skillful in working with SQL sever both inbuilt and external monitoring tools such as activity monitor, MSSQL server Profiler, Redgate just to name a few. Database Design, Maintenance. Very skillful in database backup and Recovery, have a high understanding of database recovery models.
Strong in database normalization and indexes. Have a high skill in creating and managing high availability and data recovery solutions, such as Always on availability groups, Log shipping, Replication and Database mirroring Have and understanding of SLA(RTO, RPO, RP)
Very swift in understanding details. Proactive in solving problems, can work in a team without any issues.
Very fluent in English speaking.

PROFESSIONAL EXPERIENCE:

MS SQL Database Administrator

Confidential

Responsibilities:

Working as a part of the team and providing 24x7 supports on Production databases and system support environment
Experience in managing databases under various environments
Storage management
Database Refresh
Implementation and maintaining Database Security (create and maintain users and roles, assigning privileges)
Strong at Database backup and Recovery
Upgrading and patching the Windows and SQL Server
Currents projects:
Experince in SQL Server side by side and in place upgrade
Experienced with SSRS, SSIS, and SSAS
Setting Data Recovery(DR) Solutions (Always on, replication and database log shipping)
Experinced in Windows and SQL patching
Experince in Database migration
Responding to ticket queue (refreshing databases, creating logins and users and assigning permission folloeing the principles of least prevellage ), Installing and maintaining SQL Server database systems
Ensuring successful backups, resolving system issues, opening cases with vendors to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery
Coordinating with the Systems Administration team, in building virtual machines for SQL installation
Experience in working with Virtual Machins with a strong understanding of active directory.
Upgrading SQL Server by reviewing, planning, testing and installing database security patches and service packs
Design, documention, and promote security best practices, policies, standards
Strong knowlege of Database design
Working with development and systems teams to perform application and database upgrades and tuning
Transform raw data into real business intelligence
Migrating databases and upgrading SQL Server from a lower version to an uper version
Experience in maintenance of appropriate database and application monitoring using Idera monitoring tool
Have setup, test and maintain business continuity/disaster recovery infrastructure database and applications
Experience with Transperent Data Encription(TDE) and Always Encrypted(AE)
Configuring and monitoring High Availability(HA) and Data Recovery (DR) solutions, Creating Availability Groups (AG), Log shipping, Replication and Failover clustetring.

MS SQL Database Administrator

Confidential

Responsibilities:

Perform all day-to-day aspects of MS SQL database and Administration such as:
Ensure 24/7 availability of all mission critical data
Be available to address issues as needed
Installations, configuration, upgrades, security, user management and Logins, performance tuning
And monitoring, database Availability, backup and recovery, trouble shooting, and problem resolution
Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in and Production environment
Configured High availability, solutions- Always On Cluster, Traditional Failover Clustering, Database Mirroring and Log shipping
Perform tasks for data recovery, Maintenance, and promoting integrity
Creating and modifying table, running stored procedures, views, indexes and triggers just to name a few
Work with the development team to resolve bug-fixes and assist in relevant testing through various environments
Support multiple SQL Server instances on Linux, Windows
Provide solutions for database issues including capacity, redundancy, replication, and performance
Design, implement and test disaster recovery solutions and procedures
Respond promptly to user complaints regarding access to database
Perform automated Jobs to run and resolve database issues
Configured and supported replication (Snapshot/Transactional/Merge) and log shipping in both SQL 2014 through 2016 Servers.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship