Ms Sql Management Process

Objectives

I am an experienced SQL Server DBA with over 5 years of experience, who can be relied upon to perform duties with passion and professionalism while ensuring that the goals of the company are met. I pay attention to detail and have solid working experience in managing large databases, Backup/Restore, Migration, Configuring and managing HADR solutions, Performance Tuning and Data Security. I possess a methodical approach to troubleshooting and problem solving. I like to add that I work well both as an individual contributor and as a team player and have an aptitude for learning.

Core Competences

●Installation, Configuration and Setting up of MS SQL Server 2012,2014,2016,2017 following best practices.

●Performance Tuning & Monitoring.

●Design, implement, Administer, develop, test & demonstrate databases across different platforms.

●SQL Standalone and cluster environments setup and installation.

●Backup & Recovery.

●Closely working with development and engineering teams during product releases and responsible for end-to-end database change management process, automated database deployments.

●Upgrades, Patching & Migration.

●Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.

● Implementing and maintaining new databases, backup/recovery and configuration management.

●Experience with DB encryption and SQL/Power shell script.

●Expertise in Always-On Availability Groups (AAG) and Log Shipping and HA/DR Troubleshooting.

●Failed job analysis and prevention.

●Migrating from standalone NT servers to VMware.

●Strong Experience with SQL Server 2017 Administration standalone and cluster environment.

●Good working knowledge on Incident management and Change management process.

●Documenting all my processes in a step-by-step manner to keep up with a good knowledge sharing policy within the team and the entire company.

Experience

Smart Data Analytic

MS SQL Server Database Administrator October 2020– Present

Responsibilities

Installed and configured SQL Server 2016, 2019 following best practices, applied service pack.

Configure and support replication (snapshot/transactional) in both 2016 and 2019 servers.

Finding DMV queries to answer questions about server-level performance.

Design and Implement backup/restore strategy following company's SLA.

Use Data Migration Assistant to perform vertical and horizontal migration.

Administering SQL Server security by Creating User Logins with appropriate roles.

Automate my jobs, system updates, reducing manual efforts by 10% in a week.

Implement HADR such as Failover Clustering, Log Shipping, AlwaysOn, for business continuity and keeping the business downtime to a minimum.

Maintained database security using Transparent Data Encryption, Always Encrypted and Dynamic Data Masking.

Create a Pro-Active, self-correcting environment with alerts and notifications.

Documenting my work in a systematic manner to keep up with a good knowledge sharing policy.

Participate in an on-call rotation to support after hours issues and planned work.

SQL Server 2008/2012/2016/2017 Administration.

Reviewing and optimizing virtual machines environment.

Reviewing and optimizing storage.

Responsible to monitor and troubleshooting Log shipping.

Used Data partitioning, Snapshot Isolation in SQL server.

Bethesda Lutheran Community

Jr MS SQL Server Database Administrator June 2014 – September 2020

Responsibilities

●Installed and configured different versions of SQL Server.

●Implement and enforce security for all the SQL Server Databases.

Upgrading SQL 2008 to 2016 in our environment.

Setting up always on, replication and database mirroring.

Windows and SQL patching.

Reviewing and optimizing storage.

Responding to ticket queue (refreshing databases, creating logins and users)

Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.

Configured High Availability Solution- Always on Cluster, Traditional Failover Clustering, and Log Shipping.

Designed and implemented comprehensive Back up and disaster recovery strategies according to company’s SLA.

●Automation of DBA Tasks and monitoring.

●Capacity planning and resource allocation.

●Respond to and resolve database access and performance issues.

Education And Training

Bachelor’s Degree

180+ hours training program in SQL Server 2016, SQL server 2017 Administration, SQL server 2019 Administration, TSQL Programming

Certifications:

MTA Database Fundamentals certified

Pursuing AZ104: Microsoft Azure Database Administration

References

Available upon request

Contact this candidate