Database Developer Expert (AWS Aurora PostgreSQL)

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.