AWS Database Engineer

REI Systems•Sterling, VA

3d•Hybrid

About The Position

REI Systems is seeking an experienced AWS Database Engineer to support mission-critical federal applications, database modernization, data integration, and cloud engineering initiatives within the GrantSolutions platform. The role designs, develops, optimizes, secures, and maintains scalable database solutions for complex federal applications and enterprise data environments. It involves hands-on work with Oracle SQL/PL/SQL, PostgreSQL, Amazon RDS, AWS database services, ETL development, and database migration technologies. The engineer collaborates with application developers, cloud architects, DevOps engineers, data engineers, Product Owners, Agile teams, and federal stakeholders to deliver reliable, secure, high-performing database solutions. The position also uses approved AI-assisted development and automation tools to improve database engineering, testing, documentation, troubleshooting, and operational efficiency. The position is hybrid, with two days per week at REI Systems’ Sterling, Virginia office. The successful candidate must be able to obtain and maintain a Federal Public Trust clearance; candidates with an active Public Trust or federal suitability determination are preferred.

Requirements

At least 5 years of professional experience in database engineering, Oracle database development, ETL development, data integration, or related software engineering roles.
Strong hands-on Oracle SQL and PL/SQL experience, including stored procedures, packages, functions, triggers, views, materialized views, complex queries, and performance tuning.
Experience with Oracle database development tools such as SQL Developer and SQLLoader.
Hands-on experience with AWS database services, including Amazon RDS for Oracle and PostgreSQL, Amazon Redshift, Amazon S3, AWS DMS, AWS SCT, Amazon CloudWatch, AWS Secrets Manager, AWS KMS, and IAM.
Strong PostgreSQL and Amazon RDS for PostgreSQL experience, including SQL/PL/pgSQL development, administration, indexing, query optimization, performance tuning, backup and recovery, high availability, and troubleshooting.
Experience implementing database migrations and replication using AWS DMS and AWS SCT, including schema conversion, endpoint configuration, full-load migrations, CDC, validation, and cutover activities.
Experience implementing AWS database operational controls for monitoring, logging, backup and recovery, encryption, credential management, access control, and infrastructure automation.
Experience designing and implementing ETL workflows, data transformation, batch processing, and data migration solutions.
Experience with Matillion ETL or similar cloud-native data integration and orchestration platforms.
Strong understanding of relational database architecture, logical and physical data modeling, normalization, indexing, transaction management, and referential integrity.
Experience optimizing complex database queries and troubleshooting performance bottlenecks.
Experience developing database unit tests, regression tests, data validation processes, and automated deployment verification.
Experience supporting production database environments, incident management, root-cause analysis, and application releases.
Experience with CI/CD pipelines, DevSecOps practices, and database deployment automation.
Experience working in Agile environments using Scrum, Kanban, or similar methodologies.
Proficiency with version control and development tools such as Git, GitHub, GitLab, Bitbucket, or Azure DevOps.
Familiarity with AI-assisted development tools and their use in software engineering, testing, documentation, and troubleshooting.
Understanding of responsible AI, data privacy, cybersecurity, and secure technology adoption in enterprise environments.
Strong analytical, communication, collaboration, and problem-solving skills.
Ability to work independently, manage competing priorities, and collaborate effectively with cross-functional technical teams.
Ability to obtain and maintain a Federal Public Trust clearance.
Bachelor’s degree in Business, Engineering, Computer Science, or a related field.

Nice To Haves

