PostgreSQL Database Admin

Key Responsibilities

• Manage and administer PostgreSQL databases in production and non-production environments.
• Perform database installation configuration upgrades patching and maintenance.
• Monitor database performance availability and capacity.
• Troubleshoot database issues and perform root cause analysis.
• Manage database backup recovery and disaster recovery activities.
• Implement and maintain database security access controls and user management.
• Perform database tuning and optimization to ensure efficient performance.
• Support database migration and upgrade activities.
• Monitor database health and resolve performance and availability issues.
• Maintain database documentation and operational procedures.

Required Technical Skills

• Strong hands-on experience in PostgreSQL Database Administration.
• Experience in database installation configuration upgrades and patching.
• Strong knowledge of PostgreSQL performance tuning and troubleshooting.
• Experience with backup and recovery strategies.
• Knowledge of database security user management and access controls.
• Experience with high availability and disaster recovery concepts.
• Strong SQL and database troubleshooting skills.