Uploaded File
add photo
Mudia
mudiedo1@gmail.com
404-388-7218
0Mudia Edokpayi
Mudia
MS SQL Server Database Administrator II
8 years experience W2
0
Recommendations
Average rating
2
Profile views
Summary

Skilled Database Administrator bringing more than 7 years of experience in the administration of databases, as well as key skills in the modeling and warehousing of data. Proven skills in security management, database maintenance and establishing backup and recovery process to safeguard data. 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.

SKILLS

  • Experience working with various SQL versions; SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2019.
  • Worked on linked server to setup Heterogeneous connections coming to SQL Server from ORACLE, TERADATA, MS Access, DB2, etc.
  • Experience working with CAB Process implementing Incident and Change management modules.
  • Monitor Performance PERFMON used to resolve system hardware bottlenecks and DBCC utilities for database consistency checks.
  • Extensive work on setting up FCI Clustering, AlwaysOn Availability Groups (AG), Mirroring, Log Shipping and Replication as HA and DR solutions for Business Continuity strategies.
  • Worked on Excel to make good reports and build reports with the team using SSRS.
  • Experience as SQL Server DBA in multiple client enterprises and SCRUM/Agile and ITIL environments.
  • Collaborated on numerous management initiatives, including Data security, data Management & Data Retention, Resource tracking, Change control, disaster Recovery Planning and High Availability.
  • Extensive work on Performance tuning of long running queries and troubleshooting bottlenecks.
  • SQL Server Database Backup/ Restore processes with SQL native and Quest Lite Speed.
  • Migration of databases with enterprise upgrades from SQL Server versions to higher versions and cloud (AWS / Azure).
  • Experience with building DR plans and performing DR Test exercises.
  • Experience with Installation, configuration, administration, maintenance, performance tuning, security, SSIS, SSAS & SSRS administration.
  • Creation of database maintenance plans, SQL Agent jobs, setup alerts and operators.
  • Hands on experience on Replication for load balancing and Data autonomy.
  • Extensively used SQL and system counters to monitor bottlenecks on the disk IO and throughputs.
  • SQL Server Profiler Trace and Quest tools like spotlight for identifying query bottlenecks causing performance issues.
  • Extensive knowledge in Microsoft SQL Server databases as well as SSIS, DTS packages, T-SQL and performance tuning.
  • On call Production DBA for 24 x 7 in an OLTP Mission critical systems/environment.

Experience
MS SQL Server Database Administrator II
Information Technology
Jan 2017 - present
  • Administered and maintained over 150 database servers of Production, QA, Development, standalone and Test environments in various MS SQL Server environments.
  • Identified and quickly addressed database performance issues by continuously monitoring systems to ensure minimum downtime.
  • Documented best practices for ongoing production support.
  • Provided ongoing database support including database performance tuning, monitoring database health, maintenance of database users and security, coordinating with storage team on capacity planning and storage distribution.
  • Setting up DB Maintenance Jobs for DB Backups, BD Integrity Check, DB Re-indexing, and update stats.
  • Maintained database schema, tables, stored procedures, constraints, indexes, functions, views and more.
  • Worked closely with infrastructure team for patching and hardware upgrades and ensured that both production and test servers are up to date by applying Windows and SQL Server patches.
  • Designed, implemented, and administered High Availability solutions. (Failover Clustering, log shipping, mirroring, Always ON availability groups and replication).
  • Reviewed security, performance, and disk space and recommended corrective actions where needed.
  • Performed installations, patching, upgrades, and installations of SQL Server versions. (SQL Server 2012 /2014 /2016 /2017/ 2019).
  • Responsible for maintenance, Backup & Recovery, testing, alerts, job failures etc. and database integrity checks.
  • Experience in Microsoft Azure and migrating on premises SQL databases to AWS Cloud.
  • Automated DB refreshes production to QA/ Staging/ Development based on user requests or application team needs.
  • Created database objects like tables, views, indexes, stored
  • procedures, triggers, cursors using T-SQL.
  • Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2016.
  • Monitored disk space usage, memory and connections and Databases for lock escalation, dead lock, resource utilization by sessions, package caching, buffer pool hit
  • ratios.
  • Setup Transactional and Snapshot Replication and made sure data was in sync.
  • Scheduled Differential, Full and Transactional log backups for users and system databases in production using SQL Agent.
  • Ran DBCC Consistency checks and fixed data inconsistency databases.
  • Worked with Development, QA, Application Engineering, Release Management, and Project Management Teams.
  • Setting up Log Shipping and DB Mirroring for DR Servers.
