Sql Server Database Administrator

Abiodun Ogunmakin

Dallas, Texas ***** 682-***-**** ****************@*****.***

PROFESSIONAL SUMMARY

Detail-oriented Database Administrator with over 8 years of experience in SQL Server Database Administration involving database development, Cloud Architecture. Expertise in optimizing database performance, executing cloud migrations, and implementing high-availability and disaster recovery solutions on Azure and AWS platforms. Am known for resolving complex technical issues, enhancing system efficiency, and delivering seamless database solutions design and performance analysis across Test, Development, and Production Server Environments. I have maintained several servers and systems to ensure smooth business operations, a passionate contributor to team success with good track record of empowering teams. A self-starter who is versatile with database technologies, always motivated to learn, grow, and stay updated. Renders quality services to our client through teamwork, excellence, professionalism, innovation and value creation.

SKILLS

Database Management and Administration: Performance Monitoring and Troubleshooting:

· SQL Server 2005-2019) · Query Optimization

· SQL Server Installation and Configuration · SQL Profiler

· Performance Tuning and Maintenance · Extended Events

· High Availability and Disaster Recovery Strategies · Database Engine Tuning Advisor (DTA)

· Backup and Restore/Recovery · Query Store

· Migration/Upgrade of SQL Server Environments. · Resolving Bottlenecks

High Availability and Disaster Recovery: · Deadlocks · Log Shipping and Clustering · Slow Running Queries · Always On Availability Groups Automation and Scripting:

· Data Mirroring · T-SQL,

•· Replication Models (Snapshot, Transactional, Merge). · PowerShell Skilled in using DMVs, Ex-Events, thirdparty tools for data analysis and root cause analysis (SQL Performance Monitor, Brent Ozar’s Consultant toolkit, First Responder kit, AWS Performance Insights)

•Proficiency in analyzing and interpreting complex datasets, with experience in AWS RDS performance metrics.

ETL and Reporting: · Linux

· SSIS and SSRS Tools and Platforms:

· ETL Process Creation and Support · ServiceNow

· Data Integration · SolarWinds

· POWER BI and Tableau. · SQL Sentry

WORK HISTORY

SQL Database Administrator / Engineer 04/2023 - Current

VLSIP Technologies INC.

SQL Code Optimization: Reviewed and optimized SQL code for Efficiency, identifying and implementing performance enhancements that led to more efficient processing times across multiple applications.

Database Design & Implementation: Designed and implemented stored procedures, triggers, and views to enhance application functionality and improve database interaction.

Database Performance Tuning: Optimized database performance by applying index tuning strategies and query optimization techniques, improving overall system efficiency.

Troubleshooting & Issue Resolution: Collaborated with teams to troubleshoot complex database issues, providing solutions and ensuring minimal disruptions to database services.

Proactive Monitoring & Downtime Reduction: Monitored server health and proactively identified potential issues, executing preventative measures to reduce downtime and maintain continuous operations.

Capacity Planning & Resource Forecasting: Assisted in capacity planning by analyzing growth trends, forecasting future storage needs, and facilitating timely infrastructure investments.

Technical Support & Integration: Provided technical support to application developers, ensuring seamless integration of databases within software solutions for optimal performance.

Database Partitioning & Performance Optimization: Implemented database partitioning strategies, leading to significant improvements in query response times and overall system performance.

Database Migrations & Upgrades: Managed database migrations and upgrades, ensuring minimal impact on end users, maintaining data consistency and seamless transitions.

Change Management: Facilitated change management processes, reviewing proposed changes thoroughly to minimize risk during production environment alterations.

Cross-Functional Collaboration: Collaborated with cross-functional teams to develop efficient data storage solutions, resulting in more streamlined and optimized business processes.

Database Documentation: Maintained detailed documentation for database systems, providing valuable resources for both team members and stakeholders.

Performance Monitoring & Tuning: Implemented regular performance monitoring and tuning strategies, proactively addressing bottlenecks and enhancing database reliability.

