New York State Civil Service Student Assistant - COO/ Business Office Software Asset Management Ref# 90094 in Menands, New York

Minimum Qualifications
  • Must be a US citizen or foreign national eligible to work in the United States

  • Must be 18 years of age or older

  • Must be currently attending a New York State college, university or graduate program, or be a resident of New York State attending a college, university or graduate program outside of New York State

Preferred qualifications:

  • Preferred Sophomore; minimum Sophomore level college student

  • Major in Information Technology

  • Investigations

  • Planning/Analysis/Research

  • Must have completed a minimum of one (1) year as a student at a degree-granting two or four-year college or university (completion of one year’s worth of academic credits over a more extended period of time may qualify part-time students)

  • Or currently enrolled graduate student or accepted in a graduate degree program

  • Must have a minimum grade point average (GPA) of 2.0 or equivalent to a C.

Internship Skills: Oracle SQL And PL/SQL Oracle Data Loading Data Extraction Techniques Executing/ Monitoring system reports Analysis and Investigations ## Duties Description The intern will require a minimum of (20 hours/week) to support the data analysis and reporting function of the Software Asset Management section within the Business Office of the COO Division.

The Software Asset Management function consists of a mix of technical and investigative functions, involving the following:

  1. Technical & Administrative a. Create Reports and post them in SharePoint site b. Executing SCCM Reports for research purposes c. Oracle Data Loads d. Oracle and Other source, Data Extraction e. Intermediate to advanced SQL Queries in Oracle f. Authoring Oracle PL/SQL Stored Procedures g. Data analysis h. ILMT (IBM License Management Tool) Product bundling and maintenance

  2. Investigative & Research a. Investigation of Software license consumption b. Supplying Price data for software products c. Create reservations in Microsoft Volume Licensing Center, to allow provisioning d. Product Research for a variety of purposes

    Additional Comments

Fingerprinting will be required of hired candidate. New or returning ITS employees may be required to pay for their own fingerprinting.

Please include a copy of your most recent transcript and enrollment verification along with your resume and cover letter. ## Notes on Applying Please send a resume and cover letter indicating that you are applying for a Student Assistant, Ref. #90094 position no later than January 25, 2019 ATTENTION: Mac Vericain

Date Posted: 01/14/19

Applications Due: 01/25/19

Vacancy ID: 63306

Agency: Information Technology Services, Office of

Title: Student Assistant - COO/ Business Office Software Asset Management Ref# 90094

Occupational Category: I.T. Engineering, Sciences

Salary Grade: NS

Bargaining Unit: PS&T; - Professional, Scientific, and Technical (PEF)

Salary Range: From $19.69 to $22.08 Hourly

Employment Type: Full-Time

Appointment Type: Temporary

Jurisdictional Class: Non-competitive Class

Travel Percentage: 0%

Workweek: Mon-Fri

Hours Per Week: 30

From: 8 AM

To: 5 PM

Flextime allowed?: No

Mandatory overtime?: No

Compressed workweek allowed?: No

Telecommuting allowed?: No

County: Albany

City: Albany

State: NY

Zip Code: 12220

Name: Mac Vericain

Telephone: 518-473-0398

Fax: 518-402-4924

Email Address:

Street Address: 800 North Pearl Street

Street: Empire State Plaza PO Box 2062