The Developer DBA will collaborate with software developers, solution architects, DevOps engineers, data engineers, Product Owners, and Agile delivery teams to implement scalable, secure, and high-performing database solutions.
This role also offers opportunities to leverage AI-assisted development tools, intelligent automation, and modern DevSecOps practices to improve engineering productivity, code quality, testing, and operational efficiency.
Responsibilities
Database Development and Engineering
Design, develop, implement, and maintain Oracle database solutions, including stored procedures, packages, functions, triggers, views, materialized views, and sequences.
Develop and optimize complex SQL queries and PL/SQL code supporting enterprise applications, reporting, and business processes.
Perform database performance tuning, query optimization, indexing, partitioning, and execution plan analysis.
Design and maintain database schemas, data models, entity relationship diagrams (ERDs), and database objects.
Develop database migration scripts, schema modifications, deployment packages, and automated database release processes.
Troubleshoot database performance issues, application integration challenges, and data integrity concerns.
Support database administration and operational activities, including monitoring, troubleshooting, and production support.
ETL, Data Integration, and Cloud Technologies
Design, develop, and maintain ETL workflows, data integration pipelines, and data transformation processes.
Develop and support batch processing, data migration, data validation, and reconciliation solutions.
Work with Matillion ETL or comparable enterprise ETL tools to develop and maintain data integration pipelines.
Support cloud-based data engineering and analytics solutions utilizing AWS services, including Amazon Redshift, Amazon RDS, and Amazon S3.
Analyze complex application data models, data mappings, and enterprise data flows.
Collaborate with application and data engineering teams to ensure reliable data integration across multiple systems.
Support database and application modernization initiatives, including cloud migration and integration efforts.
Application Development and DevSecOps
Partner with application developers, architects, and technical teams to design efficient database solutions aligned with business and technical requirements.
Develop and maintain database unit tests, regression tests, data validation scripts, and deployment verification processes.
Support CI/CD pipelines and automated database deployments using modern DevSecOps practices.
Participate in code reviews, technical design discussions, and troubleshooting activities.
Support production deployments, incident resolution, root-cause analysis, and post-release validation.
Maintain technical documentation, including database designs, deployment procedures, data mappings, and operational support guides.
AI-Assisted Development and Automation
Utilize approved AI-assisted development tools to enhance SQL and PL/SQL development, testing, documentation, and troubleshooting.
Identify opportunities to automate repetitive database development, validation, and operational activities.
Support AI-enabled software development lifecycle (SDLC) practices to improve engineering productivity and delivery quality.
Apply responsible AI practices while maintaining data security, privacy, and compliance requirements.
Agile Collaboration and Federal Compliance
Participate in Agile ceremonies, including sprint planning, backlog refinement, daily standups, sprint reviews, and retrospectives.
Collaborate with Product Owners, Scrum Masters, business analysts, developers, and federal stakeholders to deliver high-quality solutions.
Ensure database solutions follow established security, governance, and compliance standards.
Support federal cybersecurity requirements and best practices aligned with FISMA, NIST, and FedRAMP, as applicable.
Implement secure database development practices, including access controls, audit logging, and data protection measures.
Qualifications
Minimum of 5 years of professional experience in Oracle database development, database engineering, ETL development, data integration, or related software engineering roles.
Strong hands-on experience with Oracle SQL and PL/SQL, including
Stored procedures, functions, packages, and triggers.
Complex SQL queries, views, materialized views, and sequences.
Query optimization, indexing, execution plans, and performance tuning.
Oracle SQL Developer, SQL*Loader, or similar Oracle development utilities.
Experience designing, developing, troubleshooting, and maintaining enterprise database solutions.
Hands-on experience developing ETL workflows, data transformation processes, batch processing, and data migration solutions.
Experience working with AWS cloud technologies, including Amazon Redshift, Amazon RDS, and Amazon S3.
Experience with Matillion ETL or comparable ETL/data integration platforms.
Strong understanding of relational database architecture, logical and physical data modeling, normalization, referential integrity, and transaction management.
Experience with database performance tuning, query optimization, and troubleshooting.
Experience supporting complex enterprise applications and production database environments.
Experience developing database unit tests, regression tests, data validation processes, and deployment verification scripts.
Experience supporting production deployments, incident management, root-cause analysis, and issue resolution.
Familiarity with CI/CD pipelines, source control, release automation, and DevSecOps practices.
Experience using tools such as Git, GitHub, GitLab, Bitbucket, or Azure DevOps.
Experience working in Agile/Scrum development environments.
Familiarity with AI-assisted development tools and automation practices to improve software engineering productivity.
Understanding of secure development practices, data privacy, cybersecurity, and responsible AI adoption.
Strong analytical, troubleshooting, problem-solving, and communication skills.
Ability to work independently and collaboratively in a fast-paced, mission-driven environment.
Must be able to obtain and maintain a Federal Public Trust clearance, with approved adjudication required before onboarding.
Preferred Qualifications
Previous experience supporting Federal Government IT programs, particularly within Health IT or large-scale enterprise environments.
Experience with grants management, financial management, case management, or workflow-driven applications.
Experience with Oracle Data Pump, Oracle GoldenGate, Oracle Data Integrator (ODI), Informatica, Talend, Liquibase, or Flyway.
Experience with additional database technologies such as PostgreSQL, SQL Server, or MySQL.
Experience supporting cloud modernization, database migration, or application modernization initiatives.
Knowledge of data warehousing, dimensional modeling, enterprise reporting, and business intelligence technologies.
Experience with Power BI, Tableau, Amazon QuickSight, or comparable analytics platforms.
Familiarity with AWS cloud-native architectures and enterprise data platforms.
Experience supporting data pipelines for analytics, AI, or machine learning workloads.
Familiarity with AI-enabled DevSecOps, intelligent automation, and AI-assisted database engineering.
Knowledge of emerging AI technologies, including vector databases, retrieval-augmented generation (RAG), AI agents, and enterprise AI platforms.
Understanding of federal security and compliance requirements, including FISMA, NIST, and FedRAMP.
Active Federal Public Trust clearance or favorable suitability determination.
Relevant Oracle certifications, such as
Oracle Certified Professional (OCP).
Oracle Database Administrator Certified Professional.
Oracle SQL Certified Associate.
Education: Bachelor’s degree in Business, Engineering, Computer Science, or related field. Masters degree preferred.
Clearance: Ability to obtain and maintain a clearance is preferred.
Location: Hybrid: 2 days per week at REI Systems’ Sterling, VA office.
EEO Statement: REI Systems is an Equal Opportunity Employer
