Greenplum Database Administrator - PostgreSQL (5-6 yrs)

Role : Greenplum Administrator

Location : Pune

Experience : 5+ years

NOTE : Immediate joiner

Mandatory skills :

Experience : 5+ years in database administration

Key Skills : Greenplum Database, PostgreSQL, performance tuning, backup & recovery, cluster management, SQL optimization

Responsibilities : Maintain and optimize Greenplum clusters, manage database security and performance, troubleshoot and support ETL processes

The Greenplum will administer the Greenplum infrastructure for the organization, as well as multiple development and test infrastructures. The Administrator will also be involved in advanced support and administer Greenplum cluster providing support for all administrative tasks such as user management, security planning and implementation, backups, disk management and cluster maintenance (e.g. re-indexing or node balancing

Responsibilities :

- Maintain and screen Greenplum capacity planning, administration, expansion and install, configure Greenplum environment components and manage troubleshoot scheduled analytics;

- Provide 24x7 operation support;

- Responsible for implementation and ongoing administration of Greenplum infrastructure, file system management, log files, and monitoring;

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

- Diligently partner with the infrastructure, network, database, application teams to provide high data quality and availability;

- Develop and maintain documents pertaining to installation and configuration for installations/deployments and support;

- Accountable for assessment of current technical infrastructure and provide performance monitoring of routines and tuning of tools;

- Document best practices, guidelines, and make recommendations for future environments;

- Align with the systems engineering team to propose and deploy new hardware and software environments required for Hadoop and to expand existing environments;

- Monitor Greenplum cluster connectivity and security, support and maintenance; and

- Responsible for installs, administration, and support of Windows and Linux operating systems in an enterprise environment.

Qualifications & Technical Skills :

- Bachelors degree in Information Technology or related field and/or relevant work experience required;

- 5+ years of demonstrated experience of administering a large Greenplum or PostgreSQL databases.

- Proven deep understanding of Greenplum technology, knowledge of Linux as Greenplum runs on Linux, and general operational expertise such as good troubleshooting skills, understanding of systems capacity, and networks, etc.;

- Ability to Add and remove nodes, keep track of jobs, monitor critical parts of the cluster, schedule and configure it and take backups;

- Knowledge of troubleshooting Java applications is a plus;

- Demonstrated experience as a technical leader with strong acumen in architecture, design, development, testing, and administration of Hadoop based solutions;

- Ability to work independently and work with internal and external teams to deliver results;

- Ability to or willing to learn other database technologies;

- Highly motivated, energetic with hands on experience working in a fast-paced, evolving environment with frequently changing priorities; and

- Strong communication and influencing skills (oral, written, listening, interactions with senior management