Greenplum Dba

Mumbai***

**About Us**
- We empower enterprises globally through intelligent, creative, and insightful services for data integration, data analytics and data visualization.
- Hoonartek is a leader in enterprise transformation, data engineering and an acknowledged world-class Ab Initio delivery partner.
- Using centuries of cumulative experience, research and leadership, we help our clients eliminate the complexities & risk of legacy modernization and safely deliver big data hubs, operational data integration, business intelligence, risk & compliance solutions and traditional data warehouses & marts.
- At Hoonartek, we work to ensure that our customers, partners and employees all benefit from our unstinting commitment to delivery, quality and value. Hoonartek is increasingly the choice for customers seeking a trusted partner of vision, value and integrity

**How We Work?**

Define, Design and Deliver (D3) is our in-house delivery philosophy. It’s culled from agile and rapid methodologies and focused on ‘just enough design’. We embrace this philosophy in everything we do, leading to numerous client success stories and indeed to our own success.
- We embrace change, empowering and trusting our people and building long and valuable relationships with our employees, our customers and our partners. We work flexibly, even adopting traditional/waterfall methods where circumstances demand it. At Hoonartek, the focus is always on delivery and value.
- JD:
- Minimum 3-7 years of experience in Green plum database.
Experience in production environment 24*7 support
Hands on experience with Greenplum database V6.X.
Excellent Greenplum/PostgreSQL architecture and database maintenance knowledge
Experience in Greenplum command center and workload management
Experience in Greenplum Performance monitoring,tuning,Backup and troubleshooting
Maintain Greenplum capacity planning, administration, expansion and install, configure Greenplum environment components.
Responsible for administration of Greenplum infrastructure, file system management, log files, and monitoring;
Monitor data distribution to identify data skew, also monitor vacuum and analyze needed on objects
Manage segments, recover segments during segment crash.
Manage GP backup and restore
Proficient with gpfdist for data loading and other tools/utility of GP
Excellent shell and sql skill for DBA tasks automation
Ability to or willing to learn other database technologies.
Excellent analytical, problem-solving, and troubleshooting skills.
Maintain a good relationship with other technology teams.
Monitor Greenplum cluster connectivity and security, support and maintenance
Strong communication skills
Role required to work from Office only.
Provide 24x7 operation support;
Ability to work both independently and Lead.
Overall Details:
- Primary Skill: Greenplum,Linux
Secondary Skill: Postgress,Cloudera, Oracle, Shell Scripting
OS: Linux
Role: Administrator**Job Requirement**
- JD:
- Minimum 3-7 years of experience in Green plum database.
Experience in production environment 24*7 support
Hands on experience with Greenplum database V6.X.
Excellent Greenplum/PostgreSQL architecture and database maintenance knowledge
Experience in Greenplum command center and workload management
Experience in Greenplum Performance monitoring,tuning,Backup and troubleshooting
Maintain Greenplum capacity planning, administration, expansion and install, configure Greenplum environment components.
Responsible for administration of Greenplum infrastructure, file system management, log files, and monitoring;
Monitor data distribution to identify data skew, also monitor vacuum and analyze needed on objects
Manage segments, recover segments during segment crash.
Manage GP backup and restore
Proficient with gpfdist for data loading and other tools/utility of GP
Excellent shell and sql skill for DBA tasks automation
Ability to or willing to learn other database technologies.
Excellent analytical, problem-solving, and troubleshooting skills.
Maintain a good relationship with other technology teams.
Monitor Greenplum cluster connectivity and security, support and maintenance
Strong communication skills
Role required to work from Office only.
Provide 24x7 operation support;
Ability to work both independently and Lead.
Overall Details:
- Primary Skill: Greenplum,Linux
Secondary Skill: Postgress, Oracle,Cloudera, Shell Scripting
OS: Linux
Role: Administrator