Senior Oracle Database Administrator; DBA​/Developer

Select how often (in days) to receive an alert:

We seek an experienced Senior Oracle Database Administrator (DBA)/Developer for the Neutrons Systems Engineering and Support group to design, maintain and optimize our Oracle database environment. The Neutron Systems Engineering and Support group provides technical expertise and computing support to Neutron Science Directorates (NScD) and the Neutron Upgrades Project Office (NUPO). NScD operates the High Flux Isotope Reactor (HFIR) and the Spallation Neutron Source (SNS), the world’s most powerful pulsed accelerator-based neutron source.

As a DBA/developer, you are responsible for a deep administrative expertise with strong development skills making it ideal for someone who can architect reliable data solutions while collaborating closely with our end users, application developers, and infrastructure teams.

This position reports directly to the Neutron Systems Engineering and Support group lead, in the Research Computing Support Division (RSCD) at Oak Ridge National Laboratory (ORNL).

What We're Looking For:

A self-motivated professional who takes ownership of database reliability and application delivery, communicates clearly with both technical and non-technical stakeholders, and brings a continuous improvement mindset to everything they do.

Major Duties/Responsibilities:

• Install, configure, patch, and upgrade Oracle Database environments (19c/26ai preferred) in both 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 custom themes, interactive reports, forms, and REST-enabled data services.
• Collaborate with business stakeholders to translate requirements into functional APEX applications.
• Manage APEX work spaces, application security, and user access controls.
• Integrate APEX applications with external systems via 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; 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 on-call rotation for critical database support, as needed.
• Deliver ORNL’s mission by aligning behaviors, priorities, and interactions with our core values of Impact, Integrity, Teamwork, Safety, and Service. Promote equal opportunity by fostering a respectful workplace – in how we treat one another, work together, and measure success.

Basic Qualifications:

• A BS in information technology, information systems, computer science, computer engineering, business, science, or a related field of study and a minimum of 8 years of relevant experience required for consideration. An overall combination of equivalent education and experience may be considered.
• 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…