Noida, Uttar Pradesh
Job Summary
PostgreSQL DBA – Job Description
Position: PostgreSQL Database Administrator (DBA)
Experience: 5+ Years
Location: Noida / Hyderabad / Chennai
Employment Type: Full-Time
Job Summary
We are seeking an experienced PostgreSQL Database Administrator (DBA) with 5+ years of hands-on experience in managing, maintaining, and optimizing PostgreSQL databases in production environments. The ideal candidate should possess strong expertise in PostgreSQL administration, performance tuning, high availability, backup and recovery, database migrations/upgrades, and stakeholder management.
Key Responsibilities
Install, configure, upgrade, and maintain PostgreSQL database servers.
Monitor database performance and proactively identify and resolve bottlenecks.
Perform database tuning, query optimization, and index management.
Implement and manage backup, recovery, and disaster recovery strategies.
Manage database security, user roles, permissions, and access controls.
Ensure high availability and disaster recovery using PostgreSQL replication and HA solutions.
Troubleshoot production database issues and perform root cause analysis.
Support application and development teams with database design and optimization recommendations.
Automate routine database administration tasks using Shell/Python scripting.
Perform database migrations and version upgrades with minimal downtime.
Monitor database health, storage utilization, and capacity planning.
Create and maintain database documentation, operational procedures, and runbooks.
Collaborate and communicate effectively with application teams, infrastructure teams, vendors, and business stakeholders.
Participate in production support activities and critical incident management.
Required Skills
5+ years of hands-on PostgreSQL Database Administration experience.
Strong experience with PostgreSQL architecture, replication, partitioning, indexing, and performance tuning.
Experience with PostgreSQL HA technologies such as Patroni, repmgr, and PgBouncer .
Strong knowledge of VACUUM, Autovacuum tuning, table bloat management, and index bloat management .
Ability to perform performance troubleshooting using pg_stat_statements, EXPLAIN ANALYZE, and wait event analysis .
Experience with backup and recovery solutions such as pg_dump, pg_restore, pgBackRest, or Barman .
Strong SQL and PL/pgSQL programming skills.
Hands-on experience in PostgreSQL replication, failover, and disaster recovery setups.
Ability to perform database migration and version upgrades from older PostgreSQL versions to newer versions.
Strong troubleshooting and performance optimization skills for production databases.
Experience working on Linux/Unix environments.
Knowledge of Shell scripting, Bash, or Python scripting.
Familiarity with monitoring tools such as Prometheus, Grafana, pgAdmin, Nagios, or Zabbix .
Strong understanding of database security best practices.
Soft Skills
Ability to independently handle calls and discussions with multiple stakeholders with minimal supervision.
Strong communication, presentation, and documentation skills.
Excellent analytical and problem-solving abilities.
Ability to work effectively in a fast-paced production support environment.
Strong ownership, accountability, and customer-focused mindset.
Ability to prioritize tasks and manage multiple activities simultaneously.
Preferred Skills
Experience with cloud database platforms such as AWS RDS PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL .
PostgreSQL or cloud database certifications are a plus.
Nice to Have
Working knowledge of other database technologies such as MySQL, Microsoft SQL Server, and MongoDB .
Qualifications
Bachelor's Degree in Computer Science, Information Technology, or a related field.
Minimum 5 years of relevant PostgreSQL DBA experience supporting production environments.
Key Responsibilities
PostgreSQL DBA – Job Description
Position: PostgreSQL Database Administrator (DBA)
Experience: 5+ Years
Location: Noida / Hyderabad / Chennai
Employment Type: Full-Time
Job Summary
We are seeking an experienced PostgreSQL Database Administrator (DBA) with 5+ years of hands-on experience in managing, maintaining, and optimizing PostgreSQL databases in production environments. The ideal candidate should possess strong expertise in PostgreSQL administration, performance tuning, high availability, backup and recovery, database migrations/upgrades, and stakeholder management.
Key Responsibilities
Install, configure, upgrade, and maintain PostgreSQL database servers.
Monitor database performance and proactively identify and resolve bottlenecks.
Perform database tuning, query optimization, and index management.
Implement and manage backup, recovery, and disaster recovery strategies.
Manage database security, user roles, permissions, and access controls.
Ensure high availability and disaster recovery using PostgreSQL replication and HA solutions.
Troubleshoot production database issues and perform root cause analysis.
Support application and development teams with database design and optimization recommendations.
Automate routine database administration tasks using Shell/Python scripting.
Perform database migrations and version upgrades with minimal downtime.
Monitor database health, storage utilization, and capacity planning.
Create and maintain database documentation, operational procedures, and runbooks.
Collaborate and communicate effectively with application teams, infrastructure teams, vendors, and business stakeholders.
Participate in production support activities and critical incident management.
Required Skills
5+ years of hands-on PostgreSQL Database Administration experience.
Strong experience with PostgreSQL architecture, replication, partitioning, indexing, and performance tuning.
Experience with PostgreSQL HA technologies such as Patroni, repmgr, and PgBouncer .
Strong knowledge of VACUUM, Autovacuum tuning, table bloat management, and index bloat management .
Ability to perform performance troubleshooting using pg_stat_statements, EXPLAIN ANALYZE, and wait event analysis .
Experience with backup and recovery solutions such as pg_dump, pg_restore, pgBackRest, or Barman .
Strong SQL and PL/pgSQL programming skills.
Hands-on experience in PostgreSQL replication, failover, and disaster recovery setups.
Ability to perform database migration and version upgrades from older PostgreSQL versions to newer versions.
Strong troubleshooting and performance optimization skills for production databases.
Experience working on Linux/Unix environments.
Knowledge of Shell scripting, Bash, or Python scripting.
Familiarity with monitoring tools such as Prometheus, Grafana, pgAdmin, Nagios, or Zabbix .
Strong understanding of database security best practices.
Soft Skills
Ability to independently handle calls and discussions with multiple stakeholders with minimal supervision.
Strong communication, presentation, and documentation skills.
Excellent analytical and problem-solving abilities.
Ability to work effectively in a fast-paced production support environment.
Strong ownership, accountability, and customer-focused mindset.
Ability to prioritize tasks and manage multiple activities simultaneously.
Preferred Skills
Experience with cloud database platforms such as AWS RDS PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL .
PostgreSQL or cloud database certifications are a plus.
Nice to Have
Working knowledge of other database technologies such as MySQL, Microsoft SQL Server, and MongoDB .
Qualifications
Bachelor's Degree in Computer Science, Information Technology, or a related field.
Minimum 5 years of relevant PostgreSQL DBA experience supporting production environments.
Skill Requirements
Other Requirements
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-
