Review Vacancy
AgencyTeachers' Retirement System
TitleInformation Technology Specialist 2
Occupational CategoryI.T. Engineering, Sciences
Bargaining UnitCSEA Local 658 (NYS Teachers’ Retirement System)
Salary RangeFrom $78669 to $115477 Annually
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.
Email Address recruitment@nystrs.org
Address
Street 10 Corporate Woods Drive
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.