ITS53 Programmer BID requirements~1.doc

Specifications for ITS53 Staff Augmentation Posting

Doc # ITS53_Programmer_TRB_1 Rate Card Title: Software Systems Analyst/Programmer

_x_ New Posting

__ RePosting: __ No suitable resumes received- reposted with no changes (please do not resubmit resumes)

__ Reposted with skill set edits

__ Reposted with different title, higher maximum rate

General Requirements:

CORI requirements:

_x_ After candidate selection

Other (including special requirements):

Interview requirements:

_x_ Initial contact by phone, interview may be in person

Other:

Total number of positions sought:

Maximum acceptable hourly rate: $60 (Range: $50-$60) May be filled PRIOR TO CLOSE DATE: _x_ Yes __No Additional Resume Submission Specifications and Requirements:

· Maximum number of resumes per ITS53 Vendors: three (3)

· Resumes must be submitted as attachments in CommBuys

· No phone calls please – Submit questions in CommBuys/Answers will be provided through CommBuys

· Indicate on resume if candidate is presently working for another State Agency or has worked for another State Agency within the past 12 months (if so, indicate State Agency name)

· Include candidate Pay Rate when submitting a candidate’s resume in CommBuys (vendors can upload as a separate attachment)

· Rates are all-inclusive (travel and any additional expenses are included in the rate)

Worksite Address:

Mass Teachers’ Retirement System

One Charles Park, 2nd floor

Cambridge, MA 02142 Contract Length:

Estimated - through June 30, 3017 Project(s) Duration:

two (2) years Hours per Week:

30-40 hours (To Be Determined) Other Schedule Related:

Rate Card Title from the Rate Card posted on CommBuys:

Software Systems Analyst/Programmer MTRS Functional Title:

Applications Systems Analyst/Programmer (Oracle PL/SQL Developer)

Position Summary:

Under the direct supervision of MTRS’s Senior Data Analyst and technical lead for the creditable service conversion team, Massachusetts Teachers’ Retirement System is seeking an experienced Oracle PL/SQL Developer to develop a program to calculate Creditable Service totals for their members. The candidate selected for this position will work closely with creditable service conversion team on design, coding, testing, and transformation based on the data models. This position requires experience working in an agile environment.

Responsibilities

· Serving as an Oracle PL/SQL developer, this person will work closely with existing Business and Technical leads on tasks involving design, coding, data cleansing, transformation, aggregation and system testing based on the data models developed.

· Maintain data integration, data distribution and correct issues as they arise

· Responsible for estimating, tracking and reporting status on task

· Conducts code reviews with peers

· Work with Business Analysts and Subject Matter Experts to understand the business requirements Qualifications

· Bachelor’s Degree

· At least five (5) years of related professional work in the IT industry

· 3+ years of Oracle PL/SQL development experience

· Oracle 11g experience

· Must have strong Oracle PL/SQL programming skills

· Experience with data modeling, data conversion and data migration

· Experience with relational database design and database management systems (Oracle)

· Experience with object-oriented software design and development

· Experience with iterative software development methodologies, such as Agile

· Strong interpersonal skills and the ability to work effectively in a team environment