Database Developer/DBA

Requirements:

• At least 5 years of professional experience in Oracle database development, database engineering, ETL development, data integration, or a related software engineering field.
• Strong hands-on Oracle SQL and PL/SQL skills, including stored procedures, functions, packages, triggers, complex queries, views, materialized views, sequences, and Oracle development utilities such as SQL Developer or SQL*Loader.
• Experience designing, developing, troubleshooting, and maintaining enterprise database solutions, schemas, and data models; knowledge of relational database architecture, normalization, referential integrity, and transaction management.
• Experience with database performance tuning, query optimization, indexing, execution plans, and production database environments.
• Hands-on experience with ETL workflows, data transformation, batch processing, data migration, validation, and reconciliation.
• Experience with AWS services such as Amazon Redshift, Amazon RDS, and Amazon S3, and with Matillion ETL or a comparable data integration platform.
• Experience developing database tests and validation processes, and supporting deployments, incident management, root-cause analysis, and issue resolution.
• Familiarity with CI/CD, source control, release automation, and DevSecOps practices, including tools such as Git, GitHub, GitLab, Bitbucket, or Azure DevOps.
• Experience working in Agile/Scrum environments; familiarity with AI-assisted development tools and automation practices.
• Understanding of secure development, data privacy, cybersecurity, responsible AI, and applicable federal security and compliance standards.
• Strong analytical, troubleshooting, problem-solving, and communication skills, with the ability to work independently and collaboratively in a fast-paced environment.
• Must be able to obtain and maintain a Federal Public Trust clearance, with approved adjudication required before onboarding. The posting also lists an active Federal Public Trust clearance or favorable suitability determination as preferred.
• Bachelors degree in Business, Engineering, Computer Science, or a related field; a masters degree is preferred.
• Preferred: Federal Government IT experience, particularly in Health IT or large-scale enterprise environments; experience with grants, financial, case management, or workflow-driven applications.
• Preferred: Experience with Oracle Data Pump, Oracle GoldenGate, Oracle Data Integrator (ODI), Informatica, Talend, Liquibase, Flyway, PostgreSQL, SQL Server, or MySQL.
• Preferred: Experience with cloud, database, or application modernization; data warehousing, dimensional modeling, reporting, business intelligence, or analytics platforms such as Power BI, Tableau, and Amazon QuickSight.
• Preferred: Experience with analytics, AI, or machine learning data pipelines; familiarity with AI-enabled DevSecOps, intelligent automation, vector databases, RAG, AI agents, and enterprise AI platforms.
• Preferred: Knowledge of FISMA, NIST, and FedRAMP, and relevant Oracle certifications such as OCP, Oracle Database Administrator Certified Professional, or Oracle SQL Certified Associate.

Responsibilities:

• Design, develop, implement, and maintain Oracle database solutions, including database objects such as procedures, packages, functions, triggers, views, materialized views, and sequences.
• Develop and optimize SQL queries and PL/SQL code for enterprise applications, reporting, and business processes; perform performance tuning, indexing, partitioning, and execution plan analysis.
• Design and maintain database schemas, data models, and entity relationship diagrams; create migration scripts, schema changes, deployment packages, and automated release processes.
• Troubleshoot performance, application integration, and data integrity issues, and support database monitoring, operations, and production environments.
• Build and maintain ETL workflows, data integration pipelines, data transformations, batch processing, migrations, validation, and reconciliation solutions.
• Use Matillion ETL or comparable tools and support cloud data engineering and analytics with AWS services such as Redshift, RDS, and S3.
• Analyze application data models, mappings, and enterprise data flows; work with application and data engineering teams to enable reliable integration across systems.
• Support database and application modernization, including cloud migration and integration initiatives.
• Collaborate with developers, architects, and technical teams to create database solutions that meet business and technical needs.
• Develop database unit and regression tests, data validation scripts, and deployment verification processes; support CI/CD pipelines and automated database deployments.
• Take part in code reviews, technical design discussions, troubleshooting, production deployments, incident resolution, root-cause analysis, and post-release validation.
• Maintain technical documentation covering database designs, deployment procedures, data mappings, and operational support.
• Use approved AI-assisted development tools to support SQL and PL/SQL development, testing, documentation, and troubleshooting; identify opportunities to automate repetitive engineering and operational work.
• Apply responsible AI practices and support AI-enabled software development lifecycle practices while protecting data security, privacy, and compliance.
• Participate in Agile ceremonies and collaborate with Product Owners, Scrum Masters, business analysts, developers, and federal stakeholders.
• Follow security, governance, and compliance standards; support applicable federal cybersecurity requirements aligned with FISMA, NIST, and FedRAMP, including access controls, audit logging, and data protection.

Technologies:

• AI
• AI Agents
• AWS
• Redshift
• Azure
• BitBucket
• Business Intelligence
• CI/CD
• Cloud
• DevSecOps
• DevOps
• ETL
• Flyway
• Git
• GitHub
• GitLab
• Incident Management
• Informatica
• Support
• Liquibase
• Machine Learning
• MySQL
• ODI
• Oracle
• PostgreSQL
• Power BI
• RAG
• SQL
• Security
• Tableau
• Talend

More

We are REI Systems, delivering reliable, innovative technology solutions to advance federal clients missions. Our technologists and consultants address complex challenges through application modernization, grants and case management, government data analytics, and advisory services. Our Mindful Modernization® approach, the REI Way, aligns client objectives with measurable outcomes across people, processes, and technology. We offer professional development, meaningful projects, and flexibility to support employees personal lives. Employees voted us a Washington Post Top Workplace in 2015, 2016, 2018, and 2020–2025. This role supports a mission-critical Federal Health IT program and works with software developers, architects, DevOps and data engineers, Product Owners, and Agile teams. The position is hybrid, with two days per week at our Sterling, Virginia office. We are an Equal Opportunity Employer.

last updated 43 week of 2026