AWS Database Engineer

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.

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