AWS Database Engineer

Job Title: AWS Database Engineer

Location: REMOTE

Type: Contract-to-Hire

Security Clearance: Due to a Federal Contract, U.S. citizenship is required, and the ability to obtain a Public Trust

• Work closely with application developers, architects, Dev Ops engineers, data engineers, Product Owners, Scrum teams, business stakeholders, and Federal partners to support mission-critical applications and modernization initiatives.
• 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 Cloud Watch, 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, monitoring, and post-migration verification.
• Configure and operate AWS database monitoring, logging, backup, recovery, high-availability, encryption, credential-management, and access-control capabilities using Amazon Cloud Watch, 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, Dev Ops 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 Dev Sec Ops  and CI/CD initiatives by implementing automated testing, deployment, monitoring, and compliance practices for database solutions.
• Create and maintain technical documentation, including database designs, data mappings, interface specifications, operational procedures, and support guides.
• Develop and support database unit testing, regression testing, data validation testing, and automated test support for SQL, PL/SQL, ETL, and data migration changes.
• Support production operations, release deployments, incident troubleshooting, root-cause analysis, and post-deployment validation for mission-critical database and application components.
• Leverage approved AI-powered development tools to…