Information Technology Specialist 2 (NY HELPs) - 6224

NY HELP Yes Agency Information Technology Services, Office of Title Information Technology Specialist 2 (NY HELPs) - 6224 Occupational Category I.T. Engineering, Sciences Salary Grade 18 Bargaining Unit PS&T - Professional, Scientific, and Technical (PEF) Salary Range From $65001 to $82656 Annually Employment Type Full-Time Appointment Type Temporary Jurisdictional Class Non-competitive Class Travel Percentage 0% Workweek Mon-Fri Hours Per Week 37.5 Workday From 8 AM To 5 PM Flextime allowed? No Mandatory overtime? No Compressed workweek allowed? Yes Telecommuting allowed? Yes County Albany Street Address Swan St. Bldg, Core 3, Flr 1 City Albany State NY Zip Code 12220 Minimum Qualifications Open Competitive: A bachelor's or higher-level degree including or supplemented by 15 semester credit hours in computer science. ORA 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. ORTwo 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.55b/c Appointment: This position is eligible for 55b/c designation and candidates are encouraged to apply.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 4 Db, SG-25, within the Chief Technology Office, Shared Platform Services, Enterprise Database Services, the Information Technology Specialist 2, SG-18, will have the primary responsibility of supporting Oracle databases of various agencies.Duties include, but are not limited to: Perform Oracle database changes as requested in ITSM tickets. Create and maintain database objects (tables, views, indexes, etc.). Perform Oracle Database access management and access control according to the organizational policies. Manage space for the Oracle Database. Perform Oracle Database monitoring. Evaluate and troubleshoot Oracle database performance issues, including SQL tuning. Assist development and user staff with Oracle database related issues/questions. Provide off hours support for Oracle database issues. Troubleshoot Oracle database issues. Migrate Oracle Database objects between various environments. Create and maintain Unix shell scripts. Perform datapump imports/exports. 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- competitive appointment, which means no examination is required but all candidates must meet the minimum qualifications of the title for which they apply. At this time, agencies may recruit and hire employees by making temporary appointments. In May 2024, if a temporary NY HELPS employee is satisfactorily performing in the position, the appointment will be changed from temporary pending Civil Service Commission Action to permanent non-competitive and the official probationary period will begin.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 developmentHealth Care Benefits Eligible employees and dependents can pick from a variety of affordable health insurance programs Family dental and vision benefits at no additional costAdditional Benefits 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. Some positions may require additional credentials or a background check to verify your identity.Name ITS Human Resources Telephone 518-473-0398 Fax 518-402-4924 Email Address [email protected] Address Street Empire State Plaza Swan Street Building, Core 4, Floor 1 City Albany State NY Zip Code 12220 Notes on Applying To apply for this position, please submit a cover letter and resume clearly indicating how you qualify. Your Social Security number may be required to confirm eligibility.