NAME EMMANUEL NJEI

adjmwr@r.postjobfree.com

● +1-281-***-****

Currently working with Frontline Insurance, has exper se on administering Microso SQL Database servers. Demonstrate commitment to superior customer service through posi ve a tude, leadership, and teamwork and also possess the ability to clearly communicate intricate technical solu ons to business users, resul ng in successful implementa on. To seek an organiza on where my abili es and talents will be u lized to the fullest and where my desire to succeed will be an asset. I am seeking a posi on where I will be given an opportunity to work effec vely and efficiently. Total Experience: 10+ yrs of IT experience and 8+ years of MSSQL DBA experience, 2 years of Azure could DBA experience, 1+ years of Sybase DBA experience, and 1 year of AWS cloud experience.

● Working in Frontline Insurance as DBA, Lake Mary Florida from 16 Dec 2019 to ll now.

● Worked as DBA for Texas Department of Criminal Jus ce, Huntsville Texas from 30th October 2017 to 30th November 2019

● Worked as a Database Administrator for Sobha Engineering and Contrac ng LLC, Dubai from September 9, 2012 to June 30th, 2017.

Opera ng systems: Windows 10, Window server 2008 and 2012.

Database: MS-SQL 2008 up to 2019

Cloud compu ng: Azure and AWS

Monitoring tool: Spotlight, PRTG Network Monitor and Sentry one

Tool: SharePoint, MS Office, PowerShell.

SQL technologies: Always-On AG, Failover Cluster, Log-shipping, replica on

● Microso Azure Administrator.

AZ-104: Microso Azure Administrator

● MCSA (Microso Cer fied Solu on Associate)

70-764: Administering a SQL Database Infrastructure

70-765: Provisioning SQL Databases

Summary

Career Objec ve

Professional Experience

Technical Skills

Cer fica ons

● Microso professional training for MS SQL, Kiawitech Academic.

● Microso Azure training for Azure cloud compu ng, Kiawitech Academic.

● CloudEndure Disaster Recovery Technical Training, AWS training and cer fica ons

● Adventure ISA- Informa on and Security Awareness and Acknowledgment and Rules of Behavior (ROB) Training, AGLearn.

● Insider Threat Awareness, Center for Development Of Security Excellence (CDSE)

(A) Working as a MS SQL DATABASE Administrator at Frontline Insurance Period :

Dec 16 to ll date

Role : MSSQL DBA.

Environment : SQL Server 2014, 2016, 2019

Roles and Responsibility:

● To assist the customer and Incident Management team (24/7 support) to drive down the number of Incidents by iden fying the root cause. Perform Post Incident Review on major incidents.

● Maintaining more than 20+ Produc on servers in different domains and 34+ Dev and Test Servers.

● Used powershell to Automate tasks and create jobs.

● Installing, configuring, administering, and securing clients' produc on and non-produc on servers.

● Incidents by iden fying the root cause. Perform Post Incident Review on major incidents.

● Doing System and Subsystem Health check analysis.

● Service now tool - Change request, process request, incident cket and Service cket ac vity.

● Spotlight and PRTG Network monitoring tool for alert analysis, iden fying and implemen ng for MS SQL warning & Cri cal alerts.

● Used Ola Hallengren maintenance solu on to set a maintenance plan on y DB servers

● Configured SQL 2016 Always-ON Availability solu on for PROD environment.

● Monitoring and performance tuning of SQL Server databases.

● Log shipping, Mirroring and Replica on configura on and managing.

● Iden fy and resolve SQL Server Database locks and hardware-related issues, using SQL Server Profiler And SQL Server Query Tuning where necessary, to resolve Performance slow-downs due to blocking and Other index issues, etc.

● Involved in op mizing code and improving efficiency in databases including re-indexing, upda ng Sta s cs, recompiling stored procedures and performing other maintenance tasks.

● Coordinate with developers for Op miza on and improvements of Database Design.

● Maintained Database authen ca on modes, crea on of users, configuring permissions and assigning Roles to users.

● Query Op miza on and performance tuning of long running queries.

● Secure data in database using

TDE Transparent Data Encryp on,

Always Encrypted and

Column/Cell Encryp on

● Backup and restora on of database.

Making a Strategy, planning and policy for DB backup

Managing FULL, Differen al and Transac on backup

Recovering system and user databases

● Database DATA Archival plan and ac vity.

Professional Training

Technical Records

