Please note: State agencies that contact job applicants do not usually request personal or financial information via text message or over the phone in connection with your response to a job posting. If you are contacted for such information by these methods, or any other method, please verify the identity of the individual before transmitting such information to that person.
Note: For questions about the job posting, please contact the agency that posted this position by using the contact information provided on the "Contact" tab for the position.

Review Vacancy

Date Posted 07/01/15

Applications Due07/15/15

Vacancy ID22098

AgencyFinancial System, Statewide

TitleInformation Technology Specialist 3 (Database), Ref. #15-20

Occupational CategoryNo Preference

Salary Grade23

Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)

Salary RangeFrom $67703 to $85635 Annually

Employment Type Full-Time

Appointment Type Contingent Permanent

Jurisdictional Class Competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 9 AM

To 5:30 PM

Flextime allowed? No

Mandatory overtime? Yes

Compressed workweek allowed? No

Telecommuting allowed? No

County Albany

Street Address Statewide Financial System

W.A. Harriman State Office Building Campus, Bldg. 4

City Albany

StateNY

Zip Code12227

Minimum Qualifications Candidates must be reachable on appropriate Civil Service eligible list or have one year permanent, competitive service as an Information Technology Specialist 3 (Database), G-23, or in a title deemed eligible for transfer under Section 70.1 or 52.6 of the Civil Service Law. The transfer cannot be a second, consecutive transfer resulting in an advancement of more than two grades. In order to qualify for a Section 70.1 transfer, candidates must have one year of permanent, competitive service in qualifying title such as Chief Computer Operator, G-23; Information Technology Specialist 3, G-23; Information Technology Specialist 3 (Data Communications), G-23; or Information Technology Specialist 3 (Systems Programming), G-23. In order to qualify for a Section 52.6 transfer, candidates must have one year of permanent, competitive service in a qualifying administrative title such as Information Technology Specialist 3 (Programming), G-23; Project Manager 1, G-23; or Program Technology Analyst 1, G-23.

Duties Description The incumbent will work in the System Architecture Unit as a member of the Database Administration Team under the direction of the Statewide Financial System (SFS) lead DBA, and serve as a technical expert for a number of specialized Oracle Database features. While responsibilities will include all aspects of database administration the incumbent will focus on developing systems, procedures, documentation and DBA Team expertise in the areas of Recovery Manager, Data Guard, System Monitoring, Instance Tuning, and SQL Tuning.

General Job Responsibilities:

• Establish database monitoring processes, procedures and reporting schedules;
• Review monitor output for exceptions and trends;
• Review database metrics to determine the root cause of availability or performance issues;
• Ensure the recoverability of SFS databases and the integrity of backup;
• Assist in developing, testing and managing procedures for database backup and recovery;
• Assist in developing, testing and managing disaster recovery procedures for SFS databases;
• Assist in capacity planning, performance analysis, tuning, monitoring, change control, and database management;
• Assist in proactive monitoring, diagnosing, and correcting database problems, i.e. data corruption, contention, incorrect indexes, CPU utilization, etc.;
• Work with other SFS Team members to tune program SQL;
• Work with other members of the SFS DBA Team to provide operational support to the SFS Program;
• Adhere to the SFS project management methodology to ensure work is completed properly and on schedule; and
• Perform supervisory duties as required.

Some positions may require additional credentials or a background check to verify your identity.

Name Deanna Weiss

Telephone 518 486-4236

Fax 518 474-0132

Email Address personnelsfs@budget.ny.gov

Address

Street NYS Division of the Budget

State Capitol

City Albany

State NY

Zip Code 12224

 

Notes on ApplyingTo apply, please send a cover letter and resume by e-mail, fax, or post office mail. Please include your current Civil Service title and grade and be sure to indicate that you are applying for the position of Information Technology Specialist 3 (Database), ref#15-20.

Printable Version