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.
 
-