Job Title: Database Administrator II
PVN ID: VA-2303-005521
Category: Managerial and Professional
Location: OFFICE OF SR. UNIV DEAN FOR ACADEMIC AFFAIRS

Job Description

General Description

This position is responsible for storing, organizing, presenting, using, and analyzing data and database management software for the Office of Research, Evaluation, & Program Support (REPS).

Specific duties include: 

  • Create advanced PL/SQL functions, procedures, packages, triggers incorporating complex conditional logic to address business needs
  • Utilize database 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
  • Automate data extraction, transformation, and load (ETL) using Oracle Data Integrator (ODI)
  • Plan out, create tasks for, delegate, lead and review the work of DBA Is
  • Create protocols, files, task lists, SQL and PL/SQL syntaxes for database security, access privileges, permissions
  • Provide technical and operational assistance to users, troubleshoot, and resolve application and database related problems
  • Provide guidance and feedback to Application Developers on the design and execution of new features
  • Contribute to data infrastructure strategic planning to meet organizational and collaborative goals
  • Review existing data management practices and develop and implement project plans to address future database and technology needs
  • Assess current processes and develop technology solutions to create efficiencies, maximize data integrity and minimize manual data entry

Other Duties

N/A

Qualifications

Requires bachelor’s degree in Computer Science or related field and four years of related work experience.

Experience must include at least two years of the following:

  • Experience in data management with a strong background in relational database design
  • Experience with SQL Databases (Microsoft Access, Oracle database, Microsoft SQL Server)
  • Experience with data structures, theories, principles, and practices
  • Experience with Oracle, SQL, and PL/SQL

 

Multiple positions

New York, NY

RFCUNY Benefits

RFCUNY Employee Benefits and Accruals

About the Research Foundation

The Research Foundation of The City University of New York (RFCUNY) is a nonprofit educational corporation founded in 1963 to provide post-award fiscal and administrative support for CUNY’s research and sponsored programs. RFCUNY’s services allow CUNY researchers, faculty, and staff to focus on their intellectual curiosity and scientific discoveries, on projects and programs that serve our local and global communities, proposing concrete solutions to society’s most pressing challenges.

RFCUNY serves as a fiscal agent and works closely with all the CUNY campus Grants Offices to perform the core functions of post-award financial management for CUNY research projects and sponsored programs. These functions include legal assessment and signing of agreements where RFCUNY is named as a fiscal agent; setting up award accounts; preparing sub-awards and assisting PIs in monitoring the work of the recipients of sub-awards; supporting project directors with hiring and managing research project and sponsored program staff; supporting the purchasing and paying for goods and services with grant and program funds; managing financial aspects of projects including accounts receivable, financial reporting, invoicing, budget monitoring, and cost compliance with uniform guidance; ensuring that sponsor financial requirements are met; monitoring compliance with applicable project and financial management rules and laws; supporting the management of independent and external audits and financial reviews; and providing data, information, management expertise, and other supports to CUNY’s research and sponsored programs.

Equal Employment Opportunity Statement

The Research Foundation of the City University of New York is an Equal Opportunity/Affirmative Action/Americans with Disabilities Act/E-Verify Employer. It is the policy of the Research Foundation of CUNY to provide equal employment opportunities free of discrimination based on race, color, age, religion, sex, pregnancy, childbirth, national origin, disability, marital status, veteran status, sexual orientation, gender identity, genetic information, marital status, domestic violence victim status, arrest record, criminal conviction history, or any other protected characteristic under applicable law.

Key Features

Department
Office of Research Evaluation & Program
Status
Full Time
Annual Salary Range
$101,500.00 - $101,500.00
Closing Date
Jul 03, 2023 (Or Until Filled)
Bargaining Unit
No

Actions