Consultant

Job Description (Posting).

Client

• Centene [ US Health Insurance ]Location

• Any nearest HCL delivery center

Experience

• L2 - 3-5 years of relevant experience L3 - 5-8 years of relevant experience

Work hours

• 24x7 shift roster

Must have expertise on managing PostgreSQL for 3-5 years.If you have been an Oracle DBA for more than 5 years, at least 3 years of experience in PostgreSQL is preferred.Must have a deeper understanding of the PostgreSQL architecture and internals.Should have an understanding of the limitations and the work-arounds for managing PostgreSQL deployed on DBaaS 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. (1.) To adhere to quality standards, regulatory requirements and company policies (2.) To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases (3.) To participate or contribute on EN business in creation of proposals to drive Service improvement plans. (4.) To independently resolve tickets and esnure that the agreed SLA of ticket volume and time are met for the team. (5.) To provide support for on call escalations orL3 level support and doing incident and problem management (6.) Work on value adding activities such Knowledge base update and management, Training freshers, coaching analysts and conducting interviewsorparticipation in hiring drives.