PostgreSQL Developer
Posted 3hrs ago
Employment Information
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
















