PostgreSQL Database administrator

Job Title: PostgreSQL Database Administrator (DBA)

📍 Location: Pune (Candidates must be based in Pune or willing to relocate. Interviews will be conducted face-to-face in Pune.)

🕒 Experience: 2–4 years

💰 Salary: Up to ₹10 LPA

👥 Openings: 20

⚡ Note: Immediate joiners will be given preference

Job Summary

We are looking for an experienced PostgreSQL Database Administrator (DBA) to join our growing technology team. The role involves installation, configuration, monitoring, maintenance, performance tuning, and security of PostgreSQL databases. The DBA will play a critical role in ensuring high availability, scalability, and integrity of our databases, while collaborating closely with development, operations, and infrastructure teams.

Key Responsibilities

Database Management & Operations

Install, configure, and maintain PostgreSQL servers across production and non-production environments.

Perform proactive health checks, monitoring, and maintenance for database performance and uptime.

Implement backup & recovery strategies (pg_dump, pg_basebackup, WAL archiving, PITR).

Manage PostgreSQL replication (streaming/logical) and clustering for HA/DR.

Troubleshoot performance issues (query tuning, indexing, resource utilization).

Execute routine maintenance (vacuum, reindex, analyze).

Manage schema changes, user roles, and permissions in alignment with security policies.

Plan and implement database upgrades, patching, and migrations.

Performance Tuning & Optimization

Optimize SQL queries and resolve performance bottlenecks.

Leverage tools like pg_stat_activity, pg_stat_statements, pgBadger, Prometheus, and Grafana.

Collaborate with developers on schema design and query optimization.

Security & Compliance

Enforce database security best practices.

Monitor and respond to security incidents.

Ensure compliance with data protection standards and regulations.

Collaboration & Support

Partner with developers, DevOps, and infrastructure teams for deployments and troubleshooting.

Provide PostgreSQL expertise and mentoring within the team.

Participate in on-call support for production issues.

Maintain clear documentation and runbooks.

Automation

Develop scripts (Bash, Python) to automate DBA tasks.

Implement automation for database provisioning, monitoring, and maintenance.

Qualifications

Bachelor’s degree in Computer Science/IT or related field.

2–7 years of hands-on PostgreSQL DBA experience in production environments.

Strong knowledge of PostgreSQL internals (VACUUM, WAL, connection pooling).

Proficiency in SQL and PL/pgSQL.

Experience with replication (streaming/logical) & HA tools (Patroni, Repmgr, Pgpool-II).

Expertise in backup, recovery, and disaster recovery planning.

Strong Linux/Unix administration and shell scripting skills.

Familiarity with monitoring tools (pgAdmin, Prometheus, Grafana, Datadog, Nagios).

Excellent troubleshooting, problem-solving, and communication skills.

Preferred Skills (Good to Have)

Cloud experience: AWS RDS, GCP Cloud SQL, Azure PostgreSQL.

Exposure to other databases (Oracle, MySQL) or NoSQL systems.

Experience with version control (Git, Liquibase).

Hands-on with database migration projects across platforms.

📩 Interested candidates can share their resumes at:

👉 saundrya.patil@telesourcenow.com