Computer Associate I-III/Computer Specialist I-IV Series (Software) Represented
Description
Title: Computer Associate I-III/Computer Specialist I-IV Series (Software) | Department: Subways |
Authority: TA/OA | Division/Unit: Electronics Maintenance Division/ Automated Fare Collection (AFC) |
Work Location: 2 Broadway | Hours of Work: 8am-4pm |
Compensation: Computer Associate I (SW) - TA Computer Associate II (SW) - TA Computer Associate III (SW) - TA Computer Specialist I – (SW) - TA Computer Specialist II – (SW) - TA Computer Specialist III – (SW) - TA Computer Specialist IV – (SW) - TA NYCT titles are represented by DC 37 Computer Associate I – (SW) - OA Computer Associate II – (SW) - OA Computer Associate III – (SW) - OA Computer Specialist I – (SW) - OA Computer Specialist II – (SW) - OA Computer Specialist III –(SW) - OA Computer Specialist IV – (SW) - OA MaBSTOA titles are represented by TWU L 100 | $89,003 $95,829 $102,348 $112,067 $116,750 $126,082 $135,251 $86,643 – $106,858 $95,445 - $115,515 $101,938 - $129,763 $109,076 - $118,218 $113,637 - $127,300 $122,715 - $138,441 $131,642 - $158,514 |
Deadline (if Applicable): | Open until filled |
Reporting Manager (If Applicable): | Superintendent |
Candidates selected for this position on the NYC Transit payroll may be placed in a competitive or non-competitive class position based on their qualifications. Qualified candidates who are placed in a competitive class position are eligible for the 55-a Program. Please indicate in your cover letter and in the upper right corner of your resume that you would like to be considered for the position under the 55-a Program. For detailed information regarding the 55-a Program, please visit the following link
https://www1.nyc.gov/site/dcas/employment/55-a-program.page
https://www1.nyc.gov/site/dcas/employment/55-a-program.page
TA Applicants must be in a permanent civil service status in the title(s) of Job Title or be on an established list for said title(s). If you are on an established list, your list number must be reachable to be considered for appointment.
Responsibilities:
The selected candidate will play a key role in ensuring the accuracy, completeness, and consistency of data within the EAM Hexagon and Spear 4i environments. Core responsibilities will include but are not limited to developing and maintaining database queries, custom searches, business rules, Pivot tables and job schedulers across SQL Server and Oracle platforms. The role involves maintaining Spear 4i clients interacting with Oracle 9i, 11g, and 12c databases. The candidate will leverage Kezava and Power BI dashboards and reporting tools to analyze inspection and maintenance patterns that support effective work order generation. Responsibilities also include updating data records, creating custom work orders, and designing inspection and maintenance patterns within the EAM environment. Regular collaboration with field maintenance personnel is required to troubleshoot and resolve user issues.
Education and Experience:
Computer Associate I-III (Software)
- A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full‑time computer software experience in computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design; or
- A four‑year high school diploma or its educational equivalent and five years of satisfactory full‑time computer software experience as described in “1” above; or
- Education and/or experience equivalent to “1” or “2” above. College education may be substituted for up to two years of the required experience in “2” above on the basis that 60 semester credits from an accredited college is equated to one year of experience. In addition, 24 semester credits from an accredited college or graduate school in computer science or a related field, or a certificate of at least 625 hours in computer programming from an accredited technical school (post‑high school), may be substituted for one year of experience.
All candidates must have at least a four‑year high school diploma or its educational equivalent and at least one year of satisfactory full‑time experience as described in “1” above.
Computer Specialist I-IV (Software)
- A baccalaureate degree from an accredited college, including or supplemented by 24 semester credits in computer science or a related computer field, and two years of satisfactory full‑time computer software experience in the areas listed above, including one year in a project leader capacity or as a major contributor on a complex project: or
- A four‑year high school diploma or its educational equivalent and six years of satisfactory full‑time computer software experience as described in “1,” including one year in a project leader capacity or as a major contributor on a complex project; or
- Education and/or experience equivalent to “1” or “2.” College education may substitute for up to two years of the required experience in “2” (60 credits = one year). A master’s degree in computer science or a related field, or a certificate of at least 625 hours in computer programming from an accredited post‑high‑school technical school, may substitute for one year of the required experience in “1” or “2.”
All candidates must have at least a four‑year high school diploma or its educational equivalent and at least one year of satisfactory full‑time experience in a project leader capacity or as a major contributor on a complex project.
Special Note
To be eligible for Assignment Level IV, candidates must have one additional year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or applications programming.
To be eligible for Assignment Level IV, candidates must have one additional year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or applications programming.
Desired Skills:
- Experience supporting EAM maintenance management databases and application development using Oracle PL/SQL and T-SQL, including designing tables, queries, views, stored procedures, packages, cursors, and exception handlers.
- Proficiency with SQL Developer, TOAD, SQL Plus, and scripting languages
- Knowledge of EAM, Oracle Gateways to DB2, MS Access, MS Excel, and Power BI
- Familiarity with Win 10/Windows Server 2012, Linux, Visual Studio, VBA, C++, C#, HTML, and ASP.NET
- Strong analytical, written, verbal, and interpersonal communication skills
- Ability to work effectively with personnel at all levels of the organization
- Ability to prioritize and manage multiple projects within tight timeframes
Selection Method:
Based on evaluation of education, skills, experience, and interview.
Other Information:
Pursuant to the New York State Public Officers Law & the MTA Code of Ethics, all employees who hold a policymaking position must file an Annual Statement of Financial Disclosure (FDS) with the NYS Commission on Ethics and Lobbying in Government (the “Commission”).
Equal Employment Opportunity:
MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including with respect to veteran status and individuals with disabilities.
The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.