Senior Oracle Database Analyst

Role - Analyst, Computer Systems (Senior) (1 position)

Education: This position requires a bachelor s degree from an accredited college or university with a major in computer science, information systems, engineering, business, or a related scientific or technical discipline; or three (3) years of equivalent experience in a related field.

Responsibilities and Tasks:

The Computer Systems Analyst shall perform the following tasks:

A. Receive data from various agencies and load the data into the centralized MLDS Center database system.

B. Develop guidelines for identity resolution.

C. Perform identity resolution procedures based on guidelines established.

D. Create complex data set files for use by researchers.

E. Develop data marts to support the MLDS Center reports and dashboards.

F. Develop logical and physical database designs and apply appropriate modifications to design models or database schema.

G. Analyze data received from various agencies and transform the data to meet the business and technical needs of the MLDS Center databases.

H. Load data into MLDS Center databases and perform data validation. Ensure the data transformation and data loading is successful and accurate.

I. Implement Oracle security modules, such as data masking and data encryption, in order to maintain security and confidentiality of system data.

J. Perform data cleansing, data matching, and identity resolution functions within the database.

K. Provide weekly status reports which include, but are not limited to:

a. Tasks Completed

b. Tasks Planned

c. Risks/Issues

L. Perform other duties related to MLDS database analysis as assigned by the Contract Manager.