CUNY Database Administrator, Data Management & Analytics (IT Associate Level 1 Provisional) in New York, New York

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

CONTRACT TITLE

IT Associate

FLSA

Exempt

CAMPUS SPECIFIC INFORMATION

The City University of New York (CUNY) is the nation's leading urban public university, serving more than 540,000 students in degree, certificate, and continuing education programs at 24 colleges and institutions in New York City. The Office of the Senior University Dean for Academic Affairs (SUD) oversees a wide range of programs and initiatives across the University and in New York City, including adult literacy, service learning, early childhood professional development, workforce development, and continuing education programs. SUD also oversees a number of collaborative programs between the university and the New York City public schools, such as CUNY's Early College Initiative and College Now; additionally, the unit manages the CUNY Language Immersion Program, CUNY Start, and the Accelerated Study in Associates Program (ASAP).

The Office of Data Management & Analytics (DM&A;) is situated within SUD, under the University Dean for Strategic Initiatives. Led by the Senior Director for Data Management & Analytics, DM&A; works closely with the Office of Research, Evaluation & Program Support (REPS) to support social science research about SUD programs, as well as external projects and initiatives. DM&A; is responsible for the design and development of systems to manage data, analytics, data integration, data governance across programs, and for translating program practices and management needs into complex data solutions.

Under the supervision of DM&A;'s Database Manager, the Database Administrator will work cross­ functionally with SUD staff to provide critical support for timely and accurate data collection and analysis. The Database Administrator will be responsible for implementing data models, database designs, database maintenance, storing, organizing, presenting, using, and analyzing data with database management software. Responsibilities will include building and organizing administrative data from a variety of sources and setting up new databases or integrating data from legacy systems to new systems. The Database Administrator will also maintain policies and procedures for ensuring the security and integrity of the SUD program database. In addition to the above, the Database Administrator I will regularly perform routine tests and modifications to ensure that the data systems are performing and running correctly. If a problem occurs, the Database Administrator will troubleshoot the systems.

Key duties include but will not be limited to the following: Planning/Design

  • Map out the conceptual design for new database features; design data flow diagrams and data models in SQL Developer Data Modeler.

  • Develop and design new functionality for the SUD program database applications to meet program and administrative needs. Database Implementation and Project Management

  • Create and administer database objects (tables, forms, queries/views, reports, and functions, etc.) from design to deployment and utilize subject matter expertise to design or re-use, configure, and implement database solutions/processes that maximize system availability efficiently and effectively, and to preserve data integrity, recoverability, and supportability.

  • Perform all tasks related to the database and implementation of technology tools.

  • Provide guidance and feedback to Application Developers on the design and execution of new features.

  • Work closely with SUD program staff to support all stages of data collection, cleaning, coding, and file conversion into formats that are useful for program management, evaluation, and research.

  • Periodically perform checks for accuracy in program databases.

  • Maintain selected data sources and implement regular updates to ensure data quality. Documentation

  • Document procedures and calculations used to describe program outcomes. Other

  • Provide technical and operational assistance to users, troubleshoot and resolve application and database related problems.

  • Work with IT to solve technical problems.

  • Perform related duties as assigned.

MINIMUM QUALIFICATIONS

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

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

  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 job has three levels. 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

  • Bachelor's degree in Computer Science or related field;

  • Experience working in data management, with a strong background in relational database design with knowledge of SQL Databases (Microsoft Access, Oracle database, Microsoft SQL Server);

  • Strong understanding of relational data structures, theories, principles, and practices;

  • Strong background working with Oracle, SQL, and PL/SQL;

  • Knowledge of data warehousing, dimensional design/modeling and ETL architectures;

  • Ability to write complex SQL queries, stored procedures, triggers and views and program in PL-SQL,VB/VBA and at least one other programming language (such as Python or Java);

  • Advanced proficiency with MS Access and Excel; Computer proficiency using academic, administrative, or financial programs, systems or databases;

  • Experience matching data sets and manipulating large amounts of data from multiple sources;

  • Detail-oriented and accurate with superior project management and documentation skills;

  • Capable of translating technical issues for non-technical audiences;

  • Proactive, flexible, and customer focused with strong organizational and follow-through skills to devise and execute work plans, prioritize work, manage multiple projects and meet deadlines;

  • Good understanding of the current data technology environment (particularly, but not confined to Oracle, Microsoft, etc.).

COMPENSATION

$66,710

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

For full consideration, submit a cover letter and résumé online via CUNY's web-based job system, addressing how your experience and credentials fulfill the responsibilities and qualifications outlined. The direct link to the job opening from external sources is: https://home.cunyfirst.cuny.edu/psp/cnyepprd/GUEST/HRMS/c/HRSHRAM.HRSCE.GBL?Page=HRSCEJOB_DTL&Action;=A&JobOpeningId;=19876&SiteId;=1&PostingSeq;=1

CLOSING DATE

February 5, 2019

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: Database Administrator, Data Management & Analytics (IT Associate Level 1 Provisional)

Job ID: 19876

Location: Central Office

Full/Part Time: Full-Time

Regular/Temporary: Regular