PostgreSQL Database Administrator

• Install, configure, and maintain PostgreSQL database systems.
• Monitor database performance and optimize for efficiency and reliability.
• Implement and manage database backup and recovery processes.
• Ensure database security and compliance with organizational policies.
• Collaborate with developers to design and optimize database schemas.
• Troubleshoot and resolve database-related issues promptly.
• Perform regular database maintenance tasks, including updates and patches.
• Develop and implement disaster recovery plans.
• Monitor and manage database storage and capacity planning.
• Provide best practice guidance to development teams.
• Maintain database documentation and standards.

Qualifications:

• 6 to 8.5YEARS
• Must-Have Skills and Experience:

Mandate skills:

• DB admin - PostgresSQL write query plan, index , hands SQL commands.
• DB replication, PG commands, write script for upgrades.
• Proven experience as a PostgreSQL Database Administrator.
• Strong knowledge of database design, performance tuning, and optimization.
• Proficiency in writing query plans, creating indexes, and SQL commands.
• Experience with database replication and PostgreSQL commands.
• Ability to write scripts for database upgrades.
• Experience with backup, recovery, and disaster recovery planning.
• Familiarity with database security best practices.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a team.
• Knowledge of cloud database services (e.g., AWS RDS, Azure Database for PostgreSQL).
• Experience with automation tools and scripting languages (e.g., Python, Bash).