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

• Expertise in SQL Server on-premises and Azure SQL Databases, Managed Instances, and Fabric Databases.
• Proficiency in backup and recovery strategies, including AAG, MI Link, Mirroring, Transaction Log Shipping, Simple/Full/Bulk-Logged Recovery Models.
• Strong knowledge of high-availability solutions and performance tuning techniques.
• Experience in optimizing performance and reliability through tempdb management, parallelism, data file and I/O throughput optimization, and table/index partitioning.
• Deep expertise in designing, documenting, coding, and delivering database solutions as part of a managed SDLC (Database Projects, Azure DevOps, Git)
• Extensive experience in ELT processes, tools (Azure Data Factory, SSIS, Data Pipelines, Dataflow Gen2, SQL) and ingestion from external sources (text files, Excel, HL7, FHIR, and other databases).
• Proficiency in creating and managing data warehouses/lakehouses using Microsoft Fabric and Azure Data Lake, following a medallion architecture.
• Familiarity with Microsoft PowerApps, C# and/or PowerShell is a plus
• Demonstrates a logical approach to problem solving with high-level analytical capabilities, ingenuity, and creativity, including attention to detail and understanding of business data and constraints.
• Excellent interpersonal, analytical, written and verbal communication skills, including the ability to convey information to non-technical colleagues in a concise and clear way.
• Possess strong skills in relationship management, presentation and mentoring/coaching.
• Ability to work both independently and in a team environment, meet deadlines, mentor, share knowledge and assume ownership for assigned areas.
• Detail-oriented with a focus on accuracy and quality.

Training/Education:

• Bachelor's degree in Computer Science, Information Technology, or a related field; or, an equivalent combination of education and related work experience.

Experience:

• Minimum of eight (8) years professional experience in database administration and engineering, with a focus on SQL Server, Azure SQL Databases, SSIS and ETL.

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.