Sql Server DBA / Business Intelligence Lead
Resume:
Ife “Tolu” Adeniyi (MCITP, MBA)
Snr. SQL Server DBA/Consultant
**************@*****.***
+1-404-***-****; +1-404-***-****
Atlanta, GA.
https://www.linkedin.com/in/tolu-adeniyi-mcitp-mba/
SUMMARY
I am a seasoned and award-winning Microsoft Data Platform professional with over 8 years of industry experience designing and implementing data solutions using cloud computing infrastructure platforms like Azure, GCP and AWS to deliver proactive Business Intelligence. I also have relevant experience in database administration, Database Management Software tuning, Performance Tuning and Optimization of MSSQL Server, high availability, disaster recovery, MS SQL Server, Progress Open Edge 4GL, Snowflake, Sisense, Azure Synapse, AWS RDS (Custom), Fabric, Power BI, Windows Server, SSAS, SSIS, SSRS, GitHub, Azure Data Bricks, SolarWinds Sentry, Agile, CI/CD techniques, Windows Admin Center, System Center Operation Manager, Microsoft Data Migration Assistant, Docker, Containers, Azure DevOps, Master Data Services, Azure Data Factory, Microsoft Integration Runtime, Azure Data pipelines, Database Tuning Advisor, Query Tuning Assistant, Microsoft Purview and Azure OpenAI.
I have garnered experience in migrating and administering complex/hybrid Data Infrastructure and Business Intelligence (BI) projects between on-premises data centers and cloud-based providers like AWS, GCP, Azure, and VMware. I also have experience upgrading and migrating production workloads to SQL Server 2022/2025, Azure SQL and Fabric SQL.
My Specialties and focus areas:
Scaling SQL Server
Workload Analysis
Capacity Planning
Performance Tuning
Consolidations/Migrations
Architecture Plannings
High Availability Strategy
Disaster Recovery Strategy
Security Strategy
Full-stack Troubleshooting
My contributions have guided my clients through a range of services including proper deployment, ongoing maintenance, and troubleshooting of their On-Line Transaction Processing (OLTP) and On-Line Analytical Processing (OLAP) environments; as well as managing smooth server farm expansion of rapidly growing international enterprises.
I am also considered highly skilled in the areas of Value Stream Mapping, System thinking, Design thinking, Dependency management, Risk management, Stakeholder management, and Problem-solving.
EXPERIENCE
Senior Database Administrator, at HyCite Enterprises, Atlanta GA
February 2023 – present
I:
•Employ various agile framework principles in leading a team of database administrators and data architects in designing and implementing data solutions for various projects, ensuring alignment with business requirements and industry best practices.
•Successfully develop and execute data strategies, resulting in improved data quality, database uptime, enhanced data governance, and increased operational efficiency of over 13,000 distributors worldwide, over 300 MSSQL instances, ~29,700 SQL Server & Azure SQL databases comprising over 100 multi-terabyte 10TB SQL databases.
•Leveraged DBT for reusable transformation logic, enabling scalable and maintainable ELT processes.
•Integrated data modeling with CI/CD pipelines in Azure DevOps for model-to-code synchronization and deployment.
•Utilized ER/Studio and PowerDesigner to create 3NF and dimensional models supporting OLTP and OLAP workloads.
•Designed and implemented end-to-end data models (conceptual, logical, and physical) to support enterprise-wide systems and reporting initiatives.
•Collaborated with cross-functional teams to identify data integration opportunities and implement effective data integration solutions using tools like DPT 5, FiveTran and Erwin- resulting in streamlined processes, improved database accessibility and stability.
•Implemented data workload modeling techniques in architectural consolidations and configurations to optimize database performance and scalability, resulting in improved system response times and reduced maintenance efforts.
•Champion weekly lunch n’ learn to help mentor and train team members on database architecture principles, techniques, and emerging technologies, fostering a culture of continuous learning and professional growth.
•Played a key role in the successful implementation and completion of a major SQL Server migration & upgrade project from our on-premises data center to the AWS RDS Custom, ensuring a seamless transition and minimal disruption to business operations.
•Proactively implemented monitoring of the entire SQL Server footprint using Azure Monitor, SolarWinds Sentry, and Redgate SQL monitor.
•Developed and executed effective database backup and recovery strategies, minimizing downtime and data loss using native PowerShell scripts as well as 3rd party CommVault and Ola backup solutions.
•Lead database performance tuning initiatives, resulting in a significant reduction in query response time and improved overall system efficiency.
•Integrated data classification, data obfuscation and data cloning containerization for optimizing the secure provisioning of development environments using BigID, Azure DevOps, Azure Kubernetes Services and Redgate Test Data Manager ensuring continuous integration and seamless deployment of high-quality solutions.
•Collaborate with cross-functional teams to design and implement database security measures like Transparent Data Encryption, database-level roles ensuring data integrity and compliance with industry standards.
•Display extensive experience in SQL Server administration, including installation, configuration, and maintenance via Infrastructure as Code (IaC) using Terraform, Amazon CloudFormation, Amazon Machine Image, Azure Resource Manager & templates.
•Collaborate with stakeholders to gather requirements and translate them into effective data solutions to design and implement data models for complex business systems, ensuring data privacy, security, integrity, accuracy, and consistency -hence, resulting in improved data management and reporting capabilities.
•Developed and maintained data dictionaries, data flow diagrams, and other documentation to facilitate understanding and communication of data architecture.
•Implement data governance processes and standards, ensuring compliance with regulatory requirements and industry best practices using Microsoft Purview, IDERA, and PII Vault.
•Conduct data analysis and performance tuning to optimize database performance and enhance system efficiency using a combination of Brent and Glenn’s SQL Server and Azure SQL assessment tools.
•Play a key role in the successful implementation of SAAS analytics solution for our direct-sale business model using Microsoft Fabric, enabling efficient data analysis, and reporting for business stakeholders.
•Implement high availability and clustering solutions, such as AlwaysON Availability Groups and Distributed AlwaysON Availability Groups.
•Mentor the team members in scripting languages, including T-SQL and PowerShell.
•Regularly attend industry conferences and workshops to stay updated with the latest trends and advancements in database administration.
•Employ strong communication and leadership abilities, with a proven track record of effectively collaborating with cross-functional teams.
Senior Consultant, at Fortified Data, Atlanta GA
December 2021 – January 2023 (1 year 1 month)
I:
•Led delivery teams to resolve client technical issues.
•Served as Subject-matter Expert (SME) for all MS SQL Server database-related objects.
•Proactively led the service delivery teams in managing the production and non-production databases to include monitoring, performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity projects for over 32 clients, over 3150 MSSQL instances comprising over 450 multi-terabyte 10TB SQL databases.
•Consulted clients on data modeling best practices and standards for industry compliance, governance, and scalability.
•Utilized PowerDesigner and DBT to build scalable models and transformation layers across Azure Synapse and Data Factory solutions.
•Applied normalization, dimensional modeling, and denormalization techniques to optimize hybrid transactional and analytical processing (HTAP).
•Upheld enterprise-level service delivery quality of all SSAS, SSRS, and SSIS solutions for multiple clients.
•Designed, deployed, and maintained Azure Data Factory, Data Pipelines and Synapse Link for client’s business intelligence and analytics needs.
•Set up database maintenance policies to manage enterprise database systems.
•Used GitHub and Azure DevOps for handling database change management and versioning.
•Championed the provision and migration of large-scale database environments for cloud deployments on EC2 instances, Azure VMs, AWS RDS, Azure SQL databases, and Azure SQL Managed Instances.
•Configured and deployed AI agents to meet team and business needs using Azure OpenAI.
•Championed product restructuring and cloud infrastructure cost-saving projects for SQL servers in Azure and AWS.
•Used PowerShell to automate various SQL Server administrative tasks.
•Created SQL Server on Windows and Linux using Docker containers to meet business needs for testing and proofs-of-concept.
•Monitored and resolved database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues.
•Communicated ticket status with team members and clients.
•Documented in detail the resolution of issues.
•Engaged in 24x7 On-call Availability (rotating schedule).
•Planned and performed the installation of Database application software, patches, and services packs.
•Proactively implement database monitoring and maintenance using SolarWinds Sentry and Ola scripts.
•Implemented and supported systems for high availability and disaster recovery (e.g. Availability Groups, replication, log shipping, mirroring, WSFC, and FCI)
•Migrated data between various RDBMS providers.
•Generated and maintained scripts to support DB creation, schemas, automated tasks, and related activities.
•Performed root cause analysis, documented, and presented to the client.
•Updated internal processes and support documentation.
•Mentored Junior DBAs and conducted internal lunch &learns.
•Reviewed and contributed blog posts and White Papers.
•Represented delivery teams in Scrum of Scrums meetings.
•Facilitated all scrum ceremonies for the teams I was entrusted with (Backlog Refinement, Daily Scrum, Sprint Planning, Sprint Demo, Sprint Retrospectives).
•Tracked data from the burn-down charts and velocity reports facilitating an understanding of our progress and areas that needed improvement.
•Facilitated defect triage call to implement the best solutions to fix and close defects.
•Championed Team activity facilitation (large-size teams).
•Facilitated cross-training for various scrum teams I manage.
•Generated regular team reports for clarity to upper management.
•Led the adoption of Jira, Asana, Miro, and Confluence for various clients and teams.
•Tracked team metrics (Health, Velocity, Productivity, Balance, etc.)
•Worked with Director and C-Level management to develop and refine department goals and roadmaps.
•Utilized Agile principles (Scrum and KanBan) to improve the efficiency of workflow for the entire DBA team.
•Measured DPM (Deliveries / Month) and Lead time of the delivery teams for reporting to upper management.
•Provided coaching to team members and leadership to ensure the adoption of best Agile practices.
•Managed a COP where we share knowledge and come up with solutions to issues faced within our teams.
•Worked with RTE to map out all features and stories to be featured in the PI planning for each quarter.
•Facilitated SCRUM ceremonies for the Delivery team for multiple projects resulting in increased CSAT and NPS for company products.
•Worked with the Team and the Product Owner to define the teams database management processes.
•Was responsible for Coaching and leading multiple Client Scrum teams (feature team) in a LeSS program.
Senior MS-SQL Database Administrator, at Docutap, Sioux Falls SD
December 2017 – December 2021 (4 years 1 month)
I:
•Served as Subject-matter Expert SME for all MS SQL Server database-related objects.
•Successfully applied stiff framework implementation of SQL server on-premises, in private or public cloud platforms.
•Proactively implemented monitoring of the entire SQL Server footprint using SolarWinds Sentry, and Redgate SQL monitor.
•Managed the production and nonproduction databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity of over 150 MSSQL instances comprising over 1450 SQL databases, and VLDB of up to 10TB.
• Applied normalization, dimensional modeling, and denormalization techniques to optimize hybrid transactional and analytical processing (HTAP).
•Architected enterprise-grade conceptual, logical, and physical data models tailored for high-performance AI and analytics systems.
•Oversaw and managed enterprise-level SSAS, SSRS, and SSIS solutions.
•Designed, deployed and maintained ADF, Data Pipelines and Synapse Link for business intelligence and analytics needs.
•Set up database maintenance policies to manage enterprise database systems.
•Used GitHub for automating database change management and versioning.
•Champion the provision and migration of large-scale database environments for cloud deployments on EC2 instances, Azure VMs, AWS RDS, Azure SQL databases, and Azure SQL Managed Instances.
•Managed product restructuring and cloud infrastructure cost-saving projects for SQL servers in Azure and AWS.
•Created SQL Server on Linux using Docker containers to provision resources for development and testing proof-of-concepts to meet business needs.
•Successfully implemented Data at Rest Encryption, Transparent Data Encryption, as well as managed resources and certificate components required for modern-day advanced-level DBMS security.
•Used PowerShell to automate various SQL Server administrative tasks.
•Used SQL Server Profiler, Query optimizer, Tuning Advisor, and Query plans to troubleshoot and resolve performance issues arising from slow-running queries. I also have experience with recommending and creating table indexes as well as proper database checks for maintaining industry best practices in index, statistics maintenance, and defragmentation to improve/maintain database table performances.
•Worked with application development teams to tune, test and deploy queries for new feature changes.
•Handled data modeling and mapping for application migration or re-platforming.
•Administer ETL packages and jobs to support reporting services, Business Intelligence systems, large data warehouses, and Big Data lakes including Snowflake and Sisense.
•Create documentation for complex tasks in and around the MSSQL server and Progress Open Edge database management systems.
•Worked in an Agile environment to build and deploy numerous high-availability solutions, application features, and code changes in various MS SQL Server environments (production and nonproduction) from SQL Server 2008 through SQL Server 2019 on Windows Server 2012, 2012R2, 2016, 2019 and 2022.
•Engaged in Strategic Planning, implementation, and support of high availability (HA) and disaster recovery (DR) solutions via log shipping and database mirroring, Replication, AlwaysON Availability Groups, AlwaysON Failover Clustered Instances along with deploying responsive 99.99% durable backup strategies across multiple MS SQL Server instances into Amazon S3 and Azure blob storage.
•Review configuration changes and developers’ scripts; and ensure proper testing and rollback procedures are followed.
•Worked within the teams in setting up domain resources like network, security, monitoring, and certificates for supporting Microsoft High Availability & Disaster Recovery solutions like Always ON Availability Groups, Always ON Failover clustered instances, Replication, and troubleshooting these technologies.
•Carried out MS SQL server maintenance & upgrade activities, following safe practices to maximize resource availability by troubleshooting MS SQL server issues in a timely manner.
•Serve as a reliable point of contact for internal clients, installing, configuring, updating, upgrading, and supporting hybrid MS SQL Server/ Progress database systems.
•Exceed Service Level Agreements for uptime and performance of MSSQL Server databases by implementing PAAS on cloud platforms like AWS and Azure.
Senior Database Administrator, at LibTAX, Atlanta GA
December 2015 – December 2017 (2 years)
I:
•Migrated data sources and NoSQL databases to SQL Servers in the cloud-based Azure platform (PAAS).
•Deployed numerous development and production high-availability solutions in various MS SQL Server environments from SQL Server 2005 through SQL Server 2012 as well as SQL Server 2014 and SQL Server 2016 on Windows Server 2003, 2003r2, 2008, 2008r2, 2012, 2012R2, and 2016.
•Implemented HA solutions to support domain infrastructure (DNS, Active Directory) on-site and in the cloud [Azure] using VMware and Hyper-V (IAAS).
• Applied normalization, dimensional modeling, and denormalization techniques to optimize hybrid transactional and analytical processing (HTAP).
•Architected enterprise-grade conceptual, logical, and physical data models tailored for high-performance data and analytics systems.
•Created Azure Virtual Machines to support production and DEV/TEST environments.
•Administered the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
•Ensured continuous monitoring and troubleshooting in a 24x7 environment including On-Call Support using SolarWinds Sentry.
•Trained and mentored colleagues on setting up HA & DR solutions like Always ON, Replication, and troubleshooting these technologies.
•Trained and mentored colleagues on carrying out SQL server maintenance & upgrade activities, and safe practices in troubleshooting SQL servers in a timely manner in other to maximize resource availability.
•Successfully engaged in various DR (Disaster Recovery) scenarios for my customers.
•Served as the lead point of contact for internal clients, installing, configuring, updating, upgrading, and supporting our Database platforms.
•Worked with BI teams in the full development and production lifecycle administration of the SQL Server 2005 - 2012 enterprise data warehouses (SSIS) and SSRS Report Servers.
•Made recommendations on systems hardware and software implementation for management approval and took responsibility for complete and timely implementation.
•Automated repetitive maintenance tasks such as database backups, restores, performance tuning, Index maintenance & rebuilding as well as capacity analysis and set up alerts systems for such jobs.
•Organized and coordinated daily operations and project delivery meetings to identify all possible problems and ensure they are rectified to keep the project on schedule and report any project variance to the appropriate upper management personnel.
•Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
•Performed various data migration tasks for mission-critical databases. Migration involving non-relational databases and relational databases using SSIS and PowerShell scripting.
•Effectively managed over 2000 databases ranging from 350GB to 2.3TB along with 6 other DBAs.
Senior Database Administrator at Emirates, Dubai UAE
March 2013 - December 2015 (2 years 10 months)
• Made use of PowerShell and SQL Server Management Objects to manage MSSQL Server databases for high availability.
• Successfully engaged in various DR (Disaster Recovery) scenarios for my customers.
• Served as the lead point of contact for internal clients, installing, configuring, updating, upgrading, and supporting our Database platforms.
• Worked with BI teams in the full development and production lifecycle administration of the SQL Server 2005 - 2012 enterprise data warehouses (SSIS) and SSRS Report Servers.
• Made recommendations on systems hardware and software implementation for management approval and took responsibility for complete and timely implementation.
• Automated repetitive maintenance tasks such as database backups, restores, performance tuning, Index maintenance & rebuilding as well as capacity analysis and set up alerts systems for such jobs.
• Organized and coordinated daily operations and project delivery meetings to identify all possible problems and ensure they are rectified to keep the project on schedule and report any project variance to the appropriate upper management personnel.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
•Performed various data migration tasks for mission-critical databases. Migration involving non-relational databases and relational databases using SSIS and VB scripting.
•Effectively managed over 2000 databases ranging from 350GB to 2.3TB along with 6 other DBAs.
SQL Server Database Infrastructure Administrator at BiCourtney Aviation Services, Lagos NG
October 2010 - December 2012 (2 years 3 months)
• Designed storage layout plan for new servers and recommended improvements for existing servers.
• Made hardware resource (CPU, Memory) sizing recommendations for new servers and improvements for existing servers as needed.
• Performed SQL Server installation (cluster and standalone) for SQL Servers version 2000/2005/2008/2008R2/2012.
• Configure various High Availability solutions; Failover Clustering (Windows and Database), Mirroring and Log-shipping.
• Perform support duties including performing backups and restores, Query and Index performance tuning, capacity analysis, troubleshooting, and fixing failed jobs.
• Served as a point of contact for internal clients, installing, configuring, updating, upgrading, and supporting our Database platforms.
• Managed database security across environments by performing tasks like creating logins, assigning adequate user permissions, and removing unused logins.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, and database security configuration.
Infrastructure Project Roll-out Support Engineer at Alcatel-Lucent Enterprise, Lagos
February 2009 - December 2010 (1 year 11 months)
• Roll-out support duties for GSM projects: Design, installation planning assistance, troubleshooting, repair, installation and modifications of power systems for telecommunication equipment [AC & DC] at Globacom Main Sub-Stations (MSS) Lagos.
• Project supervision on Glo-1 submarine cable project, for milestone and timeline tracking.
• Monitoring, man-power allocation, supervision and standardization of electrical and civil works throughout the project implementation phase of the Glo-1 submarine cable project.
• Troubleshooting and maintenance supervision of industrial redundancy UPS configuration systems.
• Review, interpretation, and implementation of civil and electrical design drawings.
• Perform project management duties at project expeditor level on Glo-1submarine cable project.
Design and maintenance of IT networks and computer systems for Data Centers, office automation, residential automation & entertainment system- tailored to client needs and specifications.
• Planning, design, and implementation of access control and automation systems for office buildings, data centers, private residential villas, schools, hostels, industrial factories, etc. with the aid of AutoCAD, Proteus7.
• Custom design, installation, and after-sale maintenance of computer hardware, peripherals, and operating system for luxury apartments, villas, and schools.
• Design, implementation, and maintenance of cleaning robots, power systems, and cranes.
• Maintenance planning and repair of cleaning robots, cranes, residential automation systems, Computer networking systems, power, core infrastructure power systems for data centers
• Supervision and motivation of a group of subordinate engineers and technicians.
EDUCATION
•Doctor of Philosophy (Ph.D.) in Strategic Leadership and Business
[in progress].
at Capella University, Minneapolis, USA
Location: Minneapolis, MS
2024 - 2025
•Master of Business Administration (MBA) in Logistics & Supply Chain Management.
at Coventry University, Coventry, UK Emirates Aviation University, Dubai, UAE
Location: Coventry, U.K; Dubai, U.A.E
2014 - 2015
•Bachelor of Engineering (B.Eng.) Honors in Electrical and Electronics Engineering
at Covenant University, Ota, Nigeria
Location: Ota, Nigeria
2005 - 2010
Skills
AWS
Microsoft Fabric
Azure
DNS
Azure Synapse
Microsoft SQL Server
Microsoft Windows Server
Docker
Postgres SQL
Linux
Azure DevOps
Azure OpenAI
Oracle
SQL
KQL
Containers
Disaster Recovery
Cloud Computing
Scripting
VMWare
Business Requirements
SSIS
SSAS
SSRS
SolarWinds Sentry
Redgate SQL Monitor
IIS
XML
Agile
Data center experience
T-SQL
Network Administration
Relational databases
Supply chain
Git
Data warehouse
PowerShell
Operating systems
MySQL
MEMBERSHIPS & CERTIFICATIONS
•Microsoft
Microsoft Certified: Azure Solutions Architect Expert
Amazon Web Services (AWS)
AWS Certified: AWS Solutions Architect – Professional
International Information System Security Certification Consortium (ISC2)
Certified Information Systems Security Professional (CISSP)
•Institute of Project Management
Membership/Role: Project Management Professional
•National Institute for Occupational Safety & Health (NIOSH)
Membership/Role: Certified Safety Professional
•SAFe® Community Platform
Membership/Role: Certified SAFe® Scrum Master
REFERENCES
Contacts can be provided when needed.
Contact this candidate