Database Administrator Sql Server

FEMI ADEREMI

DATABASE ADMINISTRATOR

PHONE: 301-***-**** MAIL: ***************@*****.*** RESIDENCE: Dallas, TX 76227

PROFESSIONAL SUMMARY

Highly accomplished Database Administrator with 9 years of expertise in designing, implementing, and managing robust database solutions in both production and development environments. Proficient in a broad range of tools and technologies, including MS SQL Server, Azure, AWS, VMware, T-SQL, SSIS, SSRS, SSAS, PowerShell, Power BI, DAX, MDS, Azure Data Factory, and more. Skilled in database performance optimization, security, high availability, disaster recovery, data warehousing, ETL, cloud migration, data governance, data quality, and master data management. Experienced in implementing and managing database frameworks, such as Always on Availability Groups, Failover Clustering, Database Mirroring, and Replication. Strong understanding of database security measures, including TDE, Data Masking, Access Control, and Compliance.

SKILLS

MS SQL Server 2008- 2019

Cloud: Azure, AWS

Migration

Patching

PowerShell Scripting

T-SQL

Performance tuning (PTO)

Redgate

RDBMS database design

Backup and restore

Capacity Planning

SQL Profiling

Security: Transparent Data Encryption, Access Control, Compliance

T-SQL, SSIS, SSRS, SSAS, PowerShell, Power BI, DAX, MDS

Data Management: Data Warehousing, ETL, Data Migration, Data Governance

High Availability: Always On, Replication, Log Shipping, Mirroring Snowflake

SQL Server Database Administrator, NSM Insurance Group (March 2021 - Present)

Designed and implemented a highly available database architecture on Azure Cloud Computing using SSMS, ensuring seamless failover and minimizing downtime.

Performed SQL Server Performance Tuning using SSMS, analyzing query execution plans, optimizing indexes, and rewriting queries to improve performance in Snowflake and SQL

Implemented Database Security measures using TDE, Data Masking, and Access Control in SSMS, ensuring compliance with industry standards and protecting sensitive data.

Configured High Availability solutions, Always On and Failover Clustering, using SSMS and PowerShell scripting, ensuring automatic failover and minimizing downtime.

Developed and executed Disaster Recovery plans, including Backup, Restore, and Replication, using SSMS and Azure Portal, ensuring data integrity and availability.

Designed and developed Data Analytics solutions using Power BI, Tableau, and SSRS, creating data visualizations and insights for business stakeholders.

Created ETL pipelines using SSIS, Informatica, and Talend, integrating data from various sources and loading into data warehouses.

Applied Database Design principles, including Data Modeling and Normalization, using Visual Studio and SSMS, optimizing database schema and improving data consistency.

Developed and optimized SQL Server and snowflake Development scripts, including T-SQL and Stored Procedures, using Visual Studio and SSMS, improving application performance.

Managed Azure Database Administration, including configuration, security, and monitoring, using Azure Portal and SSMS.

Utilized SQL Server Integration Services (SSIS) to integrate data from various sources and load into data warehouses, using Visual Studio and SSMS.

Performed Database Administration tasks, including backup and recovery, performance tuning, and troubleshooting, using SSMS, Visual Studio, and PowerShell scripting.

Designed and implemented Data Warehousing solutions using SQL Server Analysis Services (SSAS), creating business insights and analytics.

Developed Business Intelligence solutions using BI, OLAP, and DAX, creating data visualizations and insights for business stakeholders.

Automated database tasks using PowerShell Scripting, improving efficiency and reducing manual errors.

Ensured Database Backup and Recovery processes were in place, using SSMS and Azure Portal.

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

Optimized database configuration and setup for optimal performance and scalability in both SQL Server and PostgreSQL, utilizing SSMS and Visual Studio.

Troubleshot and resolved database issues using maintenance and troubleshooting techniques across SQL Server and PostgreSQL environments, leveraging SSMS and Visual Studio.

Designed and implemented a highly available database architecture on Azure Cloud Computing for SQL Server, while also deploying PostgreSQL solutions, ensuring seamless failover and minimizing downtime.

Analyzed query execution plans for both SQL Server and PostgreSQL to optimize performance and improve application efficiency.

Implemented Database Security measures using TDE, Data Masking, and Access Control in SQL Server, and similar practices in PostgreSQL, ensuring compliance with industry standards and protecting sensitive data.

Configured High Availability solutions, always on and Failover Clustering, using SSMS and PowerShell scripting, ensuring automatic failover and maintaining data integrity.

Developed and executed Disaster Recovery plans, including Backup, Restore, and Replication strategies in both SQL Server and PostgreSQL, using SSMS, Azure Portal, and PostgreSQL tools, ensuring data availability and business continuity.

Database Administrator, Fajoda (Apr 2014 – Oct 2015)

Created data visualizations and insights for business stakeholders using Power BI, Tableau, and SSRS, improving decision-making and business outcomes.

Applied Database Design principles, including Data Modeling and Normalization, using Visual Studio and SSMS, ensuring data consistency and improving application performance.

Developed and optimized SQL Server Development scripts, including T-SQL and Stored Procedures, using Visual Studio and SSMS, improving application efficiency and reducing manual errors.

Managed Azure Database Administration, including configuration management, security management, and monitoring management, using Azure Portal and SSMS.

Utilized SQL Server Integration Services (SSIS) to integrate data from various sources and load into data warehouses, ensuring data integrity and availability.

Performed Database Administration tasks, including database maintenance, troubleshooting, and performance tuning, using SSMS, Visual Studio, and PowerShell scripting.

Designed and implemented Data Warehousing solutions using SQL Server Analysis Services (SSAS), creating business insights and analytics solutions.

Developed Business Intelligence solutions using BI, OLAP, and DAX, creating data visualizations and insights for business stakeholders.

Automated database tasks using PowerShell Scripting, improving automation efficiency and reducing manual errors.

Ensured Database Backup and Recovery processes were in place, using SSMS and Azure Portal, maintaining data integrity and availability.

Optimized database configuration and setup for optimal performance, scalability, and efficiency, using SSMS and Visual Studio.

EDUCATION

B.Sc. Computer Science – Imo State University – Nigeria

CERTIFICATION

Azure Fundamentals Microsoft Certified, Microsoft Certified, Azure Administrator Associate Database Management

Contact this candidate