ORACLE DATABASE ADMINISTRATOR

Oracle Database AdministratorGH 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.Active WorkIndex rationalization and remediation on high-volume production tablesSQL execution plan stabilization across critical workloadsSpace reclamation on production storageConnection pool configuration and session management reviewNear-Term RoadmapOracle patching schedule development and ongoing patch managementOracle version upgrade planning and execution - the upgrade will also be the gate for several downstream projectsOracle APEX and ORDS deployment for internal tooling - scoped to begin after the version upgrade is completeLower environment refresh process design and automationPrivilege and password security hardening across the Oracle environmentTable partitioning evaluation and implementation for large, high-growth tablesDocumentation and operational runbook developmentServer 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 outcomeProduction Database AdministrationServe as the primary Oracle DBA for a production RAC environment with Data Guard standbyMonitor and tune performance using Oracle Enterprise Manager, AWR, ASH, and ADDMManage storage, capacity planning, and tablespace healthMaintain a proactive patching and version management scheduleRespond to production incidents, diagnose root cause, and implement durable fixesManage backup and recovery procedures in coordination with infrastructure teamPerformance & OptimizationInvestigate and resolve SQL plan instability using SPM baselines and SQL ProfilesDesign and maintain indexing strategies aligned with actual application usage patternsTune connection pools, RAC-specific configuration, and parallel execution settingsIdentify and remediate locking, contention, and wait event issuesSecurity & StandardsManage Oracle user accounts, roles, profiles, and least-privilege service accountsEnforce session controls, password policies, and audit configurationsPartner with the development team on stored procedure design, code review, and change managementMaintain and build out DBA documentation, runbooks, and operational standardsCollaboration & ProjectsWork closely with application, development, and infrastructure teamsCoordinate with Datavail on infrastructure-layer and migration tasksContribute to project planning and provide technical input on architecture decisionsSupport APEX and ORDS administration as the internal footprint grows post-upgradeRequired5+ years of hands-on Oracle DBA experience in production environmentsStrong expertise in Oracle 19c (or comparable recent version) administrationProven production experience with Oracle RAC and Data GuardStrong SQL and PL/SQL proficiency - you read and write production code, not just run scriptsExperience with Oracle Enterprise Manager for monitoring and diagnosticsProficiency with AWR, ASH, ADDM, and execution plan analysisAbility to independently diagnose and resolve performance issuesComfortable operating with broad ownership in a small team environmentIn-office presence three days a week is requiredPre-employment background and drug screenings are requiredStrongly PreferredExperience with Oracle patching and version upgrade planning and executionIndex lifecycle management, partitioning, and large table reorganizationSQL Plan Management (SPM) and SQL ProfilesConnection pool administration experience (DRCP or shared server)Lower environment refresh process design or automationOracle APEX and/or ORDS administrationExposure to infrastructure or storage migrationsExperience writing and maintaining technical documentation and runbooksNice to HaveOracle Certified Professional (OCP) or equivalent certificationBackground in financial services or transaction-processing environmentsWho We're Looking ForThe 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.