PostgreSQL Database Administrator

We are looking for an experienced PostgreSQL DBA to join our growing team.

Key Responsibilities :

• Design, develop, and optimize SQL databases for high-performance applications.
• Write and maintain complex SQL queries, stored procedures, functions, and triggers.
• Perform database performance tuning, indexing, and query optimization.
• Develop and maintain ETL pipelines for seamless data processing.
• Ensure data integrity, security, and implement backup strategies.
• Collaborate with developers to integrate PostgreSQL databases with applications.
• Monitor database health, troubleshoot issues, and provide production support.
• Work on database partitioning, replication, and sharding for large datasets.
• Implement and maintain PL / pgSQL scripting for business logic.
• Partner with DevOps teams for database deployments, migrations, and automation.
• Maintain technical documentation for database structures and processes.

(ref : hirist.tech)