HI
Database Developer
Han IT Staffing
Location not stated
4 months ago
- AWS
- Aurora
- PostgreSQL
- Oracle Database
- Oracle
- SQL
- PL/pgSQL
- PL/SQL
- Data Modeling
- ETL
- ELT
- IaC
- Terraform
- EC2
- IAM
- CloudWatch
- KMS
- VPC
- RDS
- Secrets Management
- Devops
- CI/CD
- Liquibase
- Flyway
- ECS
- EKS
- Kinesis
- Redis
- Redshift
- Python
- Bash
- Agile
4 months ago
We are seeking aDatabase Developer with strong hands-on experience inAWS Aurora PostgreSQL andOracle Database, plus working knowledge of coreAWS 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 onAWS Aurora PostgreSQL andOracle (on-prem or AWS-hosted).
- Write and optimizeSQL/PL/pgSQL (PostgreSQL) andSQL/PL/SQL (Oracle) for performance and maintainability.
- Develop and maintainstored procedures, functions, triggers, and views.
- Performschema 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 usingTerraform for database and supporting AWS components.
- Work with AWS services such asEC2, S3, IAM, CloudWatch, KMS, VPC/Security Groups, and (if applicable)RDS tooling for operations.
- Enforcesecurity 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 withPostgreSQL (preferablyAurora PostgreSQL) including performance tuning and troubleshooting.
- Strong experience withOracle Database, including PL/SQL development and optimization.
- Advanced SQL skills: complex joins, window functions, execution plan analysis, indexing strategies.
- Experience withAWS fundamentals and hands-on usage of services likeEC2, S3, IAM, CloudWatch.
- Hands-onTerraform 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 to Have)
- Experience withdatabase migration (Oracle → PostgreSQL/Aurora) and tools like AWS DMS/SCT (if relevant).
- Familiarity withCI/CD for database changes (Liquibase/Flyway or similar).
- Knowledge ofmonitoring/observability: CloudWatch metrics/logs, performance insights, alerting.
- Experience withcontainerized workloads (ECS/EKS) interacting with databases.
- Experience withdata 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 balanceperformance, reliability, and security.
- Clear communication and documentation skills.
- Comfortable working in agile delivery and collaborating across teams.
Database Developer · Han IT Staffing