Job Description

Job Family Descriptor

PostgreSQLDBA profile

Minimum 5-7 yrs of experience as PostgreSQL database administrator
Experience in MongoDB and NoSQL would be desirable
Experience in administering and maintaining PostgresDB and Mongo DB in medium enterprise database servers on Linux servers/Winodws servers
Supporting PostgreSQL databases on promises and AWS (RDS)
Installing and Configuring PostgreSQL from source or packages on Linux machines/ Windwos Machine
Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
Hands on Various postgres Replications
Hands on Postgres HA technologies
Implementing backup and recovery (Logical and Online).
Setup and maintenance of postgres master-slave clusters utilizing streaming replication (BDR)
Cross-datacenter disaster recovery and backup architecture
Performing schema management, database sizing, maintaining privileges.
Data migration while upgrading database versions.
Extensive experience with Warm Standby (PostgreSQL 9.x and later), and Hot Standby (PostgreSQL 9.x and greater).
Performance monitoring and optimization
Analyzing logs for any issue, create and Analyze PgBadger Reports
Hands on Pooling of connections, using PgBouncer.
Installing and configuring Object level replication like Slony etc.
Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.
Configuring log analyzation tools like pgfouine and pgbadger etc.
Removing the Index bloat Concurrently to improve the performance.
Scheduled maintenance activities to vacuum, analyze to improve the query response time.
Maintaining custom vacuum strategies at table and db level.
DB optimization and troubleshooting

Broad outline of the Role

Purpose - Broad objective of the role

Operating Network - Key External

Operating Network - Key Internal

Size and Scope of Role - Financial

Size and Scope of Role - No. of direct reports

Size and Scope of Role - Total team size

Size and Scope of Role - Other size parameters

Minimum qualification & experience

Other knowledge/skills

Key Responsibilities

Technical Competencies

Education:
Bachelors/Maters degree (BSc/BE/BTech)(MCA/MSc/MS/MTech)
6+ yrs of IT experience on PostgreSQL Database
Experience in MongoDB and NoSQL would be desirable

Certification:
Preferred PostgreSQL Associate or Professional Certification (good to have)
Preferred ITIL Foundation

Knowledge / Skills

Communication Skills