Postgresql Database


Company Name


Job Description

  • Job Description:

    We are hiring an experienced PostgreSQL Database Administrator (DBA) with 3+ years of experience. The ideal candidate will be responsible for the installation, configuration, administration, and performance tuning of PostgreSQL databases to ensure high availability, security, and reliability.

    Responsibilities:

    • Install, configure, and maintain PostgreSQL databases across development, testing, and production environments.

    • Monitor database performance, optimize queries, and fine-tune system parameters.

    • Implement database backup, recovery strategies, replication, and disaster recovery solutions.

    • Work closely with application teams to design efficient database schemas and queries.

    • Troubleshoot database issues, perform root cause analysis, and implement corrective actions.

    • Ensure database security, including user management, roles, and permissions.

    • Support migration, upgrades, and patches of PostgreSQL databases.

    • Document processes, configurations, and procedures for database operations.

    • Collaborate with cross-functional teams in project phases such as design, solution generation, and deployment.

    • Contribute to organizational initiatives, ensuring high-quality, value-driven solutions for clients.


    Skills Required:

    Mandatory Technical Skills

    • Strong experience as a PostgreSQL DBA (installation, configuration, performance tuning, and monitoring).

    • Expertise in backup/recovery, replication, and clustering.

    • Solid understanding of SQL, PL/pgSQL, query optimization, and indexing strategies.

    • Experience with Linux/Unix environments (as PostgreSQL typically runs on them).

    • Knowledge of database security and compliance best practices.

    Additional Technical Skills (Good to Have):

    • Familiarity with cloud databases (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL).

    • Experience in scripting (Shell, Python, or Ansible) for automation.

    • Exposure to other databases like MySQL, Oracle, or MongoDB.

    • Knowledge of high availability solutions (Patroni, PgPool-II, etc.).

    • Understanding of Agile and DevOps practices (CI/CD pipelines, Git, Jenkins).

    Professional & Soft Skills:

    • Strong problem-solving and analytical skills.

    • Excellent communication and teamwork abilities.

    • Ability to diagnose complex issues and provide robust solutions.

    • Self-motivated, adaptable, and proactive in handling responsibilities.

Job Details

Experience : 3 To 8
Number Of Vacancies : 1000
Job Type : Permanent
Industry Type : IT/Software
Salary : 3 Lac - 9 Lac P.A

Education Summary

UG : BE/B.Tech,B.Sc,BCA PG : M.Sc,MCA,M.Tech

Contact Details

Contact Person : NA
Contact Number : 7338856831
e-mailId : askus@infosys.com
Address : Infosys Ltd. Plot No. 1, Rajiv Gandhi Infotech Park, Hinjawadi, Taluka Mulshi, Pune.

Back

Office Location

Central Jakarta No 1234, Jakarta, Indonesia