Role description:
* The Postgres Senior SME is responsible for the administration, optimization, and support of PostgreSQL databases within the organization.
* This role involves ensuring the performance, security, and reliability of database systems, as well as providing expert guidance to development teams and business users.
Key responsibilities:
* Database Administration: Manage and maintain PostgreSQL databases, including installation, configuration, and upgrades.
* Performance Tuning: Optimize database performance through query tuning, indexing, and schema design. experience of performance tuning in a datawarehousing application
* Backup and Recovery: Implement and manage backup strategies and disaster recovery plans.
* Security: Ensure database security by implementing best practices and monitoring for vulnerabilities.
* Troubleshooting: Diagnose and resolve database-related issues, providing support to development teams and end-users.
* Documentation: Create and maintain documentation for database configurations, procedures, and policies.
* Collaboration: Work closely with developers, system administrators, and business analysts to support database-related needs.
* Training: Provide training and mentorship to junior database administrators and other team members.
Key skills/knowledge/experience:
* Proficiency in SQL and PL/pgSQL.
* Strong understanding of database design principles.
* Experience with performance tuning and optimization.
* Knowledge of backup and recovery techniques.
* Familiarity with database security best practices.
* Excellent problem-solving and analytical skills.
* Strong communication and teamwork abilities.
* Certifications: PostgreSQL certification or other relevant database certifications.
* Additional Skills: Experience with other database systems (e.g., Oracle, MySQL), cloud platforms (e.g., AWS, Azure), and automation tools.