Postgre SQL DBA

Key Responsibilities

• Aid in the installation, configuration, and maintenance of PostgreSQL databases.
• Monitor database health, availability, storage usage, and system performance.
• Support database backup, recovery, and restoration activities.
• Execute routine database maintenance tasks and health checks.
• Assist with database patching, upgrades, and environment migrations.
• Troubleshoot database connectivity, performance, and operational issues.
• Write and support SQL queries, scripts, and stored procedures.
• Support user access management, permissions, and database security controls.
• Maintain database documentation, procedures, and operational runbooks.
• Support high-availability and disaster recovery activities as needed.

Required Skills & Qualifications

• 1-3 years of experience supporting PostgreSQL databases or database administration.
• Basic understanding of PostgreSQL architecture and database concepts.
• Strong SQL querying and troubleshooting skills.
• Familiarity with Linux/Unix operating systems.
• Understanding database backup and recovery concepts.
• Experience with database monitoring and log analysis.
• Knowledge of database security, user roles, and permissions.
• Ability to troubleshoot performance and connectivity issues.
• Strong analytical and problem-solving skills.
• Good communication and documentation skills.