AWS Data Replication Database Backups Database Upgrades DBA MS Azure Performance Tuning Production Support Project Management SQL SQL Server Stored Procedure T-SQL Triggers Windows
Remove Skill
MS SQL Server Database Administrator
Information Technology
Nov 2014 - Jan 2017

CLIENT: COMCAST

  • Engaged in Strategic Planning, Implemented and supported high availability (HA) and disaster recovery (DR) solutions via log shipping and database mirroring along with proper backup strategies across multiple SQL Server instances.
  • Responsible for Data center migration and Disaster Recovery site built.
  • Installed, built, and configured SQL Server with standard access privileges service account to improve security and attain high rating in SOX audits.
  • Database Administration including installation, configuration, upgrades, performance tuning, backup, and recovery in managing clusters of SQL servers.
  • Monitoring of Servers using SQL Sentry third party tools that extend across all platforms and data centers.
  • Designed, Implemented, and maintained database schema, entity relationship diagrams, data modeling, tables, stored procedures, constraints, indexes, functions, views, rules, defaults, and complex SQL statements.
  • Resolved and tweaked memory pressures caused during production release.
  • Used scripts and SQL Agent jobs to automate database maintenance task.
  • Standardized processes for the database team by creating documentations for Installations, migrations, upgrades, backups, restores, index maintenance etc.
  • Developed and optimized stored procedures, triggers, SSRS reports and SSIS packages.
  • Installed and configured SQL Server 2008R2 Clustering on Microsoft Clustering Services (MSCS) for Active
  • Passive and Active
  • Active Cluster Nodes.
  • PL/ SQL Programming.
  • Understanding of TCP/ IP networking environments.
  • Migrated databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014.
  • Involved in analyzing and upgrading SQL Server 2005 and 2008R2 test and Production servers to SQL Server 2012 and 2016 with AlwaysOn AG configuration of up to 4 replicas and enterprise DB Cluster.
  • Involved in troubleshooting and finetuning databases for high performance and concurrency.
  • After Hours and weekend support for any Database maintenance related activity.
Data Center Data Modeling Database Backups Database Upgrades DBA Disaster Recovery Performance Tuning SQL SQL Server SSIS SSRS Stored Procedure TCP/IP Triggers
Remove Skill
Junior Database Administrator
Information Technology
Feb 2013 - Apr 2014
  • Troubleshoot disk, network, memory, and CPU related performance issues on high volume OLTP servers.
  • Configured and administered Microsoft SQL Server 2000 and 2005 for approximately 50 database servers, and 100+ databases.
  • Assisted in establishing standards and schedules for database backups by making sure that the backup schedules meet the recovery requirements on a daily, weekly, and monthly basis.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Created new database logins and users as required.
  • Rebuilt and reorganized indexes at regular intervals for better performance.
  • Helped team handle high-volume work by prioritizing tasks and organizing supplies.
  • Created reports that ran daily for jobs running in SQL Server Agent.
  • Worked as on call support DBA in a 24/7 environment on a weekly rotational basis.
Database Backups DBA OLTP SQL Server
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Process Engineering
University of Lagos | Lagos 2016
Bachelor's in Chemistry
University of Benin |Edo 2011
Skills
Database Backups
2021
7
DBA
2021
7
SQL Server
2021
7
Database Upgrades
2021
6
Performance Tuning
2021
6
SQL
2021
6
Stored Procedure
2021
6
Triggers
2021
6
AWS
2021
4
Data Replication
2021
4
MS Azure
2021
4
Production Support
2021
4
Project Management
2021
4
T-SQL
2021
4
Windows
2021
4
Data Center
2017
2
Data Modeling
2017
2
Disaster Recovery
2017
2
SSIS
2017
2
SSRS
2017
2
TCP/IP
2017
2
OLTP
2014
1
Agile Methodology
0
1
DB2
0
1
HA
0
1
Load Balancing
0
1
Microsoft Excel
0
1
Oracle
0
1
SSAS
0
1