Database Administrator - Information Mgmt Technical (Full Time, 40, Day)

Queen& X27 S Health System - Honolulu, HI

Full-time

Honolulu, HI

About the position

The Queen's Health Systems (QHS) is seeking a Database Administrator to manage, administer, organize, monitor, and maintain databases that support its operations across various data domains, including clinical, financial, employee, and patient experience. The role primarily involves working within a Microsoft SQL Server environment, ensuring the integrity of databases through effective backup, recovery, capacity planning, security management, troubleshooting, and issue resolution. The Database Administrator will also be responsible for applying updates to the Relational Database Management System (RDBMS) and associated applications as assigned. In addition to maintaining database integrity, the Database Administrator will perform tuning and optimization, testing, disaster recovery, and ensure data quality. The position requires providing consulting support to the Data Architecture team in all aspects of design, development, and deployment of Enterprise Data Warehousing (EDW), applications, and analytic solutions. This includes supporting data model and flow design, as well as ensuring metadata accuracy. The role also involves maintaining and monitoring the health of upstream and downstream data flows to support EDW operations, business intelligence (BI) initiatives, and third-party application suites. A key aspect of this position is the training and mentoring of junior-level team members in various aspects of database administration, fostering a collaborative work environment. The Database Administrator will be expected to work independently under general direction while maintaining a high level of confidentiality and a strong sense of customer service to effectively address the needs of business and clinical partners.

Responsibilities

• Manages, administers, organizes, monitors, and maintains databases to support QHS operations across all data domains.
• Responsible for integrity of databases including backup, recovery, capacity planning, security management, troubleshooting and issue resolution.
• Performs tuning/optimization, testing, disaster recovery, and ensures data quality.
• Provides consulting support to the Data Architecture team in all aspects of design, development, and deployment of Enterprise Data Warehousing (EDW), applications, and analytic solutions.
• Maintains and monitors the health of upstream/downstream data flows in support of EDW operations, business intelligence (BI) initiatives, and third-party application suites.
• Trains and mentors junior-level team members in aspects of database administration.

Requirements

• Bachelor's degree in Information Technology (IT) or related field; or four (4) years experience in information technology may be substituted for the education requirement.
• Five (5) years experience in database administration including performance tuning and optimization, using native monitoring and troubleshooting tools.
• Experience with backups, restores, maintenance plans, and recovery models.
• Advanced database object development, including hand-coded stored procedures, user-defined functions, check constraints, indexing methods, partitioning, and filestream.
• Experience with installing, upgrading, adding features, and configuring MS SQL Server instances and migrating databases.
• Hands-on experience with Extract, Transform, and Load (ETL) applications, Microsoft SQL Server - Integration Services (SSIS).
• Experience working with Windows server, including Active Directory.
• Thorough knowledge of practices, policies, and systems related to database management.
• Demonstrated application of information technology data and programming principles, theories, concepts, and best practices.
• Core tenants of Relational Database Management Systems (RDBMS) principles, processes, technologies, and tools.

Nice-to-haves

• Graduate degree.
• Database (Oracle, Teradata, DB2, Sybase), Microsoft, Developer certifications.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Experience with Replication, Log Shipping, and/or Mirroring.
• Experience with MS SQL Server - Reporting Services (SSRS), and Analysis Services (SSAS).
• Experience with other enterprise class database systems (e.g. Teradata, Oracle, DB2, Sybase, MySQL).
• Working with healthcare data systems, understanding of clinical operational measures, including experience with Electronic Medical/Health Record Systems (EMR/HER) and data (Epic/Clarity, ideally).
• Experience with healthcare regulatory and clinical quality measurements frameworks such as NCQA HEDIS, Meaningful Use, PQRS, OPPE, CORE measures, etc.
• General understanding of analytics and statistics.
• Familiarity with development methodologies including AGILE development approaches.
• Experience with Qlikview or other similar visualization and analysis tools (e.g. Tableau).
• Experience with data-driven web application development, e.g. ASP.net.
• Experience with scorecard/dashboarding visualizations to sustain and drive process improvement.
• Prior experience in leading projects and/or work streams and assignments.
• Experience with Big Data structures, platforms, programming languages such as R, Hadoop, Hive, NoSQL, Cloudera, MongoDB, predictive analytics, machine learning.