database administration, software development

FEMI NNAKWE

Atlanta, GA 678-***-**** ad7flg@r.postjobfree.com

US CITIZEN

PROFESSIONAL SUMMARY

Database administrator (DBA) with extensive experience in designing, testing, and supporting next- generation database solutions in SQL Server environments as well as clustering, mirroring, and high availability solutions in OLTP environments. I am proficient in database backup, recovery, performance tuning, reporting, maintenance tasks, security, and consolidation. TECHNICAL SKILLS

MONGODB

Database Security Backup and restore

Solar Winds, Redgate Server Installation and

Implementation

Always-on-Availability

PostgreSQL Data Migration Disaster Recovery

AZURE Performance Tuning and

Troubleshooting

High Availability

AWS Database Maintenance Failover Clustering

Snowflake VMware Hardware and Server

Operating Systems

SKILL SUMMARY

Expertly support diverse Microsoft SQL Server environments spanning SQL Server 2012 through SQL Server 2022 on Windows Server.

Proficient in MS SQL Server administration, encompassing installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, and failover clusters.

Well-versed in virtualization technologies, adept at managing SQL databases in virtual environments.

Collaborate with developers to identify, debug, and optimize stored procedures, T-SQL queries, and related components.

Administer users, handling creation/alteration, and grant of system/DB roles and permissions on diverse database objects.

Possess in-depth knowledge of High Availability for database servers, utilizing technologies such as Database Mirroring, Replication, Log Shipping, and Always on Availability Group.

Proficiency in creating tables, views, indexes, stored procedures, and other database objects. 2

Expertise in environment transition planning across development, test, stage, and production environments.

Conduct database administration tasks, including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, and index maintenance.

Knowledgeable in Azure SQL Database migration methods, including Database Migration Service (DMS) and Azure Site Recovery.

Skilled in configuring and optimizing Azure SQL Database performance, including query tuning, and indexing strategies.

Proficient in optimizing SQL Server performance on AWS, including instance sizing, storage optimization, and performance tuning.

Experience with AWS Backup and AWS Disaster Recovery for backup and disaster recovery solutions.

Proven track record in optimizing PostgreSQL database performance through query optimization, indexing strategies, and database parameter tuning.

Proficient in designing and implementing robust backup and recovery solutions for PostgreSQL databases, including full, incremental, and point-in-time recovery methods. PROFESSIONAL EXPERIENCE

U.S. BANK - ATLANTA GA. DEC 2021- PRESENT

Database Administrator with the following responsibilities:

Responsible for administering and maintaining over 150 database servers of Production and Test environment.

Analyzing the current database environment to determine recommended database maintenance, security, and Microsoft SQL Server best practices.

Monitoring and troubleshooting production environments.

Creating and maintaining documentation for DBA standard operating procedures.

Ensuring that all code changes made in the production environment are SOX compliance before they are deployed.

Analyzing and migrating data using ETL into SQL Server databases to support customer’s implementation.

Implementation of High Availability solutions for database servers, utilizing technologies such as Database Mirroring, Replication, Log Shipping, Failover-Clustering and Always on Availability Group.

3

Working closely with infrastructure team for patching and hardware upgrades and ensuring that both production and test servers are up to date by applying Windows and SQL Server patches.

Upgrading servers as required from SQL Server 2012 to Newer Versions of SQL Server.

Completing database administration maintenance projects as required.

Providing 24/7 on call support as needed.

Coordinating and configuring new nodes for production server clusters for high availability.

Periodically restoring backup files in test environment to check for corruption.

Reviewing security, performance, and disk space and recommending corrective actions where needed.

Assisting application team in the creation of databases, construction of queries, modification of database tables, and troubleshooting data issues.

Monitoring servers for resources utilization (disk space, memory, CPU, etc.). BTX GLOBAL LOGISTICS- ATLANTA GA. JAN 2019- NOV 2021 Database Administrator with the following responsibilities:

Worked with a team of 5 that manages over 1200 databases of 250GB to 2TB.

Proactively monitoring and ensuring high database performance and availability.

Identified and troubleshoot any Blockings, Deadlocks, or hung Jobs.

Identified and troubleshoot any CPU or Memory spikes.

Monitored table and disk utilization and database fragmentation and created trace files and validate any issues on the database in question.

Worked with team to ensure appropriate hardware resources are allocated and worked with users to develop and optimize their SQL Server queries.

Designed and performed various disaster recovery procedures and database maintenance.

Performed and automate database backups and restores.

Configure log shipping, as well as schedule various jobs and design, create and schedule various maintenance plans.

Perform various standard DBA task and created and deleted databases and database objects, when necessary

Perform routine tasks such as purging old files and checking disk space. EDUCATION

GEORGIA STATE UNIVERSITY, ATLANTA, GEORGIA.

4

BACHELOR OF SCIENCE.

2014 - 2018

Contact this candidate