Database Architect - Expert

Provide a short description of the Position: ALFS: used to develop a budget, allocate funds, disburse payments and ensure that funds are expended in compliance with existing laws, regulations and guidelines. OCRA provides cost reporting information to Medicare & Medicaid. CWP: Allows for patients to become employed at OMH psych centers and tracks rosters, hours worked, payments, etc. MET A rewrite of OMH s MHARS electronic medical record system.

Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Write queries in PL/SQL; Write database migration scripts to move forward any changes to database structures and data from the Development platform to the QA and Production platforms. Develop scripts for automating support and maintenance; Compare databases on different platforms (Development, QA, Production) for differences in structure and produce database scripts to make the databases the same, structure-wise; Troubleshoot and performance tune database queries; Develop and troubleshoot processes that exchange data with other systems such as Statewide Financial System (SFS); Implement work-arounds on the database side for failed processes in applications while the application side is being fixed; Assist other developers working on database related items; Interact with business users to translate requirements into technical models