ENEWAN UMOH
Hyattsville, MD, *****
ac52qm@r.postjobfree.com
PROFILE SUMMARY
Versatile and Resourceful Database Administrator (DBA) with extensive experience in designing, implementing, testing and supporting next-generation database solutions in Enterprise MS SQL Server environments including Windows Server 2012/2008 R2, SSMS, SSIS, and SSRS. Provides full life cycle of SQL Server database support across global enterprises. Creates high-level analyzed findings reports for management and clients specifically identifying database issues that leads to overall database health improvements. Proficient in technologies comprising MS SQL Server, Access, Excel and Windows. Excellent interpersonal and communication skills, ability to work collaboratively with other team members, juggle multiple priorities while enjoying sharing knowledge.
TECHNICAL SKILLS
Virtualization: VMware
RDBMS: MS SQL Server, MS-Access
Performance Tools: SQL Profiler, System Monitor, Performance Monitor, Database Tuning Advisor, Index Tuning Wizard, Extended Events, IDERA SQL Diagnostic Manager
ETL Tools: SSMA, SSIS, BCP, Import and Export Wizard
Reporting Tools: MS SQL Server Reporting Services (SSRS)
Operating Systems: Windows Server 2008/2012, Windows 2008/2012
Microsoft SQL Servers: SQL Server 2008/2008 R2, 2012, 2014
SQL Language Statements: DDL, DCL, TCL, DML
Migration: Detailed Migration and Mitigation plans
Documentation: Design Document of SQL Architectural design of the whole environment
CORE COMPETENCIES
Migration and Upgrades
Security & Database Permissions
Database Backup & Disaster Recovery
Database Performance Tuning
Database Monitoring
Capacity Planning
Performance Analysis
Project Management
Database Design
System Analysis
Always-On Technology
Troubleshooting
Critical Thinking & Problem Solving
Information Security Policies
Process Improvement
Meticulous Attention to Detail
PROFESSIONAL EXPERIENCE
SQL Server Database Administrator
Holistic Medical - Beltsville MD Dec 2014 - Present
Responsible for SQL Server Logical and Physical Database design, implementation, maintenance and capacity planning
Using IDERA SQL Diagnostic Manager to quickly pinpoint and predict database issues before they happen, from query monitoring to transactional application monitoring, getting built in tuning advise and best practices and guidance to address problem issues.
Installed SQL Server 2012R2 on WindowsServer2012Enterprise Edition Environment as well as virtual machines.
Used Unattended Installation of SQL server for the installation of multiple SQL instances to save time.
Configured high availability disaster recovery solutions, including Database Mirroring, SQL Server cluster and Always On Technology.
Configured and enabled Always-On to take advantage of the access to four endpoints in SQL Server 2012, 2014,2016
Performed data migration from different RDBMS to SQL Server using SSMA (SQL Server Migration Assistant)
Upgraded data to a modern data platform using DMA (Database Migration Assistant)
Applied Patches and Service Packs to keep the databases and OS at current patch level
Currently using EMC SAN storage.
Design, create and maintain ad-hoc and permanent reporting using any of the following technologies: SSIS, SSRS, SSAS.
Develops SQL Server Logins, Groups, Users and assigning roles and authentication modes as a part of Security Policies for Various Categories of User Support
I use PowerShell scripting for my automation and deployment of services.
Created a design document documenting the entire topology of the environment.
Scheduled jobs to automate different database related activities including Backup, Monitor Database health, Disk space and Backup verification with my scripted performance tuning jobs that run every day as part of my performance tuning steps to optimization of the environment.
Implemented troubleshooting of SQL Server performance issues using SQL Tools, execution plans, Trace, statistics, index tuning wizard, SQL profiler, DTA (Database Tuning Advisor).
Daily routine DBA tasks like handling user's permissions and space issues on Production and Development Servers and handling maintenance Jobs
Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics, partitions, Client/Server Connectivity and structure modification.
Maintains the Database Consistency Checks with DBCC at Regular intervals to optimize indexes.
Facilitated Data Migration to and from various sources using SQL Server Integration Services (SSIS and SSMA)
Worked and generated reports using SQL Server 2008 R2 Reporting Services(SSRS)
Assisted SQL developers to optimize SQL queries and Stored Procedures.
Created, scheduled and monitored scripted SQL jobs, making sure jobs run successfully every night
Created maintenance plans that helped in effective disk utilization and index maintenance
Developed a detailed designed document of the environment after stabilizing it.
SQL Server Database Administrator
AiNet - Beltsville, MD Oct 2013 – Nov 2014
Backed up databases using Full, Differential and Transactional log backup methods.
Restored Database from database backups and file backups. Experienced with Point-in-Time Recovery.
Ran DBCC statements to check physical and logical consistency of the database and rebuild indexes.
Performed and monitored Database Backup and other jobs in the maintenance plan Restoration and Point-in-Time Recovery.
Monitored Server Activity, Error Log, space usage etc. during capacity planning, and solved problems as needed
Maintained server level, database level and object level security best practices by creating logins and users, configuring permissions and assigning different roles to users.
Experience with Active Directory.
Configured database mirroring as part of the disaster recovery solution.
Configured Database Mail and SQL Server Agent. Created operators and proxies.
Created SQL Server Event, Maintenance Plans and Performance Condition Alerts.
Configured and administered Fail-Over Clustering, Transactional Log shipping, Replication and Database Mirroring.
Schedules and automates maintenance plans using SQL Server job agent
Performed database integrity checks using DBCC utilities and maintenance plan configuration wizard.
Created, reorganized and Rebuilt indexes and constraints.
Performed database migration and upgrade from SQL Server 2008 to 2012.
Install and apply Service Packs (SP) on SQL Server 2008 and 2012
Installed, configured, and administered MS SQL Server 2008 and 2012 Integration Services (SSIS) and Reporting Services (SSRS).
Performance tuning, maintaining and troubleshooting database problems
Developed a detailed designed document of the environment after stabilizing it.
SQL Database Administrator
Cisco Systems - Lagos Nigeria Mar 2010 – Sep 2013
Designed the backup and recovery strategies for SQL Server databases to meet SLA requirements.
Managed and maintained production Microsoft SQL Server 2008R2 on which the databases are hosted
Recommend and implement best practices for SQL architecture
Conducted database optimization and allocation of database resources for optimum configuration and performance
Implemented the methodologies and technologies that determine the flow of data within and between the various business systems and databases
Responsible for the identification and resolution of information flow and content issues
Monitored SQL servers and made necessary changes to optimize their performance
Installed, upgraded and migrated SQL server as necessary
Performed security checks on the databases and SQL servers
Assisted in the maintenance of the SQL user accounts; i.e. creations, changes, deletions, etc.
Assisted in providing a stable backup structure for the SQL databases and SQL servers
Documented the SQL server configuration, connectivity, function, reboot requirements, etc.
Assisted in troubleshooting to isolate and diagnose database and SQL server related problems
EDUCATION & CERTIFICATIONS
Bachelor of Science, Economics (B.Sc.)
University of Uyo, Nigeria
Administering Database, Microsoft SQL Server 2008/2012 (Implementation and Maintenance)
Strategic Intelligence Tech Institute – Laurel, MD United States
Microsoft Certified Solutions Associate (MCSA) Certification – In view