Resume

Sign in

Sql Server Maintenance

Location:
Hyattsville, MD
Salary:
$120,000
Posted:
June 29, 2018

Contact this candidate

Resume:

ENEWAN UMOH

Hyattsville, MD, *****

240-***-****

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



Contact this candidate