Mainframe Developer

Job Title: Mainframe Developer

Duration: 30+ Months

Location: Albany NY 12243

(3 Days Onsite in a week)

Core Technical Skills (Must-Have):

Oracle 12c or higher

• PL/SQL development (Functions, Stored Procedures, Sequences)
• Table design, tuning, data normalization
• Handling large datasets (millions of rows/gigabytes of data)

Micro Focus COBOL Runtime Environments

• Micro Focus COBOL, Oracle Pro*COBOL
• Maintaining production & development environments
• Supporting runtime operational environments

Oracle Database Administration

• Tuning, storage management, table design, user administration

C# / .NET (CLS Languages)

• Visual Studio experience (application development & maintenance)

Microsoft SQL Server

• T-SQL, SSIS
• Stored Procedures, Functions, DDL/DML

Documentation Skills

• Technical specifications
• Architecture specifications
• System/Database design documentation

Required Qualification:

• 84 months experience working directly with Oracle 12c or higher. Experience to include PL/SQL development, Functions, Stored Procedures, sequences, Table Design, and Tuning. Experience should include data normalization and working with large data sets involving millions of rows or gigabytes of data.
• 84 months experience with Micro Focus COBOL Runtime environments including activities related to production and / or development environments maintaining current technology and versions for Micro Focus CCOBOL, Oracle ProCobol, and all related software to maintain operational environments.
• 84 months experience in Oracle Database administration including tuning, stored management, table design and user administration.
• 84 months experience in C#/CLS languages utilizing Visual Studio.
• 84 months experience with Microsoft T-SQL or SSIS. Including stored procedures, Functions, DDL & DML.
• 84 months experience documenting Technical and Architecture Specifications.

Responsibilities:

Provide high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi[1]leveled architecture or component interactions of a large-scale software system. May include system and/or Database design, application programming, and documentation and integration testing of programs, as well as guidance and mentoring of other staff.

Short Description:

Summer Electronic Benefits Transfer (SEBT) is a food benefit program that helps low-income families with school-age children buy groceries during the summer when kids might not have access to school meals.

Required Qualification:

• 84 months experience working directly with Oracle 12c or higher. Experience to include PL/SQL development, Functions, Stored Procedures, sequences, Table Design, and Tuning. Experience should include data normalization and working with large data sets involving millions of rows or gigabytes of data.
• 84 months experience with Micro Focus COBOL Runtime environments including activities related to production and / or development environments maintaining current technology and versions for Micro Focus CCOBOL, Oracle ProCobol, and all related software to maintain operational environments.
• 84 months experience in Oracle Database administration including tuning, stored management, table design and user administration.
• 84 months experience in C#/CLS languages utilizing Visual Studio.
• 84 months experience with Microsoft T-SQL or SSIS. Including stored procedures, Functions, DDL & DML.
• 84 months experience documenting Technical and Architecture Specifications.

Responsibilities:

Provide high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi[1]leveled architecture or component interactions of a large-scale software system. May include system and/or Database design, application programming, and documentation and integration testing of programs, as well as guidance and mentoring of other staff.