- Bachelor's degree in computer science or related discipline.
- Experience - 8 to 12 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.
Qualifications
ESSENTIAL SKILLS/COMPETENCIES Including: Interpersonal skills, management, leadership, communications, sales, planning and organizing, project management skills etc.
- Excellent communication and problem-solving skills. Demonstrate the ability to resolve the difficult situation.
- A proactive personality with self-motivation. Good analytical and interpersonal skill.
- Candidate should have sense of ownership & urgency, attention to detail, flexibility, process orientation, strong analytical skills, sense of vigilance & adherence to all compliance procedures & policies.
- Ability to manage relationships with various stakeholders.
- Strong teamworking skills including working with remote teams.
- Highly motivated with a positive and proactive attitude to learn new technologies.
- Experience working within an agile environment
