Database Developer   AWS Aurora PostgreSQL & Oracle 
Location: Wilmington, DE (Onsite)
Duration: Long Term Contract
 
 Job Summary 
We are looking for a Database Developer with strong experience in AWS Aurora PostgreSQL and Oracle Database development and administration. The ideal candidate will have expertise in SQL/PLSQL development, database performance tuning, cloud-based database solutions, and infrastructure automation using Terraform.
 Key Responsibilities

Design, develop, and maintain database solutions using AWS Aurora PostgreSQL and Oracle Database.

Develop and optimize SQL, PL/pgSQL, and PL/SQL code for high performance and scalability.

Create and maintain stored procedures, functions, triggers, views, and database objects.

Perform schema design, data modeling, indexing, query tuning, and execution plan analysis.

Support database operations including backup/restore, patching, upgrades, troubleshooting, and capacity planning.

Integrate databases with APIs, batch processes, and ETL/ELT pipelines.

Build and maintain Infrastructure-as-Code (IaC) using Terraform for AWS database environments.

Work with AWS services including EC2, S3, IAM, CloudWatch, KMS, VPC, Security Groups, and RDS tools.

Implement database security best practices including encryption, secrets management, auditing, and least privilege access.

Create and maintain technical documentation, deployment procedures, runbooks, and operational playbooks.

Collaborate with application development, DevOps, infrastructure, and security teams in an Agile environment.

Required Skills

3+ years of experience in Database Development.

Strong experience with PostgreSQL, preferably AWS Aurora PostgreSQL.

Strong Oracle Database development experience with PL/SQL optimization.

Advanced SQL expertise including:

```
Complex joins
```
```
Window functions
```
```
Query optimization
```
```
Execution plan analysis
```
```
Indexing strategies
```

Hands-on experience with AWS services:

```
EC2
```
```
S3
```
```
IAM
```
```
CloudWatch
```

Experience with Terraform and Infrastructure-as-Code concepts.

Understanding of database reliability concepts including replication, failover, high availability, and read scaling.

Strong troubleshooting and debugging skills in production environments.

Preferred Skills

Experience with Oracle to PostgreSQL/Aurora migrations.

```
Familiarity with AWS DMS and AWS SCT.
```

Experience with CI/CD tools for database deployments such as Liquibase or Flyway.

Knowledge of monitoring and observability tools including CloudWatch and Performance Insights.

Experience with ECS/EKS, Kafka/Kinesis, Redis/ElastiCache, or Redshift.

Scripting experience using Python or Bash.

Experience working in Agile development environments.

Core Competencies

Strong analytical and problem-solving skills.

Ability to balance performance, scalability, reliability, and security.

Good communication and documentation skills.

Strong collaboration skills across cross-functional teams.

Database Developer AWS Aurora PostgreSQL & Oracle

Key skills

About this role