● Data Transfer (One/Mul Direc on Replica on, SSIS/ DTS Crea on, Snapshots of mirrored databases)

● Migra on databases from on-prem to AZure.

● Create backup jobs to refresh PROD to STG on AWS using powershell.

● Very convenient in using PowerShell and T-SQL to manipulate, transform and execute data to obtain dis nct results.

(B) Worked as MS SQL DBA for Texas Department of Criminal Jus ce, Huntsville Texas Period :

30 October,2017 to 30 November,2019

Role : MS SQL DBA/Azure DBA.

Environment : SQL Server 2012, 2016 Azure and AWS

Roles and Responsibility:

● Performed all day-to-day aspects of MS SQL database administra on. Responsibili es include database design, installa on, configura on, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup, and recovery, troubleshoo ng and problem resolu on

● Configured High Availability Solu on- Always-On Cluster, Tradi onal Failover Clustering, Database Mirroring and Log Shipping

● Run SQL server health check and Implement best prac ces on Microso SQL server databases and servers

● Controlling access, permissions, and privileges

● Troubleshoot and fix performance issues related to slow running applica ons

● Troubleshoot and reduce complex database and query issues to zero

● Document all server processes and create documenta on showing SQL server Topology

● Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical databases. Crea ng and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Func ons and Triggers etc. as requirement on SQL Server Environments

● Used Service Now for Change Request and Ticke ng system.

● Responded to and resolved all database access and performance issues

● Oriented other database administrators on SQL Server management including upgrades and migra on

● Ensured databases adhere to corporate standards and policies, including database audi ng

● Used Data Encryp on technologies like Transparent Encryp on and always encrypted for data security.

● Installed SQL Server 2008, 2008R2, 2012, 2014 and 2016 on advanced servers, applied security fixes

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

● In charge of Server Lease Replacement, Server Decommissioning for the en re Datacenter

● Azure Cloud professional with strong experience in migrating application and IT infrastructure to public cloud, Azure, DevOps, Azure Administration, Azure Infrastructure Operations and end to end Project management.

● Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.

● Strong expertise in MS Azure security and identity services including but not limited to Azure Active Directory, Domain Services, Azure Security Center, Azure Governance, Security, Authentication, MFA, Authorization, B2C, Data Privacy, Identity and Access Management (IAM), Cryptography / Key Management, Access Controls and Security Protocols

● Hands-on experience in managing configuration, Windows Azure Migration, Deployments, maintenance, software application & hardware devices with a focus on systems and Windows Azure environments.

● Displayed quality skills in planning & designing servers for backup & recovery in Azure, restoring application/VMS etc. in case of crash/ emergencies & maintaining high availability with configuration.

● Having Experience on Data center servers and handling TB databases.

● Troubleshoo ng Sybase database issues, crea ng and gran ng user access, crea ng maintenance plan tasks as well as monitoring the logs and crea ng database mail to email me the health of the servers fixing any issues that may occur. Worked as a Database Administrator for Sobha Engineering and Contrac ng LLC, Dubai Period :

September 9, 2012 to June 30, 2017.

Role :

SQL DBA.

Roles and Responsibility:

● Configured High Availability Solution- Clustering, AlwaysOn, Database Mirroring and Log Shipping.

● Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical databases. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as requirement on SQL Server Environments.

● Planning and implementation of Database backup/restore and disaster recovery

● Installed SQL Server 2012 on advanced servers, applied security fixes.

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

● Implementation of snapshot isolation and DDL triggers

● Configured and supported replication and log shipping in both SQL 2008 and 2012.

● Maintained database response times in 24/7 Production environments.

● Monitoring standby Databases to ensure high availability

● Automation of DBA Tasks and monitoring

● Configured and managed Contained Database

● Configured and supported replication and log shipping in both SQL 2008 and 2012.

● Used Azure Active Directory authentication

● Firewall Rule, Trigger, Change Data Capture (CDC) etc.

● MS SQL Database Administra on in SQL 2008 up to 2019.

● SQL Server high availability – Always ON, Clustering, Log Shipping and Replica on.

● Installa on of Windows Server and clients with networking.

● MS Azure

● AWS

● Sybase database

● PowerShell and T-SQL

Name Emmanuel Mbah Njei

Marital Status : Married

Gender : Male

Languages Known : English

Educa on : Associate of Science in Civil Engineering. Exper se

Personal Details

Contact this candidate