Job Description
<p><p><b>Designation</b> : PostgreSQL Database Administrator.<br/><br/> <b>Location</b> : Wadgaonsheri, Pune.<br/><br/> <b>Experience</b> : 5 to 10 yrs.<br/><br/> <b>Type</b> : On site, Full :</b></p><p><br/> We are looking for a highly skilled Senior PostgreSQL Database Administrator with 7-10 years of experience, ideally within the insuretech or insurance domain.<br/><br/> This is a critical role responsible for ensuring the integrity, performance, and scalability of our PostgreSQL environments including advanced time-series workloads with TimescaleDB and high availability via Patroni.<br/><br/> You will also play a key role in implementing and maintaining observability and alerting solutions, with a preference for OpenTelemetry, though experience with Prometheus, Grafana, or SigNoz is also highly valued.<br/><br/> You will collaborate with cross-functional teams to deliver resilient data infrastructure for mission-critical Responsibilities :</b></p><p><br/> <b>Database Deployment & Management :</b><br/><br/> - Design, deploy, and maintain robust PostgreSQL clusters in production and staging environments.<br/><br/> <b>High Availability :</b><br/><br/> - Configure, manage, and monitor Patroni-based PostgreSQL clusters to ensure automatic failover and minimal downtime.<br/><br/> <b>Time-Series Data :</b><br/><br/> - Implement and optimize TimescaleDB for handling large-scale time-series data and analytics.<br/><br/> <b>Performance Tuning :</b><br/><br/> - Monitor database health, analyze performance, tune queries, and optimize indexes to ensure peak performance.<br/><br/> <b>Backup & Disaster Recovery :</b><br/><br/> - Develop and automate backup, restore, and disaster recovery processes that meet compliance and business requirements.<br/><br/> <b>Observability & Alerting :</b><br/><br/> - Integrate, configure, and manage observability solutions using OpenTelemetry (preferred), or Prometheus, Grafana, or SigNoz to ensure proactive monitoring and alerting of database health and performance.<br/><br/> <b>Collaboration :</b><br/><br/> - Work closely with DevOps, engineering, and data teams to support application development, deployment, and incident response.<br/><br/> <b>Security & Compliance :</b><br/><br/> - Implement and maintain database security policies and ensure compliance with industry regulations (e.g., GDPR, HIPAA).<br/><br/> <b>Documentation & Best Practices :</b><br/><br/> - Document architecture, processes, and best practices; mentor junior team members as :</b></p><p><br/> <b>Experience :</b><br/><br/> - 5-10 years hands-on experience as a PostgreSQL DBA, with a track record of supporting production environments.<br/><br/> <b>Technical Skills :</b><br/><br/> - Advanced expertise with PostgreSQL administration, performance tuning, and troubleshooting.<br/><br/> - In-depth experience with TimescaleDB extension for time-series data.<br/><br/> - Hands-on experience configuring and managing Patroni for high availability.<br/><br/> - Strong SQL skills and experience with database schema design.<br/><br/> - Proficiency in observability and alerting tools : OpenTelemetry (preferred), Prometheus, Grafana, or SigNoz.<br/><br/> - Familiarity with scripting languages (e.g., Bash, Python) for automation.<br/><br/> <b>Cloud & Containers :</b><br/><br/> - Experience with cloud platforms (AWS, Azure, GCP) and containerization technologies (Docker, Kubernetes) is a :</b></p><p><br/> - Exposure in fastest growing industry.<br/><br/> - Experience in domain.<br/><br/> - Opportunity to work on innovative projects shaping the Indian insurance sector.<br/><br/> - Supportive, collaborative, and growth-oriented culture.</p><p><br/></p><p>If interested, kindly share your resume with below required details-<br/><br/> Total Experience-<br/><br/> Relevant Experience-<br/><br/> Current CTC-<br/><br/> Expected CTC-<br/><br/> Current Company-<br/><br/> Current Designation-<br/><br/> Reason for leaving-<br/><br/> Are you serving Notice period-<br/><br/> If no, then Notice Period-<br/><br/> How soon you can join, if selected-<br/><br/> Current Location in Pune-<br/><br/> Available for face to face interview-<br/><br/> Updated CV-<br/><br/> Experience in PostgreSQL DBA-</p><br/></p> (ref:hirist.tech)