MTN Cameroon

o Install and configure SQL server 2012. o Use the monitoring tools to identify queries and optimize. o Make recommendations to improve and gain efficiency for existing processes. o Assist the database team and IT group with other administrative needs (maintenance, backups, restore). o Monitoring, production incident resolution o Assist in the product release process. o Review requirements and adhere to regulatory body guidelines and IT best practices. o Communicate change management procedures. o Help with other database projects and set goals to increase efficiency. o Implement database maintenance plans. o Apply Patches and Cumulative Updates to SQL Instances. o Perform health checks and monitor database server performance. o Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events. o T-SQL Writing skills. o Third party monitoring tools, SolarWinds, Idera, Razor etc. o Knowledge on Active Directory. o Virtualization (vSphere, VM ware, Hyper V. o Backup and restore (Rubrik). o SQL Networking, Activity Monitor. o Working Knowledge of SSIS and SSRS . o Working knowledge with ETL processes. o Reporting Services . o OLAP. o Working with Back-end client.

CVS Caremark

o Installation and configuration of new instances of SQL Server. o Implement best practices on Microsoft SQL Server Databases and Servers. o Monitor databases using inbuilt SQL Server tools and external tools. o Create and Manage SQL server Users, Roles, and Privileges (Principal of Least Pre villages). o Implement Active directory reset user’s password and create accounts. o Plan and implement database backups/restore based on company’s SLA. o Manage indexes (update statistics) to improve performance. o Configure database parameters and define data repositor. o Configure SSIS , SSAS and SSRS. o Schedule jobs, configure alert and monitor using SQL server agent. o Maintain database security as a high priority following company security policies. o Update security tables, database auditing and limiting data access to defined groups. o Tune T-SQL code to ensure optimal performance and data intergrity across very data set. o T-SQL writing skills. o Work in a collaborative agile environment. o Upgrade SQL Server databases from SQL Server 2012 to SQL Server 2019. o Performance tuning and Query Optimization (Indexes). o Exposure to Azure Fundamental (Cloud Computing experience). o Experience in deploying SQL Server Databases in Cloud Computing (Azure). o Migrating database to Azure SQL, Azure manages instance, instance SQL Azure VM. o Assessing on-prem environment for migration using Azure Migration assistant. o Create Azure SQL database. o Manage monitor and optimize the performance of SQL managed instances. o Automated backups using SQL Server Agent. o Automated maintenance tasks like index rebuilds and database statistics updates. o Automated database monitoring and alerting using SQL Agent and third-party tools. o Automated performance tuning using query optimization and database tuning advisor. o Automated database replication using SQL server replication. o Automated security auditing using SQL server audit.

CHEWY

o Installation of SQL Servers Instances using Microsoft best practice. o Implement HADR for all business-critical databases (Always on, Log shipping, Database mirroring and replication). o Implement/or improve database monitoring and capacity management tools globally. o across all data centers to detect performance issues and prevent potential outages before they occur. o Achieve maximum performance gain for overall database performance. o Knowledge of SSIS and SSRS. o Implement In-memory technology for heavily used databases. o Upgrade all SQL Server databases from SQL Server 2008,2012 to 2014/2016. o Apply Patches and Cumulative Updates to SQL Instances. o Perform health checks and monitor database server performance. o Proactively monitor and tune slow running queries. o Administer database security, Data encryption (TDE, AE and DDM). o Implement database maintenance plans. o Design and implement data replication strategies (transactional, snapshot and merge) o Migrate database using backup and restore, detached, and attached, log shipping and database mirroring both on premise and to Azure. o Creating Azure active directories . o Configure database instances as per industry’s best practices. o Perform health checks and monitor database server performance. o Proactively monitor and tune slow running queries. o Administer database security, Data encryption (TDE, AE and DDM). o Front-end. o Implement database maintenance plans. o Design and implement data replication strategies (transactional, snapshot and merge). o Configure database instances as per industry’s best practices.