Database Administrator/Developer I

Overview

Halifax Health is seeking a Database Administrator/Developer I for the IT Department.

Summary

Under the direction of the Automation and Development Manager and the Sr. DBA Dev, the DBA Dev I maintains and supports all aspects of Halifax Health's SQL Server database environment. The environment consists of 100+ on premise virtualized, Microsoft SQL Server instances powering several hundred in-house and third-party enterprise applications. The incumbent will also assist the development team with database level software development tasks.

Job Qualifications

• Bachelor's Degree in computer-related field and knowledge of SQL and or programming experience or equivalent combination of education and experience.

• Evidence of ability to analyze and translate user requirements into specifications and prepare detailed design/implementation documentation.

• Demonstrated ability in analytical reasoning and logical problem solving.

• Knowledge of SQL Server design, build, configuration, administration, and troubleshooting.

• Knowledge of scripting in T-SQL.

• Preferred:

• Knowledge of Microsoft Server + CAL and Core licensing models and editions.

• Knowledge and experience in DevOps practices, CI/CD and Agile.

• Knowledge and experience in advanced SQL Server features and architectures including Cloud, AlwaysOn and containerization.

• Ability to advocate for appropriate technology solutions and to continually advance the organization's readiness and capabilities.

Job Duties and Responsibilities

• Install and configure Microsoft SQL Server database instances.

• Maintain, monitor, and patch existing SQL Server database instances.

• Add, modify, and audit system/user permission to databases or servers, maintain appropriate system security levels and continually improve enterprise threat posture.

• Maintain, monitor, and audit database backups and jobs.

• Upgrade and migrate legacy SQL versions.

• Perform application capacity planning, set up, performance tuning and monitoring.

• Work with infrastructure team for cluster resource planning, participate in purchasing decisions, testing and presales due diligence.

• Detect and troubleshoot database slowness, resource contention, locking and blocking.

• Provide continuous planned uptime and participate in rotating on-call duties, DR planning and implementation.

• Assist with SQL database build and task automation.

• Develop new and maintain existing in-house developed queries, views, stored procedures, reports, and ETLs.

• Participate in agile team development projects.

About Us

Recognized as one of the 50 Top Cardiovascular Hospitals in the United States by IBM Watson Health, Halifax Health serves Volusia and Flagler counties, providing a continuum of health care services through a network of organizations including a tertiary hospital, two community hospitals, urgent care clinics, psychiatric services, a cancer treatment center with five outreach locations, the area's largest hospice, a center for inpatient rehabilitation, outpatient rehabilitation clinics, primary care walk-in clinics, a clinic specializing in women's health, a pediatric care community clinic, five pediatric medical practices, a home health care agency and an exclusive provider organization. Halifax Health offers the area's only Level II Trauma Center, Thrombectomy-Capable Stroke Center (TSC), Center for Transplant Services, Pediatric Intensive Care Unit, Child and Adolescent Behavioral Services, complete Neurosurgical Services, OB Emergency Department and Level III Neonatal Intensive Care Unit that cares for babies born earlier than 28 weeks. For more information, visit halifaxhealth.org.