Information Technology Specialist 2

NYSTRS•Albany, OR

7d•Hybrid

About The Position

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. At NYSTRS, diversity, equity, and inclusion are integral to our mission of providing our members with a secure pension and exceptional customer service. We are committed to fostering an inclusive and equitable culture where all diversity is valued and recognized as a source of strength and enrichment across all operations. NYSTRS is proud to provide equal opportunities to all employees and qualified applicants without regard to race, color, religion, creed, sex, gender expression or identity, national origin, age, ability and disability status, veteran status, marital status, pregnancy status, sexual orientation, citizenship, or any other legally protected class. We are committed to being a workplace that attracts, supports, and retains talented individuals from diverse backgrounds and experiences while championing equal opportunity across recruitment, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. All applications to NYSTRS should be done via our Website. NYSTRS will never ask you to submit private information via email or direct you to submit private information to another site as part of our recruitment process. Established in 1921 by the New York State Legislature, the New York State Teachers’ Retirement System (NYSTRS) provides retirement, disability and death benefits to eligible New York State public school teachers and administrators. The System is among the 10-largest public pension funds in the nation based on total assets. Our Mission: To provide our members with a secure pension. Our Vision: To be the model for pension fund excellence and exceptional customer service. Our Values: Respect, Excellence, Diversity, Balance, Integrity, Resourcefulness, Diligence

Requirements

Reachable on the Civil Service eligible list
Eligible for reassignment by virtue of having permanent competitive service as an Information Technology Specialist 2 (SG-18)
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

Nice To Haves

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

Responsibilities

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
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