Senior Database Developer - AWS Aurora & Oracle Expert

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

Job summary

MAS Global Consulting seeks a Database Developer to design, build, and optimize secure database solutions in a cloud environment. The role focuses on AWS Aurora PostgreSQL and Oracle, with hands-on work in SQL, PL/SQL, and data modeling.

You’ll implement automation with Terraform and collaborate with DevOps and security teams to deliver reliable, scalable data services. Ideal candidates have 3+ years in database development, strong PostgreSQL and Oracle expertise, and familiarity with AWS

Qualifications

• 3+ years of database development experience.
• Strong experience with PostgreSQL (Aurora PostgreSQL) including performance tuning.
• Strong experience with Oracle Database, including PL/SQL development and optimization.
• Advanced SQL skills: complex joins, window functions, 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.

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.

Skills

Database development

SQL tuning

PL/SQL development

Performance optimization

Security

Tools

PostgreSQL

Aurora PostgreSQL

Oracle Database

AWS

Terraform

EC2

S3

IAM

CloudWatch

KMS

VPC

RDS tooling

Job description

MAS Global Consulting seeks a Database Developer to design, build, and optimize secure database solutions in a cloud environment. The role focuses on AWS Aurora PostgreSQL and Oracle, with hands-on work in SQL, PL/SQL, and data modeling.

You’ll implement automation with Terraform and collaborate with DevOps and security teams to deliver reliable, scalable data services. Ideal candidates have 3+ years in database development, strong PostgreSQL and Oracle expertise, and familiarity with AWS