JOB SUMMARY:
The Database Analyst/Administrator is responsible for design of complex databases and creation of physical database tables from design, administering and controlling the organization-s data resources, including multiple relational and post-relational databases and servers. Performs physical and logical database design, set up, configuration, monitoring and works with system administrators and uses data dictionary software / application packages to ensure data integrity and security. Recovers corrupted data and eliminates data redundancy. Develops strategies for database acquisitions, archival, design, virtualization, replication, maintenance and support and other complex technical tools and solutions. Uses tuning tools to improve database performance. Provides database programming, and structured analysis to accommodate database integration coordination and administration. Performs database development, design, analysis and configuration to provide backend storage and performance solutions for multiple databases in a complex environment. The position has overall responsibility for database installations and implementations, as assigned. Responsible for multiple organizational database technologies, platforms, and configurations in a multi-system environment with packaged application customization, and custom integration development.. Performs all aspects of programming, analysis, coding, design, development, configuration, implementation, testing, documentation, application programming and solution analysis, support, maintenance, and troubleshooting. The DBA performs programming and support for systems (Oracle/ MS SQL / OLAP / cache) and utilizes Visual Basic, Crystal reports and other systems and modules, as assigned. Performs all tasks related to lifecycle of databases using UNIX, Windows platforms, and utilizing Oracle, SQL Server, My SQL, PL/SQL, TSQL, Informix, DB2, Sybase.

Core duties include:

• Write and edit automated jobs that import and export data between systems.

• Provide detailed analysis, design, tuning, testing, implementation and documentation of the business intelligence system and data warehouse.

• Provide expertise in writing and editing queries that read, manipulate, and analyze data from business intelligence, relational databases, and data warehouses.

• Responsible for business intelligence quality testing, stakeholder approval and user acceptance testing.

• Create tables and write reports on their findings, validating data output through SQL and simplify highly technical language for end users in the company.

• Translate business requirements into system requirements and assess where support is needed relative to existing technical system design.

• Participate in creating strategies and roadmaps for business intelligence and data platforms.

• Ability to learn and utilize programs to analyze data from different sources and produce meaningful reports and/or presentations.

• Contribute to the development of standards and processes for integration projects and initiatives.

• Work with other developers to make sure that all data solutions are consistent.

• Create data flow diagrams for data management systems.

• Creation of a data catalog.

• Work with other development teams to review and approve database changes according to database design standards and principles.

• Resolve conflicts between models, ensuring that data models are consistent with the ecosystem model (e.g., entity names, relationships, and definitions).

• Code, test, and document new or modified data systems to create robust and scalable applications for data analytics.

  MINIMUM QUALIFICATIONS:

  Bachelor's Degree; relevant experience in excess of 5 years may be substituted for a Bachelor's degree

  5 years of experience

  Demonstrated experience in multiple database products, platforms and languages

  Must possess skills and experience in oral and written communications, including analysis documentation, project management deliverables and documentation, application/systems specifications, project preparation, risk identification and escalation, and report presentation

  Must be a technical expert in area subject matter demonstrated by documented experience in analysis, process design and workflow, research, installation/implementation and support of software applications and systems; Develops detailed functional system and programming specifications

  Strong critical thinking, problem solving, and analytical skills

  Must have installed a minimum of one computer based hospital system and actively performed the following: process and workflow analysis, systems/applications analysis, project lifecycle implementation with in depth experience and training in a minimum of four discreet major projects

  Must have proven experience in being able to communicate, motivate and organize projects among a broad spectrum of hospital personnel, frequently under deadline pressure

  Demonstrated leadership skills, strong customer service and team focus is required

  Must be able to work under pressure, following a plan and balancing competing requests by priority; must have a high level of integrity and trust

  Advanced verbal and written communication skills

  Minimum of six years in programming and systems analysis with proven prior experience in systems/ application process and workflow analysis, application/system analysis, programming, experience working on project team(s), health care systems administration, financial and/or clinical systems support and maintenance as well as general knowledge of major health care information issues

  Experience in performing all tasks related to lifecycle of databases using UNIX, Windows platforms, and utilizing several of the following DBMS: Oracle, Cache SQL Server, My SQL, PL/SQL, T-SQL, Informix, DB2, Sybase, etc.

  PREFERRED QUALIFICATIONS:

  Master's Degree

  5 + years of experience in Database programming, or related programming experience and systems analysis

  Knowledge of process/workflow engineering

  Significant experience in applicable and various development technologies and platforms, and diverse experience level in data communication technologies in a multi system environment

  Self-motivated and self-directed with capability to work independently

  Prefer database experience with previous integrated Healthcare Information systems with emphasis on Clinical and Financial, EMR applications/systems (Epic, Meditech, Cerner, etc.), and ERP systems

  One or more certifications in applicable Epic module

  • ",