Job Description

At least 6-8 years Strong hands-on experience in PostgreSQL for PostgreSQL version 12 and above Strong understanding on PostgreSQL DB architecture and providing consulting on design, review. Strong experience in PostgreSQL performance tuning, optimization and troubleshooting database issue. Strong experience in building PostgreSQL DB, configuration, upgrade, Migration, and bug fix patching. Strong experience in resolving fragmentation issue and good understanding of indexes, backup, and recovery strategies. Strong experience in SQL programming skills and Shell scripting skills and configure tools to automate database operations such as housekeeping and monitoring, capacity management, backup & job scheduling, daily BAU work. Strong experience in technical delivery of projects by providing technical / process guidance to project teams and be a subject matter expert for the PostgreSQL infrastructure team. Experience in Change Implementation & Problem Management. Provide production support and Identify root causes for incidents/problems and implement preventive measures. Good Knowledge in Automation Tools such as Rundeck, Ansible and Jenkins is preferred Good to have Oracle Development experience.