AWS Database Engineer

Guidehouse Inc.; McLean (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

Guidehouse Inc. seeks a skilled AWS Database Engineer to support the GrantSolutions platform. You will work with Oracle and PostgreSQL databases, AWS services, and data integration tools to design, develop, test, and optimize robust database solutions.

In this role you will collaborate with developers, DevOps, data engineers, and stakeholders in an Agile setting. Expect to contribute to AI-enabled engineering initiatives and modernize data architectures.

Qualifications

• Hands-on experience with Oracle SQL/PL/SQL and PostgreSQL/PL/pgSQL in production environments.
• Experience with AWS database services and migration/schema-conversion tools (DMS, SCT).
• Ability to design, develop, test, maintain, migrate, secure, monitor, and optimize database solutions.

Responsibilities

• Design, develop, and support Oracle database solutions with procedures, functions, triggers, and views.
• Develop and optimize SQL/PL/SQL and PostgreSQL code for applications and reporting.
• Create and maintain migration scripts and automated deployment processes.
• Build and maintain ETL workflows and data transformation pipelines.
• Analyze complex data models, schemas, and data mappings for business requirements.
• Configure and operate AWS database services and monitoring tools.

Skills

Oracle SQL

PL/SQL

PostgreSQL

PL/pgSQL

ETL development

AWS database services

Tools

Amazon RDS for Oracle

Amazon RDS for PostgreSQL

Amazon Redshift

Amazon S3

AWS DMS

AWS SCT

CloudWatch

AWS Secrets Manager

AWS KMS

Job description

Job Family : Systems Engineering (Digital)

Travel Required : None

Clearance Required : Ability to Obtain Public Trust

The AWS Database Engineer will support application development, database engineering, data integration, analytics enablement, and operational database activities for the GrantSolutions platform. This role requires hands-on expertise with Oracle and PostgreSQL database solutions and AWS database services, tools, and components. Responsibilities include designing, developing, testing, maintaining, migrating, securing, monitoring, and optimizing database solutions using Oracle SQL and PL/SQL, PostgreSQL and PL/pgSQL, 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), and related AWS capabilities.

The AWS Database Engineer will work closely with application developers, architects, DevOps engineers, data engineers, Product Owners, Scrum teams, business stakeholders, and Federal partners to support mission-critical applications and modernization initiatives. The ideal candidate will be a self-starter with strong analytical and problem-solving skills who can quickly understand complex application data models, independently drive solutions, and deliver high-quality database solutions in an Agile environment.

This role will also support AI-enabled engineering initiatives by applying approved AI-assisted development and automation tools to improve productivity, code quality, documentation, testing, troubleshooting, and software delivery outcomes.

What You Will Do

We are seeking a highly motivated AWS Database Engineer with strong Oracle SQL and PL/SQL expertise, PostgreSQL and PL/pgSQL experience, ETL development experience, and required hands-on experience with AWS database services, migration and schema-conversion tools, monitoring, security, storage, and automation components to support application modernization, database development, systems integration, analytics, and operational support activities.

• Design, develop, and support Oracle database solutions, including packages, stored procedures, functions, triggers, views, materialized views, and sequences, ensuring high performance, scalability, and maintainability.
• Develop, enhance, and optimize SQL and PL/SQL code to support application functionality, reporting, system integrations, and business operations.
• Create and maintain database migration scripts, schema updates, release deployment packages, and automated database deployment processes.
• Design, build, and support ETL workflows, data transformation processes, validation frameworks, and batch data processing solutions.
• Analyze and interpret complex data models, database schemas, enterprise data flows, ERDs, and data mappings to support business and application requirements.
• Design, build, configure, administer, and support AWS database and data solutions using Amazon RDS for Oracle, Amazon RDS for PostgreSQL, Amazon Redshift, Amazon S3, AWS DMS, AWS SCT, Amazon CloudWatch, AWS Secrets Manager, AWS KMS, and related AWS services and components.
• Develop, administer, and optimize PostgreSQL solutions on Amazon RDS, including schemas, functions, procedures, triggers, views, extensions, indexing, partitioning, query tuning, parameter configuration, backup and recovery, high availability, and operational troubleshooting.
• Implement and support AWS database migration, replication, and modernization activities across Oracle and PostgreSQL platforms, including schema assessment and conversion, full-load and change data capture workflows, endpoint configuration, data validation, cutover planning, and post-migration verification.
• Configure and operate AWS database monitoring, logging, backup, recovery, high-availability, encryption, credential-management, and access-control capabilities using Amazon CloudWatch, RDS monitoring features, AWS Secrets Manager, AWS KMS, IAM, and related services.
• Build and maintain data integration pipelines using Matillion ETL and other enterprise data integration platforms.
• Troubleshoot and resolve database issues, data quality concerns, application integration challenges, and performance bottlenecks across environments.
• Perform database performance tuning and optimization using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic and monitoring tools.
• Collaborate closely with software engineers, architects, DevOps engineers, and business stakeholders to deliver scalable and reliable data solutions.
• Participate in Agile development activities, including sprint planning, backlog refinement, daily standups, code reviews, sprint reviews, and retrospectives.
• Contribute to DevSecOps and CI/CD initiatives by implementing automated testing, deployment, monitoring, and compliance practices for database solutions.
• Create and maintain technica