PostgreSQL Database Consultant

2 days ago


Singapore AVATAR TECHNO SERVICES PTE. LTD. Full time $120,000 - $180,000 per year
The Role:

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 Profile:
  • 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.
What's on Offer?
  • Work within a company with a solid track record of success
  • Excellent career development opportunities
  • Great work environment


  • Singapore SCSoft Technologies Full time

    Job Description Skills Required: - Responsible for monitoring, maintaining and providing technical support for enterprise level PostgreSQL databases - Handle requests from development and engineering team on a timely basis - Vendor co-ordination - work with DB platform provider to resolve issues on a timely basis - Assist senior database administrators on...


  • Singapore MEGAMIND CONSULTING PTE. LTD. Full time

    **PostgreSQL Database Administrator (DBA) **Responsibilities**: - Manage and maintain the PostgreSQL database infrastructure, including installation, configuration, and upgrades. - Monitor database performance, identify bottlenecks, and optimize query execution to ensure efficient and reliable operations. - Design and implement backup, recovery, and...


  • Singapore CHARTERHOUSE PTE. LTD. Full time

    Job Highlights: Manage and maintain PostgreSQL and MongoDB databases Optimize database performance, security, and availability Collaborate with cross-functional IT and development teams Job Description: We are seeking an experienced Database Administrator with a specialization in PostgreSQL and MongoDB . This role focuses on cloud and hybrid database...


  • Singapore CHARTERHOUSE PTE. LTD. Full time

    Job Highlights Manage and maintain PostgreSQL and MongoDB databases Optimize database performance, security, and availability Collaborate with cross-functional IT and development teams Job Description We are seeking an experienced Database Administrator with a specialization in PostgreSQL and MongoDB . This role focuses on cloud and hybrid database...


  • Singapore Reeracoen Singapore Pte Ltd Full time

    【 What you will be doing 】 - Managing replication and failover in a cluster of PostgreSQL servers using EDB EFM tool - Administering a large PostgreSQL database’s ability to do performance tuning - Monitoring databases to optimize database performance and diagnose any issue - Performing vacuum and analysis on the high-volume tables and databases which...


  • Singapore TRINITY CONSULTING SERVICES PTE. LTD. Full time

    Qualifications Should be a bachelors/masters/engineering graduate or equivalent technical degree in Information Technology or Computer Science 6-8 years of PostgreSQL/Sybase DBA experience in administration and management of IT Database technologies Knowledge of different domains of IT Security Working & hands-on experience in administering the DB...


  • Singapore GMP TECHNOLOGIES (S) PTE LTD Full time

    Responsibilities Act as the highest level of technical escalation for PostgreSQL/Sybase issues. Manage incident, problem, and change management processes. Lead and delegate technical tasks across the team; promote knowledge sharing. Own fault investigation, resolution, and user issue escalations. Perform deployments, upgrades, and DR/HA configuration of...

  • Database Engineer

    17 hours ago


    Singapore SPRAOI SOFTWARE SERVICES PTE. LTD. Full time

    **Responsibilities**: - Demonstrated proficiency in PostgreSQL modeling and the implementation of complex workflows. - Expertise in PostgreSQL database administration, pglogical, troubleshooting, deploying security controls, and performance optimization. - Execute Incident and Problem management duties with precision and efficiency. - Solid understanding of...


  • Singapore Krisvconsulting Services Pte Ltd Full time

    We are seeking an experienced Database Administrator to manage and optimize MS SQL Server and PostgreSQL databases, ensuring high availability, performance, and security. In this role, you'll work with cloud and hybrid environments (AWS/Azure), implement disaster recovery strategies, and automate database maintenance tasks. You'll also design and manage data...


  • Singapore Krisvconsulting Services Pte Ltd Full time

    We are seeking an experienced Database Administrator to manage and optimize MS SQL Server and PostgreSQL databases, ensuring high availability, performance, and security. In this role, you'll work with cloud and hybrid environments (AWS/Azure), implement disaster recovery strategies, and automate database maintenance tasks. You'll also design and manage data...