Database Developer

Jobtailor; Wilmington (DE); On-site; USD 110,000 - 150,000; Full time

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.

Skills

PostgreSQL Development

Oracle Database Development

Advanced SQL

AWS Services

Terraform IaC

PL/pgSQL

PL/SQL

Schema Design

Data Modeling

Query Tuning

Tools

AWS Aurora

AWS EC2

AWS S3

AWS IAM

AWS CloudWatch

AWS KMS

AWS VPC

Terraform

Job description

• 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

Requirements

• 3+ years of database development experience
• Strong experience with PostgreSQL (preferably 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

Core Competencies

Demonstrates expertise in designing and maintaining database solutions using AWS Aurora PostgreSQL and Oracle, with advanced SQL skills for performance optimization and a strong understanding of AWS services and infrastructure-as-code practices.

Highest-signal resume keywords

• PostgreSQL Database Development
• Oracle Database Development
• Advanced SQL Skills
• AWS Services Experience
• Terraform Infrastructure-as-Code

ATS Optimization Keywords

Hard Skills

• Database Development
• SQL
• PL/pgSQL
• PL/SQL
• Schema Design
• Data Modeling
• Indexing Strategies
• Query Tuning
• Stored Procedures
• Functions

Industry Keywords

• Database Reliability Patterns
• Backup/Restore
• Patching Coordination
• Capacity Planning
• Incident Troubleshooting

Tools & Technologies

• AWS Aurora
• AWS EC2
• AWS S3
• AWS IAM
• AWS CloudWatch
• AWS KMS
• AWS VPC
• Terraform