Primary responsibility of this role is to provide 24x7 production support to Mongo and Postgres databases
Ideal candidate should have 6 years of experience and expert level knowledge of Mongo DB technology and good knowledge of PostgreSQL DB technology Heshe should be capable enough to handle complex issues independently and provide resolutions within agreed SLAs also ensure customer delight and always adhere to HSBC policies and procedures
Candidates who have creative thinking and are willing to bring innovations and passionate about working on challenging initiatives will be given preference
Principal responsibilities
The job holder is responsible for 24x7 production support 247 shifts on rotational basis to Mongo PostgreSQL databases and work as a Consultant Specialist for the production support team
Perform Root Cause Analysis and provide permanent fixes
Investigate and provide solutions to database performance related issues
Join crisis calls participate in MIR and PIR calls also mentor team members
Experience and expertise in maintaining complex High Availability Replication cluster setups
Provide consultancy for complex setups and Disaster Recovery
Identify automation and Self-Healing opportunities and develop automation to reduce manual efforts and contribute to process improvement
Expert knowledge in troubleshooting and handling critical issues in Mongo and Postgres workplace
Required Skill
Candidate should be capable of handling production issues independently and provide resolutions within agreed SLAs
Experience in Performance Tuning of the database
Participate in Crisis Calls MIR PIR
Should be able to present a solution and implement or explain the problem to both technical and nontechnical parties
Should be able to lead crisis calls and work on finding the Root Cause Analysis and should be able to test implement remedial actions