Database Administrator Day Shift

Full-Time, 40 Hours, Day Shift

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

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.

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.

Not substantially subjected to adverse environmental conditions.

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.

• 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.