Senior SQL Server DBA-Azure & On-Prem, 10+ Years

Femi Aderemi

****************@*****.*** 301-***-****

LinkedIn: https://www.linkedin.com/in/femi-aderemi-035236321/

CAREER SUMMARY

Senior SQL Server Database Administrator with over 10 years of experience designing, optimizing, and securing high-performance database systems across Azure Cloud and on-premise environments. Proven expertise in architecting high availability and disaster recovery solutions using AlwaysOn Availability Groups, Failover Clustering, and Log Shipping. Adept at managing hybrid infrastructures with Azure SQL Database and AWS RDS. Demonstrated success in securing data through Transparent Data Encryption (TDE), Data Masking, and Access Controls in compliance with industry standards. Skilled in performance tuning, index optimization, and query refinement to enhance system responsiveness and stability. Experienced in building end-to-end ETL workflows and data warehouse solutions using SSIS and Informatica. Delivers actionable insights through BI tools like Power BI and Tableau. Automates routine operations using T-SQL and PowerShell, with proactive monitoring via SQL Profiler and Performance Monitor.

SKILLS

●Database Platforms: SQL Server (2008-2022), Azure SQL Database, PostgreSQL (12-16), AWS RDS, Snowflake, Postgres

●Cloud & Virtualization: Microsoft Azure, AWS (EC2, S3), AWS RDS for PostgreSQL, VMware

●High Availability & Disaster Recovery: AlwaysOn Availability Groups (AAG), Failover Clustering, PostgreSQL Streaming & Logical Replication, Repmgr, PgBouncer, Log Shipping, Mirroring

●Security & Compliance: Transparent Data Encryption (TDE), Data Masking, Access Control, RBAC for PostgreSQL, Data Governance, Vulnerability AssessmentBackup & Monitoring Tools: SQL Profiler, Performance Monitor, Redgate, Azure Monitor

●Performance Tuning & Optimization: Query Optimization, Index Tuning, Execution Plan Analysis, DMVs, Query Store, Performance Tuning (PTO)

●ETL & Data Integration: SSIS, Informatica, Data Warehousing, Data Compression, Partitioning

●BI & Reporting: Power BI, Tableau, SSRS, SSAS, OLAP, DAX

●Automation & Scripting: T-SQL, PowerShell, Bash/Shell Scripting, pg_cron, VMware PowerCLI

●Tools & Utilities: SQL Server Management Studio (SSMS), Visual Studio, Azure Portal, pgAdmin, PSQL

EXPERIENCE

NSM Insurance Group Senior SQL Server Database Administrator Mar 2021 – Present

●Designed and implemented scalable, highly available database solutions on Azure Cloud using AlwaysOn Availability Groups and and Failover Clustering for SQL Server and Streaming Replication with Repmgr for PostgreSQL, ensuring 99.99% uptime for mission-critical applications..

●Enhanced system performance by over 40% through in-depth analysis of query execution plans, strategic index optimization, and rewriting complex T-SQL queries.

●Implemented robust security measures including Transparent Data Encryption (TDE) and Dynamic Data Masking to safeguard sensitive data and ensure regulatory compliance.

●Architected and deployed enterprise data warehousing solutions using SSAS, enabling advanced analytics and multidimensional data analysis.

●Developed and tested comprehensive disaster recovery strategies with automated backup (using pgBackRest for PostgreSQL) and restore processes, ensuring business continuity and zero data loss in critical scenarios.

●Automated repetitive database administration tasks using PowerShell scripts, resulting in a 30% reduction in operational overhead.

●Created interactive dashboards and reports using Power BI and Tableau, delivering actionable insights that improved decision-making for key stakeholders.

●Managed and optimized Azure SQL databases, ensuring optimal configuration, security, and real-time monitoring using Azure Portal and SSMS.

Blue Cross Blue Shield SQL Server Database Administrator Nov 2015 – Feb 2021

●Managed and optimized high-transaction database environments for large-scale healthcare systems, ensuring performance, security, and availability.

●Designed and deployed highly available solutions on Azure Cloud, configuring Always On Availability Groups and Failover Clustering to ensure continuous system availability.

●Optimized database performance and scalability for SQL Server by tuning configurations, indexing strategies, and resolving complex performance issues.

●Implemented robust security protocols, including TDE and Access Controls, to protect sensitive patient data and ensure compliance with healthcare regulations.

●Developed and executed disaster recovery strategies, including backup, restore, and replication, to ensure business continuity and data integrity.

Fajoda Database Administrator Apr 2014 – Oct 2015

●Designed and implemented database schemas applying normalization principles using Visual Studio and SSMS, ensuring data integrity and supporting scalable application performance.

●Developed and optimized T-SQL scripts, stored procedures, and ETL workflows using SSIS to integrate diverse data sources into centralized data warehouses.

●Created interactive dashboards and reports using Power BI, Tableau, and SSRS, enabling data-driven decision-making for stakeholders.

●Automated routine maintenance and deployment tasks using PowerShell scripting, improving operational efficiency and minimizing human error.

●Performed database installation, maintenance, troubleshooting, and performance tuning tasks using SSMS and Visual Studio, maintaining system stability.

EDUCATION

●Imo State University Bachelor of Science (BSc), Computer Science

CERTIFICATION

●Microsoft Certified: Azure Administrator Associate

●Microsoft Certified: Azure Fundamentals

●Database Management Certification

Contact this candidate