Active Directory Parker Hannifin

EUGENE UKPETENAN, BSc, DP-***

***** ******** **, ******** ** 77477

***********@*****.*** Tel: 281-***-****

OBJECTIVE.

A self-driven SQL Server DBA Professional and Leader with over 5 years plus extensive experience in Data Migration for On-Premises, SQL Server in Azure Cloud, Database Backup and Recovery/Disaster Recovery, Database Upgrade/Patches, Performance, Tuning/Troubleshooting, Security, Information Systems Auditing and High Availability Solutions. Impeccable attention to detail while working in a fast-paced outcome focused Enterprise environment, with ability to make decisions collaboratively and independently.

SKILLS.

Technical Skills

RMDBS: MS SQL Server 2000, 2005,2008,2012, 2014, 2016, & 2017.

SQL Server Tools: SSMS, SSIS, SSAS, SSRS, Profiler, Query Analyzer, PerfMon, Enterprise

Manager, BI Tools, IBM Tivoli, Redgate, Spotlight, Foglight, SiteScom, HP Polyserve,

LiteSpeed, Symantec Backup, DD-Boost Backup solution, and Quest, Double Take (Migration)

Programing Lang: T-SQL, PL/SQL, PowerShell, Java, C, C++, C#, Pascal, Visual Basic, COBOL, etc.

Operating System: Windows Server 2000/2003/2008/2012, 2016, NT, Linux

Migration: SSIS, DTS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Professional Summary

•7+ years of IT experience

•Extensive experience in SQL Server Database Administration from SQL Server 2000 through SQL server 2016.

•Proficient in SQL Server Performance Tuning, Installation, configuration, maintenance, and Upgrade

•Expertise in enhancing and deploying the SSIS Packages from development server to production server.

•Extensive experience in Database High Availability solutions using Mirroring, Log Shipping, Clustering (Active/Passive cluster), Replication, and AlwaysOn availability.

•Proficient in SQL Server Patching, Upgrade, Migration, Consolidation, and Virtualization.

• Knowledge of Storage Area Network (SAN) architecture and technology

•Experience in troubleshooting and resolving database integrity, performance issues, blocking, replication issues, connectivity issues, and security issues.

•Strong experience in upgrade SQL Server from one version to another and migrate databases from SQL Server 2000, 2005, 2008r2, 2012, 2014, 2016 to SQL Server 2017.

•Expertise in implementing Disaster recovery plan for SQL Server Database for BCP.

•Expert in SQL Server Patching, Configuration, Maintenance, and Performance Tuning.

•knowledge of Indexes creation and maintenance and application of Service Pack, and vulnerability patches.

•Cognizant of Databases security and SQL Server Hardening.

• Experience in monitoring, detecting, and troubleshooting SQL Server issues that are related to CPU, memory, I/O, disk space and other resource contention

•Extensive knowledge in Backup-Recovery that meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)

•Experience in DTS using Business Intelligence tool - SSIS, SSRS, & SSAS.

• Knowledge of installation and configuration of SQL Server performance monitoring tool.

•Technical background along with the ability to perform business analysis and write effective documentation and specifications

WORK EXPERIENCE

PARKER HANNIFIN Houston TX August 2018 Present

Responsibilities

SQL Server DBA

•Build new SQL Servers and updated with latest service packs and cumulative patches (hot fixes) for SQL Server 2012/2014/2016/2017

•Configured and Managing Always on High Availability on 2/3 nodes cluster environments.

•Migrated SQL Server 2008R2 databases to SQL server 2014/2016 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.

•Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012/2014/2016/2017.

•Upgrade QA and DEV SERVERS 2008R2 to 2016 on developer edition.

•Prepared Documentation for the Disaster Recovery plan.

•Managing Databases spread across multiple servers in Production, Development, staging & testing environments.

Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and Troubleshooting Failed Jobs.

•Troubleshoot Performance issues causing Application slowness.

•Created SSIS jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.

Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.

Created Linked servers for distributed queries.

•Hands-On experience on Replication set-up and troubleshooting.

•Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active Directory Group.

•Provided 24x7 DBA Production support for Databases in Production on Clustered and standalone Servers to achieve Optimum Performance.

CSAT SOLUTION Houston Texas February, 2016 - July, 2018

Database Administrator

Dataplex Integrated Sys Ltd. Remote. 09/2016 – 10/2017

SR. SQL Server DBA

•Build new SQL Servers and updated with latest service packs and cumulative patches (hot fixes) for SQL Server 2008/2008R2/2012/2014.

•Ensure all database environments (Development, QA, UAT and Production) are coordinated (DB Refresh when requested)

•Troubleshoot Performance issues causing Application slow.

•`Adhere to SQL Server databases recommended best practice, instance Hardening, and Database security

•Perform 24x7 production support and on call rotation in supporting databases to achieve maximum performance and uptime.

•Ensure all databases are backed up in a way that meets the business’s Recovery Point Objective (RPO) and Recovery Time Objectives (RTO).

•Perform all Database related activities such as Database Backup, Restore, Troubleshooting, Performance Tuning, activity monitoring, maintain and create SQL server maintenance plans, etc.

•Implement and maintain security rules; maintain Audit security policies; maintain state of Audit readiness; and cleanup database logins.

•Successfully configured Active/Active/Passive cluster and installed multiple SQL Server instances for the cluster.

•Lead in implementing TDE for databases encryption and TLS encryption for data in transit.

•Installed and configured a SQL 2012 clustered environment with AlwaysOn High availability groups.

•Install and configure SQL Server with minimum access privileges for service accounts and logins to improve security and attain high rating in auditing.

•Responsibilities include recovery, import/export, replication of data, and scheduling of tasks

•Duties included disk configuration, tuning, documenting architecture, and reviewing developers’ codes as they move through development, test, Stage, and production environments

•Implement Trigger to maintain data integrity and consistency.

•Plan and coordinate database migration between systems and environments.

•Provide optimal database file layout for utilization of storage and performance acceptable to client.

•Administering cluster failover and load balance technologies as per client requirement.

•Involve in periodic Disaster Recovery exercise in preparation for actual disaster.

•Maintain, configure, and monitor database availability solutions. I.e., Mirroring, Log Shipping, Clusters, Availability Group, and Replication.

•Analyze long running slow queries and tune the same to optimize application and system performance.

Responsible for monitoring and making recommendations for performance improvement in hosted databases

CERTIFICATIONS

• B.sc Computer Science.

• Microsoft DP-300

Contact this candidate