Job Title: SQL Developer

Location: Remote

Duration: 12 Months

Rate: Open. Depends on experience

MUST HAVE: ACTIVE IRS MBI clearance (currently working at IRS or separated or not working will also works, but need to have active IRS MBI) , Even after any resource is rolled over and if they have final MBI cleared, will be active atleast 5 years from the date of issue.

Role Description/Responsibilities:

·        Experienced in PL/PGSQL, SQL code development, maintenance, and migration

·        Experience in creating, maintaining, and optimizing stored procedures, functions, inline SQL, and ETL processes

·        In depth knowledge of the PostgreSQL architecture and application data lifecycle management

·        Knowledge of database design, query optimization, index management, integrity checks

·        Familiarity with Software Development Life Cycle, specifically Agile, and able to independently participate in each phase

·        Previous experience in monitoring, supporting, and resolving issues for applications with Database technologies

·        Willing to work during Production maintenance hours & provide on call support

Preferred: experience in working with Greenplum (PostgreSQL) and Oracle SQL/PLSQL

Preferred: Previous RRP and/or IRS experience with active MBI clearance

Requirements/Required Skills:

·        7+ years working with specified software language as a developer

·        3+ years using Rational Team Concert or equivalent toolset

·        Hands on Greenplum Experience