Oracle Database Administrator

GH PARTNERS LLC
United States
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$110,000.0 - $140,000.0
Working hours
Regular working hours

Tech stack

Artificial Intelligence Code Review Databases Continuous Integration Oracle Data Guard Operational Databases Oracle Databases Oracle (Applications) Oracle Rac Performance Tuning Oracle Apex Standard Sql
+14 more
Runbook Session Management SQL Stored Procedures PL-SQL SQL Databases Backup and Restore Apex Code SQL Plan Management Oracle Enterprise Manager Information Technology Production Code Patch Management Software Version Control User Accounts

Job description

GH LLC is looking for a hands-on, technically deep Oracle DBA to serve as the primary Oracle database administrator on a small but high-impact Database Services team. You will report directly to the Database Services Manager, who serves as your secondary DBA and organizational point of contact, but day-to-day database administration, performance management, and technical decision-making will be yours to own.

Our Oracle environment centers on a two-node RAC cluster with Data Guard standby, supporting core business operations. The databases are production-critical and in active use. There is meaningful work ahead - performance tuning, index and storage remediation, security hardening, a version upgrade, and a server infrastructure migration on the horizon - and we are looking for someone who can build a stable, well-managed foundation over time.

We understand that walking into a new environment takes time. You will be given the opportunity to acclimate, learn the system, and get your footing before being expected to drive major changes. Sustainable, well-understood work is the goal - not speed at the expense of stability. What You’ll Be Walking Into

Several initiatives are already underway or in planning, and you will be inheriting them in various stages of progress: Active Work

  • Index rationalization and remediation on high-volume production tables
  • SQL execution plan stabilization across critical workloads
  • Space reclamation on production storage
  • Connection pool configuration and session management review

Near-Term Roadmap

The following are planned initiatives. Prior experience with any of these is a plus, but not a requirement - what matters most is the ability to learn, plan, and execute methodically.

  • Oracle patching schedule development and ongoing patch management
  • Oracle version upgrade planning and execution - the upgrade will also be the gate for several downstream projects
  • Oracle APEX and ORDS deployment for internal tooling - scoped to begin after the version upgrade is complete
  • Lower environment refresh process design and automation
  • Privilege and password security hardening across the Oracle environment
  • Table partitioning evaluation and implementation for large, high-growth tables
  • Documentation and operational runbook development
  • Server infrastructure migration - managed by our external DBA vendor, Datavail - you will have visibility and input, and your perspective will be valued as someone who will live with the outcome

Core Responsibilities Production Database Administration

  • Serve as the primary Oracle DBA for a production RAC environment with Data Guard standby
  • Monitor and tune performance using Oracle Enterprise Manager, AWR, ASH, and ADDM
  • Manage storage, capacity planning, and tablespace health
  • Maintain a proactive patching and version management schedule
  • Respond to production incidents, diagnose root cause, and implement durable fixes
  • Manage backup and recovery procedures in coordination with infrastructure team

Performance & Optimization

  • Investigate and resolve SQL plan instability using SPM baselines and SQL Profiles
  • Design and maintain indexing strategies aligned with actual application usage patterns
  • Tune connection pools, RAC-specific configuration, and parallel execution settings
  • Identify and remediate locking, contention, and wait event issues

Security & Standards

  • Manage Oracle user accounts, roles, profiles, and least-privilege service accounts
  • Enforce session controls, password policies, and audit configurations
  • Partner with the development team on stored procedure design, code review, and change management
  • Maintain and build out DBA documentation, runbooks, and operational standards

Collaboration & Projects

  • Work closely with application, development, and infrastructure teams
  • Coordinate with Datavail on infrastructure-layer and migration tasks
  • Contribute to project planning and provide technical input on architecture decisions
  • Support APEX and ORDS administration as the internal footprint grows post-upgrade, Senior Oracle APEX and Database Administrator responsible for design, administration, performance tuning, upgrades, backup/recovery, and lifecycle management of Oracle databases and APEX/ORDS environments across DEV/QA/PROD. Provide Tier 3 support, automation, CI/CD contributions, and coordinate upgrades with cross-functional teams. Top Skills: APIsAutomation ScriptingCi/CdEbsLinuxMicrosoft Sql ServerMySQLOciOracle ApexOracle Data GuardOracle Database 19C+OrdsPdb/CdbPl/SqlPostgresRmanUnixWeblogic Symbiotic Group Inc.

Oracle Database Administrator

12 Days Ago Remote Senior level Senior level Information Technology * Professional Services * Sales * Consulting Lead Oracle database migration and modernization efforts across on-prem and cloud environments. Design, implement, and tune multi-tenant Oracle databases (10g-19c+), configure advanced features (Data Guard, RAC, TDE, OEM), perform backup/recovery, troubleshoot complex issues, ensure security/compliance, and document/transfer knowledge to stakeholders. Top Skills: CloudGisJavaLinuxOracle 10GOracle 11GOracle 12COracle 19COracle Data GuardOracle ObieeOracle OemOracle RacOracle TdeSQLUnixWindows Cencora

Program Manager

9 Hours Ago Remote Mid level Mid level Healthtech * Logistics * Pharmaceutical Manage and supervise execution of assigned projects within a program delivery model: coordinate tasks and schedules, monitor compliance and data quality, prepare status reports, deliver training, and escalate risks to protect timelines and outcomes. Top Skills: ExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft Word

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Requirements

  • 5+ years of hands-on Oracle DBA experience in production environments
  • Strong expertise in Oracle 19c (or comparable recent version) administration
  • Proven production experience with Oracle RAC and Data Guard
  • Strong SQL and PL/SQL proficiency - you read and write production code, not just run scripts
  • Experience with Oracle Enterprise Manager for monitoring and diagnostics
  • Proficiency with AWR, ASH, ADDM, and execution plan analysis
  • Ability to independently diagnose and resolve performance issues
  • Comfortable operating with broad ownership in a small team environment
  • In-office presence three days a week is required
  • Pre-employment background and drug screenings are required

Strongly Preferred

  • Experience with Oracle patching and version upgrade planning and execution
  • Index lifecycle management, partitioning, and large table reorganization
  • SQL Plan Management (SPM) and SQL Profiles
  • Connection pool administration experience (DRCP or shared server)
  • Lower environment refresh process design or automation
  • Oracle APEX and/or ORDS administration
  • Exposure to infrastructure or storage migrations
  • Experience writing and maintaining technical documentation and runbooks

Nice to Have

  • Oracle Certified Professional (OCP) or equivalent certification
  • Background in financial services or transaction-processing environments

Who We’re Looking For

The right person for this role is a technician first. You are most comfortable when you are diagnosing something, fixing something, or building something - not in meetings talking about doing those things. You are methodical under pressure, you document your work, and you do not consider a problem solved until you understand why it happened.

You are not deterred by a backlog or by imperfect documentation. You have walked into environments that needed attention before, and you approached the situation as an opportunity rather than a liability. You know how to prioritize, communicate tradeoffs to non-technical stakeholders, and build trust through steady, reliable execution.

You will have real ownership here. Your recommendations will be heard, your expertise will be respected, and the work you do will have a direct and visible impact on the stability and performance of systems that matter to the business.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.builtincolorado.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

2:50 min

Introduction and the value of runbooks

Hila Fish · WWC 2023

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:48 min

Daily responsibilities and alignment practices for technical engineering leadership

Edoardo Dusi · LIVE

1:32 min

Structuring automated incident workflows between runbooks and raw models

Aram Hakobyan Aram Hakobyan +1 · WWC Europe 2026

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all