PostgreSQL Developer

Posted 3hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

PostgreSQL DBA needed for building and supporting database infrastructure at a tech company. Collaboration with DBAs, Architects, and Developers to ensure database performance and integrity.

Responsibilities:

  • Install, configure, and maintain database server software, apply patches of PostgreSQL databases
  • Create high availability cluster and a Disaster Solution plan
  • Monitor database performance to identify slowdowns or potential issues
  • Create database objects such as tables, views, triggers, and indexes
  • Perform regular database backups to ensure data integrity in case of a server crash
  • Perform regular scheduled maintenance on the database server, such as vacuum analysis on large tables to remove obsolete data

Requirements:

  • Education: Bachelor’s degree in computer science, information technology, computer engineering or another related field.
  • Experience: Minimum 4 years of experience as a PostgreSQL DBA
  • experience in administering PostgreSQL databases
  • Working experience using PostgreSQL ver. 16 and higher.
  • experience with Database and SQL Tuning using PostgreSQL
  • Assist development teams in optimizing PostgreSQL
  • PostgreSQL backup and restore
  • Designing and managing PostgreSQL database schemas
  • Proficient in SQL and advanced SQL
  • Experience in security access control
  • Strong written and verbal communication skills
  • Highly motivated, able to work both in a team and solo
  • Must be able to meet deadlines and work well under pressure
  • At least 3+ years of hands-on EDB administration with experience in below:
  • EFM (EDB Postgres Failover Manager)
  • Search Path
  • EPAS Advanced Database administration
  • VACUUM Full or 3 rd party tools
  • pgbouncer, pgpool
  • EFM and streaming replication
  • Logical replication
  • PEM for monitoring
  • MTK for migration from Oracle to PostgreSQL
  • Backup and recovery Tool
  • Certification in PostgreSQL is preferred.
  • Experience with PGD is preferred.
  • Experience with MongoDB is preferred.
  • Experience with Microsoft Azure - Nice to have
  • Experience with other databases Like Oracle - Nice to have