Brice Ngea

Microsoft Sql Server Database Administrator @Kiawitechit Academy

24/7 Production Database Administration, Support and Monitoring to ensure a proactive problem recognition and resolution of database issues.• Installation of SQL Server in standalone and Clustered environments.• Provide DBA support and technical expertise for multiple applications in development, test, QA and production using SQL Server, 2012, 2014, and 2016, 2017 and 2019 environments.• Configured High Availability Solution like Always-On, Traditional Failover Clustering, Database Mirroring and Log Shipping• Upgrading databases from lower to higher versions of SQL Server.• Performing vertical and horizontal migration in SQL Server • Administering, managing, developing and configuring SQL Server database designs following best practices• Troubleshooting and resolving issues that arise with SQL Server• Performing database migration from an on-premise SQL environment to Azure Databases• Developed, implemented and documented Disaster Recovery (DR) Plans• Tested, implemented different Backup and Recovery methods - Point-in Time, Media Recovery.• Implemented maintenance jobs • Daily health check-up of all databases.• Performance Tuning for optimized results using tools like, Sentry one, and Solar Winds Monitoring Tools• Database Design/Data Modeling.• Documenting all my processes in a step- by -step manner to keep up with a good knowledge sharing policy within the team and the entire company• Deployed Database Security Policy and Installation, using Passwords, Privilege.• Applying SQL Server and OS patches to all database servers.• Designed and implemented comprehensive Backup plan and disaster recovery strategies• Rebuilding the indexes at regular intervals for better performance.• Responsible for Stored Procedures optimization, Performance tuning & index tuning.• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers