CUNY IT Senior Associate - Microsoft SQL Server DBA - Provisional in New York, New York

GENERAL DUTIES

I.T. Senior Associates perform highly complex professional work in technology-related disciplines. While areas of specialization vary, typically I.T. Senior Associates perform a range of work in development/programming, communications, technical support, or similar functions depending on the needs of the Information Technology area to which they report. Work tasks include diagnosing, evaluating, overseeing and resolving highly complex projects. They have wide latitude for independent initiative and judgment and may serve in lead roles on complex programs or projects, and/or serve as a direct supervisor of a unit or group.

I.T. Senior Associates should demonstrate mastery of one or more technology-related disciplines, decision-making ability in situations related to those disciplines, and be able to serve as a resource in these areas. They may contribute to decisions on I.T. policies and technical standards.

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/ohrm/hros/classification/ccsjobs.html

CONTRACT TITLE

IT Senior Associate

FLSA

Exempt

CAMPUS SPECIFIC INFORMATION

Borough of Manhattan Community College (BMCC), a nationally recognized leader in urban-serving education, is one of 23 colleges within The City University of New York (CUNY) system. BMCC is the largest college in CUNY, enrolling over 26,000 students in degree programs and 12,000 more students in continuing education programs. Over 155 countries from around the world are represented in its student body. BMCC students obtain associate degrees in 31 fields and are instructed by over 550 full-time dedicated faculty members who must maintain a portfolio of scholarship and research. To meet the needs of its students, the College offers courses and programs online, in offsite locations, in the evenings, and on weekends. BMCC is committed to a student-centered education and advancing knowledge through scholarly research. The school also enrolls more international students than any other community college in the Northeast.

For more information about BMCC, please visit www.bmcc.cuny.edu.

The Microsoft SQL Server DBA at Borough of Manhattan Community College is responsible for the implementation, configuration, maintenance, and performance of the SQL server environment. This is a “hands-on” position and requires solid technical skills. The successful candidate will serve as a technical expert over complex database support activities. Work with application developers, business analysts and other team members to review the business requirements and translate them into database objects.

Job Duties include but are not limited to:

  • Responsible for administration, technical support and trouble-shooting of SQL Server database Servers.

  • Performs system quality check and maintenance of databases plus do performance monitoring and capacity planning including root cause analysis for all issues.

  • Provide technical expertise in the use of database technology.

  • Documenting systems and communicate technical knowledge to team members.

  • Actively participate in incident/problem management and ensure the availability of the application database as per the business requirement and raise all capacity related issues to the concerned stakeholders and bringing to closure.

  • Change Management – Maintain the integrity of the production environment and document all changes & follow change approval process.

  • Responsible for publishing daily sanity check / health-check report to concerned distribution groups and fix the issues as identified.

  • Ensures security policies and procedures are followed to the highest level of system and data confidentiality and integrity.

  • Identify and evaluate industry trends in database systems to serve as a subject matter expert of information and advice for upper management.

  • Perform other duties as assigned.

MINIMUM QUALIFICATIONS

  1. High School Diploma, G.E.D., or equivalent

  2. An equivalent of ten years of experience post-high school that can be met by one of the following: ten years of full-time work experience in a computer or technology related position; an Associate's degree plus eight years of full-time work experience in a computer or technology-related position; or a Bachelor's degree from an accredited institution plus six years of full-time work experience in a computer or technology-related position

  3. Demonstrated English Language proficiency

  4. A Motor Vehicle Driver's license, valid in New York State, may be required for some, but not all positions.

This title has three levels. In addition to the minimum qualifications above, 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

  • 2+ years’ experience in administering SQL Server virtual environments with tasks including installation, patching, upgrade & configuration.

  • Must have experience in how to perform Automation of various administrative tasks using SSIS.

  • Proficiency in at least one programming language (C#/VB.net).

  • Ability to troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

  • Extensive experience with tuning and optimizing SQL Server and Database performance.

  • Experience with VMWARE is a plus.

  • Knowledge of monitoring & database security tools like Spotlight & Imperva is a plus.

  • Knowledge of version control software such as TFS, Team work Visual Source safe etc is a plus.

  • Knowledge of indexes, index management, and statistics.

  • Microsoft Database Certification is a plus.

COMPENSATION

Commensurate with qualifications and experience.

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

To apply, go to www.cuny.edu, access the employment page, log in or create a new user account, and search for this vacancy using the Job ID or Title. Select "Apply Now" and provide the requested information.

CLOSING DATE

Open until filled with review of resumes to begin 1/25/19

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 Title: IT Senior Associate - Microsoft SQL Server DBA - Provisional

Job ID: 19959

Location: Borough of Manhattan CC

Full/Part Time: Full-Time

Regular/Temporary: Regular