Postgresql Database Administrator Level 2

JOB Description for PostgreSQL Database ManagementPostgreSQL Database Administrator (L2)

LOCATION
DOMAIN
Level (L1/L2/L3)
Mumbai, Fort
PostgreSQL Database
L2
4-6 Years relevant experience
Required Relevant Domain Experience
Job Type (Onsite/Remote)
Shift details (General/ 24X7)
Qualification
Onsite
Onsite support 24 X 7
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]
   Relevant Certification (Preference)
   PostgreSQL Database troubleshooting and Database
   Cluster Setup working experience is Mandatory
   Certifications Required if ANY
   Specific Remarks/Requirement by
   customer
   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)
   Question based on JD:

1. Tell me about yourself, education background and current profile roles and responsibility.
2. Tell me PostgreSQL Architecture
3. How to Perform a Backup and Restore in PostgreSQL?
4. What are some important background processes in Postgres?
5. What are some wal related parameter in postgrs.conf file?
6. What is a tablespace?
7. How to kill a session in Postgres?
8. Difference between vacuum and vacuum full?
9. Difference between pg_dump and pg_dumpall?
10. How authentication happens in Postgres?
11. What do you mean by Postgres cluster?
12. What are different types of Foreign data Wrappers?