Database Developer Expert (AWS Aurora PostgreSQL)

MAS Global Consulting; Wilmington (DE); On-site; USD 90,000 - 130,000; Full time

Job summary

MAS Global Consulting in Delaware seeks a Database Developer to design, build, and optimize database solutions on AWS Aurora PostgreSQL and Oracle. You’ll implement secure, scalable data architectures in a cloud-first environment and collaborate with DevOps, security, and application teams.

The role requires hands-on SQL (PostgreSQL and Oracle), PL/SQL, and Terraform for infrastructure as code, plus experience with AWS services, backups, and performance tuning.

Qualifications

• 3+ years of database development experience.
• Strong PostgreSQL (Aurora PostgreSQL) and Oracle Database expertise.
• Advanced SQL skills and PL/SQL development.
• Hands-on AWS fundamentals and Terraform experience.

Responsibilities

• Design, develop, and maintain database solutions on AWS Aurora PostgreSQL and Oracle.
• Write and optimize SQL/PL/pgSQL and SQL/PL/SQL for performance.
• Develop stored procedures, functions, triggers, and views.
• Schema design, data modeling, indexing, and query tuning.
• Backup/restore, patching, upgrades, capacity planning, incident troubleshooting.
• CI/CD for database changes and infrastructure as code with Terraform.
• Work with AWS services and security best practices; documentation and collaboration.

Skills

PostgreSQL

Oracle

SQL

AWS

Performance tuning

Data modeling

Documentation

Agile

Tools

Terraform

Liquibase

Flyway

CI/CD

CloudWatch

KMS

ECS/EKS

Kafka

Kinesis

Redis

Redshift

Job description

Location

Delaware (DE), USA – fully On-site

Role Overview

We are seeking a Database Developer with strong hands‑on experience in AWS Aurora PostgreSQL and Oracle Database, plus working knowledge of core AWS services and infrastructure automation. You’ll design, build, optimize, and support database solutions that are secure, performant, and scalable in a cloud environment.

Key Responsibilities

• Design, develop, and maintain database solutions on AWS Aurora PostgreSQL and Oracle (on‑prem or AWS‑hosted).
• Write and optimize SQL/PL/pgSQL (PostgreSQL) and SQL/PL/SQL (Oracle) for performance and maintainability.
• 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 (APIs, batch jobs, ETL/ELT pipelines as applicable).
• Build and maintain infrastructure‑as‑code using Terraform for database and supporting AWS components.
• Work with AWS services such as EC2, S3, IAM, CloudWatch, KMS, VPC/Security Groups, and (if applicable) RDS tooling for operations.
• Enforce security best practices (encryption in transit/at rest, secrets management, least privilege, auditing).
• Create and maintain documentation: runbooks, standards, deployment procedures, and operational playbooks.
• Collaborate with application teams, platform/DevOps, and security to deliver end‑to‑end solutions.

Required Qualifications

• 3+ years (adjustable) of database development experience.
• Strong experience with PostgreSQL (preferably Aurora PostgreSQL) including performance tuning and troubleshooting.
• Strong experience with Oracle Database, including PL/SQL development and optimization.
• 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 (modules, remote state, environments, CI/CD integration is a plus).
• Understanding of database reliability patterns: replication, HA, read scaling, failover concepts.

Preferred Qualifications (Nice if you have)

• Experience with database migration and tools like AWS DMS/SCT (if relevant).
• Familiarity with CI/CD for database changes (Liquibase/Flyway or similar).
• Knowledge of monitoring/observability: CloudWatch metrics/logs, performance insights, alerting.
• Experience with containerized workloads (ECS/EKS) interacting with databases.
• Experience with data streaming/integration (Kafka/Kinesis), caching (Redis/ElastiCache), or warehousing (Redshift)
• Scripting skills: Python, Bash, or similar for automation.

Core Skills / Competencies

• Strong debugging and problem‑solving in production environments.
• Ability to balance performance, reliability, and security.
• Clear communication and documentation skills.
• Comfortable working in agile delivery and collaborating across teams.