Thomas Kpadenou

ad0qai@r.postjobfree.com

678-***-****)

OVERVIEW

Highly motivated and experienced SQL DBA with more than 10 years of extensive IT experience, 8 years of experience as a Database Administrator with 6 years of expertise in Azure environment, Technologies and environments include, Window Server, MS SQL Server 2019 and 2022, HA (AON), SQL Server, SQL Sentry, SQL Performance Tuning, database migration, AZURE Admin and Azure SQL, Database Administration, Systems Analysis, Design, Network design and testing, Implementation, Testing of Relational Database Management systems (RDBMS) Oracle and NoSQL (MongoDB/ Mongo API). Oracle Enterprise Linux, Storage & Network,

TECHNICAL SKILLS

Designed, deployed, and managed Azure Kubernetes Service (AKS) clusters to host containerized applications, ensuring high availability and scalability.

Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL server

Implement Azure PAAS and IAAS (Azure SQL, Oracle, MySQL and Postgres).

Maintenance and SQL server Performance Tuning of the databases and replication.

Deploy and maintain Azure SQL DB, SQL Managed Instance (include Elastic Pool) and SQL VM (Scale Set)

Provide and support Implement and administrate AON and FCI on Azure

Utilizing expertise in Always-On Availability Groups (AAG) and HA/DR

Configure and manage an Always On distributed availability group

Experience with setup, administrate and troubleshooting of SQL Server and Azure SQL Database Security environments using Profiles, database Privileges and Roles.

Maintains redlined Configuration schematics, user manuals, SOP and SOX

Proficiency in Agile development methodologies, Git version control, and JIRA ticketing system.

Installed and configured SSIS, SSRS, and SSAS on multiple servers and

Monitored and optimized performance of SSIS and SSRS solutions

Collaborated with cross-functional teams to deliver successful projects on time and within budget

Experienced in resolving deadlock and blocking issues for concurrent users and jobs and in-depth troubleshooting (I/O, CPU and memory issues)

Automate task process with Python

Installed, configured, and managed MongoDB and Cosmos DB databases across multiple environments, including development, test, and production.

Cardinal Health

Database Engineer / DBA November 2022 - September 2023

Participated in database migration projects, migrating on-premises databases to Azure SQL and ETL using ADF,ADL and Azure Synapse analytics

Creating SSIS packages for data extraction, transformation, and loading

Maintaining client documentation including database topology, connection procedures, and special instructions.

SQL Server and Azure SQL Database administration, management, resource provisioning and scaling and Azure SQL Data Warehouse

Security and compliance in Azure SQL

Azure SQL Monitoring, troubleshooting and implement Always ON on-Prem and on Azure

Implement, monitor and troubleshoot Azure’s Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) offerings, including Azure SQL, Oracle, MySQL, and PostgreSQL

Participate in new app project by helping deploy app to Azure Terraform and AKS

Provide advanced troubleshooting (Memory, CPU and I/O) for applications and systems and advanced technical support for database related project activities

Configure and maintain Replication, and mirroring, clustering.

Technical procedures, standards and security for databases.

Implement and Administrate Azure Storage and Azure SQL (PAAS and IAAS)

Implement and monitor Azure vnet, nsg, AVAILABILITY ZONE and scale set

Disaster recovery implementation using physical standby databases for high availability.

Develop and maintain installation and configuration procedures using Azure DevOps

Administered MongoDB databases, including installation, configuration, and performance optimization

Coordinate with vendors to assure the continuing functionality of upgrades, versions, services packs and new releases

Provide 24 x 7 on call support as part of a scheduled rotation with other team members

Developed MongoDB data models and implemented indexing strategies for efficient query performance.

The Azure Data services Administrator support application development teams during code promotion and doing configuration changes through development and UAT.

Utilizing expertise in Always-On Availability Groups (AAG) and HA/DR

Maintaining client documentation including database topology, connection procedures, and special instructions.

Microsoft

Database Engineer/ Admin September 2021 - October 2022

Provide customer with support Always-On Availability Groups (AAG) and HA/DR on Azure and on Prem

Provide Distributed Availability and SQL replication (2016 and newer) validation and implementation including troubleshooting

Provide customer support with cluster and AON validation and troubleshooting any issue Azure and on Prem.

Verify and validate any SQL server configuring and performance turning by using all the necessary tools

Design and maintain database redundancy while working to minimize database downtime and service interruptions by using Azure cost effective services (Scale set for example)

Experience with setup, administration and troubleshooting of SQL Server and Azure

SQL Database Security environments using Profiles, database Privileges and Roles.

Performs preventive database maintenance (Statistics, SQL Analyzer, SQL Baselines, SQL Profiles, remove chains rows, recreate indexes, etc.) to insure maximum database performance.

McKesson Technology, GA

Database Administrator January 2016 - August 2021

Participate on many projects with application team (by cloning database and testing new App).

Experienced in the installation, patching, upgrading of SQL Server and Oracle database and create tables, indexes, stored procedures

Database Administrator in Oracle 11gR2, 12c and 19C on Linux.

Performed both remote and on-site Oracle DBA administration tasks.

Experience in monitoring SQL Server (Redgate)

Administrate redundant systems, policies, and procedures for disaster recovery and data archiving. Monitor, optimize and allocate physical data storage for database systems. Added and removed users with authentication and time restrictions. Developed strategy for Backup Routines and Recovery Procedures.

Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems

Set up and managed database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.

Implement Azure PAAS and IAAS (Azure SQL, Oracle, MySQL and Postgres).

Installed, configured, and managed MongoDB and Cosmos DB databases across multiple environments, including development, test, and production.

Perform database backups /restores and perform database backups and restores through PgAdmin.

Monitored database performance and worked with developers to optimize queries and improve application performance.

Implemented and maintained database security policies and procedures to protect data confidentiality and integrity.

Provided 24/7 support for critical database issues.

Additional experience available upon request

EDUCATION & CERTIFICATIONS

Bachelor of Science in Engineering Technology, Kennesaw State University-SPSU 2020

AZ – 900

AZ - 104

CCNA

OCA Certified

Contact this candidate