What are the responsibilities and job description for the Principal Database Administrator position at Team TAG Services, LLC?
The Aspen Group (TAG) is one of the largest and most trusted retail healthcare business support organizations in the U.S. and has supported over 20,000 healthcare professionals and team members with close to 1,500 health and wellness offices across 48 states in four distinct categories: dental care, urgent care, medical aesthetics, and animal health. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Chapter Aesthetic Studio, and AZPetVet. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale.
As a reflection of our current needs and planned growth we are very pleased to offer a new opportunity to join our dedicated team as a Principal Database Administrator.
Position Overview:
We seek a highly skilled Principal Database Administrator (DBA) to lead our database management efforts across hybrid cloud and on-premises environments. The ideal candidate will have extensive experience with Microsoft SQL Server, advanced database concepts, optimization, debugging, and troubleshooting expertise. This role also requires proficiency in PostgreSQL and MySQL as we transition our applications to a microservices architecture. Additionally, the Principal DBA will provide mentorship and guidance to existing staff members in the DBA group, fostering a culture of continuous learning and development.
Key Responsibilities:
- Database Management: Oversee the installation, configuration, and maintenance of Microsoft SQL Server Enterprise, PostgreSQL, and MySQL databases in cloud and on-premises environments. Manage and optimize database instances to ensure peak performance, including configuring extended events, optimizing indexes, and implementing data compression strategies.
- Optimization and Troubleshooting: Diagnose and resolve complex database issues related to performance, connectivity, and data integrity. Implement best database performance tuning, query optimization, and resource management practices. Utilize extended events and other monitoring tools to identify and resolve issues proactively.
- Manage hybrid cloud environments, ensuring seamless integration and performance between on-premises and cloud-based systems. Develop and implement database backup, recovery, and disaster recovery strategies across diverse environments.
- Collaborate with development teams to design and implement efficient database schemas and stored procedures. Use scripting languages like Python or infrastructure-as-code tools like Terraform to automate database management tasks and deployments.
- Support migrating applications to microservices by designing scalable and resilient database architectures. Ensure databases are optimized for use in containerized and distributed environments.
- Security and Compliance: Ensure databases adhere to security standards and compliance requirements. Implement security measures to protect sensitive data and maintain data privacy.
- Provide mentorship and guidance to existing DBA staff members, fostering their professional growth. Lead training sessions and workshops to enhance the DBA team's skills and knowledge. Encourage a culture of continuous learning and improvement within the team. Offer technical support and advice to DBAs, helping them resolve complex issues and advance their expertise.
Qualifications & Experience:
- A bachelor’s degree in computer science, information technology, or a related field; a master’s degree is preferred.
- Extensive experience as a Database Administrator with a strong focus on Microsoft SQL Server. Minimum of 5 years hands-on experience
- Proficiency in PostgreSQL and MySQL, with an understanding of their roles in a microservices architecture.
- In-depth knowledge of advanced database concepts, including partitioning, Always Availability Groups, In-Memory OLTP, and transactional replication. Familiarity with extended events, index optimization, compression techniques, and transactional isolation levels.
- Experience with scripting languages (Python) and infrastructure-as-code tools (Terraform) is highly desirable.
- Strong understanding of hybrid cloud environments and on-premises infrastructure management.
- Excellent problem-solving skills and the ability to work collaboratively in a fast-paced environment.
- Strong communication skills to effectively interact with technical and non-technical stakeholders.
