Senior Database Administrator

HealthCare Partners, IPA and HealthCare Partners, MSO together comprise our health care delivery system providing enhanced quality care to our members, providers and health plan partners. Active since 1996, HealthCare Partners (HCP) is the largest physician-owned and led IPA in the Northeast, serving the five boroughs and Long Island. Our network includes more than 10,000 primary care and specialist physicians delivering services to over 200,000 members enrolled in Commercial, Medicare and Medicaid products. Our Management Services Organization employs over 200 skilled staff professionals dedicated to ensuring practices deliver the highest quality of care to their patients while efficiently utilizing healthcare resources.

HCP's vision is to be recognized by members, providers and payers as the organization that delivers unsurpassed excellence in healthcare to the people of New York and their communities. We pride ourselves on selecting the most qualified candidates who reflect HCP's mission of serving our members by facilitating the delivery of quality care.

Interested in joining our successful Garden City Team? We are currently seeking a Sr. Database Administrator.

Position Summary :

The Senior Database Administrator plays a crucial role in ensuring the operational excellence and stability of our hybrid database architecture, spanning SQL Server on-premises, Azure SQL Databases, Managed Instances, and Fabric Databases in the cloud. Responsible for creating, managing, and monitoring mission-critical databases core to the organization's success.

The ideal candidate will ensure the availability, performance, and security of our databases, supporting both OLTP and OLAP systems, as well as integration and ELT processes. This includes the administration of SQL Server systems, the design and development of new database solutions, solving complex performance problems, capacity planning, and automation. Given our healthcare focus, strict adherence to HIPAA compliance is essential.

As a senior member of the Enterprise Architecture team, you will field escalated issues related to data architecture, query design / development / best practice, provide guidance to colleagues, and work collaboratively in delivering database solutions that exceed business expectations. You are the expert and have an opportunity to influence both our data strategy and estate going forward.

Essential Position Functions / Responsibilities :

• Database Administration : Implement and manage operational aspects of Microsoft's products and services (SQL Server, Azure SQL Database / MI and Microsoft Fabric) across a hybrid architecture.
• Performance Tuning & Scalability : Conduct performance and capacity planning, including tempdb management, parallelism, data file and I / O throughput optimization, and partitioning.
• Database Development : Deep experience in delivering end-to-end database solutions in SQL Server, from initial design and proof of concept through development, testing, and delivery.
• Integration & ELT : Lead the administration, design, development, and maintenance of end-to-end data pipelines across internal and external data sources. Leverage modern ETL tools and frameworks to minimize file or source-specific development, maximize automation, and ensure data integrity throughout its lifecycle.
• Backup, Recovery, & Business Continuity : Create, implement, and validate solutions (AAG, MI Link, Mirroring, Transaction Log Shipping) that ensure high-availability and adherence to RTO / RPO disaster recovery objectives.
• Monitoring & Troubleshooting : Continuously monitor database performance, blocking queries, extended wait times, disproportionate resource utilization, and troubleshoot issues as they arise. Work with colleagues to review and optimize queries that are common offenders.
• Documentation : Maintain documentation of database configurations, processes, and standards; along with any data dictionaries, technical requirements, and architecture diagrams for new solutions.
• Data Warehouse / Lakehouse : Experience implementing and managing a unified data estate with a medallion architecture is a plus, preferably utilizing Microsoft Fabric, OneLake, Lakehouses, and Data Warehouses.

Qualification Requirements :

Skills, Knowledge, Abilities

Training / Education :

Experience :

Salary Information :

Annual Base Compensation : $135,000 - $150,000

Bonus Incentive : Up to 5%, based on organizational performance

HealthCare Partners, MSO provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, HealthCare Partners, MSO complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Department : Information Technology

This is a non-management position

This is a full time position

J-18808-Ljbffr