Senior Oracle Database Administrator (DBA)/Developer

Oak Ridge National Laboratory•Oak Ridge, TN

About The Position

The Senior Oracle Database Administrator (DBA)/Developer will design, maintain, and optimize the Oracle database environment for the Neutron Systems Engineering and Support group, which provides technical expertise and computing support to the Neutron Science Directorates and the Neutron Upgrades Project Office. The position combines deep database administration expertise with strong development skills to architect reliable data solutions while collaborating with end users, application developers, and infrastructure teams. The role reports directly to the Neutron Systems Engineering and Support group lead in the Research Computing Support Division at Oak Ridge National Laboratory. The successful candidate will take ownership of database reliability and application delivery, communicate clearly with technical and non-technical stakeholders, and apply a continuous improvement mindset. The position supports ORNL’s mission and values of Impact, Integrity, Teamwork, Safety, and Service, and promotes a respectful, equal-opportunity workplace. Employment at ORNL requires Real ID-compliant identification and the ability to obtain and maintain a federal Personal Identity Verification card. New employees must pass a Federal Tier 1 background investigation. Visa sponsorship is not available.

Requirements

Bachelor’s degree in information technology, information systems, computer science, computer engineering, business, science, or a related field, and at least 8 years of relevant experience; an equivalent combination of education and experience may be considered.
At least 5 years of Oracle DBA/Developer experience in a production enterprise environment.
Strong proficiency in PL/SQL development and SQL tuning.
Hands-on experience with Oracle RAC, Data Guard, ASM, and RMAN.
Hands-on experience building and maintaining production applications in Oracle APEX; version 22.x or later preferred.
Proficiency with ORDS for REST API development and deployment.
Familiarity with APEX security models, session state, and authentication schemes.
Solid understanding of Oracle security best practices, including roles, privileges, auditing, and TDE.
Experience with Oracle 19c or later.
Familiarity with Linux/Unix system administration in a database context.
Strong troubleshooting and root cause analysis skills.
Must be able to obtain and maintain a federal PIV card and pass a Federal Tier 1 background investigation.
Must provide Real ID-compliant identification for employment at ORNL.

Nice To Haves

Oracle Database 19c/26ai experience is preferred.
Oracle Certified Professional (OCP) or equivalent certification.
Experience with APEX plug-ins, Universal Theme customization, and JavaScript/CSS extensions.
Oracle APEX certification or a demonstrated portfolio of delivered APEX applications.
Exposure to DevOps practices and tools such as Git, CI/CD pipelines, and Ansible.
Knowledge of complementary databases such as PostgreSQL or SQL Server.
Experience working at a high-energy physics facility or DOE laboratory.

Responsibilities

Install, configure, patch, and upgrade Oracle Database environments, including standalone and Oracle Database Appliance environments.
Design, develop, and optimize PL/SQL stored procedures, functions, packages, triggers, and views.
Design, develop, and deploy low-code web applications using Oracle APEX, including themes, interactive reports, forms, and REST-enabled data services.
Collaborate with business stakeholders to translate requirements into functional APEX applications.
Manage APEX workspaces, application security, and user access controls.
Integrate APEX applications with external systems using RESTful web services and Oracle REST Data Services (ORDS).
Maintain and upgrade APEX environments across development, test, and production instances.
Perform capacity planning, performance tuning, and query optimization using tools such as AWR, ADDM, and Explain Plan.
Manage backup and recovery strategies using RMAN and ensure RPO/RTO targets are met.
Implement and maintain Oracle Data Guard, RAC, and/or ASM environments.
Monitor database health, availability, and security; respond to and resolve incidents.
Develop and enforce database standards, naming conventions, and change management procedures.
Collaborate with developers to review schema designs, indexing strategies, and data models.
Support data migrations and integrations.
Participate in an on-call rotation for critical database support as needed.
Align behaviors, priorities, and interactions with ORNL’s core values and promote a respectful workplace.