Postgresql Database
Company Name
Infosys Ltd ( Bangalore )
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.
-