Summary
Overview
Work History
Skills
Timeline
Generic

DAVID MBIU

Houston,TX

Summary

Highly skilled SQL Server Database Administrator with over 7 years of experience in managing production databases in high-growth, fast-paced environments. Holds a Bachelor's degree in Information Technology and possesses deep expertise in database security best practices, performance optimization, and cloud database management. Proficient in designing and deploying high availability solutions, implementing advanced data security measures, and utilizing Amazon services for cloud-based database management. Adept at using Azure DevOps for CI/CD pipelines, IaaS, PaaS, and automated deployments. Committed to improving system reliability and efficiency through proactive monitoring, performance tuning, and adherence to Site Reliability Engineering (SRE) principles. Excellent problem-solving abilities, strong interpersonal skills, and a dedication to delivering high-quality results.

Overview

8
8
years of professional experience

Work History

SQL Server Database Administrator

Highroad Technologies Inc.
Houston, TX
03.2019 - Current
  • Database Administration and Performance:
  • Over 7 years of experience managing production MS-SQL databases, ensuring high performance and reliability.
  • Expert knowledge and application of database security best practices.
  • Designed and optimized database objects to enhance performance and efficiency.
  • Created tables, views, functions, stored procedures and other database objects.
  • High Availability and Disaster Recovery:
  • Configured and maintained high availability solutions, including Always On Cluster, Traditional Failover Clustering, Database Replication, and Log Shipping.
  • Setup, tested, and maintained business continuity and disaster recovery infrastructure.
  • Troubleshot complex SQL queries to identify problems or potential improvements in performance.
  • Installation and Upgrades:
  • Installed, configured, upgraded, and applied patches to Windows and SQL Server environments, including versions 2016 and above.
  • Conducted thorough reviews, planning, and testing for seamless upgrades and security patch installations.
  • Researched new features available in the latest version of SQL Server software to determine their usefulness.
  • Cloud and Amazon Services:
  • Designed, deployed, and managed databases in the Amazon cloud.
    Familiar with databases, DB, and other Amazon services.
  • Utilized Azure DevOps for CI/CD pipelines, IaaS, PaaS, and automated deployments.
    Proficient in creating and managing release pipelines.
  • Monitoring and Maintenance:
  • Monitored database logs and set up alerts to proactively address performance issues.
    Created and monitored maintenance plans and SQL Server Agent Jobs for backups and index defragmentation.
  • Experience with SQL Server Profiler, Extended Events, Query Store, and Database Engine Tuning Advisor (DTA) for performance tuning.
  • Monitored and optimized database performance using indexes, stored procedures, triggers, and other techniques.
  • Security and Data Protection:
  • Recommended and implemented advanced data security tools such as Always Encrypted, Transparent Data Encryption (TDE), and Dynamic Data Masking (DDM).
  • Designed, documented, and promoted security best practices, policies, and standards.
  • Maintained disaster recovery plans including backup schedules and testing procedures for recovering from unforeseen events.
  • Virtualization and Migration:
  • Installed and configured virtualization platforms such as VMWare and Hyper-V.
  • Managed database migrations to new servers, including database refreshes, detach and attach operations, and decommissioning old servers.
  • Customer Service and Communication:
  • Provided excellent customer service, meeting the needs and expectations of internal and external customers.
  • Demonstrated strong listening and interpersonal communication skills to identify and address critical issues.
  • System Reliability and SRE Principles:
  • Applied Site Reliability Engineering (SRE) principles to improve system availability, reliability, and operational efficiency.
  • Proactively monitored systems, responded to incidents, and learned from failures to enhance system resilience.
  • Documentation and Best Practices:
  • Maintained comprehensive documentation covering database design, configuration, playbooks, and troubleshooting guides.
  • Demonstrated accuracy and productivity in a dynamic environment with constant interruptions.

SQL Server Database Administrator

Dril-Quip
Houston, TX
02.2016 - 02.2019
  • Developed and implemented strategies to ensure data integrity, reliability, and availability.
  • Monitored and optimized database performance using indexes, stored procedures, triggers, and other techniques.
  • Designed databases in accordance with industry best practices for scalability, security, reliability, and performance.
  • Created tables, views, functions, stored procedures and other database objects.
  • Performed daily maintenance tasks such as backups, restores and log shipping operations.
  • Troubleshot complex SQL queries to identify problems or potential improvements in performance.
  • Implemented replication between multiple servers to ensure high availability of the system.
  • Configured security settings to protect against malicious activities such as unauthorized access or data tampering.
  • Provided technical support for applications that use the database system by troubleshooting errors or providing advice on optimizing queries.
  • Reviewed query execution plans to identify inefficient code or recommend index changes for improved performance.
  • Automated routine tasks using PowerShell scripting language to streamline processes and reduce manual workloads.
  • Maintained disaster recovery plans including backup schedules and testing procedures for recovering from unforeseen events.
  • Analyzed existing databases for opportunities to improve efficiency through restructuring or re-indexing.
  • Researched new features available in the latest version of SQL Server software to determine their usefulness.
  • Deployed patches and upgrades according to established change management policies.

Skills

  • Data Warehousing
  • Disaster Recovery
  • Capacity Planning
  • Performance Tuning
  • Monitoring: Prometheus & Grafana, Idera
  • DBMS: MySQL, SQL Server
  • Languages: Bash Shell Scripting, MSSQL

Timeline

SQL Server Database Administrator

Highroad Technologies Inc.
03.2019 - Current

SQL Server Database Administrator

Dril-Quip
02.2016 - 02.2019

Similar Profiles

CREATE PROFILE
DAVID MBIU