Postgresql Database Administrator

BUSINESSNEXT

3 - 5 years

7 - 15 Lacs

noida

Posted:2 days ago| Platform:

Apply

Skills Required

database administration pgadmin postgresql database administration postgresql administration performance tuning query optimization performance monitoring backup and recovery

Work Mode

Work from Office

Job Type

Full Time

Job Description

Role & responsibilities

Installation and configuration.
Expert in Backup and Recovery including pg_dump, pg_dumpall, setting up WAL (Write Ahead Log) archiving, Point in time recovery.
Management of PostgreSQL server security and Database health checks.
Performance tuning, Query tuning by generating and explaining plan for SQL queries.
Analyse, recommend, and implement configuration for Optimized Performance.
Creation, managing and migrating PostgreSQL schema, tables, tablespaces and users, roles, and group.
Ability to plan hardware capacity requirements for storage, memory, and CPU Cycles.
Setting up replication setup for 3 nodes (Master, Slave, and Disaster Recovery).
Ability to configure and troubleshoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.
Pg pool configuration for connection pooling and load balancing.
Understanding of UNIX environment with shell scripting.
Trouble shooting and resolving database issues.

More Jobs at BUSINESSNEXT

Talent Acquisition Partner

Noida

4 - 7 yrs

INR 5 - 10 Lacs

Human Resource Manager

Pune

6 - 10 yrs

INR 8 - 12 Lacs

Associate - Finance & Accounts

Noida

2 - 4 yrs

INR 4 - 8 Lacs

Mongodb Administrator

Noida

2 - 4 yrs

INR 3 - 6 Lacs

Assistant Manager - Finance & Accounts

Noida

5 - 7 yrs

INR 9 - 15 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.