Spigot Software - Greenplum Database Administrator (3-12 yrs)

Job Description :

- 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;

- Collaborate with other teams to apply updates, patches, version upgrades as required;

- 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.

- Diligently partner with the infrastructure,network,Server,Storage, other database and application teams .

- Monitor Greenplum cluster connectivity and security, support and maintenance

- Strong communication skills

- Provide 24x7 operation support;

Good to have :

- Knowledge of other database technologies PostgreSQL, NoSQL etc

- Exposure to automation techniques/tools and languages.

- Experience with performance tuning and monitoring.