Administrator Associate Database

Monica Agbor- SQL Server DBA SQL Server ****-****, VMs, Microsoft Azure,

Disaster Recovery, Security, Troubleshooting, Monitoring Professional Summary:

• Over 5+ years of extensive Database Administrator (DBA) experience in SQL Server Administration and Database Design.

o Highly Skilled in all aspects of database management including

Security Checks And Policies, Performance Tuning, Troubleshooting

Managing Backup And Recovery Models, Installing, Configuring, and Upgrading Various Servers

Simplifying Administrative Process Through Proper Documentation, Generating Reports

Setting Up High Availability, Disaster Recovery Solutions iIn SQL Such As Always On Availability Groups, Log Shipping, And Replication.

• SQL Server:

o Comprehensive knowledge of SQL Server installation, Migration Both On-Premises And From On Premise To Azure, Patching, Troubleshooting and tuning of databases, Monitoring Optimization, Maintenance (Modeling, High- Availability (HA) And Disaster Recovery (DR)).

• Skilled in building complex environments using Technologies such as Always On, Replication and Log Shipping .

• Competent in performance Monitoring and tuning

• Excellent attention to detail, cross-functional communication, and ability to learn and adapt to change.

• Hyper V/VM:

o Creation and configuration of VM’s with Hyper V, installation of different versions of SQL server

• Devised effective solutions for slow running queries, deadlock, and blocking issues to optimize overall productivity.

• Excellent team player, good work ethics, excellent in documentation, fast learner, ability to multitask, pay attention to details.

• Create Logins, Users, and permissions and managed Security issues of the Server and Encrypt Databases using TDE, DDM and Always Encrypted according to Security Policies defined by the company.

• Used Microsoft best practices during installation, 2012, 2014, 2016, 2017 and 2019 on advanced servers, applied security fixes.

• Installed and configured high availability and disaster recovery solutions like Always-On, log shipping, replication, and mirroring.

• Used external tools like Redgate, Solar Winds for monitoring and DMA for backup and restore.

• Installation and Configuration of Power BI tools: SSIS, SSAS, SSRS.

• Used Microsoft best practices and personal experience to proactively monitor my environment and fix issues before they even occur.

Technical Skills:

• SQL Server 2012-2019, VMs, Microsoft Azure, Disaster Recovery, Security, Troubleshooting, Monitoring

Certification & Training:

• Microsoft Certified Azure Database Administrator Associate (AZ104), Pursuing

• KIAWITECH Advanced Database Administrator Training Program, 2016 Education:

• Diploma in Information Technology from University of Yaounde1 Cameroon, 2014 Professional Experience:

Colorado Access Jan 2022 - Present

MSSQL Server Database Administrator

Responsibilities:

• Installation of SQL in standalone and Clustered environment.

• Provide DBA support and technical expertise for multiple applications in development, test, QA, UAT, and production - SQL Server, 2012, 2014,2016,2019 environments.

• Configured High Availability and Disaster recovery Solution like Always on Availability group, Replication and Log shipping

• Upgrading Databases from lower versions of SQL to a higher version

• Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.

• Tested, Implemented different Physical and Logical Backup and Recovery methods - Point-in Time, Media Recovery, Full/Partial, Export/Import.

• Performance Tuning for optimized results using tools like Sentry one and Solar Winds Monitoring Tools

• Provided Support on Performance Issues during Project Development, resulting in improved response times and reduced contention.

• Implement Database Security Policies following Microsoft best practice and company policies.

• Installation and Configuration of Power BI tools: SSIS, SSAS, SSRS. Responsible for building simple packages from Visual Studio, deploying and configuring the SSIS Packages from lower to upper environments

• Assist in periodic deployments and releases during off hours and participate in on call rotations.

• Documentation of processes in a step by step manner which is part of knowledge sharing policy within our team, which works quite effectively

Costco Wholesale, TX, USA Oct 2018 – Dec 2022

MSSQL Server Database Administrator

Responsibilities:

• Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.

• Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc

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

• Installed SQL Server 2012 on advanced servers, applied security fixes.

• SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.

• Implementation of snapshot isolation and DML triggers

• Configured and supported replication and log shipping in both SQL 2008 and 2012.

• Maintained database response times in 24/7 Production environments.

• Monitoring standby Databases to ensure high availability

• Configured and managed Contained Database

• Firewall Rule, Triger, Change Data Capture (CDC) etc. Bank of America, Houston, Tx, USA Jan 2017 - Sept 2018 MSSQL Server Database Administrator

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

• 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

• 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). Application experience

• Microsoft SQL server, 2012, 2014, 2016, 2017, 2019

• Windows server 2008, 2012, 2012 r2, 2016, 2019

• Microsoft office suite (Word, Excel, power point, office 365)

• Windows Remote Desktop

• Service manager

• Service Now

• Active directory

• Windows (7,8,10)

• Hyper-V, VMware Workstation

• Jira

• Cherwell

• Logic Monitor

• Idera diagnostic Manager

Contact this candidate