Job Title

Experience Range: 5-10years Location: Noida, Chennai Notice: Immediate & currently serving notice period Note: #Other Notice period candidates are not considerable PostgreSQL DBA Job Responsibilities: · Manage PostgreSQL databases and collaborate with our customers on their in-house projects. · Perform Architectural health checks and suggest optimizations and design changes through a detailed summary. · Optimize the performance of PostgreSQL databases using your knowledge in PostgreSQL Internals. · Tune SQL’s and write complex scripts for day-to-day administrative tasks. · Flexible in managing PostgreSQL databases on Cloud such as – AWS RDS and Azure Flexible server, etc. · Publish blog posts and write knowledge base articles used by our customers. · Upgrade and Migrate PostgreSQL databases to Cloud and between Cloud platforms. . Proficient in Architect, implement, and routinely test high availability and disaster recovery—including streaming replication, failover, connection pooling . Enforce role/privilege models, row‑level security, auditing, and encryption (at rest and in transit); conduct periodic security reviews and ensure adherence to customer and regulatory requirements (e.g., GDPR/PII handling) across on‑prem and cloud deployments Technical Skills required: · Must have the mindset of helping customers to implement Community PostgreSQL and Open-Source solutions for regular activities. · Must have expertise on managing PostgreSQL for at least 5 years. . You must have a good understanding of MySQL and either MSSQL or Oracle. · Must have a deeper understanding of the PostgreSQL architecture and internals. · Should understand the limitations and the workarounds for managing PostgreSQL deployed on PAAS platforms. · Must have knowledge on implementing Automatic failover, Parallel backups and Connection Pooling using Open-Source tools. · Must be able to handle Catalog Corruptions, Database Corruptions and Point in time recovery. · Must be able to analyze the logs and optimize the time-consuming SQL’s. · Must have knowledge on the most widely used extensions in PostgreSQL for monitoring, analyzing, and maintaining the databases. · Must be able to perform PostgreSQL Upgrades from legacy to latest versions with least possible downtime. Good to have skills: · Skills in scripting using Python or Golang. · Migrating schema and data from any other database to PostgreSQL.