Postgres

Postgres

Oloop Technology Solutions Private Limited
Bengaluru / Bangalore India
5-8 years
Not Specified

Job Description


Job Description :
Overview
Request ID:11995-1
Primary Skillsets : Postgres
SO: 8281683(Subcon channel)
Grade/Exp: C1(5-8 )
The requirement is for the night shift.
o Installing and configuring high availability in Postgres like streaming replication, hot standy, warm standby and maintenance of master-master and master-slave clusters in on-prem/cloud environments.
o Connection pooling methodology using Pgpool, Pgbouncer while configured with automatic failover tools like Repmgr, Patroni or PAF.
o Ensure all database servers are backed up that meets RPO and RTO using pgdump, pg_basebackups including pgbackrest, barman etc., for database more than 250 GB with heavy read/write systems.
o Recommendations on changes needed to improve performance including index creation, query optimization, schema changes, database configuration settings and storage.
o Implement and maintain database/data archiving and retention process.
o Document database environment and administration process.
o Proactive observing of all the information bases to foresee and analyze most of the issues before they sway application execution or client experience.
o Configuring PostgreSQL monitoring using Prometheus end points, Grafana etc.
o Using pgfouine and pgbadger is an add-on.
o Undertaking periodic upgrades of database schema and perform testing and verification of released database schema upgrades.
o Skill on Enterprise DB Postgresql, testing and DevOps strategy is ideal.
o Expertise on Rep Manager to manage the failover scenarios.
Additional Responsibilities:
. Good understanding on Distributed Systems
. Expertise in Cloud technologies, preferably GCP.
. Knowledge on Python Scripting.
. Knowledge on other nosql databases like Couchbase, MongoDB, mysql, Redis.
. Basic idea on Docker based Env's.

Similar Jobs

People Also Considered

Career Advice to Find Better