Search

Application Database Administrator

PublishedPublished: 6/14/2022
Technology

Job Description

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

\n

Years’ Experience: 3+ years database administration experience

\n

Education: Bachelor’s Degree in IT related field

\n

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

\n

Key Skills:

\n

    \n
  • Must have Oracle APEX experience. PostgreSQL experience is desirable.
  • \n

  • Experience supporting databases across on-prem and AWS cloud environments
  • \n

\n


\n

Responsibilities

\n


\n

Application & APEX Development Support

\n

    \n
  • Build, maintain, and optimize Oracle APEX pages, components, forms, and interactive reports.
  • \n

  • Develop PL/SQL procedures, packages, triggers, and functions that support business logic
  • \n

  • Troubleshoot application‑layer database issues and improve SQL efficiency.
  • \n

\n

Performance Tuning & Optimization

\n

    \n
  • Tune SQL queries, review execution plans, right‑size indexes, and resolve database performance bottlenecks.
  • \n

  • Collaborate with reporting/analytics teams to optimize queries powering dashboards and reports.
  • \n

\n

Modernization to PostgreSQL

\n

    \n
  • Participate in efforts to migrate data models, business logic, and application SQL from Oracle to PostgreSQL.
  • \n

  • Assist with schema conversion, PL/SQL to PL/pgSQL refactoring, and testing for functional equivalence.
  • \n

  • Contribute to modernization planning and ensure application compatibility during transitions.
  • \n

\n

Automation, Scripting & CI/CD

\n

    \n
  • Support automated build/test/deploy pipelines for database objects and APEX applications.
  • \n

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

  • Maintain source control standards in Git and ensure full traceability to Agile work items.
  • \n

\n

Security, Documentation & Agile Collaboration

\n

    \n
  • Follow security and compliance best practices for database access, auditing, and data handling.
  • \n

  • Maintain procedural and technical documentation in shared knowledge platforms.
  • \n

  • Participate in Agile ceremonies and collaborate with cross‑functional technical teams.
  • \n

\n


\n

Required Qualifications

\n


\n

    \n
  • 3+ years of professional database administration experience with a concentration in supporting Oracle and Oracle APEX in production environments.
  • \n

  • Bachelor’s Degree in IT related field
  • \n

  • Must be able to obtain and maintain a Public Trust security clearance
  • \n

  • Hands‑on experience with Oracle APEX and PL/SQL development.
  • \n

  • Strong SQL tuning and performance troubleshooting skills.
  • \n

  • Experience working with Git‑based source control and Agile delivery processes.
  • \n

  • Experience supporting or collaborating with reporting/analytics or BI teams.
  • \n

  • Exposure to or interest in Oracle‑to‑PostgreSQL migration, including schema and code conversion.
  • \n

  • Experience with CI/CD tools (Jenkins, GitHub Actions, etc.).
  • \n

  • Familiarity with cloud database services (AWS, Azure, etc.).
  • \n

  • Knowledge of Java‑based application stacks and their database interactions.
  • \n

  • Relevant database or cloud certifications.
  • \n

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...