Description: Postgres DBA : 10798231

Section II - Job Evaluation Topics and Weight (Questions and evaluation are based on below)

Topic of Evaluation / Skills*

Mandatory / non-mandatory

Percentage*

(Skills / Topics should sum up to 100%)

(Enter only multiples of 5)

Postgres Architecture

Mandatory

25%

Backup and restores

Mandatory

20%

Database upgrade

Mandatory

10%

HA and replication

Mandatory

20%

Day to Day troubleshooting and maintenance

Mandatory

25%

1.

Strong knowledge of Postgres Architecture.

2.

Experience with different types of backup and restores in Postgres.

3.

Experience with database upgrade on minor and major versions.

4.

Hands-on experience on Database replication and point-in-time-recovery.

5.

Day to Day operations and troubleshooting performance issues like load average, locks, blocking and long running sqls.

6.





Commonly used PostgreSQL configuration parameters and common system tables usage.

7.

Exposure to PostgreSQL maintenance tasks.

8.

Exposure to PostgreSQL deployments in cloud like AWS(RDS or EC2) or GCP.

9.

High-availability like Repmgr or pgpool or efm

10.

Exceptional experience administering multi-terabyte databases

11.

Aptitude to independently learn new technologies

12.

Solid communication skills and ability to work effectively across multiple business and technical teams

13.

Background in building large database infrastructure supporting a high volume of transactions in a mission-critical environment

14.

knowledge python and Singlestore Memsql

Required Skill Profession

Computer Occupations

📌 IND_Developer (Noida)
🏢 Artech Infosystems
📍 Noida