Postgresql Database Administrator

Job Title: Greenplum Database Administrator (DBA)/Postgresql DBA

Company:

Job Overview:

Key Responsibilities:

• Database Management:

•  Manage and maintain multiple Greenplum database clusters (Versions 6xor7x), ensuring high availability and reliability.
• Oversee resource management, maintenance activities, and performancetuning of production databases.
• Develop and implement database policies and procedures to ensure dataintegrity and security.

• Migration and Upgrades:

• Plan and execute database migrations, upgrades, and patch management.
• Lead data migration projects, including transitioning from other databasesystems to Greenplum.

• Performance Optimization:

•  Monitor and analyse database performance, identifying and resolvingbottlenecks.
• Implement performance tuning measures to optimize database operations.

• Automation and Scripting:

• Develop and maintain shell scripts for database automation tasks, includingbackup and restore processes, data extraction, and ETL workflows.
•  Automate day-to-day database management tasks to improve efficiency andreduce manual intervention.

• Team Leadership:

•  Manage and mentor a team of junior database administrators, providingtechnical guidance and support.
•  Delegate tasks effectively and ensure project milestones are met withindeadlines.

• Collaboration:

• Work closely with application development teams to integrate databases withother systems and support application requirements.
• Coordinate with stakeholders to gather requirements and provide regularupdates on database-related projects.

• Incident Management:

• Handle incident management and troubleshooting for database-related issues.
• Ensure timely resolution of database incidents and communication withaffected parties.

Academic Qualifications:

•  Bachelors degree in computer science, Information Technology, or equivalent
•  Relevant certifications (e.g., Greenplum Certified Professional) are a plus.

Experience:

• 2-8 years of experience in database administration, with at least 2-5 yearsspecifically managing Greenplum databases.
• Proven experience in handling large Greenplum clusters and databasemigrations.

Technical Skills:

•  Strong knowledge of Greenplum database architecture, performance tuning, and backup/recovery processes.
• Proficiency in SQL, PL/pgSQL, and shell scripting.
• Experience with database automation tools and techniques.
• Familiarity with other database systems such as PostgreSQL, HAWQ, and SQLServer is a plus.
• Experience with Linux operating systems and tools like WinSCP, Ambari, and Pivotal Command Centre.

Soft Skills:

• Excellent leadership and team management skills.
•  Strong problem-solving and analytical abilities.
• Effective communication and interpersonal skills.
• Ability to work independently and under tight deadlines.