DBA Professionals
- Minfy
- 4 - 9 years
- Hyderabad
- 23 days ago
- Email to a friend
- Report this job
Job Description
We are looking for a PostgreSQL Database Administrator (DBA) with 4+ years of hands-on experience in managing PostgreSQL databases in cloud environments (AWS, GCP, or Azure). The role involves administering, monitoring, and supporting PostgreSQL databases to ensure high availability, performance, security, and reliability in line with business requirements.
The ideal candi will have strong experience in PostgreSQL administration, backup and recovery, performance tuning, and operational support, along with exposure to managed cloud database services.
Key Responsibilities :
Cloud PostgreSQL Deployment & Lifecycle Management
- Deploy, configure, patch, and upgrade PostgreSQL instances on AWS (RDS/Aurora), GCP (Cloud SQL), or Azure (Database for PostgreSQL) .
- Manage database provisioning via IaC tools (e.g., Terraform, CloudFormation, ARM/Bicep) and integrate with CI/CD pipelines.
- Monitor and optimize cloud cost/usage (e.g., storage auto-scaling, instance resizing, reserved instances).
- Perform routine database maintenance activities, including patching, upgrades, and health checks.
- Manage database objects, users, roles, and permissions.
High Availability, Disaster Recovery & Backup/Recovery
- Design and implement HA/DR strategies:
- Streaming replication , logical replication, read replicas
- Failover automation (e.g., using repmgr, Patroni, or native cloud failover)
- Point-in-Time Recovery (PITR) via WAL archiving (e.g., to S3/GCS/Azure Blob)
- Configure and test robust backup strategies using pg_dump, pg_dumpall, pg_basebackup, and cloud-native snapshots.
- Document and regularly vali RTO/RPO compliance.
Performance Tuning & Capacity Planning
- Proactively monitor and tune database performance using tools like:
- pg_stat_statements, pgBadger, EXPLAIN (ANALYZE, BUFFERS), CloudWatch/Metrics Explorer/Monitor
- OS-level metrics (CPU, I/O, memory pressure)
- Optimize queries, indexing (B-tree, BRIN, partial, expression), partitioning, and vacuum/autovacuum settings.
- Forecast capacity needs (storage, compute, connections) and right-size cloud instances.
Security, Compliance & Governance
- Implement and audit security controls:
- Role-based access (RBAC), row-level security (RLS), encryption (at-rest & in-transit)
- VPC/Network security (security groups, private endpoints, firewall rules)
- Integration with IAM (e.g., AWS IAM DB Auth, Azure AD)
- Ensure compliance with internal policies and external regulations (e.g., GDPR, SOC 2, HIPAA).
Automation & Operational Excellence
- Automate routine DBA tasks (backups, patching, user management, health checks) using scripts (Bash/Python) and tools (Ansible, custom CLIs).
- Maintain up-to- runbooks, architecture diagrams, and operational documentation (e.g., Confluence, Wiki).
Required Qualifications
- 4+ years of hands-on PostgreSQL DBA experience , including installation, configuration, backup/recovery, replication, and performance tuning.
- 2+ years managing PostgreSQL in at least one major cloud platform :
- AWS : RDS for PostgreSQL, Aurora PostgreSQL (preferred)
- GCP : Cloud SQL for PostgreSQL
- Azure : Azure Database for PostgreSQL (Single/Flexible Server)
Nice to Have :
- Familiarity with automation and scripting (Shell, Python).
- Exposure to database migrations or upgrade projects
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: MinfyLocation(s): Hyderabad+ View Contact
Keyskills: Performance tuning Automation SOC Postgresql Network security Monitoring SQL Python Firewall Auditing
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Minfy
\n\nQentelli is a global technology partner, we combine proven expertise in business innovation with a seasoned team, industry best practices, and specialized tools. Qentelli\'s commitment is to enhance your business operations through SAP-centric landscapes, delivering tangible value and seamless i...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in