ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR

Overview

ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR

Join to apply for the ENTERPRISE DATA WAREHOUSE (EDW) ARCHITECT AND DATABASE ADMINISTRATOR role at NYC Department of Social Services

The Department of Social Services (DSS) is comprised of the administrative units of the New York City Human Resources Administration (HRA) and the Department of Homeless Services (DHS). HRA is dedicated to fighting poverty and income inequality by providing New Yorkers in need with essential benefits such as Food Assistance and Emergency Rental Assistance. DHS is committed to preventing and addressing homelessness in New York City by employing a variety of innovative strategies to help families and individuals successfully exit shelter and return to self-sufficiency as quickly as possible.

Information Technology Services (ITS) is DSS's technology services organization. ITS mission is to support the daily, emergent, and long-term needs of both agencies. ITS creates and enhances the technology infrastructure and computer applications that support HRA and DHS and develops applications, including a variety of client eligibility and recertification systems, case management systems, housing systems, employment / work engagement services, revenue producing computer matches, claiming systems, and personnel systems.

Under the general direction of the Sr. Director, HRA Enterprise Data Warehouse, the EDW Database Administrator / Architect will provide administration, development, design, support, and maintenance of database servers that enable the agency to interface between multiple hardware and software-based systems to deliver critical business solutions in a rapid and agile manner.

Information Technology Services (ITS) Is Recruiting For One (1) IT Project Specialist, To Function As An Enterprise Data Warehouse (EDW) Architect And Database Administrator, Who Will

Responsibilities

• Implement Oracle 19c database solution for Oracle T5-8 Supercluster Engineered System on Solaris Servers, including installation, administration, configuration, integration, deployment, and design.
• Manage the database design of a very large, read-only RAC database to give business users and programmers across the agency the power to analyze historical, multi-source data quickly and easily.
• Monitor Oracle Enterprise Manager (OEM) for any performance or space-related issues. Performance tuning of the DB and any SQL queries is essential.
• Be responsible for data warehouse design, complex transformations, integration, mapping, and transporting data to multiple targets. Experience with various source systems, including mainframe, mapper, OLAP, and flat files. Strong experience with E-R modeling, modeling with Snowflake schema, slowly changing dimension, data analytics, and system architecture, maintaining Enterprise User Security, synchronizing user credentials between Oracle Internet Directory and Microsoft Active Directory.
• Be familiar with compliance requirements like the Health Insurance Portability and Accountability Act for protecting secure restricted data.

Minimum Qualifications

Preferred Skills

Additional Information

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education's website at https : / / studentaid.gov / pslf / .

Residency Requirement

New York City Residency is not required for this position

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual\'s sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Salary : $75,000.00 – $160,000.00

Compensation

Salary : $75,000.00 – $160,000.00

Seniority level

Employment type

Job function

Industries

J-18808-Ljbffr