Position Information

NY HELPNo

AgencyTeachers' Retirement System

TitleInformation Technology Specialist 2

Occupational CategoryI.T. Engineering, Sciences

Salary Grade18

Bargaining UnitCSEA Local 658 (NYS Teachers’ Retirement System)

Salary RangeFrom $78669 to $115477 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Competitive Class

Travel Percentage 0%

Schedule

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 8 AM

To 4 PM

Flextime allowed? Yes

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? Yes

Location

County Albany

Street Address 10 Corporate Woods Drive

City Albany

StateNY

Zip Code12211

Job Specifics

Duties Description Job Duties
The Information Technology Specialist 2 will be responsible for, but not limited to, the following duties:

Assist with the execution of backup, recovery, and other database procedures
Test and execute procedures for restoring the database system
Perform migrations of database objects from lower environments into QAT and PRD
Create and modify databases as needed; create new instances for upgrades and testing
Modify initialization parameters and settings as recommended by vendors
Assist developers with SQL and performance issues; create and implement triggers, procedures, and permissions as needed
Address database-related help desk tickets (password resets, permission grants, etc.)
Assist with applying database patches and performing database upgrades
Enforce database security; create and maintain database privileges and roles
Perform periodic database user audits

Other Duties and Responsibilities:

Log and resolve incidents and service requests in ServiceNow; meet SLA targets
Participate in change management for patches, upgrades, and migrations
Update CMDB entries for database servers and instances
Contribute to knowledge base articles and SOPs
Maintain accurate configuration records and update documentation
Monitor capacity and report growth trends
Stay current with Oracle, SQL Server, and ITIL best practices
Collaborate with application and infrastructure teams on deployments
Participate in disaster recovery drills and document outcomes
Support compliance with audit and security standards

Minimum Qualifications Minimum Qualifications

Either: 1) Reachable on the Civil Service eligible list; 2) Eligible for reassignment by virtue of having permanent competitive service as an Information Technology Specialist 2 (SG-18); OR 3) Eligible for transfer under the provisions of the Civil Service Law by virtue of having one year of permanent competitive service in an appropriate title.

Additional Comments Position Summary
The Information Technology Specialist 2 in the Database Unit functions primarily as the Administrator of the Oracle and MS SQL Server databases, assisting with backup and recovery, troubleshooting, migrations, and security enforcement while adhering to ITIL best practices and ServiceNow workflows. The ideal candidate is detail-oriented, customer-focused, and eager to learn advanced database administration skills.

This position requires occasional overtime work on weekends and outside of normal business hours during the week.

Preferred Qualifications

Understanding of Oracle and SQL Server Database Administration

Basic familiarity with the Linux and Windows operating systems
Experience working with at least some of the following products: Oracle Enterprise    Manager, Oracle RMAN, SQL Developer, SQLPLUS, DBArtisan, Putty, WinSCP, SQL Server Management Studio
Basic knowledge of T-SQL and/or PL/SQL
Excellent communication and interpersonal skills
Commitment to providing exceptional customer service

Work Modality
Currently we have a hybrid work schedule which may be subject to change in the future.

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

How to Apply

Name Christine DiPierno

Telephone 518/447-2838

Fax N/A

Email Address recruitment@nystrs.org

Address

Street 10 Corporate Woods Drive

City Albany

State NY

Zip Code 12211

 

Notes on ApplyingIn order to be considered for this position, you must navigate to our applicant portal to apply to the position posting: https://nystrs.wd12.myworkdayjobs.com/NYSTRS_Careers. We will not accept resumes sent via email.