PostgreSQL Senior Consultant

2 weeks ago

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 will remove the bloats and will update the statistics of the database
- Proactive managing replication like Streaming replication and logical replication using xDB
- Writing scripts for scheduled vacuuming
- Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
- Monitoring the bloat report on every table and performing maintenance with mínimal downtime
- Administering the database security, creating users, granting roles, privileges to users
- Deploying different extensions on the database server
- Deployment of external tools on the top of PostgreSQL-Server (pgbouncer,pgbadger)
- **
Requirement**:
【 What they are looking for 】
- Possess Bachelor's Degree in Engineering or equivalent
- At least 6 years of working experience on production PostgreSQL DBs and experience in a production support environment
- Excellent communication, with the ability to communicate to external Senior Management and internally
- Expertise with Windows/Linux Operating Systems and cloud hosting providers (Azure/AWS etc.)
- Should have at least one public cloud (AWS/Azure/GCP) deployment experience
- Experience in backing up and restoring PostgreSQL database
- Experience in installation, configuration, and maintenance of PostgreSQL from 9.5 to 13.x
- Work experience in migration from Oracle/MySQL to PostgreSQL using EDB MTK
- **
Working Hour**:
9:00 ~ 18:00
- **
Benefit**:
【 What they are offering 】
- Annual Leave: 14 days
- Medical Leave: 14 days
- Comprehensive Medical Insurance
- Flexible working options with WFH being the default
- Continuous Training & Development
- Reward and Recognition Program
- Professional courses and certification support 24×7 team assistance program

  • PostgreSQL, Sr. Consultant

    22 hours ago

    Singapore Ashnik Full time

    **Location**: Singapore The Position Ashnik is looking for talented and passionate person to join our database technical team in Singapore. Qualification and Experience Preferably have a working experience of 6-8 Years plus, on production PostgreSQL DBs Experience of working in a production support environment Engineering or Equivalent degree Essential...

  • Database Performance Consultant

    2 weeks ago

    Singapore Percona Full time

    **What’s the job?** Percona Support is a global, elite team of engineers who love getting to the bottom of weird and interesting database behaviour. We understand our customers’ business needs and the nuances of their technical environments. This allows us to help our customers see the big picture and identify opportunities to improve their overall...

  • PostgreSQL Database Administrator

    2 weeks ago

    Singapore Epergne Solutions Full time

    Join to apply for the PostgreSQL Database Administrator role at Epergne Solutions . We are seeking an experienced Database Administrator with strong expertise in PostgreSQL , and ideally, working knowledge of DB2 LUW . The candidate will be responsible for designing, implementing, and maintaining robust database solutions that align with performance,...

  • PostgreSQL Database Administrator

    1 week ago

    Singapore Epergne Solutions Full time

    Join to apply for the PostgreSQL Database Administrator role at Epergne Solutions . We are seeking an experienced Database Administrator with strong expertise in PostgreSQL , and ideally, working knowledge of DB2 LUW . The candidate will be responsible for designing, implementing, and maintaining robust database solutions that align with performance,...

  • Senior PostgreSQL DBA

    7 days ago

    Singapore A-IT Software Services Pte Ltd Full time

    Key Responsibilities Lead installation, configuration and management of PostgreSQL databases supporting banking/credit card transaction systems. Architect and implement high availability, disaster recovery, and backup strategies compliant with PCI-DSS and financial regulations. Perform advanced performance tuning and query optimization for high-volume...

  • PostgreSQL Dba

    1 week ago

    Singapore Hays Full time

    A technological organisation is looking for a strong PostgresSQL DBA to join their ranks to build out a new HA DB environment. Details are below! **_ Job Description:_** - Daily PostgreSQL, MySQL database monitoring, operation and maintenance, optimisation, troubleshooting; - Database security hardening to ensure the integrity and security of the database...

  • PostgreSQL DBA

    1 week ago

    Singapore GOSSTECH PTE. LTD. Full time

    Roles & Responsibilities Job Description: The candidate must be able to build up a new HA DB environment, including a DB monitoring system, DB automation system, DB log system, DB backup system, and other DB systems. Daily PostgreSQL, MySQL database monitoring, operation and maintenance, optimization, troubleshooting; Database security hardening to...

  • PostgreSQL DBA

    3 days ago

    Singapore Alphawall Full time $80,000 - $120,000 per year

    Job Description:The candidate must be able to build up a new HA DB environment, including a DB monitoring system, DB automation system, DB log system, DB backup system, and other DB systems.Daily PostgreSQL, MySQL database monitoring, operation and maintenance, optimization, troubleshooting;Database security hardening to ensure the integrity and security of...

  • PostgreSQL DBA

    2 weeks ago

    Singapore GOSSTECH PTE. LTD. Full time

    Roles & ResponsibilitiesJob Description:The candidate must be able to build up a new HA DB environment, including a DB monitoring system, DB automation system, DB log system, DB backup system, and other DB systems. Daily PostgreSQL, MySQL database monitoring, operation and maintenance, optimization, troubleshooting; Database security hardening to ensure...

  • PostgreSQL DBA

    16 hours ago

    Singapore ALPHAWALL PTE. LTD. Full time

    Overview The job involves building and maintaining a high-availability (HA) database environment and related systems, including monitoring, automation, logging, backups, and other DB components. Responsibilities The candidate must be able to build up a new HA DB environment, including a DB monitoring system, DB automation system, DB log system, DB backup...