General Summary of Position Responsibility:

Under the direction of the Director of IT, Network Services, the IT Database Specialist installs, implements, maintains, and supports database software and application processes for the enterprise. This position provides ongoing supoort of packaged software systesm, database design, and technical services to users, administers database system operational processes, and prepares and maintains documentation related to database solutions. This position requires the individual to have an understanding of assigned database technologies and to assume responsibility for the successful completion of complex project tasks. The IT Database Specialist is also expected to perform with minimal supervision and to perform the technical and project mentoring and development of other staff involved in database support

Essential Job Functions:

1. Develops and manages databases for clinical and business applications, including but not limited, to Epic, Lawson, and Axolotl Transcription. Performs quality reviews on all database processes and technologies.
2. Mentors and develops the technical and project skill sets of other database support staff as assigned.
3. Participate in project tasks related to database services as required, meeting all project deadlines and deliverables.
4. ManageS database technologies for one or more of the databases used in the enterprise: Epic Chronicles/Cache, Microsoft SQL, and Oracle (Lawson) as assigned.
5. Creation and maintenance of database tables and structures, including performance and capacity measurements and planning. Manages the Clarity ETL process (Epic).
6. Supports the import or extraction of downstream application data, ad-hoc user database requests, or reporting needs.
7. Works with reporting, export, and interface analysts, or other reporting resources on report development as required.
8. Works with system administrator on the installation and maintenance of the Epic and other system components related to database technologies.Automation of database process around starting, stopping, and restart of database processes.
9. Create reports and automate error detection and alert processes that will be utilized in the on-going operation of the database systems.
10. Develops and documents procedures covering all aspects of enterprise-wide database administration.
11. Acts as a backup resource to other database staff as assigned.

Knowledge, Skills and Abilities:

Bachelor’s Degree in information systems or a directly related field or equivalent work experience is required.

3+ years of experience in a complex healthcare enterprise applications environment, working with advanced skills with at least one of the database technologies in use at CMH..

Master level skills in one or more relevant database technologies; including but not limited to Epic Chronicles/Cache, Microsoft SQL, or Oracle (Lawson).

Programming or scripting skills necessary to assist in database server and management tasks. This would include Unix or Windows shell scripting and database vendor specific tools as appropriate. Familiarity with clinical and business applications and processes is desired.

Certification in specific database technologies is highly desired.

Analytical thinking for effective problem determination and the ability to work independently, make decisions under pressure, while providing timely and responsive services are the keys to this position.

Excellent time and project management skills, customer service and interpersonal skills, system diagnostic and communication (written and oral) are critical for success in this position.

Ability to mentor other team members.