Database Administrator Lead

Job Description

Job Description

At HealthFirst, our relentless dedication to saving lives drives us forward every day. With an impressive track record of approximately 1,000 lives saved annually and a remarkable total of 52,000 lives saved throughout our storied history, we make an undeniable impact. Each life saved is far more than a statistic; it represents the cherished connection between loved ones, family members, and dear friends. We stand resolute in our commitment and determination to make a lasting impact.

JOB OVERVIEW :

We are seeking an experienced Database Administrator Lead to architect, implement, and maintain MySQL / SQL databases, including performance tuning, and adhering to back-up and archiving schedules. As well, reviewing and approving programmatic changes prior to code deployment. This role requires expertise in database administration, performance optimization, and troubleshooting to ensure the reliability, availability, and security of critical data infrastructure. The ideal candidate will collaborate with developers, system administrators, and business stakeholders to support and optimize database operations.

KEY RESPONSIBILITIES :

• Database Management : Maintain, configure, and implement MySQL / SQL databases to ensure optimal performance and reliability.
• Managed access control and data security through Azure Active Directory integration and role-based access.
• Archiving and Purging : Execute and manage database archiving and purging as per requirements across multiple databases and systems.
• Backup & Recovery : Execute and manage database backups, restores, and disaster recovery strategies.
• Monitoring & Alerts : Review alerts, analyze performance issues, and generate reports for proactive database management.
• MSSQL server and MySQL Administration : Assist in component installations, including database, Analysis Services, Reporting Services, in standalone and clustered environments.
• Documentation : Create and maintain documentation of processes, DBA tasks, and business application workflows.
• Performance Optimization : Assist developers in identifying and resolving performance bottlenecks, including query optimization and index tuning.
• Stored Procedures & Scripting : Write, troubleshoot, and optimize complex stored procedures to support application development.
• Working with the business to define and then own the MDM (Master Data Model). Collaborate with the team and cross-functional areas to architect and establish a new Data Lake.
• Research & Recommendations : Conduct research and provide recommendations on database products, services, protocols, and standards.
• Migrated on-premises SQL Server databases to Azure using Data Migration Assistant (DMA) and Azure Database Migration Service (DMS).
• User Training & Support : Develop guidelines and routines for the best database practices and assist business users with reporting needs.
• Report Development : Generate reports based on business requirements using Server Reporting Services (SSRS) or other reporting tools.
• Maintain up-to-date knowledge of modern technologies, tools, and methodologies related to integration development.
• Create ad-hoc queries to support business decision-making.
• Other duties as assigned.

SPECIFIC KNOWLEDGE & SKILLS :

GENERAL SKILLS & COMPETENCIES :

MINIMUM WORK EXPERIENCE :

PREFERRED EDUCATION :

TRAVEL / PHYSICAL DEMANDS : Travel typically less than 10%. Office / Remote environment. No special physical demands required

KNOWLEDGE : Seasoned, experienced senior level professional; in-depth knowledge and full understanding of multiple disciplines and good knowledge of other related disciplines. Assignments are broad in nature and require excellent judgment and analytical ability, evaluation, originality and ingenuity to solve. Complete understanding and wide application of principles, theories and concepts of a particular field. Resolve a wide range of complex issues and assignments in creative and effective ways. Serve as a resource to others to resolve complex problems and issues. May play a support role in high-level projects that have an impact on company’s future direction. May take on project lead role on medium-sized projects. Barriers to entry may exist at this level.

COMPLEXITY : Work on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Interpret internal and / or external business issues and recommend solutions / best practices to solve a range of complex problems and assignments; take a broad perspective to identify solutions. Exercise judgment in selecting methods and techniques for obtaining solutions. Guide others in resolving complex issues based on existing solutions and procedures. Network with key senior internal and external personnel inside and outside own area of expertise.

SUPERVISION : Determine methods and procedures for new assignments and work independently with guidance in only the most complex situations. May act as a resource to formally train and mentor TSMs with less experience. Assignments are broad and moderately complex in nature. May manage vendor relationships.

PERFORMANCE REQUIREMENTS : Typically, to advance to a new job level, TSMs must demonstrate professional behavior and should consistently be at the high-end of meeting expectations or consistently exceed expectations.

The salary range for this position is $100,00-128,350. Many factors go into determining employee pay within the posted range including education, prior experience, training, current skills, certifications, location / labor market, internal equity, etc.

BENEFITS : Other benefits available include : Medical, Dental and Vision Coverage, 401K Plan with Company Match, FTO, Work Life Assistance Program, & Educational Benefits.

HealthFirst is an Equal Employment Opportunity Employer and does not discriminate against applicants or employees on the basis of race, color, religion, creed, national origin, ancestry, disability that can be reasonably accommodated without undue hardship, sex, sexual orientation, gender identity, age, citizenship, marital or veteran status, or any other legally protected status.