PostgreSQL Database Administrator (L2)

LOCATION: Mumbai, Fort

DOMAIN: PostgreSQL Database

Level (L1/L2/L3): L2

Required Relevant Domain Experience: 4 -6 Years
relevant experience 

Job Type (Onsite/Remote): Onsite

Shift details (General/ 24X7): Onsite support 24 X 7

Qualification:

 B.E./Diploma/BSC/BTech (No education gap, Full
time)

1. B.E. / Diploma [ In Computers Science, IT,

Electronics & Telecommunication] [ Civil and

Mechanical not preferred]

2. B.Sc. -IT

3. BCA or MCA [ Full time course from reputed

University]

4. No gap in education [ Passing year for S.S.C, H.S.C.

and Degree/Diploma to be mentioned]

Certifications Required if ANY: Relevant
Certification (Preference)

Specific Remarks/Requirement by customer: PostgreSQL Database troubleshooting and Database Cluster Setup working experience is
Mandatory.

Role Purpose

We are seeking an experienced PostgreSQL Database
Administrator to join our team. The ideal candidate will have strong technical
skills and experience in managing and supporting PostgreSQL Database including
PCS Cluster Setup and Database migration, new Database server provisioning,
replication, Link Servers, Hardening, patching in day -to -day operations.

JOB RESPONSIBILITIES

Experience with database technologies, designing data
architecture, and monitoring and enforcing

database rules

Manage and maintain PostgreSQL databases.

Ensure database performance, integrity, and security.

Design and implement database systems.

Monitor and optimize database performance.

Ensure data integrity and security.

Develop and implement backup and recovery processes.

Plan and execute disaster recovery strategies.

Collaborate with development and operations teams.

Automate database tasks and processes.

Perform database tuning and optimization.

Troubleshoot database issues and provide solutions.

Maintain database documentation and standards.

Implement database upgrades and patches.

Implement database migration to latest version.

Monitor database health and performance metrics.

Ensure compliance with data protection regulations.

Provide support for database -related issues.

Develop and maintain database scripts and tools.

Conduct database capacity planning.

Stay updated with the latest database technologies and
trends.

Technical Skills/Knowledge Requirement

1) Database troubleshooting, Hardening, patching (Must)

2) DB cluster Setup (Must)

3) Foreign data wrappers (Must)

4) Database Migration (Must)

5) Replication (Good to Have)

6) Maintenance Job (Must)

7) User Management (Must)

8) DB performance (Must)