Postgresql Database Administrator

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

Experience: 2-8 years in DBA role, with last 2+ years in Greenplum or postgresql

Location:Location:

Department: Big Data, Analytics and Cloud

Company: Smartavya Analytica Private limited is niche Data and AI company. Based in Pune, we are pioneers in data-driven innovation, transforming enterprise data into strategic insights. Established in 2017, our team has experience in handling large datasets up to 20 PBs in a single implementation, delivering many successful data and AI projects across major industries, including retail, finance, telecom, manufacturing, insurance, and capital markets. We are leaders in Big Data, Cloud and Analytics projects with super specialisation in very very large Data Your Digital Transformation with Data Modernization and AI.

Job Overview:We are seeking a highly skilled and experienced Senior Greenplum Database Administrator (DBA) to join our IT team. The Senior Greenplum DBA will be responsible for the performance, integrity, and security of our Greenplum database systems. This role requires extensive experience in managing Greenplum clusters, optimizing database performance, and ensuring data availability and consistency. The ideal candidate will also possess excellent leadership and communication skills, as they will be required to manage a team of junior DBAs and collaborate with various IT and business teams.

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.