Database Developer/DBA
REI Systems2 years ago
Sterling, VA, USASenior
Responsibilities
- Design, develop, implement, and maintain Oracle database solutions, including stored procedures, packages, functions, triggers, views, materialized views, and sequences.
- Develop and optimize complex SQL and PL/SQL code, including query tuning, indexing, partitioning, and execution plan analysis.
- Design database schemas, data models, entity relationship diagrams, and database objects.
- Create database migration scripts, schema modifications, deployment packages, and automated database release processes.
- Develop and maintain ETL workflows, data integration pipelines, data transformation processes, batch processing, data migrations, validation, and reconciliation solutions.
- Support AWS-based data engineering and analytics solutions using Amazon Redshift, Amazon RDS, and Amazon S3.
- Perform database monitoring, troubleshooting, production support, incident resolution, root-cause analysis, and post-release validation.
- Develop database unit tests, regression tests, data validation scripts, and deployment verification processes.
- Support CI/CD pipelines, automated database deployments, DevSecOps practices, and AI-assisted development and automation.
- Collaborate with application developers, solution architects, DevOps engineers, data engineers, Product Owners, Scrum Masters, business analysts, Federal stakeholders, and Agile delivery teams.
- Maintain technical documentation covering database designs, deployment procedures, data mappings, and operational support guides.
- Implement secure database development practices, access controls, audit logging, data protection, and applicable Federal cybersecurity and compliance requirements.
Requirements
- At least 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, triggers, complex queries, views, materialized views, sequences, indexing, execution plans, and performance tuning.
- Experience with Oracle SQL Developer, SQL*Loader, or similar Oracle development utilities.
- Experience designing, developing, troubleshooting, and maintaining enterprise database solutions and production database environments.
- Hands-on experience with ETL workflows, data transformation, batch processing, data migration, and data integration platforms such as Matillion ETL or comparable tools.
- Experience with AWS cloud technologies, including Amazon Redshift, Amazon RDS, and Amazon S3.
- Understanding of relational database architecture, logical and physical data modeling, normalization, referential integrity, and transaction management.
- Experience with database testing, data validation, deployment verification, production deployments, incident management, root-cause analysis, and issue resolution.
- Familiarity with CI/CD pipelines, source control, release automation, DevSecOps, Agile/Scrum, AI-assisted development tools, data privacy, cybersecurity, and responsible AI practices.
- Experience using Git, GitHub, GitLab, Bitbucket, or Azure DevOps.
- 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; a master’s degree is preferred.
- Preferred experience includes Federal Government or Health IT programs, grants or case management applications, cloud modernization, data warehousing, dimensional modeling, enterprise reporting, business intelligence, and analytics or machine learning data pipelines.
- Preferred technologies and qualifications include Oracle Data Pump, Oracle GoldenGate, Oracle Data Integrator, Informatica, Talend, Liquibase, Flyway, PostgreSQL, SQL Server, MySQL, Power BI, Tableau, Amazon QuickSight, vector databases, retrieval-augmented generation, AI agents, enterprise AI platforms, and relevant Oracle certifications.
- An active Federal Public Trust clearance or favorable suitability determination and knowledge of FISMA, NIST, and FedRAMP are preferred.
Benefits
- Hybrid work arrangement with 2 days per week at REI Systems’ Sterling, Virginia office.
- Professional development opportunities and meaningful mission-driven projects.
- Flexibility to spend time with family and friends.
- The role requires the ability to obtain and maintain a Federal Public Trust clearance, with approved adjudication required before onboarding.
Tech Stack
Categories
Data Engineering
About REI Systems
REI Systems provides full-lifecycle software engineering, data analytics, and modernization services to U.S. federal, state, and local agencies and nonprofits, including grants and case management solutions and cloud implementations. The privately held, 100% employee-owned firm delivers consulting and systems integration and supports programs at agencies such as the FDA. Founded in 1989 and headquartered in Sterling, Virginia, it focuses on open source, SaaS, and application modernization.