New England HERC

Database Developer (IT Assistant Level 1 Hourly) - Office of Computing Information Services

GENERAL DUTIES

IT Assistants perform entry-level professional work in technology-related disciplines. While areas of specialization vary, typically IT Assistants work in areas such as development/programming, communications, technical support, or similar based on the needs of the Information Technology area to which they report. Work tasks include resolving minor technology problems, monitoring activities, and maintaining documentation. They have latitude for independent initiative and judgment, under supervision.

This job is in CUNY's Classified Civil Service. The full specification is available on our web site at http://www.cuny.edu/about/administration/offices/hr/classified-civil-service/ccsjobs/.

CONTRACT TITLE

IT Assistant

FLSA

Non-exempt

CAMPUS SPECIFIC INFORMATION

New York City College of Technology (City Tech) of the City University of New York (CUNY), is a comprehensive college in downtown Brooklyn.

The Office of Computing Information Services at City Tech welcomes applications for a part-time position of Database Developer to join our team. This position entails hands-on experience with T-SQL, data modeling, database query optimization, SSIS, SSAS, and SSRS to support enterprise applications and data-driven solutions.

Under supervision and general direction, with some latitude for independent judgment, the IT Assistant will:

• Design, implement, and maintain¿relational database systems¿to support .NET applications and data integrations.
• Write and optimize¿complex SQL queries, stored procedures, views, and functions.
• Perform¿database performance tuning, indexing, and optimization.
• Ensure data integrity and compliance with database security and privacy standards.
• Integrate databases with enterprise systems and third-party APIs.
• Utilize tools such as¿SQL Server Management Studio (SSMS),¿SQL Profiler, and¿Entity Framework¿for development and troubleshooting.
• Create reporting solutions using SQL Server Reporting Services (SSRS) by analyzing user needs and information availability.
• Work with subject matter experts and development teams in design, development, testing, implementation, and support of application projects.
• Develop reports and custom queries for ERP systems such as PeopleSoft and Workday.
• Work with Big Data technologies such as MongoDB for data storage and analytics.

MINIMUM QUALIFICATIONS

Level 1

1. A High School diploma or its educational equivalent from an accredited institution and two (2) years of full-time work experience in a computer or technology-related position; or
2. An Associate?s degree from an accredited college or university and one (1) year of full-time work experience in a computer or technology-related position; or
3. A Bachelor?s degree from an accredited college or university and six (6) months of full-time work experience in a computer or technology-related position; or
4. A Bachelor?s degree in computer science or a related field from an accredited college or university.

Level 2

1. A High School diploma or its educational equivalent from an accredited institution and three (3) years of full-time work experience in a computer or technology-related position; or
2. An Associate?s degree from an accredited college or university and two (2) years of full-time work experience in a computer or technology-related position; or
3. A Bachelor?s degree from an accredited college or university and eighteen (18) months of full-time work experience in a computer or technology-related position.
4. A Bachelor?s degree from an accredited college or university in a computer related field and one (1) year of full-time work experience in a computer or technology-related position.

Level 3

1. A High School diploma or its educational equivalent from an accredited institution and five (5) years of full-time work experience in a computer or technology-related position; or
2. An Associate?s degree from an accredited college or university and four (4) years of full-time work experience in a computer or technology-related position; or
3. A Bachelor?s degree from an accredited college or university and three (3) years and six (6) months of full-time work experience in a computer or technology-related position; or
4. A Bachelor?s degree from an accredited college or university in a computer related field and three (3) years of full-time work experience in a computer or technology-related position.

English Language Proficiency: Demonstrated English language proficiency, including the ability to speak, read, write and understand English well enough to meet minimally acceptable performance standards set for job tasks.

CUNY considers full-time work to be at least 35 hours per week. Part-time experience of at least 20 hours per week may be prorated by half and credited instead of, but not in addition to, full-time experience during the same period (e.g., two month?s related work experience at 20-34 hours per week equate to one month?s full-time related work experience.) Part-time experience of fewer than 20 hours per week cannot receive any credit.

Note: A Motor Vehicle Driver License valid in the State of New York, may be required for certain positions. If you have moving violations, license suspension(s) or an accident record, you may be disqualified. If appointed to a position requiring a Motor Vehicle Driver License, this license must be maintained for the duration of your employment.

OTHER QUALIFICATIONS

Preferred Qualifications

• 2 years of experience in SQL Server, T-SQL, data modeling, database query optimization, SSIS, SSAS, and SSRS.
• Proficiency in supporting MS-SQL Server 2017/2019/2022 databases in high availability environments with intimate knowledge of both SQL and T-SQL.
• Experience developing web applications using¿.NET,¿C#,¿ASP.NET Core,¿MVC, and¿Blazor.
• Familiarity with¿ITSM platforms¿such as¿ServiceNow, and learning management systems like¿Blackboard LMS,¿Brightspace LMS,¿DegreeWorks, and¿EAB Navigate.

COMPENSATION

New Hire: $30.99/hour*

Incumbent: $34.99/hour

*This amount reflects a 13% salary suppression for the first 24 months of employment.

BENEFITS

CUNY offers a comprehensive benefits package to employees and eligible dependents based on job title and classification. Employees are also offered pension and Tax-Deferred Savings Plans. Part-time employees must meet a weekly or semester work hour criteria to be eligible for health benefits. Health benefits are also extended to retirees who meet the eligibility criteria.

HOW TO APPLY

No job description available

CLOSING DATE

Open until filled with review of resumes to begin on or after February 4, 2026.

JOB SEARCH CATEGORY

CUNY Job Posting: Information Technology/Technical

EQUAL EMPLOYMENT OPPORTUNITY

CUNY encourages people with disabilities, minorities, veterans and women to apply. At CUNY, Italian Americans are also included among our protected groups. Applicants and employees will not be discriminated against on the basis of any legally protected category, including sexual orientation or gender identity. EEO/AA/Vet/Disability Employer.

Job ID: 31645

Location: NYC College of Technology

Job Type: Part-Time

About CUNY NYC College of Technology

New York City College of Technology is a baccalaureate and associate degree-granting institution committed to providing broad access to high quality technological and professional education for a diverse urban population. City Tech’s distinctive emphasis on applied skills and place-based learning built upon a vibrant general education foundation equips students with both problem-solving skills and an understanding of the social contexts of technology that make its graduates competitive. A multi- disciplinary approach and creative collaboration are hallmarks of the academic programs. As a community City Tech nurtures an atmosphere of inclusion, respect, and open-mindedness in which all members can flourish.

Connections working at CUNY NYC College of Technology