It Associate 1 (Provisional) - Public Safety

IT Associate 1 (Provisional) - Public Safety Job ID 26924 Location Baruch College Full/Part Time Full-Time Regular/Temporary Regular Add to My Favorite Jobs **GENERAL DUTIES** I.T. Associates perform moderately complex professional work in technology-related disciplines.

While areas of specialization vary, typically I.T. Associates work in areas such as development/programming, communications, technical support, or similar functions depending on the needs of the Information Technology area to which they report.

Work tasks include resolving complex technology problems and serving as a technical resource.

They have considerable latitude for independent initiative and judgment and may have supervisory responsibilities. I.T. Associates should demonstrate mastery of one or more technology-related disciplines. 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 Associate **FLSA** Exempt **CAMPUS SPECIFIC INFORMATION** **"**

• At Baruch College we believe that student success is everyone's responsibility** " The Assistant Database Administrator will be responsible for advanced technical work in various phases of database administration support; development activities (support the application development lifecycle, planning, design, development, implementation, data migration, quality assurance, data cleanup, and data administration) as well as database operations activities database administration, database security, assuring availability, server and database monitoring, and performance monitoring.

Reporting to the Chief and Director of Public Safety, the successful candidate is: + Responsible for assisting the Senior IT Associate/ID Center Manager with the maintenance and support of the AMAG system. + Develop a new ID verification program for all security entrances, write input program to integrate ID system with AMAG, account administration, programmer and user support, security, backup and data recovery. + Create a semester validation system to update registered students and to deactivate students who are not registered. + Create visitor management system. + Manage the verification system that will consist of ID holder information, recent turnstiles access, and ID card verification check-ins as well as administering newly registered students and user accounts. + Administering and maintaining of data such as the Access Control databases and resolved system performance issues on a case by case basis. + Create program to monitor swipe in access and number of swipe access check-ins and provide ID card swipe history reports as needed. Manages and provides status update on all work activities. + Monitor databases for performance and issues using monitoring tools. Provide support for migrations, updates, fixes and issues as needed. Provide technical assistance to functional areas on problems that may be database related. Identify and track issues, risks, and action items. + Provides Operations support for Database and Database Server administration support for critical production systems. + Perform Health Checks to review the performance of databases to identify and provide recommendations to enhance performance of databases. + Performs migration and upgrade of SQL Databases from legacy server\SQL Version to new server\SQL Version. + Performs data migration by designing programs to extract cleanse optimally, transform and load data between data sources as part of data migration and data validation support. + Deploy database schema changes to test and production environments. + Creates, maintains, and supports the logical and/or physical design of assigned databases by utilizing modeling tool to develop the data models. + Meet with developers and vendors to ascertain requirements and to provide consulting assistance to determine the appropriate database configurations. + Coordinates with vendors and service providers to resolve technical support issues. Determine time estimates and schedule for own work and resolve issues in a timely manner. + Request backup and restore from the backup team/BCTC. + Perform other duties as assigned **MINIMUM QUALIFICATIONS**

• An equivalent of seven years of experience post-high school that can be met by one of the following: seven years of full-time work experience in a computer or technology related position; an Associate's degree plus five years of full-time work experience in a computer or technology-related position; a Bachelor's degree from an accredited institution plus three years of full-time work experience in a computer or technology-related position
• High School Diploma, G.E.D., or equivalent
• A Motor Vehicle Driver's license, valid in New York State, may be required for some, but not all positions. This job has three levels.
• Demonstrated English Language proficiency

To qualify for Levels 2 and 3, additional qualifications, such as education, experience, or certification relevant to the area of specialization are required. **OTHER QUALIFICATIONS** Preferred Qualifications: + 3 or more years of experience with: MS SQL Server administration complex querying, store procedures, ETL, security and optimization + 3 or years of Experience with MS SQL Reporting and Analysis services on Microsoft Windows Server + 3 or more years of experience with Oracle Server administration complex querying, store procedures, ETL, security and optimization + 3 or more years of .NET web application development. Must know HTML, CSS, JS, jQuery, connecting to various authentication sources (e.g. Active Directory) and smtp services + Demonstrated ability to communicate effectively and professionally in a high demand environment + Experience with Amag security access control + Availability to work evening and weekend hours **COMPENSATION** $72,209 CUNY's benefits contribute significantly to total compensation, supporting health and wellness, financial well-being, and professional development. We offer a range of health plans, competitive retirement/pension benefits and savings plans, tuition waivers for CUNY graduate study and generous paid time off. Our staff also benefits from the extensive academic, arts, and athletic programs on our campuses and the opportunity to participate in a lively, diverse academic community in one of the greatest cities in the world. IMPORTANT NOTICE: Health Plan Coverage for Employees Hired on or after October 1, 2022 City of New York employees and employees of Participating Employers and their eligible dependents hired on or after October 1, 2022 will only be eligible to enroll in the Emblem Health HIP HMO Preferred Plan and must remain in the HIP HMO Preferred Plan for the first year (365 days) of employment. After 365 days of employment, the employee will have the option of either remaining in the HIP HMO Preferred Plan or selecting a different health plan within 30 days before the end of the 365th day period. If a new health plan is selected, the new plan will be effective on the 366th day. Only after the 365th day can the employee participate in any Annual Fall Transfer Period. An employee who needs to request an exemption from the required enrollment in the HIP HMO Preferred Plan can do so by submitting a HIP HMO Opt-Out Request Form to Emblem Health. An employee, or eligible dependent, must meet certain criteria and the request must be approved by Emblem Health before the exemption is granted. The HIP HMO Opt-Out Request Form and HIP service area are available on the Emblem Health website https://www1.nyc.gov/site/olr/health/healthhome.page **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** Click on the "Apply Now" button and follow the application instructions below. Please upload a resume and cover letter. For general assistance with your CUNYfirst application, please go to http://www2.cuny.edu/employment/system-instructions/ for information **CLOSING DATE** Open until filled.

Application review to begin on June 16, 2023 **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.