Database Developer/DBA

REI Systems•Sterling, VA

1d•Hybrid

About The Position

REI Systems is seeking experienced Developer / Database Administrators to support a mission-critical Federal Health IT program focused on application modernization, database engineering, data integration, analytics, and cloud-based solutions. The role designs, develops, maintains, and optimizes enterprise database solutions for complex federal applications and business operations, with a focus on Oracle SQL and PL/SQL, ETL processes, performance optimization, and AWS cloud technologies. The Developer DBA collaborates with software developers, solution architects, DevOps engineers, data engineers, Product Owners, and Agile delivery teams to implement scalable, secure, high-performing database solutions. The position also uses approved AI-assisted development tools, intelligent automation, and modern DevSecOps practices to improve engineering productivity, code quality, testing, and operational efficiency. The work environment is hybrid, with two days per week at REI Systems’ Sterling, Virginia office.

Requirements

At least 5 years of professional experience in Oracle database development, database engineering, ETL development, data integration, or related software engineering roles.
Hands-on Oracle SQL and PL/SQL experience, including stored procedures, functions, packages, triggers, complex queries, views, materialized views, and sequences.
Experience with query optimization, indexing, execution plans, and database performance tuning.
Experience with Oracle SQL Developer, SQLLoader, 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 with AWS technologies, including Amazon Redshift, Amazon RDS, and Amazon S3.
Experience with Matillion ETL or comparable ETL/data integration platforms.
Understanding of relational database architecture, logical and physical data modeling, normalization, referential integrity, and transaction management.
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 with Git, GitHub, GitLab, Bitbucket, Azure DevOps, or similar tools.
Experience working in Agile/Scrum development environments.
Familiarity with AI-assisted development tools and automation practices for improving 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.
Ability to obtain and maintain a Federal Public Trust clearance, with approved adjudication required before onboarding.
Bachelor’s degree in Business, Engineering, Computer Science, or a related field.

Nice To Haves

Master’s degree.
Previous experience supporting Federal Government IT programs, particularly in 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 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 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 certification, such as Oracle Certified Professional (OCP), Oracle Database Administrator Certified Professional, or Oracle SQL Certified Associate.

Responsibilities

Design, develop, implement, and maintain Oracle database objects and solutions, including stored procedures, packages, functions, triggers, views, materialized views, and sequences.
Develop and optimize complex SQL queries and PL/SQL code for 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, and database objects.
Develop database migration scripts, schema modifications, deployment packages, and automated database release processes.
Troubleshoot performance issues, application integration challenges, and data integrity concerns; support monitoring, production troubleshooting, and other database operations.
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 build and maintain data integration pipelines.
Support cloud-based data engineering and analytics solutions using Amazon Redshift, Amazon RDS, and Amazon S3.
Analyze application data models, data mappings, and enterprise data flows, and collaborate with application and data engineering teams on reliable integration across systems.
Support database and application modernization initiatives, including cloud migration and integration.
Partner with application developers, architects, and technical teams to design 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 DevSecOps practices.
Participate in code reviews, technical design discussions, and troubleshooting.
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.
Use approved AI-assisted development tools for SQL and PL/SQL development, testing, documentation, and troubleshooting; identify opportunities to automate repetitive database work.
Support AI-enabled SDLC practices and apply responsible AI practices that protect data security, privacy, and compliance.
Participate in Agile ceremonies and collaborate with Product Owners, Scrum Masters, business analysts, developers, and federal stakeholders.
Ensure database solutions follow security, governance, and compliance standards, including applicable federal cybersecurity requirements aligned with FISMA, NIST, and FedRAMP.
Implement secure database development practices, including access controls, audit logging, and data protection measures.