Description

You will manage and maintain PostgreSQL databases to ensure performance, security, and data integrity.

Responsibilities

• Install, configure, and upgrade PostgreSQL databases while managing replication, failover, and high-availability solutions.
• Design and implement database schemas, indexes, and constraints, and perform routine maintenance like vacuuming and updating statistics.
• Monitor performance using tools like pg_stat_statements and optimize queries, indexing, and execution plans.
• Develop and implement backup and recovery strategies using tools such as pg_dump and pg_basebackup.
• Collaborate with development teams on code reviews, test case reviews, and integrating business requirements into existing software.

Required Skills

• 5+ years of experience in database administration.
• Deep understanding of PostgreSQL architecture, internals, data types, and constraints.
• Proficiency in SQL syntax, querying, and complex database design/modeling.
• Hands-on experience with Bash, Python, or Perl for scripting and automation.
• Expertise in performance tuning, query optimization, and indexing strategies.
• Experience managing user access via Role-Based Access Control (RBAC) and PostgreSQL security features.
• Competency in troubleshooting connectivity, performance, and data issues.
• Proven ability writing Unix Shell Scripts for batch processing.

Preferred Skills

• Knowledge of MuleSoft integration.

Key Skills

Education

Any Graduate