Information Technology Specialist 2 (Programming)

Under the direction of the Manager of Enterprise Applications, the Information Technology Specialist 2 (Programming) is responsible for all activities associated with the design, development, installation, and performance of agency databases.

Responsibilities

• Design or assist in the design and maintenance of databases.
• Assist in the development of logical data models.
• Define data entities, data attributes, and logical data groups and relationships.
• Assist in the development of physical database design.
• Address performance criteria and standards.
• Coordinate database change controls to interact with application change management.
• Assist in the training of application programmer analysts and operations personnel in the efficient use of database software.
• Participate in the development of disaster recovery planning for databases.
• Maintain specialized data access modules and other programs required to make data available to program and end-users.
• Install and maintain database software products and specialized data access programs.
• Install, customize, and maintain complex database software components.
• Test and implement new and updated versions of databases, data dictionary, and other files handling software from vendors.
• Act as vendor liaison for the diagnosis and resolution of database-related software problems.
• Participate in the development of database standards such as naming conventions, update protocols, performance standards, and internal controls.
• Convert existing databases to new or updated software releases from vendors.
• Monitor the operation and performance of the database software, taking corrective action to obtain the most effective use of it.
• Monitor and tune variables such as space, buffers, logs, and journals.
• Identify and resolve malfunctions and complex problems related to database use, maintenance, and management.
• Maintain a log of database problems and resolutions for future reference.

Qualifications

Minimum Qualifications:

• Current New York State employee with one year or more of qualifying permanent service allocated to a Grade 16 or above and eligible for transfer under Section 52.6 of the NYS Civil Service Law.
• A bachelor's or higher-level degree including or supplemented by 15 semester credit hours in computer science; OR
• A bachelor's or higher-level degree in any field AND one year of experience in information technology; OR
• 60 semester credit hours including or supplemented by 15 semester credit hours in computer science AND one year of professional experience in information technology; OR
• Two years of professional experience in information technology.

This title is part of the New York Hiring for Emergency Limited Placement Statewide Program (NY HELPS). For the duration of the NY HELPS Program, this title may be filled via a non-competitive appointment, meaning no examination is required but all candidates must meet the minimum qualifications of the title. At a future date, employees hired under NY HELPS will have their non-competitive employment status converted to competitive status without having to compete in an examination, affording them the same rights and privileges as competitive class employees of New York State. While serving permanently in an NY HELPS title, employees may take part in any promotion examination for which they are qualified.

Benefits

• Paid time off and sick leave incentive.
• Membership to the NYS Retirement System.
• 90% tuition assistance.
• Free onsite employee parking.
• Telecommuting program offering up to 20% (two days per pay period) upon completion of at least three months of satisfactory performance and appropriate approvals.

Pay

The salary range for this position includes:

• Base Pay: $64,427 hiring rate up to $91,409 job rate.
• Recruitment & Retention Pay: $7,000.

All potential candidates must be legally eligible to work in the United States at the time of appointment and throughout employment with the New York State Thruway Authority.