ETL Process Improvement: Enhanced ETL process efficiency by developing high-performance SSIS data integration solutions, improving data warehousing through advanced extraction, transformation, and load techniques.

Database Management & Reliability: Managed over 500 databases and VLDBs across multiple data centers, utilizing SQL Profiler and NetMon for issue resolution and performance monitoring, enhancing database reliability.

Cloud Migration & Scalability: Improved resource utilization and system scalability by migrating extensive SQL data from on-premises environments to Azure SQL Database, improving overall reliability and performance.

High Availability & Disaster Recovery: Led initiatives to integrate and maintain high-availability solutions, executing large-scale SQL Server migrations from versions 2005 to 2022, and ensuring disaster recovery readiness.

Data Integrity & Support: Assured data consistency and integrity through physical and logical data modeling for VLDBs, providing 24/7 DBA support for over large production databases hosted on clustered servers.

SQL Server Database Administrator/Azure DBA 01/2016 - 04/2023

THE TRADEGROUP.

Database Performance & Security Optimization: Optimized database performance and security in both on-premises and cloud environments (Azure, AWS), ensuring efficient and secure database operations.

Cloud Migration & Scalability: Led SQL Server migrations to Azure and AWS, minimizing downtime and ensuring smooth transitions while scaling resources to accommodate growth.

Database Monitoring & Management: Monitored database environments using tools like SolarWinds DPA, Red Gate, and AWS CloudWatch, proactively identifying performance issues and sys. reliability.

Database Design & Query Optimization: Collaborated with development teams to design databases and optimize queries, ensuring high performance and streamlined data operations.

Data Security Protocols: Implemented robust data security protocols, including role management and encryption, safeguarding sensitive data across all database systems.

Azure SQL Database Architecture: Designed, implemented, and maintained SQL database architectures within Azure, ensuring high availability, reliability, and performance.

Performance Tuning & Bottleneck Resolution: Analyzed and improved database performance by identifying bottlenecks and applying tuning techniques to enhance overall efficiency.

High Availability & Disaster Recovery: Ensured high availability and disaster recovery readiness by implementing strategies to maintain database reliability and uptime.

Backup & Recovery Procedures: Developed and maintained comprehensive backup procedures and configurations, ensuring data integrity and availability during system disruptions.

Data Integration & Automation: Created and managed integration endpoints for seamless data exchange between systems, ensuring efficient workflows and automation.

Application & System Integration: Worked closely with application developers to ensure efficient data flow and integration with other systems, including Power BI, enhancing business intelligence capabilities

Database Management & High Availability: Managed Microsoft SQL Server databases, ensuring high availability with SQL Server Failover Cluster, AlwaysOn, Log Shipping, and Mirroring to minimize downtime and ensure seamless operations.

Database Maintenance & Disaster Recovery: Developed and executed comprehensive database maintenance plans, including backup, restore, and disaster recovery strategies, ensuring data integrity and security.

Performance Optimization & Query Support: Provided technical support to development teams, facilitating query optimization and performance tuning to ensure efficient database operations.

Automation & Scripting: Developed and maintained advanced T-SQL scripts and PowerShell automation, including stored procedures, functions, views, and triggers, ensuring streamlined and efficient data manipulation.

Database Security & Best Practices: Implemented best practices for database security and maintenance, including regular audits and Windows Event Log Filtering, to maintain optimal database performance and safeguard data.

Cross-functional Collaboration & Custom Solutions: Collaborated with cross-functional teams to understand data requirements and translated them into technical specifications, creating efficient, tailored database solutions that aligned with business needs.

EDUCATION

B.Sc in Computer Science, M.Sc Management University of Lagos

●DP-900 Microsoft Azure Data Fundamentals

●DP-300: Microsoft Azure Database Administrator Associate

●Project Management Professional (PMP)- (In view )

Contact this candidate