DBA..

Role description

Job Summary

We are looking for an experienced PostgreSQL DBA .The ideal candidate should have strong expertise in PostgreSQL administration, SQL/PLSQL development, database replication technologies, and Infrastructure as Code (IaC). The role involves managing enterprise-grade database environments, supporting cloud migration initiatives, ensuring database performance, and collaborating with DevOps and engineering teams.

Key Responsibilities
• Administer, monitor, and maintain PostgreSQL database environments.
• Perform database installations, configurations, upgrades, patching, and performance tuning.
• Develop and optimize SQL queries, stored procedures, and PL/SQL scripts.
• Implement and support database replication and CDC solutions such as Debezium, Datastream, and Dataflow.
• Automate infrastructure provisioning and database deployments using Terraform and IaC practices.
• Manage backup, recovery, high availability, and disaster recovery strategies.
• Support CloudSQL environments and cloud-based database operations.
• Perform database migrations from on-premise to cloud platforms.
• Collaborate with application, DevOps, and infrastructure teams for deployment and operational support.
• Troubleshoot production issues and provide root cause analysis.
• Ensure database security, compliance, and monitoring standards are followed.