Cloud DB Developer: Aurora PostgreSQL & Oracle (Terraform)

Jobtailor

Wilmington (DE)

On-site

USD 110,000 - 150,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Jobtailor in Wilmington, Delaware seeks an experienced database developer to design, implement, and optimize database solutions on AWS Aurora PostgreSQL and Oracle. You will craft complex SQL, develop stored procedures, and tune performance to support high‑volume applications.

Responsibilities include schema design, indexing strategies, and query tuning, plus backup/restore, upgrades, and capacity planning.

Qualifications

3+ years of database development experience.
Strong experience with PostgreSQL (Aurora PostgreSQL).
Strong experience with Oracle Database.
Advanced SQL skills: complex joins, window functions, execution plan analysis, indexing strategies.
Experience with AWS fundamentals and hands-on usage of services like EC2, S3, IAM, CloudWatch.
Hands-on Terraform experience.
Understanding of database reliability patterns.

Responsibilities

Design, develop, and maintain database solutions on AWS Aurora PostgreSQL and Oracle.
Write and optimize SQL/PL/pgSQL (PostgreSQL) and SQL/PL/SQL (Oracle).
Develop and maintain stored procedures, functions, triggers, and views.
Perform schema design, data modeling, indexing strategies, and query tuning.
Support database operations: backup/restore, patching coordination, upgrades, capacity planning, and incident troubleshooting.
Implement data access patterns and integration with applications/services.
Build and maintain infrastructure-as-code using Terraform.
Work with AWS services such as EC2, S3, IAM, CloudWatch, KMS, VPC/Security Groups.