Desmond Enoh
Houston,USA
Summary
Certified Senior SQL Server/Azure Database Administrator. Have over 9years experience in the design and administration of databases, as well as key skills in the modeling, development of enterprise architectures and the strategic collection and use of business intelligence. Proficient in technical software, languages, and tools, and able to learn new strategies quickly. Collaborative and team-oriented with first-rate oral and written communication, complex problem-solving and decision-making abilities.
Overview
9
9
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
MRI Software LLC
01.2021 - Current
- Optimized database performance by implementing index tuning strategies and query optimization techniques.
- Reduced downtime by proactively monitoring server health, identifying potential issues, and executing preventative measures.
- Ensured data integrity and security through the implementation of comprehensive backup and recovery plans.
- Provided technical support to application developers for seamless integration of databases within software solutions.
- Participated in troubleshooting efforts for complex database-related issues as part of a collaborative problem-solving approach among colleagues.
- Implemented regular performance monitoring and tuning strategies, proactively addressing potential bottlenecks before they impacted end users.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Supported projects enabling delivery efficiencies and technical resolution.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Managed database upgrades and migrations, ensuring minimal impact on end users and maintaining data consistency.
- Assisted in capacity planning by analyzing growth trends and forecasting future storage needs, facilitating timely infrastructure investments.
- Maintained documentation of database systems, providing a valuable reference resource for team members and stakeholders alike.
- Trained junior staff members on SQL Server administration tasks, fostering continued professional development within the team.
Database Administrator
Bank Of America
06.2017 - 01.2021
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters.
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
- Tested programs and databases to identify issues and make necessary modifications.
- Setting up and configuring database maintenance.
- Perform and monitor daily tasks such as Backups & Restores, maintenance jobs, handling developers' requests and user's permissions etc.
- Configure/setup Server Properties like Memory Options, Database parameter Settings etc.
- Checking Database Consistency/health by using DBCC &Commands DMVs at regular intervals.
- Administering relational Database in azure
- Implement a Secure azure Environment
- Deployment of Databases to Azure
- Perform Administration by Using T-SQL
- Perform Automation of Tasks
- Schedule and monitor maintenance activities including database consistency checks and index fragmentation.
- Configure Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.
- Rebuilding indexes with different fill factors and updating statistics.
- Relocation/migration of Databases from one server to another using attach and detach database tasks or backup and restore.
- Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
- Developed, updated, and organized databases to handle customer data -Tested programs and databases to identify issues and make necessary modifications.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
- Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Database Administrator
DXC Technology
12.2014 - 05.2017
- Providing 24/7 support for critical production databases
- Providing Primary DBA responsibilities for around 100 applications. - Migrated the SQL Server 2005/2008R2 to SQL Server 2014/16.
- Provisioning AWS EC2 instances and managing databases running in the cloud
- 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 Server 2022/2019/2017/2016/ 2014/2012/ 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 DBAs 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 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.
- 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.
- Monitoring SQL server performance to find deadlocks and blocking to improve the performance.
- Creation of logins, roles, assigning permissions and mapping users as per the client's request.
- Analyzing database health and consistency by using DBCC Commands and DMVs
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
Education
Master of Arts - International Trade
University of DSchang Cameroon
01.2014
Bachelor of Arts - Law
University of Dschang Cameroon
06.2012
Skills
- Administering relational Database in azure
- Query Optimization
- SQL Server Reporting Services
- Monitor and Optimize Operational Resources
- Teamwork and Collaboration
- Time management abilities
- Database Installation and configurations
- Microsoft SQL
- SQL Server database troubleshooting and query optimization
- Performing HA/DR techniques - Always On, Clustering, mirroring, and Always on Availability Group
- Data conversion and migration
- SQL Server Database Performance scalability and indexing
- Databases upgrading from lower to latest versions/migration/patching
- Continuous process improvement
- Replication and data synchronization among multiple servers
- Experience in SQL Server Integration Services (SSIS)
- Running backups
- Process Automation
- Performance Tuning
Certification
Azure Database Administrator. (DP-300)
Timeline
SQL Server Database Administrator
MRI Software LLC
01.2021 - Current
Database Administrator
Bank Of America
06.2017 - 01.2021
Database Administrator
DXC Technology
12.2014 - 05.2017
Master of Arts - International Trade
University of DSchang Cameroon
Bachelor of Arts - Law
University of Dschang Cameroon
Azure Database Administrator. (DP-300)
Similar Profiles
Colleen PettyColleen Petty
Manager - Lease Administration Services (Occupier) at MRI Software LLCManager - Lease Administration Services (Occupier) at MRI Software LLC
NICOLLETTE JOHNSONNICOLLETTE JOHNSON
Account Receivable Analyst at MRI Software LLCAccount Receivable Analyst at MRI Software LLC
Christina Massey OlsonChristina Massey Olson
Senior Operations Manager at MRI Software LLCSenior Operations Manager at MRI Software LLC