Database Administrator I (Full-Time, 40 Hours, Day Shift) at The Queen's Health Systems

The Queen's Health Systems; Honolulu (HI); On-site; USD 70,000 - 95,000; Full time

Job summary

The Queen’s Health Systems in Honolulu, HI is hiring a Database Administrator I to manage, monitor, and maintain databases across clinical, financial, employee, and patient experience domains. The role emphasizes SQL Server integrity, backups, recovery, security, and performance tuning.

Responsibilities include supporting EDW and BI initiatives, data quality, and mentoring junior staff. Strong MS SQL Server experience and AD infrastructure familiarity are required.

Qualifications

• Bachelor’s degree in Information Technology (IT) or related field or four years of IT experience may substitute for education.
• Experience with Performance Tuning and Optimization (PTO) using native monitoring/troubleshooting tools.
• Experience with backups, restores, maintenance plans and recovery models.
• Advanced database object development beyond tables and views (procedures, UDFs, indexing, partitioning).
• Experience with installing/upgrading MS SQL Server, migrating databases.
• Hands-on experience with ETL applications, SSIS.
• Experience with Windows Server and Active Directory.
• Strong knowledge of RDBMS principles and data modeling concepts.

Responsibilities

• Manages, administers, organizes, monitors, and maintains databases across data domains (clinical, financial, employee, patient experience).
• Responsible for SQL Server database integrity, backups, recovery planning, security, and troubleshooting.
• Performs tuning/optimization, disaster recovery, development, and data quality assurance.
• Provides consulting support to the Data Architecture team for EDW, BI, and analytics solutions.
• Trains and mentors junior team members in database administration.

Skills

Performance Tuning

Backups & Recovery

SSIS ETL

SQL Server

Windows Server

Communication

Confidentiality

Independent Work

Education

Bachelor’s degree in Information Technology or related field

Graduate degree

Tools

SSRS

SSAS

Tableau

Job description

Full-Time, 40 Hours, Day Shift

The Queen's Health Systems in Honolulu, HI, US.

Database Administrator I

RESPONSIBILITIES I. JOB SUMMARY/RESPONSIBILITIES:

Manages, administers, organizes, monitors, and maintains databases (DB) to support The Queen’s Health Systems (QHS) operations across all data domains (e.g. clinical, financial, employee, and patient experience). QHS is predominantly, but not exclusively, a Microsoft SQL Server environment. Responsible for integrity of databases including, backup, recovery, capacity planning, security management, troubleshooting and issue resolution. Applies Relational Database Management System (RDBMS) and application DB updates as assigned. Performs tuning/optimization, testing, disaster recovery, development 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, including supporting data model/flow design and metadata accuracy. 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.

II. TYPICAL PHYSICAL DEMANDS:

Essential: sitting, finger dexterity, seeing, hearing, speaking, lifting, pushing and carrying items up to usual weight of 5 pounds.

Continuous: reaching above, at and below shoulders; repetitive arm/hand motion and frequent gripping of objects.

Frequent: standing, walking, stooping/bending, and twisting body.

Operates various office equipment such as computers, copiers, 10-key adding machine, typewriter, facsimile, telephone, shredder etc.

III. TYPICAL WORKING CONDITIONS:

Not substantially subjected to adverse environmental conditions.

IV. MINIMUM QUALIFICATIONS:

A. EDUCATION/CERTIFICATION AND LICENSURE:

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.

B. EXPERIENCE:

• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Experience with backups, restores, maintenance plans and recovery models.
• Advanced database object development, beyond tables and views, such as hand-coded stored procedures, user-defined functions, check constraints, indexing methods, partitioning, 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.
• Demonstrated application of information technology data and programming principles, theories, concepts, and best practice (e.g. requirements documentation, source code control, change management, promotions, and segregation of duties).
• Core tenants of Relational Database Management Systems (RDBMS) principles, processes, technologies and tools including management.
• Strong sense of customer service to consistently and effectively address business and clinical partners’ needs.
• Comfortable with ambiguity and changing priorities and direction in projects and core work.
• Enjoys participating in a collaborative work environment partnering with colleagues inside and outside of own department.
• Ability to maintain a high level of confidentiality.
• Self-motivated; comfortable working independently under general direction.
• Effective written and verbal communication and presentation skills.

V. PREFERRED QUALIFICATIONS:

A. EDUCATION/CERTIFICATION AND LICENSURE:

Graduate degree. Database (Oracle, Teradata, DB2, Sybase), Microsoft, Developer certifications.

B. EXPERIENCE:

• 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 the 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.
• Self-motivated; comfortable working independently under general direction.

Equal Opportunity Employer / Disability / Vet Your Health.

Our Legacy Our Mission: To fulfill the intent of Queen Emma and King Kamehameha IV to provide in perpetuity quality health care services to improve the well‑being of Native Hawaiians and all of the people of Hawai‘i.

Our Values: Compassion guides our actions Aloha inspires us in all that we do Respect and understanding are essential for the dignity of all Excellence is our quest