10 Nov
|
Volto Consulting
|
Noida
10 Nov
Volto Consulting
Noida
– Database Engineer (PostgreSQL / EDB / AWS)
Experience: 8+ Years in PostgreSQL
Cloud Experience: 5+ Years
Location: Noida
Work Mode: Work from Office – 5 Days a Week
Shift: US Shift – US Pacific Time Zone Alignment (Mandatory)
Job Overview
We are looking for an experienced Database Engineer with strong hands-on expertise in PostgreSQL, EDB, and AWS cloud database technologies. The ideal candidate should have experience in database administration, performance optimization, high availability, cloud migration, and automation.
Candidates must have a minimum of 8 years of PostgreSQL experience and 5 years of cloud experience. Strong technical expertise in at least two of the listed skills is mandatory.
Required Technical Skills
Candidates must have hands-on experience in any 2 or more of the following:
1. PostgreSQL / EDB
2. AWS RDS
3. EDB EPAS
4. Postgres Distributed (PGD)
5. AWS IAM
6. RDS High Availability, Aurora Replicas, and Global Database
7. Performance Tuning and Indexing
8. Partitioning and Sharding
9. Linux RHEL
10. Kubernetes / OpenShift
11. On-premises to AWS and AWS to On-premises Database Migration
12. GitLab CI/CD
13. Ansible
14. Terraform
15. PgBouncer / PgPool / RDS Proxy / PGD Proxy
Key Responsibilities
- Manage, administer, configure, and maintain PostgreSQL, EDB, and AWS RDS databases.
- Perform database installation, patching, upgrades, maintenance, and migration activities.
- Configure and support database high availability, resiliency, and disaster recovery solutions.
- Manage AWS RDS and Aurora environments, including replicas and Global Database.
- Perform database performance tuning, query optimization, indexing, and capacity planning.
- Implement database partitioning and sharding strategies.
- Support database security, user authentication, access management, and AWS IAM policies.
- Perform database migrations between on-premises environments and AWS cloud.
- Manage PostgreSQL deployments on Linux RHEL and Kubernetes / OpenShift platforms.
- Develop and maintain database automation using Ansible, Terraform, and GitLab CI/CD.
- Work with database connection pooling and proxy technologies such as PgBouncer, PgPool, RDS Proxy, and PGD Proxy.
- Monitor database performance, troubleshoot issues, and support production database operations.
- Maintain database documentation, operational procedures, and automation workflows.
Mandatory Requirements
- 8+ years of hands-on PostgreSQL experience.
- 5+ years of cloud experience, preferably AWS.
- Robust database administration and troubleshooting skills.
- Hands-on experience in at least two of the specified technical skills.
- Must be comfortable working in US shifts.
- US Pacific Time Zone alignment is mandatory.
- Candidates must be willing to work from the Noida office, 5 days a week.
📌 Senior Database Engineer (Noida)
🏢 Volto Consulting
📍 Noida