Database Administrator

Quanta Services Management Partnership, L.P. - Houston, TX

Full-time

Houston, TX

Management of Companies and Enterprises

About the position

The Database Administrator role at Quanta Services is crucial for ensuring the availability, security, support, and integrity of the company's database platforms. This position involves the implementation and maintenance of SQL and Oracle databases, providing support to operating units, and utilizing various management tools. The ideal candidate will have a strong background in database server design, architecture, and performance tuning, contributing to the overall efficiency and reliability of database operations.

Responsibilities

• Perform daily DBA tasks including verifying daily backups and resolving backup-related issues.
• Verify health checks by reviewing database alert log errors and space usage.
• Confirm off-site sync and ensure database scheduled jobs are completed successfully.
• Resolve blocking, deadlocking, log shipping, connectivity, or security issues.
• Monitor database health and performance using Enterprise Manager (13c) or queries and provide recommendations based on monitoring results.
• Install, configure, monitor, and troubleshoot MS SQL Server systems in both non-clustered and clustered configurations.
• Maintain communication regarding ticket updates and progress.
• Participate in on-call rotation for database support.
• Maintain database documentation and standards.
• Work on projects as defined by the Manager of Database Systems.

Requirements

• Oracle Certified Associate (Preferred)
• MCSA for Microsoft SQL Server (Preferred)
• ITIL Foundation (Preferred)
• Experience administering complex 24x7 database environments
• Hands-on experience with Oracle Version 19c
• Hands-on experience with MSSQL Versions (2016, 2017, 2019, 2022)
• Experience with instance caging and resource management
• Good knowledge about partitioning and compression, including Exadata specific compression features
• Proven experience with Access Advisor, Segment Advisor, Memory Advisor, and other Oracle Advisor tools
• Familiarity with user, role, and profile management
• Comprehensive knowledge of RMAN backup and recovery
• Experience with flashback and restore points in Data Guard and non-Data Guard environments
• Experience with Data Guard failover/switchover process
• Experience with AlwaysOn failover process
• Extensive practice with Enterprise Manager
• Understanding of patching procedures and Oracle best practices

Nice-to-haves

• Knowledge about Azure/OCI is a plus