Tochukwu Kanu

• Installed, upgraded, and configured SQL Server 2012 - 2019 across various applications, ensuring integration with the latest service packs.
• Coordinated resource planning and application migrations, collaborating closely with project managers, application teams, and web app teams.
• Configured and managed Always On Availability Group on SQL Server, including setting up a primary replica and five secondary replicas for high availability.
• Conducted critical database migration, code deployments, and managed backups and recovery processes.
• Applied service packs and patches to MSSQL Server instances, both standalone and clustered, ensuring system security and stability.
• Implemented log shipping and database mirroring as part of disaster recovery strategies.
• Managed Windows Active Directory roles for SQL Server, ensuring appropriate server roles and database mappings.
• Executed point-in-time recovery operations, aligning with the company's RTO and RPO based on SLAs.
• Developed and optimized SQL queries, stored procedures, and views, contributing to system efficiency and scalability.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Write/maintain PowerShell scripts for DB automation and application maintenance.

Set up and monitor Always-On availability groups.
Monitor SQL server performance using Query Store, extended
events, and SQL profiler.
Set up maintenance jobs and alerts.
Troubleshoot and fix performance issues related to slow running
applications.
Run SQL server health check and implement best practices on
Microsoft SQL server databases and servers.
Install new instances of SQL server for staging and development
purposes.
Controlling access, permissions, and privileges Developing,
managing, and testing backup and recovery plans using both
SQL server level backups and third-party tools Upgrade and
migrate from SQL SERVER 2012 to 2019 (in place) and from SQL
server 2008 to 2016 (Side by side) Apply security patches.
Database and Server Security (setting up TDE, DDM, Always
Encrypted)