Job Description

Location: Hybrid-Remote. Must be able to be onsite, as needed, for program execution in Suitland, MD

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

Responsibilities

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.

Required Qualifications

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

Job Tags

Similar Jobs