Oyekunbi Fadipe
Frisco,TX
Summary
Database administrator with over 9 years of in-depth experience in MS SQL Server database creation and administration in a production environment for businesses. Experienced, results-oriented, and meticulous. Combined with a track record of success in database security through the setup of transparent database encryption (TDE) and dynamic data masking. SQL competence in stored procedures, performance tuning, and optimization. Repeatedly effective in negotiating complicated technological situations. Possess unparalleled communication skills to share creative ideas with a variety of audiences with various levels of technical experience. Adept at using strong analytical thinking skills to prioritize activities, spot technical problems, and offer quick fixes.
Overview
10
10
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
Grand Canyon Education
01.2021 - Current
- Provide application development support, including database analysis and design data model changes, data export and import, data load and conversion and old data restoration, and SQL tuning.
- Conduct routine database maintenance and upgrades, as well as ad hoc disaster recovery.
- Maintaining and administering current and future versions of Database Management Systems including MS SQL systems and other relational databases.
- Schedule and perform database server updates and backups using server management tools or back up software; configure and monitor database replication, database mirroring and log shipping on database servers at local and remote sites.
- Analyze database server performance and resource usage and make recommendations or implement other mechanisms that will improve performance, reliability, security, and availability.
- Utilize SQL-based tools to build queries, stored procedures, views, and other functions to enable users to sort data and generate reports in both electronic and printed formats.
- Design, build, maintain and publish data connections using products such as Microsoft Reporting Builder, Crystal Reports and Automation Anywhere.
- Review technical designs, reports, documentation, manuals, help files and instructions, and other materials produced by staff.
- Successfully implemented and maintained database backup and recovery processes, reducing data loss incidents by 95% and minimizing recovery time to within 1 hour
- Led and executed 10 successful database migration projects, ensuring smooth transitions to newer SQL Server versions while minimizing disruption to business operations including from on prem to cloud (Azure and AWS)
- Developed and fine-tuned complex SQL queries and stored procedures, achieving 40% increase in overall application performance.
- Implemented high availability solutions, such as database mirroring and Always on Availability Groups, Replication, and log shipping, resulting in average system uptime of 99.99%
- Conducted capacity planning and resource utilization analysis, leading to 25% reduction in hardware costs and improved scalability for future growth.
- Implemented robust security measures, including granular access controls and data encryption, Data masking, data privacy and achieving compliance with industry regulations, and reducing security vulnerabilities by 90%
- Collaborated with development teams to optimize database design, indexing strategies, and query execution plans, resulting in 80% improvement in overall application efficiency.
- Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor for monitoring and tuning SQL Server performance.
- Experience in T-SQL, & PowerShell Scripting
- Manage and troubleshoot Integration Services (SSIS), Support Reporting Servers (SSRS), Analysis Services (SSAS) packages.
SQL Server Database Administrator
State Of Maryland
01.2018 - 12.2020
- Perform management, backups, and maintenance of all databases
- Ensure highest level of database performance, availability, and security
- Proactively monitor, analyze, solve, and tune issues in real time
- Refine and automate repeatable processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Managed and maintained portfolio of 50 SQL Server databases, ranging from small-scale to enterprise-level systems.
- Implemented performance tuning strategies, resulting in 25% improvement in overall query execution time
- Reduced database downtime by 80% through proactive monitoring, troubleshooting, and implementing preventive maintenance tasks
- Implemented database backup and recovery solutions, reducing data loss incidents by 90% and ensuring minimal disruption to business operations
- Designed and executed database migration projects, successfully migrating 100 databases to newer versions of SQL Server with zero data loss and minimal downtime
- Developed and optimized complex SQL queries, improving application response time by 40% and enhancing user experience
- Implemented high availability and disaster recovery solutions, achieving average system uptime of 99.99%
- Conducted capacity planning and resource utilization analysis, resulting in 30% reduction in hardware costs and improved system scalability
- Implemented database security measures, including role-based access controls and encryption, ensuring compliance with industry regulations and mitigating security risks
- Collaborated with development teams to optimize database schema and indexing strategies, leading to 70% improvement in overall application performance
- Installed and configured middleware in Linux and Windows environments.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
SQL Server Database Administrator
Sanofi Aventis
02.2014 - 12.2017
- Act as backup to the DBA during normal business hours
- Assist with continued development & documentation of backup and disaster recovery plans
- Serve as technical lead on Strategic Initiatives requiring technology solutions
- Develop and deliver documentation and training for all relevant systems
- Develop and maintain a hardware/software inventory system
- Develop, and maintain stored procedures, triggers, and batch files
- Improved database performance by implementing indexing strategies, resulting in 30% reduction in query execution time.
- Oversaw migration of legacy database system to cloud-based platform, reducing infrastructure costs by 40% and improving system availability by 99.9%
- Implemented data backup and recovery procedures, reducing data loss incidents by 80% and ensuring business continuity
- Developed and executed database maintenance plans, resulting in 40% increase in system stability and uptime.
- Optimized SQL queries and stored procedures, leading to 90% improvement in application response time
- Conducted regular database performance tuning and capacity planning, resulting in 25% reduction in hardware and storage costs
- Collaborated with cross-functional teams to design and implement data replication solution, achieving 99.99% data accuracy rate across multiple locations
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Conducted tests to identify issues and make necessary modifications.
Education
MBA - Organizational Leadership
Grand Canyon University
Phoenix, AZ10.2024
Bachelor of Science - Microbiology
Olabisi Onabanjo University
Nigeria02.2009
Skills
- Backup Strategy & Recovery
- Transparent Data Encryption
- PowerShell Scripting & TSQL
- Always On Availability Groups
- SQL Server Reporting Services
- Security Best Practices & Patches
- In-Place & Side-by-Side Migration
- Log Shipping & Database Mirroring
- Maintenance Planning and Execution
- Failover Cluster Instances & Replication
- SQL Server Installation and Configuration
- Performance Tuning & Query Optimization
Certification
- Azure Fundamentals Microsoft Certified
- Microsoft Certified, Azure Administrator Associate
- Database Management
Timeline
SQL Server Database Administrator
Grand Canyon Education
01.2021 - Current
SQL Server Database Administrator
State Of Maryland
01.2018 - 12.2020
SQL Server Database Administrator
Sanofi Aventis
02.2014 - 12.2017
MBA - Organizational Leadership
Grand Canyon University
Bachelor of Science - Microbiology
Olabisi Onabanjo University
Similar Profiles
Leah StephensLeah Stephens
Executive Financial Aid Specialist at Grand Canyon Education (Grand Canyon University)Executive Financial Aid Specialist at Grand Canyon Education (Grand Canyon University)
Da'Naija DixDa'Naija Dix
Call Center Specialist at Grand Canyon EducationCall Center Specialist at Grand Canyon Education
Steven MartinSteven Martin
Vice President of Operations at Grand Canyon EducationVice President of Operations at Grand Canyon Education