What are the responsibilities and job description for the Database Developer position at Hallmark Global Solutions Ltd?
Role Summary
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 to Have)
- Experience with database migration (Oracle → PostgreSQL/Aurora) 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.