Postgres Database Administrator - Performance Tuning

Job Title : PostgreSQL Database Administrator

Experience : 68 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.

Skills :- PostgreSQL, SQL and Oracle Data Guard