Database Developer; IT Assistant Level 1 - Office of Computing Information Services

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.

IT Assistant

Non-exempt

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.

• 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 People Soft and Workday.
• Work with Big Data technologies such as Mongo
  
  DB for data storage and analytics.

• 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
• 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
• 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
• A Bachelor’s degree in computer science or a related field from an accredited college or university.

• 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
• 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
• 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.
• 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.

• 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
• 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
• 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
• 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.

Demonstrated English language proficiency, including the ability to speak, read, write and understand English well…