Kenechukwu Enemuo

• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers following MS best practices.
• Created and implemented database designs and data models.
• Configured High Availability Solution always On Cluster, Traditional Failover Clustering and log shipping
• Troubleshooting and resolving issues that may arise with SQL Server
• Upgrading Databases from lower versions of SQL to higher version.
• Strong Experience with SQL Server 2008 through 2019 Administration standalone and cluster environments
• Configured and supported replication (Snapshot/Transactional/Merge/Peers to Peers) and log shipping in both SQL 2008 through 2019 Servers.
• Production level support for onsite and offshore - On Call 24/7 environment
• High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping
• Advanced skills in Monitoring Tools
• Query Store, Import/Export Wizard, SSMS, SQL Server Profiler, Extended Events and Tuning Advisor tools
• Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.
• Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Always On, Clustering, and Replication), TDE (Transparent Data Encryption)
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Experience with VM, Hyper-V
• Experience with partitioned schemas and tables, creating File groups using SQL Server.
• Experience in SQL Server Performance Tuning, Query Optimization, Client Connectivity and Database Consistency Checks Using DBCC.
• Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring user accounts, granting privileges to users and groups
• Applying Windows and SQL Server patches on Production/Non Production server.

· Upgrading SQL 2008 to 2019 in our environment

· Configured High Availability Solution- Always on Cluster, Traditional

· Fail-over Clustering, Database Mirroring and Log Shipping

· Installing and maintaining SQL Server database systems.

· Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with vendors to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery.

· Responded to and resolved all database access and performance issues.

· SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning, Advisor (DTA) for performance

· Upgrading SQL Server by reviewing, planning, testing, and installing database security patches and service packs.

· Design, documentation, and promote security best practices, policies, standards.

· Working with development and systems teams to perform application and database upgrades and tuning

· Migrating and upgrading SQL Server 2008 to SQL Server 2016.

· Setup and maintenance of appropriate database and application monitoring using Idea monitoring tool.

· Setup, test and maintain business continuity/disaster recovery infrastructure database and applications

· Setting up TDE, DDM, and always encrypted

· Configuring and monitoring, HA and DR solutions. AG, Log shipping, Replication, Fail-over clustering

· Setting up always on, replication and database mirroring