StateJobsNY

NY HELPNo

AgencyState Comptroller, Office of the

TitleInformation Technology Specialist 2, SG-18 (Programming)

Occupational CategoryI.T. Engineering, Sciences

Salary Grade18

Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)

Salary RangeFrom $51268 to $65190 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.50

Workday

From 8:30 AM

To 4:30 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No

County Albany

Street Address Division of Retirement Services Redesign Project

110 State Street

City Albany

StateNY

Zip Code12236

Minimum Qualifications Interested candidates must be currently reachable on the Information Technology Specialist 2 (Programming), SG-18, eligible list OR eligible to transfer under Section 52.6 of the Civil Service Law.

52.6 Transfer

Candidates must have one year of permanent, competitive service in a qualifying title allocated to salary grade 16 or higher.

Duties Description Under the direction of the Information Technology Specialist 3 Database (Database Administration Specialist), the Information Technology Specialist 2 (Programming) will be responsible for, but not limited to, the following activities:

• Work collaboratively with application development Data Cleansing staff by preparing database fixes for the date cleansing effort;
• Collaborate with NYSLRS’ selected implementation vendor in the implementation of and technical support of the database environments (including installation, modification, and maintenance) for the Retirement Benefit Administration System;
• Participate with NYSLRS’ selected implementation vendor in the implementation of and technical support of the database environments from ancillary products associated with the NYSLRS Project;
• Ensure that the Information Technology Specialist 3 Database (Database Administration Specialist) is made aware of emerging issues dealing with any of the database environments associated with the NYSLRS Project;
• Work cooperatively in the development, implementation, and maintenance of detailed technical designs, and procedures for data modeling, capacity planning, performance analysis, tuning, monitoring, change control, and database management in accordance with OSC’s existing systems standards as well as any other applicable standards;
• Participate in proactive monitoring, diagnosing, and correcting database problems (i.e. data corruption, contention, incorrect indexes, CPU utilization, etc);
• Participate with NYSLRS’ selected implementation vendor in the development of backup, recovery and contingency/disaster planning;
• Work cooperatively with NYSLRS’ selected implementation vendors for conversion planning to ensure that the database environment is designed, developed, installed and is performing in a manner adequate to meet the needs of the Retirement Benefit Administration System.

Additional Comments PREFERRED QUALIFICATIONS:
• Experience maintaining SQL scripts and PL/SQL procedures
• Excellent technical documentation skills
• Excellent oral and written communication skills
• Excellent organizational skills

Some positions may require additional credentials or a background check to verify your identity.

Name Brian Vogel

Telephone (518) 474-1924

Fax (518) 486-6723

Email Address recruit@osc.state.ny.us

Address

Street 110 State Street

City Albany

State NY

Zip Code 12236

Notes on ApplyingInterested candidates should submit a cover letter and resume to recruit@osc.state.ny.us no later than April 21, 2014. Please reference Item # 07269bv-OSC in the subject line of the email and on the cover letter when responding.
When responding, please include the reference number and letters listed in this section. The GOER ID # should not be included.