Greenplum Database Administrator (DBA)

Job Description

Job Title: Greenplum Database Administrator (DBA) Location: BKC, Mumbai Job Type: Full time Experience : 2 - 6 years in DBA role, with last 2+ years in Greenplum 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 large Data Platforms. https://smart-analytica.com Empowering Your Digital Transformation with Data Modernization and AI Job Overview: We are seeking a highly skilled and experienced Greenplum Database Administrator (DBA) to join our IT team. The 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. Key Responsibilities: Database Management: Manage and maintain multiple Greenplum database clusters (Versions 6x or 7x), ensuring high availability and reliability. Oversee resource management, maintenance activities, and performance tuning of production databases. Develop and implement database policies and procedures to ensure data integrity and security. Migration and Upgrades: Plan and execute database migrations, upgrades, and patch management. Lead data migration projects, including transitioning from other database systems to Greenplum. Performance Optimization: Monitor and analyse database performance, identifying and resolving bottlenecks. Implement performance tuning measures to optimize database operations. Automation and Scripting: Develop and maintain shell scripts for database automation tasks, including backup and restore processes, data extraction, and ETL workflows. Automate day-to-day database management tasks to improve efficiency and reduce manual intervention. Collaboration : Work closely with application development teams to integrate databases with other systems and support application requirements. Coordinate with stakeholders to gather requirements and provide regular updates on database-related projects. Academic Qualifications: Bachelors degree in computer science, Information Technology, or equivalent Relevant certifications (e.g., Greenplum Certified Professional) are a plus. Experience: 2-6 years of experience in database administration architecture , with at least 2 years experience in Greenplum databases. Proven experience in handling large Greenplum clusters and database migrations. Technical Skills: Strong knowledge of Greenplum database, 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 SQL Server 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