Data Service

DESMOND ATAH ENOH

Houston, Texas

Cell : +1-346-***-****

adhuzx@r.postjobfree.com

SQL SERVER DATABASE ADMINISTRATOR

Dedicated and hardworking SQL Server Database Administrator with 6 years of experience in supporting and managing database applications. Successfully managed database across multiple servers in production, development, staging and testing environments. Committed to ensuring complete database organization and security. Excel at database modification and improvement. Exceptional analytical, problem-solving, and communication skills. Worked on several projects. Excellent attention to details and experience with numerous types of database software. Strong individual/team oriented spirit, READY to learn and face new challenges

SKILLS

Experience in general SQL SERVER Administration 2019/2017/2016/2014/2012/2008/2005

Database Installation and configurations

Experience in performing HA/DR techniques - Always On, Clustering,

Database mirroring Always On Availability Group

Replication and data synchronization among multiple servers

Experience upgrading databases from lower to latest versions/migration/patching

SQL Server database troubleshooting and query optimization

SQL Server Database Performance scalability and indexing

SQL Server Stored Procedure Design and implementation skills

Expert understanding of Database best practices

Operational automation

Database security and user management

Backup/Restore monitoring, memory check, administration and maintenance

Experience in SQL Server Integration Services (SSIS)

Experience in SQL Server Reporting Services (SSRS)

TOOLS

COMMVAULT, REDGATE, CONFLUENCE, SOLARWINDS and JIRA

SQL SERVER DBA

Bank of America

Dallas, TX June 2017- October 2020

Responsibilities:

Providing 24/7 support for critical production databases of Bank of America Data Centers.

Providing Primary DBA responsibilities for around 100 applications.

Migrated the SQL Server 2005/2008R2 to SQL Server 2014/16.

Managed 2000+ databases and few huge databases, which are more than 7TB.

Installed SQL Server 2008/2012/2014/2016 in both Standalone VM’s and Physical clusters server to support multiple business applications

Installed MS SQL 2008/2012/2014/2016/2017/2019 on production, Test and Development boxes.

Worked as part of a project to provide DBA support from VM spin off/ installation/configuration/administration of SQL Servers for new applications (begin to end support).

Experience in planning for the backup and recovery strategy to meet the business SLA’s for RTO & RPO using SQL native backups tools to schedule (FULL, DIFF, translog backups) and other third party tools like Fog Light(Monitoring tool) and Litespeed(Backup tool).

Administering the MS SQL Server 2016, 2012, 2014 & 2012,2008 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Experience in planning and deploying SQL SERVER HARD technologies like Always On AAG, log shipping, Transactional replication, mirroring and resolving related issues that may arise because of failures

Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.

As part of the team, I worked on upgrading /migrating over 50+ SQL Server instances from SQL 2005/2008 to SQL Server 2012 &2014 after careful planning and testing to support the business critical applications.

Very experienced scheduling and automating some SQL server mundane activities like database update stats, DBCC check, index rebuild, Backup jobs and database clean up jobs using native tools and by using some scripts. Also, work on getting alerts in case of any failures of these jobs.

Very experience in reviewing the SQL SERVER error logs and windows event viewer, troubleshooting, and SQL SERVER related issues reported.

Involved in General Database Administration, Query Performance tuning by using different techniques and tools like SQL profiler, checking on locking and blocking as per queries ran from the app, index maintenance, Activity monitor, DMV’s, Perfmon and resource Monitor etc.

Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.

Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.

Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.

Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

Developed a few reports using MS SQL Reporting Services.

Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

Experience in review overall database design and propose good ideas as per organization data changes

Involve in weekly refreshes/clone of production database using backup/restore method to UAT and Development environments for developer and QA engineers to mimic production data for their testing

Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.

Worked closely with the development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.

Extracted data from various sources like SQL Server 2008/2012/2014/2016/2017, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.

Working with Jira service Desk (Any changes on staging and development environment need to Create Nexus Tickets).

Working with Maximo Change Request (Any changes in Production database need to Create Maximo Tickets this should be approved by Global DBA team after changes made in stage and development environment).

Involved in all ITIL processes like Change management, Incident Management & Problem Management.

Environment: Microsoft SQL Server 2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third party tools Red gate, SolarWinds, Azure, log shipping, Mirroring, Always On etc.

SQL SERVER DBA

DXC Technologies

Houston –TX Jan 2015 – May 2017

Responsibilities:

Maintaining 400+ SQL Servers with multiple instances in different environments (RTE, DEV, Pre-prod and Production) and proficiency in deploying new code base release to UAT and Production Environments.

Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server2017/2016/ 2014/2012/2008R2/ 2008/ 2005 in standalone and cluster environments and applying service packs, hotfixes and cumulative updates.

Implementation of automated jobs for database backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

Troubleshooting and resolving day-to-day issues such as job failures, transactional log issues, blocking and deadlock issues, permission issues etc.

Migration, creation and configuration of databases based on the specifications sent by the client and meet the SLA (Service Level Agreement)

Administering database security by creating logins, users, groups and managing roles and privileges assigned to them. Also, used database auditing in auditing for suspicious database activities.

Implemented TDE on some critical database and database table with sensitive data to adhere with SOX and PCI compliance.

Experience and work as part of a team of DBA’s to do monthly test of backups and restore and perform DR drilling scenarios

Work on a project to review all server instances brings them update with service packs and also upgraded most of old and legacy applications running on older versions to support SQL Server 2014.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Created proper Indexes on different tables that improve the performance of T-SQL queries on the database.

Using TSQL for developing stored procedures to enhance the performance of the database system.

Maintaining the Database Consistency with DBCC commands.

Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, and troubleshooting space issues.

Set up Database Maintenance Plans to reorganize, rebuild and update the index statistics for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Configured log shipping, database mirroring (Synchronous & Asynchronous) and replication (transactional and snapshot) for synchronization of databases.

Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS. Created and deployed various reports using SSRS.

Used SSIS jobs for importing data from the flat files that brings the data to the application tables.

Creation of logins, roles, assigning permissions and mapping users as per the client's request.

Performing SQL Server service pack and Windows Service pack upgrades.

Scheduling JOBS (Daily, Weekly, and Monthly) as per the client request.

Experience in performance tuning of the server, SQL instances, database and queries ran from applications. Help analyze long running and slow queries and tune them using different techniques and tools like SQL PROFILER, execution plans, DMV’s, tracing locks, blocks and killing them as needed to improve application and system performance.

Automated messaging services on server failures, for task completion and success

Executed stored procedures requested by the application team to accomplish short-term business goals.

Handling Memory configurations for SQL Server and responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Running Database tuning wizard and continuously monitoring and updating the Backup and Recovery strategy.

Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Implementation of Database maintenance plan for Database consistency & Integrity

Monitoring SQL server performance to find deadlocks and blocking to improve the performance.

Analyzing database health and consistency by using DBCC Commands and DMVs.

Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices.

Environment: Microsoft Windows Server 32/64 bit, DB2 10.5/11.1 Linux, IBM Data Studio, Windows Enterprise Server 2012/2014, SSIS, SSRS, PowerShell ISE, .NET, T-SQL, SQL Server Enterprise Edition 2014.

Education Background :

BACHELOR DEGREE IN LAW (UNIVERSITY OF DSCHANG CAMEROON)

MASTER'S DEGREE INTERNATIONAL TRADE AND INVESTMENT LAW (UNIVERSITY OF DSCHANG CAMEROON).

Contact this candidate