StateJobsNY

NY HELPNo

AgencyAttorney General, Office of the

TitleInformation Technology Specialist 3 (Database)

Occupational CategoryI.T. Engineering, Sciences

Salary Grade23

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

Salary RangeFrom $67703 to $85635 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 One year of permanent competitive service as ITS 3 (DB), G-23 or in a position 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 such as ITS 3 (DataCom), G-23. Candidates reachable on the eligible list for this title will be canvassed and do not need to apply.

Duties Description The Office of the Attorney General (OAG) is seeking an Information Technology Specialist 3 (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 an Information Technology Specialist 4, the incumbent of this position will work with significant independence.

Duties:

• Participate in requirements gathering for highly visible applications with short project time lines.
• Convert end user requirements into logical database models.
• Convert logical database models into scalable, efficient physical database models.
• Design, build, maintain and support the OAG’s custom Oracle databases using products like Toad, PL/SQL Developer, SQL Plus and Oracle Designer.
• Create and maintain documentation supporting physical models, logical models and other logical flows.
• Creation of PL/SQL packages, functions, stored procedures, materialized views, triggers, sequences and other associated data tier objects in conformance with OAG naming and performance standards.
• Creation of scripts and associated permission grants to necessary objects.
• Small to large volume extraction, transforming and loading of data from various sources, incorporating SQL*Plus copy and scripts.
• Produce time sensitive ad hoc reports in response to customer needs.
• Interact with end-users and supervisory staff to troubleshoot performance, data and training issues.
• Develop and implement test plans for new and existing code for development environment.
• Troubleshoot and perform root cause analysis to diagnose issues.
• Document support calls completely in call tracking software. Document all user requested enhancements.
• Supervision of ITS-2 staff and the delegation of tasks to other staff and contracted consultants may be required.
• Contribute to agency coverage requirements for production applications.

Additional Comments Preferred Qualifications:

• Strong understanding of n-tier architecture for a web environment.
• Experience in OLTP and Data Warehouse schema design.
• Proficient with PL/SQL, SQL and debugging techniques.
• Proficient with ETL and data migration.
• Experience with SDLC and full development life cycle.
• Experience developing and deploying web-based applications.
• Experience gathering business requirements from end users.
• Practical experience supporting end-users in a production application. Strong problem solving and analytical skills.
• 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.
• Experience with Project Management lifecycles.

Candidates from diverse backgrounds are encouraged to apply. The Office is an equal opportunity employer and is committed to workplace diversity.

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

Name William Harrison

Telephone

Fax 518-915-7753

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 Vacancy ID #19116 in the subject of your email. 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.