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.

Review Vacancy

Date Posted 10/28/15

Applications Due11/30/15

Vacancy ID25494

NY HELPNo

AgencyAttorney General, Office of the

TitleInformation Technology Specialist 4 (Database)

Occupational CategoryI.T. Engineering, Sciences

Salary Grade25

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

Salary RangeFrom $75243 to $94834 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 8:30 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No

County Rensselaer

Street Address 200 Broadway

City Troy

StateNY

Zip Code12180

Minimum Qualifications Candidates reachable on the eligible list for this title will be canvassed and do not need to apply. Seeking transfer candidates only through this posting. One year of permanent competitive service as ITS 4 (DB), 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.

Duties Description The Office of the Attorney General (OAG) is seeking an Information Technology Specialist 4 (DB) to work within our Application Development section. The incumbent will be responsible for the design, maintenance and support of the customization of our public and internal databases and websites. Under the supervision of a Manager of Information Technology Services 1, the incumbent of this position will work with significant independence.

DUTIES:
• Maintain and support existing internal customized Oracle applications built with Oracle Forms, Reports and Designer.
• Develop and maintain new applications and modules using Java, HTML and PL/SQL.
• Develop or assist in the development of logical data models, defining data entities, data attributes and logical data groups and relationships using data modeling tools.
• Perform Project Management duties including creating business cases, project plans, scope documents, project schedules and summary reports.
• Respond to help desk calls and work with end-users to troubleshoot performance, data and training issues.
• Recommend and implement solutions based on feedback. Document all help calls and requested enhancements.
• Develop and implement test plans for new systems which ensure that they are implemented expeditiously with minimal risk to their design intent and environments. Test peer and own code and prepare migration deployments.
• Assist in the development of user interfaces that conform to NYS Accessibility standards.
• Create user documentation to support applications and train end users in custom applications. Document support calls completely in call tracking software. Document all user requested enhancements.
• Supervision and the delegation of tasks to ITS-2 and ITS-3 staff as well as contracted consultants.

Additional Comments Preferred Candidate:
• Experience in Relational DBMS, SQL and PL/SQL.
• Practical experience with Oracle Forms, Reports and Designer.
• Demonstrable understanding of logical data models, defining data entities, data attributes and logical data groups and relationships.
• Experience gathering business requirements from end users to assess need and incorporate requests into database and system design.
• Experience developing web-based applications using Java, HTML, JavaScript and Cascading Style Sheets.
• Practical experience supporting end-users in a production application. Strong problem solving and analytical skills.
• Experience with root cause analysis.
• Focus for quality, with attention to detail and the ability to meet strict deadlines.
• Strong communication and customer service skills.
• Experience working independently, but also as part of a team.

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

Name William Harrison

Telephone

Fax 518-915-7754

Email Address william.harrison@ag.ny.gov

Address

Street Office of the Attorney General, Human Resources Managment Bureau

The Capitol

City Albany, NY 12224

State NY

Zip Code 12224

 

Notes on ApplyingPreferred method of applying is via e-mail. Please include vacany ID# 25494 the subject line. Please be sure to include a cover letter and resume, and how you meet the minimum qualifications. Please note that ITS 2 titles are NOT transferrable to this title.

Printable Version