Database Developer 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

Career Opportunities with MAS Global Consulting

A great place to work.

Share with friends or Subscribe!

Are you ready for new challenges and new opportunities?

Join our team!

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

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.