Snaphunt Pte Ltd – PostgreSQL Database Consultant

• Work within a company with a solid track record of success
• Excellent career development opportunities
• Great work environment

The Job

You will be responsible for :

• Perform database installation, configuration, and upgrades.
• Monitor database health, optimize performance, and troubleshoot issues.
• Optimize database performance through indexing, query optimization, and schema design.
• Conduct capacity planning to ensure database scalability.
• Develop and maintain backup and disaster recovery strategies.
• Perform regular backup tests to ensure data integrity and availability.
• Implement database security measures, including access controls and encryption.
• Ensure compliance with data protection regulations and standards.
• Develop automation scripts for routine database tasks using tools like Bash, Python, or Ansible.
• Manage database patching and upgrades seamlessly.
• Set up and maintain replication (logical/streaming replication) and high-availability solutions.
• Implement clustering and failover strategies.
• Work closely with application development teams to design database solutions.
• Provide technical expertise for database-related aspects of development and deployment.
• Use monitoring tools (e.g., pgAdmin, Nagios, or custom scripts) to track database performance.
• Generate regular reports on database health, growth, and performance.

Ideal Candidate

• Total 12+ years of experience in IT infrastructure management services
• Total 8+ years of relevant experience in postgre database architecture, including setup, installation, and maintenance.
• Proficiency in PostgreSQL database management and administration.
• Strong knowledge of SQL and PL/pgSQL.
• Experience with database design, performance tuning, and optimization.
• Familiarity with database security best practices.
• Experience with database migration and upgrade processes.
• Knowledge of backup and recovery techniques.
• Strong experience with postgre database, and other databases.
• Strong background in Linux system administration.
• Experience with Infrastructure-as-Code (IaC) tools such as Terraform and Ansible.
• Excellent troubleshooting and problem-solving skills.
• Hands-on experience with ITSM tools and processes.
• Experience in working in infra projects with BFSI customers.
• Experience of global delivery with offshore/ onsite model.
• Experience working in agile and DevOps-driven environments.
• Familiarity with cloud infrastructure and containerization technologies like Docker and Kubernetes.

Ref: 18CYTUGLZO