Review Vacancy
AgencyInformation Technology Services, Office of
TitleInformation Technology Specialist 4 (Database), Ref # 15499
Occupational CategoryI.T. Engineering, Sciences
Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)
Salary RangeFrom $75243 to $94834 Annually
Appointment Type Contingent Permanent
Minimum Qualifications Open to NYS employees with one year of permanent competitive service as an Information Technology Specialist 4 (Database), G-25, OR in a position at the G-23 level or above deemed administrative under Section 52.6 of the Civil Service Law OR in a title designated appropriate for Section 70.1 transfer of the Civil Service Law. The transfer cannot be a second, consecutive transfer resulting in an advancement of more than two salary grades.
Duties Description Within Chief Operations Office and under the direction of a Manager of Information Technology Services 1 (Database), the Information Technology Specialist 4 (Database) is primarily responsible for the management and upkeep of Oracle databases that support Division of Budget business applications.
The Information Technology Specialist 4 (Database) will also provide DBA support for databases at additional agencies including those at the NYS consolidated datacenter located at the College of Nanoscale Science and Engineering (CNSE). This position will provide supervision and oversight over two or more subordinate ITS-3(DB) staff and consulting staff if assigned. This position will also provide expert level assistance to Systems Administrators and CTO architects relating to database software platforms, including design/build of new Database service offerings, problem detection and resolution, installation, and upgrades.
The incumbent will work closely and provide assistance to Application Developers, Application Architects, and Data Architects in creating physical database designs and will create physical database structures and database objects to implement the physical design.
The incumbent will provide expert level administration and operational support of Production databases by monitoring and tuning database systems and SQL queries to ensure optimal performance and availability; analyzing and diagnosing Database system problems and providing timely resolution; maintaining Database security related to applications, and guaranteeing recoverability of data by ensuring daily backup operations and processes complete successfully.
Specific duties include:
• Perform the most complex and critical Oracle DBA tasks
• Provide supervision and oversight over subordinate DBA staff and consultants
• Make sure that Oracle Databases are backed up, functioning properly and available to users.
• Safeguard Oracle Databases by ensuring that proper backup/restore and other administrative procedures are followed.
• Monitor Oracle database statistics for current and potential problems. Solve or participate in the solution of any problems associated with the databases. Suggest changes that may result in increased access and/or efficiency of the databases.
• Ensure that all NYS established security protocols pertaining to Database Administration have been taken.
• Perform database tasks as per requests from users. This includes requests for all types of database administration tasks.
• Generate task lists, test plans and implementation plans pertaining to changes to the database structure. Implement planned changes to the database structure.
• Participate in the On Call rotation schedules. Ensure that there is On Call coverage at all times. Work to resolve any problems that may arise. Be available to assist in crisis situations.
• Generate necessary database documentation, including updates to manuals.
• Participate in Enterprise Databases meetings and keep supervisor informed of the status of assigned database projects.
• Participate in training.
Additional Comments Due to the 24x7 availability requirements for certain critical applications, the Information Technology Specialist 4 (Database) is expected to be part of an On Call schedule to respond to incidents and outages occurring during off-shift hours. Some positions may require fingerprinting.
Some positions may require additional credentials or a background check to verify your identity.
Email Address HR.recruitment@its.ny.gov
Address
Street Office of Information Technology Services
ESP, PO Box 2062
Notes on ApplyingTo apply, please send a resume and cover letter attention Amy Sacco indicating that you are applying for the Information Technology Specialist 4 (Database), Ref. #15499. Please clearly indicate how you meet the minimum qualifications for this position. Your Social Security number may be required in order to confirm eligibility.