Database Developer AWS Aurora PostgreSQL & Oracle

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.