Sql Server Database Administrator

SQL Server Database Administrator

Tel: 832-***-****

Email: ************@*****.***

Objectives

I am an experienced SQL Server DBA with over 8 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

Experience

MEDTRONIC

MS SQL Server Database Administrator FEBUARY 2016 APRIL 2019

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 Daiken

MS SQL Server Database Administrator June 2019 – May 2022 Responsibilities

• Installed and configured different versions of SQL Server.

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

• Used Performance monitor, Activity Monitor, DMV and Extended Events to optimize queries and enhance the performance of database servers.

• 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 SQL Server Database Administrator

Amazon July 2022-Present

Responsibilities:

• Installed and configured SQL Server following MS best practices

• Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space

• Managed the migration of SQL Server 2012 databases to SQL Server 2016

• Created and maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects

• Designed and implemented comprehensive Backup plan and disaster recovery strategies

• Rebuilding the indexes at regular intervals for better performance

• Responsible for Stored Procedures optimization, Performance tuning & index tuning.

• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers

• Used log shipping for synchronization of database

• Implemented and maintained Database mirroring as a DR solution

• SQL Server 2005/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

• Update statistics, database integrity check and backup operations

• Installed and configured SQL Server

• Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space

• Responsible for Stored Procedures optimization, Performance tuning & index tuning.

• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers

• Used log shipping for synchronization of database

• Implemented and maintained Database mirroring as a DR solution

• SQL Server 2005/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

• Update statistics, database integrity check and backup operations

• Documented processes for installations, clustering, availability group setup, and patching Developed PL/SQL Programs (Functions, Procedures, Packages and Triggers).

• Planning and implementation of Database backup/restore and disaster recovery SKILLS

• Installation, Configuration of MS SQL Server versions from 2008 to 2019 following best practices

• Performance Tuning & Monitoring using DMV, Extended Events, Activity Monitor

• Configuring Replication, Failover Clustering, Log Shipping, AlwaysOn Availability.

• Database Migration, Backup and Restore

• Index management, integrity checks, statistics

• Managing Logins and Permission for a multi-user

• Configuring Transparent Data Encryption, Dynamic Data Masking and Always Encrypted

• Good Knowledge of T-SQL Scripting,

• Basic proficiency in dataset analysis using Python

• Detail oriented, Strong analytical, Problem solving and Interpersonal skills

• 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. EDUCATION

Bachelor of Science/ CITEC Higher institute of Technology and management Yaoundé Cameroon

Currently pursuing a career in computer science

References: Available upon request

Contact this candidate