CUNY Database Manager, Data Management & Analytics (IT Senior Associate Level 1 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

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.

The Office of Data Management & Analytics (DM&A;) is seeking a Database Manager who will work under the supervision of the Senior Director for Data Management & Analytics, and will oversee and coordinate database design and development for programs in the Office of the Senior University Dean for Academic Affairs at CUNY and to develop and implement a strategic plan for the office's next generation of data management.

The Database Manager must be able to function independently. Under the supervision of the Sr. Director of DM&A;, the Database Manager will be responsible for leading database design projects for the DM&A; unit. This role will involve overseeing the migration of existing Access databases to an Oracle environment by planning, managing, and documenting the data architecture of DM&A; databases in Oracle. The Database Manager will manage a growing team of database administrators, application developers, and database report writers.

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

  • Review existing data management practices with the Sr. Director of DM&A; and address future office database needs through the development and implementation of a strategic plan;

  • Map out the conceptual design for proposed databases and APEX applications in Oracle;

  • Design data flow diagrams and data models;

  • Identifies database requirements by interviewing stakeholders; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems;

  • Develop and manage policies and processes to continually improve the supported technologies and projects. 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 so as to preserve data integrity, recoverability, and supportability;

  • Work effectively with the Senior Director, Data Management & Analytics to oversee REPS data projects; manage projects and project teams by creating project timelines, assigning tasks, monitoring progress, and ensuring deliverables are on time;

  • Manage day-to-day maintenance of SUD program databases

  • Supervise individual staff members. Documentation

  • Create and maintain Standard Operating Procedures (SOPs) to ensure accuracy, consistency, and relevancy of all information stored across the SUD program databases;

  • Work with staff to create the end user documentation and training materials to be used throughout the life of the database. Other

  • Provide technical and operational assistance to users, trouble.shoot 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 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

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

  • Broad experience work 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;

  • 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 managing project teams working on multiple tasks and deadlines;

  • Experience with Oracle database products (APEX, SQL Developer Data Modeler, SQL Developer, ODI).

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

COMPENSATION

$84,345

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;=19877&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 Manager, Data Management & Analytics (IT Senior Associate Level 1 Provisional)

Job ID: 19877

Location: Central Office

Full/Part Time: Full-Time

Regular/Temporary: Regular