Messiah A. Email & Phone Number

Houston, TX, US

Boise, ID, US

• SQL Server DBA, my duty is to manage and maintain SQL Databases through multiple tiers, including Development, Staging, QA, and Production.I also deliver proactive assisting in migrating/upgrading from lower versions.
• Designed, configured, and maintained High Availability and Disaster Recovery solutions, including Windows Failover Clustering, Always-On, Log Shipping, and Replication.
• Performed Database Refresh as requested, and backup databases using backup compression in SQL server databases
• Performed Database Migration and upgrade from a lower version to a higher version.
• Assisted Engineering team in applying data modeling techniques to ensure development and implementation.
• Automated maintenance jobs on Databases using different maintenance solutions and scripts.

Houston, Texas, US

• In this role, I was responsible for delivering applicable database solutions to meet stability, reliability, and performance metrics.It was my duty to build, maintain, and support SQL Server High Availability and.
• Implemented SQL Server Security Auditing, hardening, and remediation.
• Wrote/coded logical and physical database descriptions, specifying database identifiers to management systems.
• Automated routine maintenance tasks, including routine database refresh requests using SQL Server Agent, Maintenance Plans, and PowerShell scripts.
• Performed backup using backup compression and data compression in SQL server databases.
• Maintained and troubleshot SQL performance issues by cycling the SQL Server error logs, Activity monitor, DTA, BCC, DMV's, and SQL profiler.

US

• In this company, my duty was to lead daily data management activities, including end-to-end database support, such as installing/configuring/upgrading SQL Servers, database migration, and troubleshooting.
• Contributed to installing, upgrading, configuring, and migrating SQL server in clustered and non-clustered production environments of SQL server.
• Setup and configured SQL Server Clustering on Window Failover Clustering Service.
• Configured always on for providing AlwaysOn high availability (HADR) in both synchronous and Asynchronous modes as per application requirements.
• Designed and handled High Availability and Disaster Recovery solutions such as Windows Failover Clustering, Always-On, DB Mirroring, Log Shipping, and Replication).
• Uncovered and resolved the mission-critical issue of high usage of system CPU, Disk, blocking issues and transaction per/sec, and memory involved in performance monitoring of Memory, Processor, and Disk I/O.

• During this role, I was managing SQL Server databases through multiple product lifecycle environments, from development to critical production.I provided training to non-technical users and answered technical support.
• Scaled solutions and optimized processes using DBA knowledge to perform database architecture tasks.
• Gathered, outlined and refined requirements, led design processes, and oversaw project progress.
• Created and implemented complex business intelligence solutions.
• Applying data modelling techniques to ensure development and implementation.
• Headed the upgrading of the Microsoft SQL server, failover clustering, log shipping, and replication.