postgres_greenplum database developer

A PostGres DBA with skills in PostGres DB design, performance tuning, maintenance, PG best practices, & PL/pgSQL. The PostGres DBA will manage a Massively Parallel Processing (MPP) DCA and Oracle and handle all PDM management, deployment, and validation across multiple databases.

Experience in MPP databases (Netezza, Teradata, Greenplum) a major plus along with experience as an Oracle DBA. This is a highly complex and extremely large database environment with thousands of tables and and tens of thousands of fields in one PDM.

Duties include:

Job Duty 1 with % of time - Manage an MPP Data Computing Appliance (DCA) with a PostGres architecture as the DBA and multiple development and testing databases.

All PostGres best practices from a DBA perspective is to be applied along with the MPP best practices based on experience or on the job training.

Grow and develop the DBA expertise and practice on the program. Become the go-to person in DB management. (70%)Job Duty 2 with % of time - Establish and champion DBA best practices along with owning and updating the DB process and change management.

(20%)

Job Duty 3 with % of time - Understand and comply with development standards and SDLC to ensure consistency across the business (5%)

Job Duty 4 with % of time - Collaborate with Client SMEs, IBM team and other vendor teams (5%)

Required Skills:

Please note these are the top technical skills that the Buyer feels a candidate MUST have. General knowledge of basic office software such as MS Office Suite as well as good communications skills are a given.

PostGres database design and performance tuning skills. 5+

PL/pgSQL 4+.

Advanced SQL skills 4+

Good oral communication skills

Strong written communication skills

Nice to have skills:

Please note these are nice to have skills.

It does not preclude a candidate who does not possess all or some of these skills from the selection process but this could be used as a differentiator between candidates:

MPP (Netezza, Teradata, or Greenplum) Database design and performance tuning skills 4+

MPP-Informatica Power Exchange skills 3+

Oracle database design & performance tuning skills 3+.

Java or Shell scripting experience. 3+

SAS Scoring Accelerator in Greenplum Database skills 2+

Prior IRS experience and, especially, an active MBI are a plus.