Achem Otui Ebai

Fort Worth, Texas ***** 682-***-**** adyo3i@r.postjobfree.com

Professional Summary

* ***** ** ********** ** Database Administration working with SQL Server 2019,2017,2016, 2014, 2012, 2008, 2005.

Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup, and recovery, troubleshooting and problem resolution.

Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.

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

Planning and implementation of Database backup/restore and disaster recovery

Installed SQL Server 2005-2019 on following Microsoft best practices, applied Patches and security fixes.

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

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

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

Monitoring standby Databases to ensure high availability

Automation of DBA tasks using PowerShell scripts and monitoring

Configured and managed Contained Database

Managed and provisioned Azure SQL databases and services.

Configured and supported Replication, Mirroring, AlwaysOn Availability Group, Traditional Failover Clustering and Log shipping.

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

Installed and configured MS SQL Server VM in Azure Database

Proficient in SSIS, SSRS, SSAS

Skills

Microsoft SQL server 2005, 2012, 2014, 2016, 2017, 2019

Windows server 2008, 2012, 2012 r2, 2016, 2019

Microsoft office suite (Word, Excel, power point, office 365)

Windows Remote Desktop

Service manager

Service Now

Active directory

Windows (7,8,10)

Hyper-V, VMware Workstation

SolarWinds

Jira

SQL Server Tools SSMS, Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSASRDBMS MS SQL server 2005/2008/2012, MS Access, ETL DTS, SSIS,SSRS,SSAS

Work History

MS SQL SERVER DBA, 04/2021 to present

DEBAI Investment, Fort Worth, Texas

Planning an Installation of Microsoft SQL Server 2005SP4, 2008R2, 2012, 2014, 2016, 2017, 2019, building, designing, Configuration, Upgrade, Migration and application of Windows and SQL Patches during scheduled database nonproduction hours to ensure databases are up to date in Virtualized environments

Implement and define vigorous Backup and Recovery strategy and Capacity planning following company's SLA that is Recovery Point Objective (RPO), Recovery Time objective (RTO) and Retention policy

Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and also with technologies such as Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure client’s sensitive data

Using SQL server in-built tools such as SQL Server profiler, Extended Events, activity monitor to monitor performance and system health; Database Integrity checks to ensure database integrity, stability, and system availability.

Configured High Availability (HA) and Disaster Recovery (DR) Solutions on production in standalone and Clustered environments such as Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WTFC), Database Mirroring, Replication such as transactional replication and Log Shipping to make sure the databases are always available and participating in disaster recovery.

Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues, updating statistics for query optimization using performance and activity monitor, event viewers, extended events.

Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems.

Create and update database documentation about company standard procedures, technology features and production issue troubleshooting.

Analyze, solve and correct issues in real time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes and assisting developers with query/index tuning, Partitioning, compression and updating statistics to enhance speed and maximize system performance.

Creating and monitoring maintenance plans and agent jobs that automates backups and reorganize/rebuild indexes for query performance.

Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing on call support during after-hours and weekends. Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24 x 7 support.

Review scripts submitted by the development team and working with other teams like systems analysts, developers, business analysts, and project teams to perform capacity planning required to create and maintain the Databases.

Control and establish appropriate database user access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases. Develop database security guidelines and perform audits.

Migrate SQL server databases from on prem to AZURE using Data Migration Assistant.

Develop and monitor system and application alerts to ensure Health monitoring and performance tuning

Create and maintain azure managed SQL instances and databases

Resolve highly complex, technical, and escalate support incidents. troubleshoot and diagnosis issues in SQL Server environment.

Installed and configured SSIS, SSAS, SSRS

Implementation of SQL Logins, Roles and Authentication Modes as part of Security Policies for various categories of users.

Rebuilding indexes at regular intervals for better performance in large datasets

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitored and modified Performance using execution plans and Index tuning.

Deploying new code base release to UAT and Production Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Working with customers on Application rollouts and server migrations.

Extensively worked on Enterprise Manager for managing database.

Troubleshoot performance problems and fine-tuning of databases.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrating SQL Server 2000 data bases into SQL Server 2005.

Database Administrator 03/2018 to 02/2020

Ditek International Group, Fort Worth, Texas

Manage infrastructure performance, data security and make recommendations for improvements

Manage infrastructure performance, data security and make recommendations for improvements

Assist in monitoring and review of Strong analytical, planning, and organizational skills with ability to manage competing demands

Managed data security in our environment by creating Logins/Users and granting them permission according to principle of least privilege. Also performed database Encryption: TDE, Always Encrypted and Dynamic Data Masking

Involved in planning, setup, and implementation of new servers across the entire enterprise

Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.

Planned and deployed monthly windows and SQL server patches.

Planning and implementation of Database backup/restore and disaster recovery

Create and work on High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Writing basics TSQL scrips, stored procedures, functions and triggers, data transformations using BIDS

Implementation of snapshot isolation and DDL triggers

Migration of SQL Server 2005 servers to SQL Server 2008

Stable Replication Topology

Installed SQL Server 2008 on advanced servers, applied security fixes

SQL Server Upgrade

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

Installed and configured MS SQL Server 2008 R2, supported all Production and development servers

Maintained database response times in 24X7 Production environments

Developing SQL scripts for maintaining administration tasks

Capacity Planning and resource allocation

Monitoring standby databases to ensure high availability

Troubleshoot, resolve issues related to computer software and hardware controlling production equipment application

Production level support for onsite and offshore Clients

Support Patch Management

Education

Advanced MS SQL Server Hands-on DBA training - 2022

Bachelor’s in Computer Science and Information Technology - 2023

South Texas College – McAllen, Texas

Contact this candidate