Senior Database Administrator

Health Care Partners; Village of Garden City (NY); On-site; USD 135,000 - 150,000; Full time

Job summary

Health Care Partners is seeking a Senior Database Administrator to ensure operational excellence of its hybrid database systems. The role requires expertise in SQL Server and Azure SQL databases, focusing on performance tuning, security, and database management. Candidates should have a strong background in IT with a bachelor's degree and a minimum of eight years of experience in database administration.

Qualifications

• Minimum of eight years professional experience in database administration.
• Strong knowledge of high-availability solutions and performance tuning.
• Experience with SQL Server and Azure SQL Databases.

Responsibilities

• Implement and manage operations of SQL Server and Azure SQL Database.
• Conduct performance and capacity planning.
• Lead administration and design of end-to-end data pipelines.

Skills

SQL Server

Azure SQL Databases

Performance Tuning

Backup and Recovery

Data Warehousing

ELT Processes

Communication

Education

Bachelor's degree in Computer Science

Job description

Join to apply for the Senior Database Administrator role at Health Care Partners

Join to apply for the Senior Database Administrator role at Health Care Partners

Get AI-powered advice on this job and more exclusive features.

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.

Department: Information Technology

This is a non-management position

This is a full time position

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Medical Practices

Referrals increase your chances of interviewing at Health Care Partners by 2x

Sign in to set job alerts for “Senior Database Administrator” roles.

Jersey City, NJ $120,000.00-$160,000.00 18 hours ago

Englewood Cliffs, NJ $90,000.00-$100,000.00 2 minutes ago

New York, NY $89,301.33-$121,194.66 1 month ago

New York, NY $114,816.00-$165,845.33 1 month ago

New York, NY $100,000.00-$120,000.00 2 weeks ago

New York, NY $70,000.00-$130,000.00 6 months ago

Jersey City, NJ $100,000.00-$125,000.00 3 days ago

Englewood Cliffs, NJ $90,000.00-$100,000.00 1 week ago

Jersey City, NJ $140,000.00-$165,000.00 6 days ago

New York, NY $130,000.00-$160,000.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.