CHUKWUEMEKA OKOYE

301-***-****) adz3m3@r.postjobfree.com

Highly qualified, creative, and hardworking SQL Server DBA with over six years of experience in managing SQL Server databases, configuring, and maintaining database servers and processes, monitoring system performance, and ensuring a high level of performance and security. Experienced in analyzing and correcting issues in real-time, providing suggestions, refining, and automating regular processes, and assisting developers with query tuning work. Eager to manage SQL Server and its operations. Strong track record of excellence and delivering high-quality, innovative work. Proven impact on reducing customer churn by 20%, increasing revenue by 15% every quarter, and improving workflow efficiencies. Eager to join the team to deliver excellent results for the company.

SQL Server 2019, 2016, 2014,

2012, 2008 R2

Windows Server 2019, 2016, 2012 R2, 2008,

Linux

VMware

Data Migration

SQL Server Migration

SQL Server to SQL Server

SQL Server to Azure VM-MI

PaaS

Azure

GCP

SQL

Docker

High Availability (HA)

Transparent Database Encryption (TDE)

Dynamic Data Masking (DDM)

SSIS

SSRS

Power BI

Tableau

SolarWinds

SQL Sentry

Brent Ozar Toolkit

AWS

PostgreSQL/Oracle

Kubernetes

SharePoint

Project Management

Microsoft Office

Multitasking

Time Management

Communication Skill

Learning & Development

Critical Thinking

Strategic Planning

Data Analysis

Process Improvement

Analytical Skills

Github

PL/SQL

S3

SQL SERVER DATABASE ADMINISTRATOR JULY 2018 – PRESENT

St Theresa Nurselink

Implemented SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various categories of users. Provisioned Databases and configured appropriate HA/DR strategy based on the RTO/RPO of the Business Division. Implemented Always-On Availability Group as a High Availability solution on SQL Server 2016. Used third-party tools such as SQL Profiler to analyze performance issues, Database Tuning Advisor for baseline synthesis, performance monitor for resource evaluation, and gathered information about the SQL environment using Database Management Views (DMV).

Created and deployed Tables, Indexes, Constraints, Views, Stored Procedures, Functions, and Triggers.

Monitored database status, including CPU, memory, I/O, space, and deadlock issues using SQL Server Utilities.

Created and supported ETL processes to SQL Server, Access to SQL Server, Excel to SQL Server.

Worked on setting up the SQL Server Configuration to resolve resource allocation and memory issues for SQL Server databases and set up ideal memory and min/max server options.

Managed and troubleshoot SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, Azure SQL, Azure Managed Instance, SQL VM Instances both on-premises and in the cloud.

Migrated and Upgraded SQL server from Legacy to 2016, 2017, & 2019 and Azure.

Supported Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).

Monitored regular backup and maintenance tasks for over 150 databases.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Wrote complex T-SQL queries using stored procedures, functions, and views.

Supported PostgreSQL and Oracle environment (software installation, cluster initialization, database and objects creation, security, performance tuning operations)

Worked with the front-end developers to deploy the reports.

Assisted in Multi-cloud migration, using AWS S3 bucket, Terraform, GCP Cloud SQL & Kubernetes, and Docker.

24 X 7 Production Database On-Call Support.

SQL SERVER DATABASE ADMINISTRATOR NOV 2016 – JUNE 2018

April 2 Ventures

Defined database security and enabled data distribution to the appropriate users. Applied new patches and versions as required with minimal downtime. Migrated data between database environments (development, test, production). Configured, Maintained, and troubleshoot Log shipping, Mirroring, AlwaysOn Availability Groups, replication SQL server Failover cluster on same and multiple subnets. Installed and configured SQL Server 2008 and 2012 on Windows server 2008. Monitored and reviewed database server error logs and space usage and addressed issues. Exported and imported data from text files and Excel to SQL Server using Bulk Insert and BCP utility.

Worked with the development team to optimize schema and performance.

Responsible for installing SQL Server and upgrading an existing SQL Server and ensuring the success of the upgrade.

Provisioned Databases and configured appropriate HA/DR strategy based on the RTO/RPO of the Business Division.

Installed stand-alone and clustered SQL Server 2008R2 and SQL Server 2012 on 64-bit systems with minimum access privileges service account to improve security and attain high ratings in SOC audits.

Planned and executed disaster recovery (DR) exercises on the DR servers.

Managed multi-terabyte production of both STANDBY and CLUSTERED systems using ACTIVE-PASSIVE Clustering.

Configured Server-Level/User-Level Security Strategy, Authentication Modes, configured database Logins/Users.

Used Import/Export Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel, and many other data sources supports ODBC, OLE DB Data Sources.

Migrated and Upgraded SQL server from Legacy to 2014 & 2016.

Performed Database Refresh tasks from production to Development servers.

Supported Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).

Maintained database response times in a 24X7 production environment and proactively generated reports.

Bachelor of Science in Computer Science Lagos State University Nigeria

Experience in Supporting thousands of SQL servers in a mission-critical and highly available environment.

Experience in Disaster Recovery Planning and Implementation.

Solid experience in High availability (Always-On) SQL Server solutions, including Replication Models. (Snapshot/Transactional), Log Shipping, Mirroring, and HADR Setup Configuration.

Experience in TSQL and Power Shell script for managing multiple tasks and automation.

Implementation of SQL Logins, Roles & Permissions.

Experience in Upgrade/Migration of MS SQL Server 2008 to 2012, and from 2012 to 2014/2016.

Proficiency in using Microsoft Office (Word, Excel, PowerPoint, Outlook, Project, Publisher).

Proficiency with SQL Server 2005/2008 / 2008 R2 / 2012 & 2014 optimization, fine-tuning, and scalability techniques with knowledge of SSIS.

Basic proficiency in dataset analysis with MS Excel or similar tools.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Strong interpersonal skills, written and verbal communication, decision-making, problem-solving skills, critical thinking, and testing skills.

Strong knowledge of MS Office products.

Ability to interact with staff at all levels.

Drive and willingness to stay up to date on trends.

Contact this candidate