Information Technology Specialist 2 Programming - Albany, United States - Information Technology Services, Office of
Description
Minimum Qualifications
Open Competitive:
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.
Two years of professional experience in information technology.
Transfer:
Open to NYS employees with one year of permanent competitive service as an Information Technology Specialist 2 or Information Technology Specialist 2 Programming, G-18; OR in a title G-16 or above deemed administrative under Section 52.6 of the Civil Service Law.
NYS HELPS:
This title is part of the New York Hiring for Emergency Limited Placement Statewide Program (NY HELPS).
Duties Description
Under the direction of an Information Technology Specialist 3 Database, SG-23, within the Chief Technology Office, Shared Platform Services, Enterprise Database Services section, the Information technology Specialist 2 Programming, SG-18, will administer and support OCFS, OTDA, AGMKT and DPS Oracle databases.
Duties include, but are not limited to:
- Monitor databases for potential problems and troubleshoot any related issues.
- Create and maintain Unix shell scripts.
- Migrate database objects from one environment to another.
- Identify and troubleshoot database performance issues.
- Perform Physical object tuning (rebuild indexes, partitioning, etc.).
- Create and maintain database objects (tables, views, indexes, etc.).
- Enforce database security and create and maintain database privileges and roles.
- Perform capacity planning to ensure availability of adequate space for the database.
- Create and manage Oracle Tablespaces.
Additional Comments
Some positions may require fingerprinting.
Some positions may require up to 25% travel and/or lifting up to 50 lbs. Some positions are pending Civil Service approval. Details of position(s) will be described further if you are selected for an interview.
Positions located in New York City, will receive an additional $3,400 downstate adjustment location pay with regular annual salary. Positions located in the Mid-Hudson will receive an additional $1,650 adjustment location pay.
For the duration of the NY HELPS Program, this title maybe filled via a non
At a future date (within one year of permanent appointment), it is expected employees hired under NY HELPS will have their non-competitive employment status converted to competitive status, without having to compete in an examination.
Employees will then be afforded with all of the same rights and privileges of competitive class employees of New York State.
While serving permanently in a NY HELPS title, employees may take part in any promotion examination for which they are qualified.
Benefits of Working for NYS Generous benefits package, worth 65% of salary, including:Holiday & Paid Time Off
- Thirteen (13) paid holidays annually
- Up to Thirteen (13) days of paid vacation leave annually
- Up to Five (5) days of paid personal leave annually
- Up to Thirteen (13) days of paid sick leave annually for PEF.
- Up to three (3) days of professional leave annually to participate in professional development
- Eligible employees and dependents can pick from a variety of affordable health insurance programs
- Family dental and vision benefits at no additional cost
- New York State Employees' Retirement System (ERS) Membership
- NYS Deferred Compensation
- Access to NY 529 and NY ABLE College Savings Programs, as well as U.S. Savings Bonds
- Public Service Loan Forgiveness (PSLF)
- And many more.
More jobs from Information Technology Services, Office of
-
Information Technology Specialist 2 Programming
Schenectady, United States - 1 week ago
-
Administrative Specialist 1/trainee
Latham, United States - 2 weeks ago
-
Student Assistant Internship
Colonie, United States - 2 weeks ago
-
Information Systems Auditor 1 Its, Ref. #6893
Albany, United States - 2 weeks ago
-
DevOps Engineer
Albany, United States - 4 days ago
-
Business Systems Analyst 1
Schenectady, United States - 2 weeks ago