SCCC REFERENCE #: 19-78

DATE: October 24, 2019

TITLE: Specialist I - Office of Enterprise Applications

CAMPUS: Ammerman Campus in Selden

START DATE: ASAP

TYPE OF APPOINTMENT: Full Time

RANK: Faculty

POSITION DESCRIPTION:

 

Announcement is hereby made for a full-time, 12-month, Specialist I position in the Office of Enterprise Applications located on the Ammerman Campus in Selden.   Suffolk County Community College is an open admissions institution committed to serving a diverse student population in a variety of degree and career programs.

 

This is a Unit III position covered under the Faculty Association of Suffolk County Community College collective bargaining agreement with the College.

 

Job Description:

The Specialist 1 will report to the Associate Director of Enterprise Applications and will primarily support the analysis, development, integration, ongoing maintenance and operation of the College’s Administrative Information Systems comprised of: Oracle and MS SQL Server database management systems; Ellucian’s Banner ERP; Luminis 5 Portal; Degree Works; Slate CRM and numerous other custom applications and ancillary systems. This position is required to work with an extended team of professionals to support solutions on both on-premises and remotely hosted environments.

 

The Specialist 1 is expected to be a subject matter expert in database and application solutions and must possess a strong understanding of relational data structures, theories, principles, and practices. This position is responsible for researching, analyzing, testing and implementing application solutions in a heterogeneous environment.

 

Specific responsibilities are as follows:

 

  • Develop, implement, document and support the College’s customizations that are integral parts of mission critical student, payroll and financial systems.
  • Provide database analysis concerning usage, performance and structure.
  • Provide support for system results and data integrity through the development and documentation of database structures, functions, procedures, algorithms, routines, scripts, reports and processes.
  • Research new technology. Mentor and support developers with the development of programming standards and best practices as they relate to existing systems and emerging requirements and technologies.
  • Support enhancements, improvements and extensions to ERP system capabilities through the use of database development and programming languages and tools including PL/SQL, Ellucian extensibility tools and Java. 
  • Research, monitor, prepare and coordinate Ellucian Banner releases and patches.  Determine relevance and impact with regard to College customizations. 
  • Collaborate with College IT staff, SICAS and SUNY cohorts and third party vendors to provide IT solutions.
  • Develop and manage effective working relationships with College  departments, groups and personnel with whom tasks and assignments must be coordinated.
  • Provide periodic status to College administration with regard to assigned projects, tasks and other designated responsibilities.

     



MINIMUM QUALIFICATIONS:

A Master’s degree with at least 20 undergraduate or graduate credits in computer science or a related major, as well as 4 years of full-time professional experience, preferably in higher education.  Alternatively, a Bachelor’s degree with comparable credit requirements and minimum of 6 years of full-time technical work experience, preferably in higher education.  Work experience must pertain to the support of an enterprise-wide service that includes: system development, end-user collaboration, and responsibility for independently analyzing issues and researching and implementing solutions.

 

Applicants must possess:

  • Experience with both procedural and object-oriented programming languages using secure coding practices;
  • Experience with source development and version control tools such as Git, Maven, Eclipse IDE;
  • Ability to write complex SQL queries, stored procedures, triggers, views and functions;
  • Ability to conduct workflow and business process analysis and write technical specifications/procedures;
  • Ability and motivation to stay current with technology related to the position;
  • Solid working knowledge of systems analysis and design methods;
  • Ability to prioritize a heavy workload with minimum supervision;
  • Superior verbal and written communication skills.

