Olufemi Okunlola
Greenbelt,MD
Summary
Tech-savvy database professional with 8 years of extensive experience managing Very Large Database (VLBD). Skilled in Relational Database management systems. Strong knowledge of SQL, database design, data modeling, performance optimization, data security, backup, and recovery.Collaborative, dedicated, and organized team player, skilled at managing multiple priorities and leading cross-functional teams in high-stakes environments to enhance data integrity and operational efficiency
Overview
8
8
years of professional experience
1
1
Certification
Work History
SENIOR SQL SERVER DATABASE ADMINISTRATOR
SCOPEK SOLUTIONS
New York, NY
11.2019 - Current
- Database Maintenance and Support: Automated routine tasks like updates and patch management using SQL Server Agent, Azure Elastic Jobs, and Azure Runbook on Very Large Database (VLBD) across multiple data-centers, Supporting development teams with database design and query optimization.
- Optimized existing queries and developed stored procedures using TSQL and PowerShell for data manipulation, retrieval, reporting and automation of tasks to enhance system performance applicable in multiple environments.
- Documentation and Resolution Implementation: Used Word, PowerPoint, and SharePoint to streamline tracking and documentation. Enabled centralized access, boosting team collaboration and knowledge sharing.
- Enhanced Database Migration and Integration by Leading diverse database migration projects, including SQL Server to AWS and on-premises to cloud (Azure SQL Databases , Azure Managed Instance, Azure VMs). Used tools like Database Migration Service (DMS), AWS Schema Conversion Tool (SCT), and direct migrations to ensure seamless transitions, high system availability, reliability, and security throughout various migration paths.
- Facilitating Team Collaboration and Case Transfer by Managing case transfers between SQL and Windows teams, ensuring smooth transitions and clear communication. Coordinated cross-team efforts for multi-disciplinary case resolution.
- Managed database upgrades and migrations, both on-prem and cloud, ensuring minimal impact on end users and maintaining data consistency.
- Conducted root cause analysis by collecting logs from client systems. Using Azure Monitor, SQL Server logs, and Dynamic Management Views (DMVs) to identify solutions to complex database problems.
- Case Management and Initial Response: Handled cases quickly to meet SLA for initial response. Reviewed summaries and if necessary, set up customer meetings to understand issues.
- Developed an automated monitoring system for SSIS package execution times. This system significantly reduces manual monitoring, provides daily insights on execution anomalies, boosts productivity, and facilitates informed decision-making
SQL Server Database Administrator
Etisalat
Lagos
01.2016 - 08.2019
- Worked with staff to develop and implement procedures and Solutions to prevent data loss thereby maximizing system availability to yield optimal customer satisfaction.
- Conducted routine SQL health checks and Monitored system resources, including memory usage, CPU utilization, and disk space, and took corrective action when needed to maintain optimal performance levels.
- Assisted in capacity planning by analyzing growth trends and forecasting future storage needs, facilitating timely infrastructure investments.
- Analyzed business reports for prompt communication, follow-up, and ongoing production support.
- Provided technical support to clients and knowledge transfer to teams.
- Implemented data warehousing solutions to facilitate centralized data storage.
- Collaborated with Agile teams to approve, schedule, plan, supervise new projects, test and deploy codes into production.
- Implemented robust security measures like Transparent Database Encryption (TDE), Dynamic Data Masking, TLS 1.2, Access Management and Network Security to protect sensitive data from unauthorized access and cyber threats.
Education
Bachelor of Science - Mechanical Engineering
Yaba College of Technology
Skills
- Expertise in MS SQL Server, PostgreSQL, Azure Cloud (IAAS, PAAS, SAAS), AWS (RDS, EC2), GCP Cloud SQL with Operating Systems like Windows, Linux and Ubuntu
- Understanding of Agile Methodology
- Proficient in T-SQL and PowerShell,
- Security-focused, protecting data at rest and in transit using Transparent Database Encryption (TDE), Dynamic Data Masking, Transport Layer Security (TLS 12), Access Management and Network Security
- Experienced in Data migration and transformation using DMS, and ETL processes with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Skilled in Data Modelling, Data visual analysis, Data warehousing, Data Partitioning, Data Compression using Power BI and Tableau
- Knowledgeable in HADR, Always On, Clustering, Database Mirroring, Log shipping, and Replication
- Utilized performance tuning tools such as Query Store, Extended Events, DMVs, SQL Profiler and third party tools like Brent Ozar
- Uses Monitoring tools like ServiceNow, Solar Winds DPA, SQL Sentry and Collaboration tools like Slack, Teams and MS365 office for Operational Efficiency
- Excellent team player with a good sense of ownership coupled with Interpersonal Skills which promotes team building
Certification
- DP-300 Administering Microsoft Azure SQL Solutions, 06/2024
- Agile Safe 5.0 Certification 09/2021
- MS SQL SERVER ADMINISTRATION, 04/2013
References
Available on Request
Timeline
SENIOR SQL SERVER DATABASE ADMINISTRATOR
SCOPEK SOLUTIONS
11.2019 - Current
SQL Server Database Administrator
Etisalat
01.2016 - 08.2019
Bachelor of Science - Mechanical Engineering
Yaba College of Technology
Similar Profiles
Elizebeth GhilbertElizebeth Ghilbert
Sr Software Engineer at P Square Toll Solutions India Pvt Ltd / Seeroo IT Solutions (P Square Solutions LLC – Contractor)Sr Software Engineer at P Square Toll Solutions India Pvt Ltd / Seeroo IT Solutions (P Square Solutions LLC – Contractor)
Ana Giselle Javelly TovarAna Giselle Javelly Tovar
Marketing Consultant I at ONIS Solutions / Innova SolutionsMarketing Consultant I at ONIS Solutions / Innova Solutions
Lisa DanielsLisa Daniels
Support Coordinator at Unique Support Solutions/Next Steps Solutions /Personal Support SolutionsSupport Coordinator at Unique Support Solutions/Next Steps Solutions /Personal Support Solutions
Shamelle WestShamelle West
Executive Assistant/Project Coordinator at NASA at Barrios TechnologyExecutive Assistant/Project Coordinator at NASA at Barrios Technology
Shaudon WeaverShaudon Weaver
Overnight Stocker at WegmansOvernight Stocker at Wegmans