AWS Database Engineer

REI Systems; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

REI Systems is seeking an experienced AWS Database Engineer to support mission-critical federal applications and database modernization within the GrantSolutions platform. You will design, develop, and optimize Oracle and PostgreSQL databases, leveraging AWS services and migration tools to ensure secure, scalable solutions.

The role collaborates with developers, cloud architects, DevOps, data engineers, and stakeholders to deliver high-performing database systems with robust backups, monitoring,

Qualifications

• Strong hands-on expertise in Oracle SQL/PL/SQL and PostgreSQL.

Responsibilities

• Design, develop, maintain, and optimize Oracle and PostgreSQL database solutions.

Skills

Oracle SQL/PL/SQL

PostgreSQL

Amazon RDS

AWS services

ETL development

Database migration

Tools

Amazon RDS for Oracle

Amazon RDS for PostgreSQL

Amazon Redshift

AWS DMS

AWS SCT

Job description

Overview

REI Systems' mission is to deliver reliable, innovative technology solutions that advance Federal clients' missions and exceed their expectations. Our technologists and consultants are passionate about solving complex challenges that impact millions of lives. We take a Mindful Modernization® approach in delivering our services, including application modernization, grants management, case management systems, government data analytics, and advisory services. This approach, the REI Way, ensures mission impact by aligning our clients' strategic objectives with measurable outcomes through people, processes, and technology. We offer the same commitment to our employees by providing professional development, meaningful projects, and flexibility to spend time with family and friends. We believe employees are at their best when fulfilled in both their professional careers and their personal lives. Learn more at www.REIsystems.com Employees voted REI Systems a Washington Post Top Workplace in 2015, 2016, 2018, 2020, 2021, 2022, 2023, 2024, and 2025!

Responsibilities

Position Overview

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 ideal candidate will have strong hands‑on expertise in Oracle SQL/PL/SQL, PostgreSQL, Amazon RDS, AWS database services, ETL development, and database migration technologies . This role will focus on designing, developing, optimizing, securing, and maintaining scalable database solutions that support complex federal applications and enterprise data environments. The AWS Database Engineer will collaborate with application developers, cloud architects, DevOps engineers, data engineers, Product Owners, Agile teams, and federal stakeholders to deliver reliable, secure, and high‑performing database solutions. This position also offers opportunities to leverage approved AI‑assisted development and automation tools to enhance database engineering, testing, documentation, troubleshooting, and operational efficiency.

Key Responsibilities

Database Development & Engineering

• Design, develop, maintain, and optimize Oracle and PostgreSQL database solutions supporting enterprise applications.
• Develop complex SQL queries, PL/SQL packages, stored procedures, functions, triggers, views, materialized views, and sequences.
• Develop and optimize PostgreSQL SQL and PL/pgSQL code, including functions, procedures, triggers, and database objects.
• Analyze complex data models, database schemas, entity relationship diagrams (ERDs), and enterprise data flows.
• Perform database performance tuning using execution plans, indexing strategies, partitioning, optimizer statistics, and database diagnostic tools.
• Develop and maintain database migration scripts, schema updates, and automated deployment processes.
• Troubleshoot database performance issues, data inconsistencies, integration challenges, and production defects.

AWS Cloud Database Engineering

Design, configure, administer, monitor, and maintain cloud-based database solutions using AWS services, including:

• Amazon RDS for Oracle
• Amazon RDS for PostgreSQL
• Amazon Redshift
• Amazon S3
• AWS Database Migration Service (AWS DMS)
• AWS Schema Conversion Tool (AWS SCT)
• Amazon CloudWatch
• AWS Secrets Manager
• AWS Key Management Service (AWS KMS)
• AWS Identity and Access Management (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 control mechanisms.
• Support AWS cloud modernization initiatives involving Oracle and PostgreSQL databases.
• Monitor database performance, availability, resource utilization, and operational health across AWS environments.

Database Migration & Modernization

• Support database migration and modernization initiatives across Oracle, PostgreSQL, and AWS environments.
• Implement AWS DMS and AWS SCT solutions for database migration, schema conversion, and replication.
• Configure source and target database endpoints, full-load migration tasks, and change data capture (CDC) processes.
• Perform migration assessments, data validation, reconciliation, cutover planning, and post‑migration verification.
• Identify opportunities to improve database architecture, scalability, performance, and operational efficiency.

ETL, Data Integration & Analytics

• Design, develop, and maintain ETL workflows, data transformation processes, and batch processing solutions.
• Build and support enterprise data integration pipelines using Matillion ETL or similar technologies.
• Develop data validation frameworks and automated data quality checks.
• Support data integration between enterprise applications, databases, reporting platforms, and analytics environments.
• Collabora