Preference will be given to applicants with:

  • Experience with Ellucian’s Banner ERP or comparable higher education Enterprise Information Systems; Ellucian’s Luminis Portal Content Management Platform and/or Slate CRM.
  • Proficiency in: Oracle relational database management systems; UNIX and UNIX shell scripting; perl, Pro*C, Java, PL/SQL programming languages;  database utilities such as TOAD, PLSQL Developer or SQL*Plus; and HTML, XML/XSLT, JavaScript, JSP web-based programming;
  • Ability to create frameworks using best practices for combining strengths of database and ETL tools to optimize data movement into, out of and within the data environments;
  • Proficiency with reporting tools such as Argos, data warehousing platforms like Banner ODS, and integration with other third-party systems and reporting techniques;
  • In-depth knowledge of Linux/Windows operating systems including use of compilers, shell scripting and web interfaces.

 



HIRING SALARY:

The exact salary will be determined by prior experience and placement on the salary scale negotiated by the Faculty Association of Suffolk County Community College

 



NON-DISCRIMINATION NOTICE:
Suffolk County Community College does not discriminate on the basis of race, color, religion, creed, sex, age, marital status, gender identity or expression, sexual orientation, familial status, pregnancy, predisposing genetic characteristics, equal pay compensation-sex, national origin, military or veteran status, domestic violence victim status, criminal conviction or disability in its admissions, programs and activities, or employment. This applies to all employees, students, applicants or other members of the College community (including, but not limited to, vendors and visitors). Grievance procedures are available to interested persons by contacting either of the Civil Rights Compliance Officers/Coordinators listed below. Retaliation against a person who files a complaint, serves as a witness, or assists or participates in the investigation of a complaint in any manner is strictly prohibited.

The following persons have been designated to handle inquiries regarding the College's non-discrimination polices:

Civil Rights Compliance Officers
Christina Vargas
Chief Diversity Officer/Title IX Coordinator
Ammerman Campus, NFL Bldg., Suite 230
533 College Road, Selden, New York 11784-2899
vargasc@sunysuffolk.edu
(631) 451-4950

or

Dionne Walker-Belgrave
Affirmative Action Officer/Deputy Title IX Coordinator
Ammerman Campus, NFL Bldg., Suite 230
533 College Road, Selden, New York 11784-2899
walkerd@sunysuffolk.edu
(631) 451-4051

In an emergency, contact Public Safety to make a report 24 hours a day/7 days a week by calling (631) 451-4242 or dialing 311 from any College phone.

Inquiries or complaints concerning alleged civil rights violations in the College’s education admissions, programs and activities may also be directed to:

Office for Civil Rights (OCR) – Enforcement Office
U.S. Department of Education
32 Old Slip, 26th Floor
New York, NY 10005-2500
Telephone: (646) 428-3800
Fax: (646) 428-3843
TDD: (877) 521-2172
Email: OCR.NewYork@ed.gov
Also see: https://wdcrobcolp01.ed.gov/CFAPPS/OCR/contactus.cfm

Inquiries or complaints concerning discrimination in employment practices may also be directed to:

NYS Division of Human Rights
Long Island (Suffolk)
New York State Office Building
250 Veterans Memorial Highway, Suite 2B-49
Hauppauge, NY 11788
Telephone: (631) 952-6434
TDD: (718) 741-8300
Email: InfoLongIsland@dhr.ny.gov
Also see: https://dhr.ny.gov/how-file-complaint

U.S. Equal Employment Opportunity Commission (EEOC)
New York District Office
33 Whitehall Street, 5th Floor
New York, NY 10004
Telephone: (800) 669-4000
Fax: (212) 336-3790
TTY: (800) 669-6820
ASL Video Phone: (844) 234-5122
Also see: https://www.eeoc.gov/field/newyork/charge.cfm

Suffolk County Community College is committed to fostering a diverse community of outstanding faculty, staff, and students, as well as ensuring equal opportunity and non-discrimination in employment, education, access to services, programs, and activities, including career and technical education opportunities.

A copy of the postsecondary career and technical education courses offered by the College is available and may be obtained on our website at: www.sunysuffolk.edu/explore-academics/college-catalog or by calling the Office of Admissions at 631-451-4000 to request a mailing.

APPLY TO: Interested applicants should apply online by clicking on the button below: