Ismaila Yekini

• Over 8 years of experience in Database Administration and Development for Very large and complex databases in SQL Server 2016/2014/2012/2008 R2/2008/2005 and Oracle 10g/11g • Expertise in installation of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 and updating with latest Service Packs, Hot fixes and Security Patches • Experience managing and monitoring Azure SQL Databases and SQL instances on Azure VMs • Experience in implementing and monitoring all types of High Availability & Disaster Recovery solutions like Always-on Availability Groups, Replications, Log Shipping, Database Mirroring and SQL Server Failover Clustering on production and test environments • Experience with in-place and Side-by-Side Migration of Microsoft SQL Server of different Versions on both production and QA/test environments • Experience in analyzing and resolving Locks, Dead Locks and handling the Isolation Level and Concurrency Effects. • Experience in Query Optimization, analyzing query execution plan and index management for optimal performance. • Experience with third-party tools like Foglight and IDERA for database monitoring and diagnostic. • Experience in managing SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. • Worked extensively on SQL Server consolidation projects to save operating cost and increase efficiency • Experience with capacity panning of databases and DATA/LOG files best practice • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle by using BCP utility, Data Transformation Services (DTS) and SQL server Integration services • Experience with SSIS package creation, deployment and debugging • Excellent skills in creating and altering SQL objects like Tables, Stored Procedures, Views, functions etc. • Experience in Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling native Backup/Recovery of databases, Database Maintenance Planning