PostgreSQL DBA

Job Title: PostgreSQL Database Administrator

Experience: 6–8 Years

Work Mode: Hybrid

Locations: Hyderabad / Pune

Joiners: Only immediate joiners & candidates who have completed notice period

Required Skills

• Strong hands-on experience in PostgreSQL administration (6+ years).
• Excellent understanding of SQL and query optimization techniques.
• Deep knowledge of database services, architecture, and internals.
• Experience in performance tuning at both DB and OS levels.
• Familiarity with DataGuard or similar high-availability solutions.
• Strong experience in job scheduling and automation.
• Comfortable with installing, configuring, and upgrading PostgreSQL.
• Basic to intermediate knowledge of Linux system administration.
• Hands-on experience with shell scripting for automation and monitoring tasks.

Key Responsibilities

• Administer and maintain PostgreSQL databases with 6+ years of hands-on experience.
• Write and optimize complex SQL queries for performance and scalability.
• Manage database storage structures and ensure optimal disk usage and performance.
• Monitor, analyze, and resolve database performance issues using tools and logs.
• Perform database tuning, configuration adjustments, and query optimization.
• Plan, schedule, and automate jobs using cron or other job scheduling tools at DB and OS levels.
• Install and upgrade PostgreSQL database software to new versions as required.
• Manage high availability and disaster recovery setups, including replication and DataGuard administration (or equivalent techniques).
• Perform regular database backups and restorations to ensure data integrity and availability.
• Apply security patches and updates on time.
• Collaborate with developers for schema design, stored procedures, and access privileges.
• Document configurations, processes, and performance tuning results.

Job Types: Full-time, Permanent

Pay: ₹400,000.00 - ₹1,500,000.00 per year

Benefits:

• Health insurance
• Paid time off
• Work from home

Application Question(s):

• Currently Serving Notice Period? (Yes/No)

Experience:

• PostgreSQL: 6 years (Required)

Location:

• Hyderabad, Telangana (Required)

Work Location: In person