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