Spigot Software - Greenplum Database Administrator

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. (ref:hirist.tech)

Location: in, IN

Posted Date: 11/25/2024