Database Administrator

Job Title: Database Administrator (DBA) – Azure PostgreSQL

Location: Remote / Hybrid (as applicable)
Experience Required: 5+ Years
Role Type: Full-time

Job Overview

We are seeking a highly skilled Database Administrator (DBA) with strong expertise in Azure cloud infrastructure to manage, optimize, and secure mission-critical databases supporting our multi-tenant SaaS and on-premise products.
The ideal candidate will collaborate closely with DevOps, Infrastructure, and Application teams to ensure high availability, performance, security, and compliance across all environments.

Key ResponsibilitiesDatabase Administration & Infrastructure

• Install, configure, and maintain PostgreSQL databases on Azure (IaaS and PaaS – Azure Database for PostgreSQL).
• Manage replication, clustering, failover, and HA/DR strategies.
• Perform routine health checks, capacity planning, and performance tuning.
• Manage schemas, indexes, tablespaces, and partitions for scalability.
• Implement data encryption (TDE, SSL) and manage RBAC for secure access.

Security & Compliance

• Ensure compliance with HIPAA, GDPR, NDHM, and internal security guidelines.
• Manage audit logs, backups, and DR drills as per corporate policies.
• Troubleshoot critical issues like replication lag, connection failures, corruption, etc.

Performance Optimization

• Analyze slow queries and optimize SQL using EXPLAIN plans and index tuning.
• Develop and maintain maintenance tasks — VACUUM, ANALYZE, REINDEX.
• Monitor and optimize CPU, memory, storage, and query performance.

Azure Cloud Management

• Deploy/manage PostgreSQL through Azure Portal, CLI, ARM Templates.
• Integrate with Azure Monitor, Log Analytics, Application Insights.
• Manage automated backups, Point-in-Time Recovery (PITR), and geo-replication.
• Support infrastructure-as-code (Terraform/Bicep) for DB provisioning.

DevOps & CI/CD Integration

• Work with Azure DevOps / GitHub Actions to automate database deployments.
• Manage migration scripts and schema versioning.
• Support developers during releases, schema upgrades, and testing cycles.
• Provide 24×7 on-call support for critical production environments.

Documentation & Collaboration

• Prepare and maintain runbooks, SOPs, and incident reports.
• Collaborate with DevOps, Development, QA, and Infra teams effectively.

Qualifications

• Bachelor’s degree in Computer Science, IT, or related field.
• 5+ years of hands-on experience in PostgreSQL administration.
• Minimum 2 years on Azure PostgreSQL (IaaS/PaaS).
• Strong understanding of PostgreSQL internals, WAL, MVCC, performance tuning.
• Hands-on with pgAdmin, psql, pgBackRest, Azure CLI, logical replication.
• Experience with Python or Shell scripting for automation.
• Knowledge of MySQL, MSSQL, or MongoDB is a plus.
• Azure Database Administrator Associate certification preferred.
• Strong troubleshooting, analytical, and problem-solving skills.
• Excellent communication and documentation abilities.
• Ability to work in fast-paced, cross-functional team environments.

Job Types: Full-time, Permanent

Pay: ₹800,000.00 - ₹1,500,000.00 per year

Benefits:

• Health insurance
• Paid sick time

Work Location: Remote