Ife Adeniyi MCITP, MBA

Snr. SQL Server DBA/Consultant

advh7j@r.postjobfree.com +1-404-***-****

Atlanta, GA.

https://www.linkedin.com/in/tolu-adeniyi-mcitp-mba/

SUMMARY

I am an award-winning Microsoft SQL Server Solutions Expert with over 15 years industry experience using cloud computing infrastructure platforms like Azure and AWS 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, Power BI, Windows Server, SSAS, SSIS, SSRS, GitHub, Agile, CI/CD techniques, Windows Admin Center, System Center Operation Manager, Microsoft Data Migration Assistant, Azure DevOps, Master Data Services, Azure Data Factory, Microsoft Integration Runtime and Azure Data pipelines.

I have garnered experiences of migrating and administering complex/hybrid Data Infrastructure and Business Intelligence (BI) projects between on premise data centers and cloud-based providers like AWS, Azure, and VMware. I also have experience upgrading and migrating production workload to SQL Server 2022 and Azure SQL 2022.

My contributions have guided my clients through a range of services including proper deployment, on- going maintenance, and troubleshooting of their On-Line Transaction Processing (OLTP) 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, Dependencies management, Risk management, Stakeholder management and Problem solving.

EXPERIENCE

Senior/Principal Consultant, at Fortified Data, GA

November 2021 – present

•Lead delivery teams to resolve client technical issues.

•Serve as Subject-matter Expert (SME) for all MS SQL Server database related objects.

•Proactively lead the service delivery teams in managing the production and nonproduction 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.

•Uphold enterprise-level service delivery quality of all SSAS, SSRS and SSIS solutions for multiple clients.

•Set up database maintenance policies to manage enterprise database systems.

•Used GitHub and Azure DevOps for handling 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.

•Championed product restructuring and cloud infrastructure cost-saving projects for SQL server in Azure and AWS.

•Used PowerShell to automate various SQL Server administrative tasks.

•Resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues.

•Communicate ticket status with team members and clients.

•Document in detail the resolution of issues.

•Engage in 24x7 On-call Availability (rotating schedule).

•Plan and perform the installation of Database application software, patches, and services packs.

•Proactively implement database monitoring and maintenance.

•Implement and support systems for high availability and disaster recovery (e.g. Availability Groups, replication, log shipping, mirroring, WSFC, and FCI)

•Migrate data between various RDBMS providers.

•Generate and maintain scripts to support DB creation, schemas, automate tasks and related activities.

•Perform root cause analysis, document, and present to client.

•Update internal process and support documentation.

•Mentor Junior DBA’s and conduct internal lunch &learns.

•Review and contribute blog posts and White Papers.

•Represent delivery team 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.

•Facilitating defect triage call to implement best solutions to fix and close defects.

•Champion Team activity facilitation (large-size teams).

•Facilitate cross-training for various scrum teams I manage.

•Generate regular team reports for clarity to upper management.

•Lead the adoption of Jira, Asana, Miro and confluence for various clients and teams.

•Track team metrics (Health, Velocity, Productivity, Balance, etc.)

•Work with Director and C-Level management to develop and refine department goals and roadmaps.

•Utilize Agile principles (Scrum and KanBan) to improve the efficiency of workflow for the entire DBA team.

•Measure DPM (Deliveries / Month) and Lead time of the delivery teams for reporting to upper management.

•Provide coaching to team members and leadership to ensure the adoption of best Agile practices.

•Manage a COP where we share knowledge and come up with solutions to issues faced within our teams.

•Work with RTE to map out all features and stories to be featured in the PI planning for each quarter.

•Facilitate SCRUM ceremonies for the Delivery team for multiple projects resulting in increased CSAT and NPS for company products.

•Work with the Team and the Product Owner to define Team norms.

•Am responsible for Coaching and leading multiple Client Scrum teams (feature team) in a LeSS program.

Lead MS-SQL Database Administrator, at Experity, SD

December 2017 – January 2022 (4 years 2 months)

I:

•Served as Subject-matter Expert SME for all MS SQL Server database related objects.

•Successfully applied stiff framework implementation of SQL server on premise, in private or public cloud platforms.

•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.

•Oversaw and managed enterprise-level SSAS, SSRS and SSIS solutions.

•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 server in Azure and AWS.

•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 modelling 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, 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, Always On 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, 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 trouble shooting 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 TechEdge Group, GA

December 2015 – December 2017 (2 years)

I:

•Migrated data sources and NoSQL databases to SQL Server in 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 cloud [Azure] using VMware and Hyper-V (IAAS).

•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 24x7 environment including On-Call Support.

•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 trouble shooting SQL server in a timely manner in other to maximize resource availability.

•Successfully engaged in various DR (Disaster Recovery) scenarios for my customers.

•Served as 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 recommendation 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 meeting to identify all possible problems and ensure they are rectified to keep project on schedule and report any project variance to the appropriate upper management personnel.

•Used SQL Profiler for troubleshooting, monitoring, 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

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 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 recommendation 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 meeting to identify all possible problems and ensure they are rectified to keep project on schedule and report any project variance to the appropriate upper management personnel.

• Used SQL Profiler for troubleshooting, monitoring, 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

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 server 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 restore, Query and Index performance tuning, and capacity analysis, troubleshooting and fixing failed jobs.

• Served as lead 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 years 11 months)

• Design and maintenance of IT networks and computer systems for office automations, residential automations & entertainment system- tailored to client needs and specifications.

• Planning, design and implementation of access control and automation systems for office building, 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 and maintenance of cleaning robots and cranes.

• Maintenance planning and repair of cleaning robots, cranes, residential automation systems.

• Supervision and motivation of group of subordinate engineers and technicians.

EDUCATION

•Master of Business Administration (MBA) in Logistics & Supply Chain Management.

at Coventry University & Emirates Aviation University [Dual Award]

Location: Coventry, U.K; Dubai, U.A.E

2014 - 2015

•Bachelor of Engineering (B.Eng.) Honors in Electrical and Electronics Engineering

at Covenant University

Location: Ota, Nigeria

2005 - 2010

MEMBERSHIPS

•Institute of Project Management

Membership/Role: Certified Professional

•National Institute for Occupational Safety & Health (NIOSH)

Membership/Role: Certified Professional

•SAFe Community Platform

Membership/Role: Certified SAFe® Agilist

REFERENCES

Contacts can be provided when needed

Contact this candidate