PostgreSQL DBA

Job details

Sr. Technical Associate (PostgreSQL-DBA)

Experience-2 to 3 yrs

Work from Office

Location-Andheri East

 Responsible for understanding operational requirements including hardware, architecting, configuring, integrating, and maintaining mission-critical Production PostgreSQL databases.

 Responsible for all backup, recovery, PITR replicating, manage standby servers, refresh nonproduction databases etc.

 Experience on community-supported tools like Pgbadger, Slony, PGadmin, Pgpool, Pgbouncer & REPMGR.

 Clusters and upgrading/migrating various PostgreSQL database version.

 Database administration and tuning databases

Job Description:

 Develop database automation scripts and maintenance.

 Provide technical guidance for integration, testing, design, development, planning of new production systems/databases

 Contribute to improving and creating DBA policies, procedures and standards.

 Experience in monitoring, managing and maintaining mission-critical 24x7 production databases along with installation and configuration of the database, implementing high-availability solutions, setup monitoring tools, setup database security, optimizing resources, etc.

 Hands-on experience on Shell scripting & SQL query tuning  Hands on experience replication and HADR activities

 Good to have: Experience on Enterprise DB products and Certifications.

 Experience to manage, diagnose and fix system level issues with database.

 Must be a great team player and a highly motivated self-starter; must have the eagerness and willingness to learn and share new ideas, tools, and techniques to continually improve overall quality of software development and processes.

 Prepare technical documentations and specifications.

 Incident analysis/RCAs/troubleshooting and identification of permanent resolutions

 Troubleshoot problems reported by users and analyse and isolate issues.

 Willing to work on multi database platform.

 Ready to work on holiday/ in critical situations.

Nice to have  Exposure to working with cloud/virtualization technologies.

Interested candidates can share their updated resume

Candidates should be available to join on or before 1st December 2024

If you have any references then kindly share as it would be helpful

Job Type: Full-time

Salary: ₹450,000.00 - ₹600,000.00 per year

Benefits:

Health insurance
Provident Fund
Schedule:

Day shift
Rotational shift
Ability to commute/relocate:

Greater Mumbai, Mumbai - 4000+3, Maharashtra: Reliably commute or planning to relocate before starting work (Required)
Experience:

total work: 2 years (Preferred)
Speak with the employer
++1-XXXXXXXXXX