Oracle PL/SQL Developer / Developer DBA

Guidehouse; McLean (VA); On-site; USD 110,000 - 165,000; Full time

Job summary

Guidehouse seeks a Developer DBA to design, develop, and optimize Oracle database solutions for the GrantSolutions platform. You will work with developers, DevOps, data engineers, and stakeholders in an Agile environment to deliver high-performance database components.

The role emphasizes SQL/PL-SQL development, data migration, ETL pipelines, and cloud data integration using AWS services, with attention to security, compliance, and efficient data operations.

Qualifications

• Bachelor's degree required.
• Minimum of five (5) years of experience in Oracle database development, database engineering, ETL development, data integration, or related software engineering roles.

Responsibilities

• Design, develop, and support Oracle database solutions, including PL/SQL packaging, procedures, functions, triggers, views, and sequences.
• Develop, optimize, and maintain SQL/PL-SQL code for application functionality, reporting, and integrations.
• Create and maintain database migration scripts and deployment packages.
• Build and support ETL workflows and data transformations.
• Collaborate with engineers, architects, DevOps, and stakeholders to deliver scalable data solutions.
• Leverage AI-powered tools to accelerate SQL/PL-SQL development, code review, and testing.

Skills

Oracle database development

Database engineering

ETL development

Data integration

Software engineering

Education

Bachelor’s degree

Tools

Matillion ETL

Amazon Redshift

Amazon S3

Amazon RDS

Job description

Job Description Summary

The Developer DBA will support application development, database engineering, data integration, analytics enablement, and operational database activities for the GrantSolutions platform. This role is responsible for designing, developing, testing, maintaining, and optimizing Oracle database solutions, including PL/SQL packages, procedures, functions, triggers, ETL processes, data migration scripts, and performance‑tuned database objects.

The Developer DBA will work closely with application developers, architects, DevOps engineers, data engineers, Product Owners, Scrum teams, business stakeholders, and Federal partners to support mission‑critical applications and modernization initiatives. The ideal candidate will be a self‑starter with strong analytical and problem‑solving skills who can quickly understand complex application data models, independently drive solutions, and deliver high‑quality database solutions in an Agile environment.

This role will also support AI‑enabled engineering initiatives by applying approved AI‑assisted development and automation tools to improve productivity, code quality, documentation, testing, troubleshooting, and software delivery outcomes.

Job Family

Database Administration

Travel Required

None

Clearance Required

Ability to Obtain Public Trust

What You Will Do

• Design, develop, and support Oracle database solutions, including packages, stored procedures, functions, triggers, views, materialized views, and sequences, ensuring high performance, scalability, and maintainability.


• Develop, enhance, and optimize SQL and PL/SQL code to support application functionality, reporting, system integrations, and business operations.


• Create and maintain database migration scripts, schema updates, release deployment packages, and automated database deployment processes.


• Design, build, and support ETL workflows, data transformation processes, validation frameworks, and batch data processing solutions.


• Analyze and interpret complex data models, database schemas, enterprise data flows, ERDs, and data mappings to support business and application requirements.


• Develop and support cloud‑based data integration, reporting, and analytics solutions using AWS technologies such as Amazon Redshift, Amazon S3, Amazon RDS, and related services.


• Build and maintain data integration pipelines using Matillion ETL and other enterprise data integration platforms.


• Troubleshoot and resolve database issues, data quality concerns, application integration challenges, and performance bottlenecks across environments.


• Perform database performance tuning and optimization using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic and monitoring tools.


• Collaborate closely with software engineers, architects, DevOps engineers, and business stakeholders to deliver scalable and reliable data solutions.


• Participate in Agile development activities, including sprint planning, backlog refinement, daily standups, code reviews, sprint reviews, and retrospectives.


• Contribute to DevSecOps and CI/CD initiatives by implementing automated testing, deployment, monitoring, and compliance practices for database solutions.


• Create and maintain technical documentation, including database designs, data mappings, interface specifications, operational procedures, and support guides.


• Develop and support database unit testing, regression testing, data validation testing, and automated test support for SQL, PL/SQL, ETL, and data migration changes.


• Support production operations, release deployments, incident troubleshooting, root‑cause analysis, and post‑deployment validation for mission‑critical database and application components.


• Leverage approved AI‑powered development tools to accelerate SQL and PL/SQL development, code review, troubleshooting, documentation, testing, and knowledge‑sharing activities.


• Identify and implement opportunities to apply AI and intelligent automation to database development, data engineering, deployment, monitoring, operational support, and engineering productivity.


• Support data governance, security, privacy, and compliance requirements by implementing least‑privilege access, auditability, encryption‑aware data handling, and controls aligned with Federal standards such as FISMA, NIST, and FedRAMP where applicable.


• Continuously evaluate emerging database, cloud, AI, and data engineering technologies and recommend improvements that enhance platform capabilities and team productivity.

What You Will Need

• Must be able to OBTAIN and MAINTAIN a Federal or DoD “PUBLIC TRUST”; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred.


• Bachelor’s degree required.


• Minimum of five (5) years of experience in Oracle database development, database engineering, ETL development, data integration, or related software engineering roles