Adekunle “Ade” Oluwaleye

Greater Atlanta Area 678-***-**** ad2hll@r.postjobfree.com LinkedIn

Senior Database Administrator / SQL Database Architect / Systems Analyst

Self-motivated, service-oriented SQL Server Database Administrator. Excellent analytical, organizational, critical thinking, decision making, and problem-solving skills. Able to work independently and as part of a team. Strong determination and commitment to the deliverables. MS in Mechanical Engineering. Skillset includes:

Microsoft Windows Server 2008 R2, 2012, and 2016.

Microsoft SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, and 2019.

SQL Server Integration Services (SSIS); clustering, mirroring, and high availability solutions in OLTP environments.

SQL Server administration including installation, patching, upgrades, configuration, security, capacity planning, performance tuning, index maintenance, consolidation, backup, and disaster recovery.

Manage the production and development of databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

Providing report by using SSRS, SSIS management tools

Virtualization and installation of Windows Server on VMware; managing SQL databases in a virtual environment.

Work with developers to identify, debug, and fine-tune stored procedures, T-SQL queries, etc.

Manage users including creation, alteration, grant of system, DB roles and permissions on database objects.

High availability of database servers using database mirroring, replications, log shipping (BCR; backup, copy, restore), failover cluster, and “AlwaysOn” availability group.

Modify stored procedures, queries, views, indexes, and functions for business rules, history, and audit analysis.

Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.

Perform routine backup and recovery testing and document recovery scenarios.

Import and export data to and from database servers – including bulk loading.

Architect and implement SQL Server databases for mission-critical business.

Environment transition planning (development, test, stage, production).

Professional Experience

December 2014 – Nov 2022 Ply Gem « Alenco Atlanta, Georgia

Ply Gem is a leading manufacturer of windows, siding, and metal accessories in North America.

Database Administrator II

Administered and maintained 150+ database servers in an office, production, and testing environment.

Analyzed the current database environment to determine recommend Microsoft SQL Server database maintenance, security, and best practices. Completed database administration maintenance projects.

Monitored and troubleshot production environments using IDERA SQL Diagnostic Manager.

Created and maintained documentation for DBA standard operating procedures.

Ensured all code changes made in the production environment were SOX compliant before they were deployed.

Analyzed and migrated data using ETL into SQL Server databases to support customer implementations.

Worked closely with infrastructure team for patching and hardware upgrades; ensured both production and test servers were up-to-date by applying Windows and SQL Server patches.

Upgraded servers as required from SQL Server 2005 to 2012 to 2017.

Coordinated and configured new nodes for production server clusters for high availability.

Periodically restored backup files in test environment to check for corruption.

Reviewed security, performance, and disk space and recommended corrective actions where needed.

Created and executed a migration / decommissioning plan for 500+ databases within a four-month window.

Assisted application team in the creation of databases, construction of queries, modification of database tables, and troubleshooting of data issues. Provided 24/7 on-call support as needed.

Monitored servers for resource utilization (disk space, memory, CPU, etc.).

October 2012 – November 2014 Gateway Technologies Lagos, Nigeria

Gateway Technologies provides IT services and digital solutions, from web development to cyber-security, to international agencies and businesses around the world.

Database Administrator » MS SQL Server

Created, administered, and maintained SQL Server Databases (production, development, test, and staging environment) for various groups such as QA, developers, and users.

Upgraded databases from SQL Server 2005 to SQL Server 2008R2 and 2012.

Installed and configured multiple SQL Server instances in production environment.

Proactively monitored the database systems to ensure secure services with minimum downtime.

Performed database upgrades and applied software patches according application and client requirements.

Rebuilt and reorganized the table indexes at regular intervals for better performance.

Engaged in disaster recovery (DR) strategic planning and implementation in SQL Server.

Created jobs, alerts, and SQL Mail Agents.

Set up High Availability (HA) solutions like log shipping, database mirroring, and clustering as a part of DR.

Scheduled full and transactional log backups for the user created and system databases in the production environment using the database maintenance plan wizard.

Assigned proper user access and security via permissions to the various database objects such as tables, views, and stored procedures.

Implemented MS SQL Cluster (active / passive and active / active), Multi Node Cluster for high availability.

Rewrote and fine-tuned SQL queries to reduce execution times, ease database loads, and improve scalability.

Checked database consistency and health by using DBCC Commands and DMVs at regular intervals.

Tested and implemented procedures to detect poor database performance, collected required information, and performed root cause analyses.

Analyzed slow queries and fine-tune the same to optimize application and system performance.

Monitored and modified performance using execution plans and index tuning.

March 2008 – October 2012 Glo Communications Lagos, Nigeria

Globacom Limited, commonly known as Glo, is Africa's largest telecom company, with millions of subscribers in Nigeria and Ghana. It is the first company to build a high-capacity sub-marine fiber-optic cable from the UK to Nigeria.

SQL Database Administrator

Configured and administered Microsoft SQL Server 2000 and 2005 for 50 database servers, and 400+ databases.

Set up and administered SQL Server database security environments using profiles, database privileges, and roles.

Performed DBA activities like analysis of space availability, backups (transaction logs), and scheduled jobs.

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.

Performed various data migration tasks for mission critical databases.

Worked with a team of six to manage 2000+ databases ranging from 350GB to 2.3TB.

Worked with PowerShell for performance enhancement and security audits.

Implemented security policy design for current and new applications to prevent data corruption and theft.

Assisted in establishing standards and schedules for database backups by making sure that the backup schedules met the recovery requirements on a daily, weekly, and monthly basis.

Oversaw the design and implementation of new applications and changes to existing hardware systems and software packages for customers for high performance.

Used problem-solving skills and root cause analysis to resolve and/or mitigate IT operational issues.

Setup and configured database mirroring in high performance, high availability mode as standard DR strategy.

Monitored performance and allocated resources to achieve optimum database performance.

Monitored and modified performance using execution plans and index tuning.

Rebuilt and reorganized indexes at regular intervals for better performance.

Set up and scheduled various tasks by creating maintenance plans.

Imported and exported data (development to QA to production).

Implemented log shipping and transactional replication.

Education and Professional Development

Master of Science (MS), Mechanical Engineering University of Lagos Lagos, Nigeria

Professional Development

Administration Microsoft SQL Server Certificate, 2012

National Examination Board in Occupational Safety & Health (NEBOSH) Certificate, 2009

Contact this candidate