KENNETH ANYANWU

ad21o7@r.postjobfree.com 973-***-**** East Orange, NJ 07018

Career Summary

• Over 7+ years of IT experience as a SQL Server Database Administrator.

• Experienced in MS SQL Server 2005-2019 in Production, Testing Development Environments.

• Disaster recovery and plans, Backup/Restore, Database Mirroring, Log Shipping.

• Security, logins, users, permissions, roles management.

• Data migration, Performance Tuning, Query Optimization, Troubleshooting

• In-depth knowledge of analyzing Query Plans, Extended store Procedures.

• Strong team player with excellent communication skills. Skills

RDBMS:

MS SQL Server 2005-2022, ORACLE 11g,

12cOperating System: Windows, Linux,

UNIX

Network Topologies: TCP/IP, DNS, WINS,

DHCP, SMTP, FTP, FASP

Ticketing tool: Remedy, Service Now

Monitoring tool: CA Unified infrastructure

Management

Virtualization: VMware, Azure

ETL / Developer Tool: Oracle SQL

Developer, Microsoft Visual Studio

2012/2022, Import and Export Wizard,

Informatica Power center 9.6, 9.1

Performance Tools: SQL Profiler, System

Monitor, Performance Monitor

Database Tuning Advisor, Index Tuning

Wizard, Extended Events, IDERA

(SQL Diagnostic Manager), PowerShell

Ability to always remain calm and

diplomatic in a pressurized environment.

Excellent communication skills both written

and verbal.

Willingness to train and learn new skills.

Ability to prioritize workloads and multi-

task to always meet deadlines.

Experience

Overlook MDC, Hybrid NJ

SQL Server Database

Administrator, Database

Administrator/Production DBA

Support

10/2019 - Current

Environment: Windows Enterprise Server 2012, 2016,

,2019, 2022, SQL Server 2012, Visual Studio

Maintained best practice and provided adequate

documentation while installing SQL Server to optimize performance and implement better capacity planning strategy

Configured Database authentication parameters by creating users and groups with adequate permissions to satisfy the business need

Created indexes on tables (Clustered, Non-Clustered, Unique, Filtered indexes) for better and faster retrieval and update of data

Performed database table partitioning for efficient management of database tables and indexes

Configured transactional replication as a DR solution and supported it to ensure sync and consistency in the data set

Implemented backup and recovery strategies to

constantly secure the existing databases

Mirrored databases across servers in both Synchronous and Asynchronous modes for DR and HA purposes

Utilized PowerShell to run diagnostic scripts to check the health of the

Windows server, manipulate services and also automate processes.

Implored the use of SQL Server Agent Service to schedule jobs to automatically run backup processes, migrate data, stored procedures and

Index rebuilds Administered Transparent Data

Encryption (TDE) procedure on some of the very

sensitivity data

Employed the use of Extended Event Session for light weight tracing for performance tuning of databases

Migrated and supported Critical MSSQL Server database to AWS Cloud platform using DMS service

Supported Very Large databases (VLDB), maintaining its Performance and troubleshooting with SQL native & 3rd party tools (IDERA)

Utilized IDERA tool to monitor user privilege to the database and server to ensure that adequate access is audited, and the security of the existing data is

maintained

Installed and configured Windows Server 2012R2, 2016 Version on the VMWare to seat SQL SERVER

Clustered Windows Servers 2012R2, 2016 Enterprise Edition for SQL

Server failover Clustering setup

Installed and maintained 2 Node (Active-

Active) Cluster as a HA solution

Migrated Databases from SQL Server 2005 and SQL

Server 2008 legacy application to SQL Server 2012 with deprecation of clustering and mirroring

HA solutions and replace with AlwaysON solution

Configured AlwaysON Availability group across 3

replicas on SQL Serverversion enabling readable

secondaries to allow application connectivity on all replicas thus enhancing performance

Partitioned tables to allow the SQL Server engine to escalate locks to the partition level before the table level

Automated comprehensive backup plan, messaging

services on server failures, task completion and success

Enforced Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

K&C Technology

SQL Server Database Administrator

08/2017 - 09/2019

Environment: Windows Enterprise

Server 2012, UNIX, SQL Server 2016,

Visual Studio 2012, Excel, Azure

Confidential, Engages in commercial and retail

banking, electronic payment processing services,

and investment advisory services in the United

States

The Bank provides a range of financial products

and services to the retail, Commercial, Financial

Education and Medical Sectors

Environment: Windows Enterprise Server 2005,

2012, TSQL, Oracle 12c/11g, SQL

Analysts, Client team, Development team Capacity planning and upgrading SQL

Performed physical and logical Data Modelling for databases of varied sizes including

Responsible to provide 24x7 DBA and Production

support for over 150 Server database in Production on Clustered Servers

Setup and troubleshoot for Active/Passive Clustering in SQL Server 2005

Involved in assisting SQL Server prime customers with Configuration, Administration, implementation and

Trouble-shooting for business work flow with log

Shipping mechanism

Provided On-Call support to mission critical

environments and expertise with disaster recovery

mechanisms

Involved in auditing and performing the transactions to database and resolve the issues with performance

monitor and SQL profiler and used Net-Mon for

monitoring and performing network throughput issues

Resolved Issues for mission critical high usage of system CPU Disk, Deadlocks and Transaction per/sec, Memory

Helped application teams in query analyzing and its optimization, coordinated with users for downtime and maintained the system running 24x7

SQL Server database backup/restoration and recovery of SQL Servers

Implementation of Active directory, group policy in windows 2010

Tested the application for deployment, functional behavior

Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment

Upgraded SQL Servers database from version 2012 to 2014

Look after virus issue and the virus patches applied to the servers

Setup log shipping of production database to maintain the standby copy of production databases and for

offloading query processing from the production server

Worked with application Developer to design databases and tables to development activities and achieve optimal efficiency

Developed DTS (Data Transformation Services) Packages Created transact SQL scripts based on functional

requirement as defined by design documents, the

package does data transformation between MS Access and MS SQL Server 2005

Desktop Support Technician

Amazon

01/2016- 07/2017

Installed, set up, and maintained workstations to include workstation hardware components, base

operating systems, networking, software

environments resulting in a 30% increase in system efficiency.

Provided basic network support ensuring full

connectivity of desktop and other networked

peripherals, troubleshooting and resolving user

and site networking issues resulting in 25%

reduction in network downtime.

Performed preventative maintenance and setup for a variety of computer related equipment and

locations resulting in a 10% reduction in system

failures.

Conducted daily backup operations to ensure the

system data was safe and recoverable.

Education &Certification

Microsoft Certified Solutions Expect (MCSE), Administering SQL Server 2012/2014 USA

Microsoft Certified Solutions Associate (MCSA), Administering SQL Server 2012/2014 USA

Certified Registered Central Service Technician (CRCST) USA

Bachelor’s Degree in Computer Science (BCS), University of Calabar. Interests

I enjoy music, singing, reading, gym, country walks, photography, sport, and socializing.

Contact this candidate