Active Public Trust or federal suitability determination.
Previous experience supporting federal government agencies or large-scale enterprise applications.
Experience with federal grants management, financial management, case management, regulatory systems, or workflow-driven applications.
Familiarity with the GrantSolutions platform or similar federal grants management systems.
Experience with Oracle Data Pump, Oracle GoldenGate, Informatica, Talend, Oracle Data Integrator (ODI), Liquibase, Flyway, or comparable migration and integration tools.
Experience with Amazon Aurora PostgreSQL-Compatible Edition, SQL Server, MySQL, or additional enterprise database technologies.
Experience supporting AWS cloud migration, database modernization, and application transformation initiatives.
Knowledge of federal cybersecurity and compliance standards, including FISMA, NIST, and FedRAMP.
Experience with enterprise data warehousing, dimensional modeling, business intelligence, and reporting technologies such as Power BI, Tableau, or Amazon QuickSight.
Familiarity with AWS cloud-native application architectures and deployment patterns.
Oracle certifications such as Oracle Certified Professional (OCP), Oracle Database Administrator Certified Professional, or Oracle SQL Certified Associate.
Master’s degree; the posting states that a master’s degree is preferred.
Familiarity with modern AI data architectures, vector databases, retrieval-augmented generation (RAG), AI agents, and enterprise AI platforms.
Experience supporting AI-driven modernization, intelligent automation, or enterprise analytics initiatives.
Hands-on exposure to AI-assisted engineering tools such as GitHub Copilot, Microsoft Copilot, Amazon Q Developer, Cursor, ChatGPT Enterprise, Claude, Gemini, or similar technologies.

Responsibilities

Design, develop, maintain, and optimize Oracle and PostgreSQL database solutions for enterprise applications.
Develop complex SQL queries, PL/SQL packages, stored procedures, functions, triggers, views, materialized views, and sequences, as well as PostgreSQL SQL and PL/pgSQL code and database objects.
Analyze data models, database schemas, entity relationship diagrams, and enterprise data flows.
Tune database performance using execution plans, indexing, partitioning, optimizer statistics, and diagnostic tools.
Develop and maintain database migration scripts, schema updates, and automated deployment processes.
Troubleshoot performance issues, data inconsistencies, integration challenges, and production defects.
Design, configure, administer, monitor, and maintain AWS database solutions using services including Amazon RDS, Redshift, S3, AWS DMS, AWS SCT, CloudWatch, Secrets Manager, KMS, and IAM.
Configure and optimize PostgreSQL databases hosted on Amazon RDS, including indexing, extensions, parameter groups, performance tuning, and operational troubleshooting.
Implement database backup, recovery, high availability, monitoring, encryption, and access controls; monitor performance, availability, resource use, and operational health.
Support AWS cloud modernization involving Oracle and PostgreSQL databases.
Implement database migration and modernization solutions across Oracle, PostgreSQL, and AWS, including migration assessment, schema conversion, replication, validation, reconciliation, cutover planning, and post-migration verification.
Configure AWS DMS and AWS SCT, source and target endpoints, full-load migration tasks, and change data capture processes.
Identify improvements to database architecture, scalability, performance, and operational efficiency.
Design, develop, and maintain ETL workflows, data transformation processes, batch processing solutions, and enterprise data integration pipelines using Matillion ETL or similar technologies.
Develop data validation frameworks and automated data quality checks, and support data integration across applications, databases, reporting platforms, and analytics environments.
Collaborate with data engineering and application teams to ensure data accuracy, integrity, consistency, and accessibility; support pipelines for analytics, reporting, and AI/ML workloads.
Support database deployments through CI/CD pipelines and automated release processes, collaborating with DevOps teams on deployment automation, monitoring, and infrastructure management.
Develop and execute database unit, regression, and data validation tests, along with deployment verification activities.
Participate in production deployments, incident resolution, root-cause analysis, and post-release validation.
Implement database security controls, audit logging, encryption, credential management, and least-privilege access.
Maintain technical documentation, database designs, data mappings, deployment procedures, and operational support guides.
Participate in Agile ceremonies, including sprint planning, backlog refinement, daily standups, sprint reviews, and retrospectives.
Use approved AI-powered development tools to improve SQL development, optimization, testing, troubleshooting, and documentation; identify AI-assisted automation opportunities and apply responsible AI practices that protect data security, privacy, and compliance.
Evaluate emerging database, cloud, and AI technologies to improve engineering productivity and platform capabilities.