Lead Architect

Role Description/Responsibilities:

Ability to assess current state, identify customer requirements, and define the future state and/or business solution. Research, gather and synthesize information. Align with specific iterations of work, managing User Stories and traceability, assisting with task tracking, and getting information out of ELM, and supporting SCRUM and testing activities to help ensure successful delivery.

Requirements/Required Skills:

· 3 years using Rational Team Concert or equivalent toolset and functional expertise.

· 5 years of providing CLM Support on large projects.

· Technical Architect with experience in analyzing business requirements and designing system architecture.

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

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

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

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

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

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

· Experience with CI/CD, Jenkins, RTC / Code Repository.

· Understanding of Agile development

· Excellent organization skill to meet deadlines, fulfill task assignments, and proactively strives to achieve team objectives

· Knowledge and understanding of using Control-M

· Excellent Communication Skills

· Preferred: Experience in working with Greenplum (PostgreSQL) and Oracle SQL/PLSQL.

· Preferred: Previous IRS experience with active MBI clearance.

Please note the proposed Candidates MUST meet the following requirement(s) for consideration in filling the position:

Citizenship Requirement:

Candidates MUST be a US Citizen or Lawful Permanent Resident (LPR) with at least three consecutive years of U.S. residency, from the date of legal entry, as an LPR.

Active Treasury Public Trust Clearance Preferred.