Sr. Oracle Core DBA

at  TopBuild

We are looking for individuals who are eager to develop and apply their skills in ways that make a positive impact to communities. Here, you’ll be proud to be a part of a company known for putting safety and people first, combined with uncompromising integrity.
Job Description
We are looking for a senior Oracle database administrator with enterprise experience in managing Oracle Database environments. You will be responsible for designing, installing, configuring, tuning, troubleshooting, and maintaining Oracle databases in a high availability environment supporting the company ERP. You will also provide technical support, troubleshooting, and problem resolution for complex database issues. The perfect candidate would be expected to work with members of the App-Dev teams as well as functional and QA teams. This is a senior role that expects attention to detail and critical thinking to be exercised on an ongoing basis.
This is a remote position.

Responsibilities

• Install, configure, upgrade, patch, and maintain Oracle databases on VMWare platforms, ensuring optimal performance, availability, and security.
• Implement and manage RAC Oracle database clusters, including backup, recovery, failover, and disaster recovery, using tools such as RMAN, Data Guard, and Flashback.
• Perform database performance tuning, optimization, and monitoring using various tools and methods, such as AWR, ADDM, ASH, OEM, SQL Tuning Advisor, SQL Plan Management, etc. Identify and resolve performance bottlenecks, optimize SQL queries, and implement best practices for database performance.
• Ensure database security, integrity, availability, and compliance with best practices and standards. Implement and enforce database security policies, roles, and privileges, and audit database activities. Apply patches and updates to address security vulnerabilities and bugs.
• Develop and maintain database documentation, policies, procedures, and scripts. Automate and streamline database tasks and processes using scripting languages such as Shell, Perl, Python, etc. Create and maintain documentation for database design, configuration, operation, backup, recovery, and disaster recovery.
• Collaborate with other IT teams and stakeholders to deliver database solutions that meet business requirements. Provide guidance and support for database design, development, testing, and deployment. Troubleshoot and resolve database issues in a timely and effective manner.
• Provide on-call support and troubleshoot database issues in a 24/7 environment. Diagnose and resolve complex database problems, such as corruption, recovery, locking, contention, etc. Escalate and communicate issues to management and vendors as needed.
• Manage and migrate database workloads to Oracle cloud, leveraging cloud services and features to optimize database performance, scalability, and availability.

Qualifications

• Bachelor’s degree in computer science, Information Systems, or related field, or equivalent work experience.
• At least 10 years of experience as a core Oracle database administrator in an enterprise environment, with exposure to Oracle 11g, 12c, 19c and later versions.
• Strong knowledge and experience with Oracle database architecture, administration, backup, recovery, RAC, ASM, Data Guard, RMAN and Rubrik. Ability to design, implement, and manage high availability and disaster recovery solutions for Oracle databases.
• Proficient in Oracle database performance tuning, optimization, and troubleshooting using tools such as AWR, ADDM, ASH, OEM, SQL Tuning Advisor, etc. Ability to analyze and optimize database performance, identify, and resolve performance issues, and implement performance improvement strategies.
• Experience with Oracle database installation, configuration, and management on VMWare platforms. Ability to leverage VMWare features and capabilities to optimize database performance and availability.
• Experience with scripting languages such as Shell, Perl, Python, etc. Ability to automate and streamline database tasks and processes using scripts.
• Experience with managing and migrating database workloads to Oracle cloud, using cloud services and features such as Oracle Database Cloud Service, Oracle Autonomous Database, Oracle Cloud Infrastructure, etc.
• Excellent communication, analytical, and problem-solving skills. Ability to communicate effectively with technical and non-technical audiences, and work collaboratively with cross-functional teams.
• Critical thinking and attention to detail skills. Ability to apply logical and analytical thinking to complex database problems and ensure accuracy and quality of database solutions.
• End-to-end process understanding and ownership. Ability to manage the entire database lifecycle, from design to deployment to maintenance, and ensure alignment with business objectives and expectations.
• Certification in Oracle Database Administration is a plus.

Travel Requirements
Travel Required: Limited
Compensation
Salary, bonus, 401k, Health Insurance, PTO
Physical Requirements
Work is performed while remaining in a stationary position and may require standing, bending, lifting boxes or packages under 10 lbs., and sitting for extended periods of time.
The employee must be able to perform the essential functions of the position. Upon request and absent undue hardship, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of the job.
TopBuild is an Equal Opportunity Employer.

• Install, configure, upgrade, patch, and maintain Oracle databases on VMWare platforms, ensuring optimal performance, availability, and security.
• Implement and manage RAC Oracle database clusters, including backup, recovery, failover, and disaster recovery, using tools such as RMAN, Data Guard, and Flashback.
• Perform database performance tuning, optimization, and monitoring using various tools and methods, such as AWR, ADDM, ASH, OEM, SQL Tuning Advisor, SQL Plan Management, etc. Identify and resolve performance bottlenecks, optimize SQL queries, and implement best practices for database performance.
• Ensure database security, integrity, availability, and compliance with best practices and standards. Implement and enforce database security policies, roles, and privileges, and audit database activities. Apply patches and updates to address security vulnerabilities and bugs.
• Develop and maintain database documentation, policies, procedures, and scripts. Automate and streamline database tasks and processes using scripting languages such as Shell, Perl, Python, etc. Create and maintain documentation for database design, configuration, operation, backup, recovery, and disaster recovery.
• Collaborate with other IT teams and stakeholders to deliver database solutions that meet business requirements. Provide guidance and support for database design, development, testing, and deployment. Troubleshoot and resolve database issues in a timely and effective manner.
• Provide on-call support and troubleshoot database issues in a 24/7 environment. Diagnose and resolve complex database problems, such as corruption, recovery, locking, contention, etc. Escalate and communicate issues to management and vendors as needed.
• Manage and migrate database workloads to Oracle cloud, leveraging cloud services and features to optimize database performance, scalability, and availability