Application Database Administrator

Application & APEX Development Support

· Build, maintain, and optimize Oracle APEX pages, components, forms, and interactive reports.

· Develop PL/SQL procedures, packages, triggers, and functions that support business logic

· Troubleshoot application-layer database issues and improve SQL efficiency.

Performance Tuning & Optimization

· Tune SQL queries, review execution plans, right-size indexes, and resolve database performance bottlenecks.

· Collaborate with reporting/analytics teams to optimize queries powering dashboards and reports.

Modernization to PostgreSQL

· 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.

Automation, Scripting & CI/CD

· Support automated build/test/deploy pipelines for database objects and APEX applications.

· Use scripting languages (Shell, Python, PowerShell) to streamline routine tasks and deployments.

· Maintain source control standards in Git and ensure full traceability to Agile work items.

Security, Documentation & Agile Collaboration

· 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.

Years’ Experience: 3+ years database administration experience

Education: Bachelor’s Degree in IT related field

Clearance: Applicants must be able to obtain and maintain a Public Trust security clearance.

Key Skills:

· Must have Oracle APEX experience. PostgreSQL experience is desirable.

· Experience supporting databases across on-prem and AWS cloud environments, · 3+ years of professional database administration experience with a concentration in supporting Oracle and Oracle APEX in production environments.

· Bachelor’s Degree in 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 working with Git-based source control and Agile delivery processes.

· Experience supporting or collaborating with reporting/analytics or BI teams.

· Exposure to or interest in Oracle-to-PostgreSQL migration, including schema and code conversion.

· Experience with CI/CD tools (Jenkins, GitHub Actions, etc.).

· Familiarity with cloud database services (AWS, Azure, etc.).

· Knowledge of Java-based application stacks and their database interactions.

· Relevant database or cloud certifications.