Sql server databse administrator

Smyrna, Tennessee

Phone: 615-***-****

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

Adetoro Adu

Database Administrator (DBA)

Career Summary

SQL Database Administrator with extensive hands-on experience in Production and Development environments, specializing in database design, configuration, performance tuning, monitoring, migration, backup & recovery, and security administration. Proven expertise in implementing High Availability (HA) and Disaster Recovery (DR) solutions, including Failover Clustering, Always On Availability Groups, Database Mirroring, Log Shipping, and Geo-Replication, ensuring minimal downtime and data resilience. Adept at deploying, managing, and optimizing SQL Server and Azure (SQL Managed Instance, Geo-Replication, Azure Site Recovery) to support mission-critical applications at scale.

Skills & Expertise

Database Management: Microsoft SQL Server (2012–2022), Azure SQL Database, MySQL

Performance Optimization: Query tuning, indexing strategies, execution plan analysis, TempDB optimization, database partitioning

High Availability & Disaster Recovery (HA/DR): Always On Availability Groups, replication, log shipping, failover clustering, backup & restore strategies

Cloud & Automation: Azure Data Factory, Azure Synapse, AWS RDS, PowerShell scripting, SQL Agent jobs

ETL & Data Integration: SSIS, Azure Data Factory, SQL linked servers

Monitoring & Troubleshooting: SQL Profiler, Extended Events, Performance Monitor, Query store

Cloud Platforms & Databases: Azure (SQL Database, Synapse), Microsoft SQL Server

Automation & Scripting: PowerShell, T-SQL, Python (basic knowledge)

Security & Compliance: SQL hardening, Transparent Data Encryption (TDE), role-based access control (RBAC), audit logging, GDPR, PCI-DSS

Professional Experience

Database Administrator – Tata Consultancy Service, U.S. May 2024 – Present

SQL Server Azure SQL High Availability Performance Tuning

Designed, developed, and deployed scalable SQL Server architectures using Azure SQL, Always On Availability Groups, and Service Fabric, ensuring high availability & fault tolerance for enterprise applications.

Implemented advanced SQL Server security using Transparent Data Encryption (TDE), Row-Level Security, and Dynamic Data Masking, ensuring compliance with data privacy regulations.

Optimized & automated database performance monitoring using Azure Monitor, SQL Profiler, and Query Store, proactively detecting & resolving performance bottlenecks.

Led the migration & integration of on-premises SQL Server databases to Azure SQL Managed Instance, leveraging Azure Data Factory for seamless data transition.

Implemented database clustering & replication strategies using SQL Server Failover Clustering & Distributed Availability Groups, supporting mission-critical workloads.

Troubleshot & resolved database performance issues using Extended Events, DMVs, & Performance Insights, significantly enhancing system stability.

Developed & maintained resilient ETL pipelines using SSIS & Azure Data Factory, enabling efficient data processing & business intelligence reporting.

Automated backup & disaster recovery plans using Azure Backup, Log Shipping, & Point-in-Time Recovery, ensuring minimal data loss & rapid failover.

Optimized SQL Server performance maintenance by automating index rebuilding, statistics updates, and query tuning using PowerShell & SQL Agent Jobs.

Provided mentorship & technical guidance to junior DBAs & developers, fostering best practices in T-SQL development, query indexing, and optimization.

Enhanced TempDB performance by configuring multiple data files, optimizing disk allocation, & reducing contention issues, ensuring stable query execution & transaction processing.

Database Administrator – Accenture, U.S. February 2021 – April 2024

SQL Server Azure SQL High Availability Performance Tuning

Architected, developed, and maintained enterprise-grade databases using SQL Server, Azure SQL, and PostgreSQL, ensuring high availability, fault tolerance, and security.

Optimized database performance by implementing T-SQL query tuning, indexing strategies, and table partitioning, significantly improving data retrieval speeds.

Designed & deployed microservices-based database solutions using Azure Kubernetes Service (AKS), Azure Functions, and Service Fabric, ensuring scalability & fault tolerance.

Developed automated backup & disaster recovery strategies using Azure Backup, AWS Backup, Log Shipping, and Point-in-Time Recovery, minimizing data loss and reducing downtime.

Led SQL Server migration projects from on-premises to cloud-based Azure SQL solutions, reducing infrastructure complexity and improving scalability.

Implemented DevOps best practices for database versioning and schema changes, integrating Azure DevOps Pipelines, Git, and Redgate SQL Change Automation.

Enforced database security policies using Azure Defender for SQL, Role-Based Access Control (RBAC), and advanced auditing mechanisms, ensuring regulatory compliance.

Utilized containerization technologies such as Docker and Kubernetes to deploy SQL Server instances in hybrid cloud environments, improving portability and scalability.

Conducted in-depth performance analysis using SQL Server Profiler, Execution Plans, and Performance Monitor, ensuring efficient query execution and resource management.

Developed SSAS cubes & tabular models to enhance financial and operational analytics within cloud environments.

Optimized TempDB performance for high-volume transaction processing, ensuring smooth database operations.

Database Administrator – Access Bank, Nigeria. January 2018 – March 2020

SQL Server High Availability Disaster Recovery Data Security

Managed high-volume financial databases, handling millions of daily transactions using SQL Server, MySQL, and PostgreSQL, ensuring real-time data consistency and security.

Configured SQL Server Replication & Change Data Capture (CDC) to synchronize data across multiple banking branches, improving real-time analytics & fraud detection.

Developed mission-critical stored procedures, triggers, and views to support banking applications, financial reporting, and risk management analytics.

Implemented Azure-based disaster recovery solutions, including Geo-Replication, Azure Site Recovery, & Point-in-Time Recovery, ensuring uninterrupted banking operations.

Optimized financial transaction processing systems by tuning queries and database partitioning, improving transaction speed & efficiency.

Strengthened database security by implementing role-based access control (RBAC) & encryption policies, ensuring compliance with PCI-DSS & SOC2 security standards.

Integrated containerized database environments using Docker & Kubernetes, improving deployment efficiency & database management.

Led incident response efforts for database outages & cyber threats, applying SQL injection prevention, threat detection, & security patching strategies to maintain a secure infrastructure.

Provided mentorship & training to junior database administrators, promoting best practices in query optimization, data modeling, and high availability strategies.

Leveraged SaaS-based fraud detection tools to improve real-time risk assessment & transaction monitoring.

● Education

University of Abuja (UniAbuja), Nigeria

- Bachelor’s Degree in Biological Science

● Certification

DP-300 (Azure DBA Associate)

Contact this candidate