Oladipo Akinsanmi

Migrated physical servers, VMs, and databases from on-premises to Azure using stored procedures and Data Migration Assistant (DMA).

• Performed performance tuning and query optimization using dedicated stored procedures.
• Configured, monitored, troubleshot, and fixed maintenance jobs (e.g., automated backups, index maintenance, statistics update, database integrity check).
• Conducted performance tuning on issues ranging from query tuning to index optimization, TempDB issues, high CPU usage, blocking, and long-running queries.
• Developed and implemented appropriate HADR strategies based on RTO/RPO objectives and SLAs.
• Collaborated with cross-functional teams to improve data processing efficiency by 25%.
• Granted access to users based on principle of least privilege.
• Created and maintained SQL objects (e.g., tables, views, constraints, user-defined functions).
• Configured Transparent Data Encryption (TDE) and data masking to enhance security.
• Participated in architectural discussions to ensure successful solution design.

• Installed, configured, and managed multiple SQL Server environments ensuring high availability and disaster recovery.
• Monitored and managed databases, performing regular health checks to maintain optimal performance.
• Provided SQL administration functions for client applications including Skype and SharePoint.
• Resolved daily database-related incidents and requests efficiently.
• Executed changes on production databases following change order requests.
• Designed, managed, validated, and implemented robust backup and recovery systems.
• Supported various functions such as applying patches, interfacing with application vendors, and assisting application administrators.
• Tested and implemented database upgrades and changes.
• Managed platform migration projects effectively.
• Conducted performance tuning of index rebuilds, setup, configuration, and utilized relevant concepts, techniques, and tools.
• Performed troubleshooting, root cause analysis, and provided workarounds, including after-hours and weekends.
• Deployed database change scripts provided by developers or third-party vendors using GIT Pull and Redgate SQL Source Control
• Worked on Windows failover clustering and configured AlwaysOn for SQL Server versions 2016, 2017, 2019, and 2022.
• Participated in monthly database patching maintenance to ensure system stability.
• Conducted regular tests and evaluations to ensure data security, privacy, and integrity.
• Demonstrated advanced knowledge of BLUDB/schema backup using scripts and console environments.
• Automated database refresh from production to development, reducing resource costs by 25%.
• Developed Power BI reports to aid business decision-making.
• Utilized SQL Profiler, DMVs, and Windows Performance tools for SQL server performance monitoring and tuning.

Roles and Responsibilities:

• Configured disaster recovery solutions using Transaction Replication for multiple update table subscriptions.
• Created and maintained SQL objects such as tables, views, stored procedures, constraints, and user-defined functions.
• Applied cumulative updates to both standalone and cluster instances.
• Monitored maintenance jobs, including automated backups, index maintenance, statistics updates, and database integrity checks.
• Granted user permissions based on principle of least privilege.
• Configured replication from production to reporting servers, incorporating new tables as needed.
• Installed, configured, and maintained SQL failover clustering for production environments.
• Collaborated with system administrators on server commissioning and decommissioning.
• Ensured new database code met company standards for readability, reliability, and performance.
• Expertly performed installation, configuration, optimization, server builds, patches, service packs, upgrades, and troubleshooting of SQL Servers in both clustered and non-clustered environments.
• Routinely patched SQL servers using PowerShell scripts.
• Used SQL Server Profiler to generate traces for performance optimization.
• Automated server and database health checks using PowerShell scripts.
• Provided dedicated support for production database servers.
• Created and implemented backup and restore strategies following strict RPO and RTO guidelines.
• Configured and managed high availability solutions, including clustering, database mirroring, and log shipping.
• Experienced in migrating from SQL Server 2008, 2012, and 2014, and documented the complete upgrade process.
• Configured AlwaysOn for high availability as a disaster recovery (DR) solution.
• Maintained indexes regularly to ensure optimal performance.
• Scheduled jobs to automate various database-related activities, including backups and health monitoring.
• Designed and implemented SSIS packages to migrate data from multiple data sources.
• Troubleshooted and resolved performance issues, database integrity problems, and security issues.