Application Database Administrator

Sparibis•Washington, DC

8d•Hybrid

About The Position

The Application Database Administrator supports Oracle and Oracle APEX applications in production environments, with a focus on APEX development, database performance, modernization, automation, security, and Agile collaboration. The role is hybrid-remote and requires the ability to work onsite in Suitland, Maryland, as needed for program execution. Applicants must be able to obtain and maintain a Public Trust security clearance. The administrator builds and maintains Oracle APEX components and develops PL/SQL supporting business logic. The role also tunes SQL and database performance, contributes to Oracle-to-PostgreSQL migration efforts, supports database and application CI/CD, and maintains security practices and technical documentation. The administrator works with reporting and analytics teams and other cross-functional technical teams.

Requirements

At least 3 years of professional database administration experience, concentrated on supporting Oracle and Oracle APEX in production environments.
Bachelor’s degree in an IT-related field.
Must be able to obtain and maintain a Public Trust security clearance.
Hands-on experience with Oracle APEX and PL/SQL development.
Strong SQL tuning and performance troubleshooting skills.
Experience with Git-based source control and Agile delivery processes.
Experience supporting or collaborating with reporting, analytics, or BI teams.
Experience with Oracle APEX.
Experience supporting databases across on-premises and AWS cloud environments.
Experience with CI/CD tools such as Jenkins or GitHub Actions.
Familiarity with cloud database services such as AWS or Azure.
Knowledge of Java-based application stacks and their database interactions.

Nice To Haves

PostgreSQL experience is desirable.
Exposure to or interest in Oracle-to-PostgreSQL migration, including schema and code conversion.
Relevant database or cloud certifications.

Responsibilities

Build, maintain, and optimize Oracle APEX pages, components, forms, and interactive reports.
Develop PL/SQL procedures, packages, triggers, and functions to support business logic.
Troubleshoot application-layer database issues and improve SQL efficiency.
Tune SQL queries, review execution plans, right-size indexes, and resolve database performance bottlenecks.
Collaborate with reporting and analytics teams to optimize queries that power dashboards and reports.
Participate in efforts to migrate data models, business logic, and application SQL from Oracle to PostgreSQL.
Assist with schema conversion, PL/SQL-to-PL/pgSQL refactoring, and testing for functional equivalence.
Contribute to modernization planning and ensure application compatibility during transitions.
Support automated build, test, and deployment pipelines for database objects and APEX applications.
Use Shell, Python, or PowerShell scripting to streamline routine tasks and deployments.
Maintain Git source control standards and ensure traceability to Agile work items.
Follow security and compliance best practices for database access, auditing, and data handling.
Maintain procedural and technical documentation in shared knowledge platforms.
Participate in Agile ceremonies and collaborate with cross-functional technical teams.