Oracle PL/SQL Developer / Developer DBA

Travel Required: None | Clearance Required: None | Ability to Obtain Public Trust (must obtain approved adjudication prior to onboarding; active Public Trust preferred).

About the role

The Developer DBA will support application development, database engineering, data integration, analytics enablement, and operational database activities for the GrantSolutions platform. This role designs, develops, tests, maintains, and optimizes Oracle database solutions—including PL/SQL packages, procedures, functions, triggers, ETL processes, data migration scripts, and performance‑tuned objects—and works closely with developers, architects, DevOps engineers, data engineers, Product Owners, Scrum teams, business stakeholders, and Federal partners to support mission‑critical applications and modernization initiatives. The position also leverages approved AI‑assisted development and automation tools to improve productivity, code quality, documentation, testing, troubleshooting, and software delivery outcomes.

Responsibilities

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