Please note: State agencies that contact job applicants do not usually request personal or financial information via text message or over the phone in connection with your response to a job posting. If you are contacted for such information by these methods, or any other method, please verify the identity of the individual before transmitting such information to that person.
Note: For questions about the job posting, please contact the agency that posted this position by using the contact information provided on the "Contact" tab for the position.

Review Vacancy

Date Posted 08/20/19

Applications Due09/30/19

Vacancy ID73192

AgencyFinancial Services, Department of

TitleData Warehouse/Database Administrator

Occupational CategoryI.T. Engineering, Sciences

Salary GradeNS

Bargaining UnitM/C - Management / Confidential (Unrepresented)

Salary RangeFrom $0 to $0 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Exempt Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.5


From 9 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No

County New York

Street Address One State Street

City New York


Zip Code10004

Minimum Qualifications Appointment method:

This is an appointment to a position in the exempt jurisdictional class. As such, the incumbent of this position would serve at the pleasure of the appointing authority.

Duties Description Under the provisions of the Paid Family Leave (PFL) program, the Department of Financial Services (DFS) has been charged with implementing a data warehouse that will not only be used by DFS, but also the Workers Compensation Board, the Department of Health and other agencies. DFS is seeking to fill the position of Data Warehouse/Database Administrator in our Information Technology Unit to be responsible for designing and implementing and maintaining staging, operational data stores (ODS) and data warehouse environments using data from multiple sources through data normalization, de-normalization, flattening and enrichment for the development of the infrastructure of the new Paid Family Leave data warehouse. This includes playing an important and sensitive role in decision-making and policy-making activities.

The incumbent will advise policy-makers on issues related to PFL implementation and provide expertise as to what data is needed to support policy decisions. The incumbent will be involved in confidential, high level discussions about acquisition, publication and security of data related to PFL. Other duties of this position include, but are not limited to:

• Designs and implements the architecture and infrastructure of enterprise systems:
o Configures and maintains database servers and processes;
o Performs backups, restorations, reorganizations, and recovery work on server databases;
o Optimizes servers and databases for high levels of performance and availability, including disaster recovery and business continuity (DR/BC); and
o Ensures relational database management system (RDBMS) and data warehouses confirm to all security best practices and applicable regulations;
• Maintains thorough understanding of the environment to ensure adherence to standards and utilizes accepted practices for enterprise design;
• Perform SQL tuning and SQL optimization
• Reviews current and proposed architectures to meet acceptable enterprise system practices;
• Provides technical advice and guidance for infrastructure improvements and deploys and maintains systems in accordance with established guidelines;
• Implements enterprise information security, procedures and protocols and participates in security risk reviews and remediation activities including producing written technical reports;
• Participates in the testing of applications, such as developing test plans, test conditions, and validation testing; and
• Designs, develops, and maintains logical/physical data models, entity relationship diagrams and a common data dictionary.

Skills Requirements:

• At least 7 years experience in working with Oracle 11g/12c RDMS;
• Strong experience in Oracle database advanced security
• Experience with Oracle Enterprise Manager
• Strong technical experience in designing and implementing data-intensive Data Warehouse solutions;
• High proficiency writing SQL/ T-SQL;
• Strong Knowledge of logical and physical data modeling (relational, dimensional data modeling); and
• Experience in database DR/BC.

Additional Comments Positions located within the New York City metropolitan area, as well as Suffolk, Nassau, Rockland, and Westchester Counties, are also eligible to receive an additional $3,026 annual downstate adjustment

Some positions may require additional credentials or a background check to verify your identity.

Name Darlene Clemente

Telephone 518-474-0873

Fax 518-402-5071

Email Address


Street One Commerce Plaza, Suite 301

City Albany

State NY

Zip Code 12257


Notes on ApplyingTo Apply: Interested qualified candidates must submit a resume and letter of interest no later than September 30, 2019, to the email address listed below. Please include (Box DW-BIE-00155) in the subject line of your email to ensure receipt of your application. Email submissions are preferred.

Darlene Clemente
Box DW-BIE-00155
New York State Department of Financial Services
Office of Human Resources Management
One Commerce Plaza, Suite 301
Albany, New York 12257
Fax: (518) 474-0873

Please note that not all applicants may be scheduled for an interview.

Under the Americans with Disabilities Act (ADA), the Department of Financial Services is required to provide reasonable accommodation for known physical or mental limitations of an otherwise qualified applicant with a disability if an accommodation would enable the applicant to perform the essential functions of the job and the accommodation would not constitute an undue hardship on the operations of the agency.

Printable Version