Database Administrator IV

Job Description

Job Description

Planet DDS is a leading provider of a platform of cloud-based solutions that empowers growth-minded dental businesses. Now serving over 13,000 practices and 118,000 customers in North America, Planet DDS delivers a comprehensive suite of solutions, including Denticon Practice Management, Cloud 9 Ortho Practice Management, and Apteryx Cloud Imaging. Planet DDS is dedicated to enabling dental support organizations (DSOs) and groups to grow and thrive with technology that delivers seamless integrations, improved workflows, and future-proof scalability.

• This is a hybrid role (onsite 2x per week) in either our Atlanta, GA or Akron, OH offices.

Overview

A DBA IV is a vital member of the DBA Team. You will be involved in the management, deployment, and monitoring of database systems while ensuring security and a high level of data availability. You will be responsible for delivering high-quality, timely solutions and services through the full lifecycle, including development, testing, and implementation.

You will be working on a team in fast-paced environment and will take the initiative to explore, experiment new technologies to find the right solution and mentor other members of the DBA team. To be successful, we are looking for a friendly, hard-working, positive person with a true passion for solving problems with technology.

Responsibilities :

Write;

Solid queries, stored procedures, functions, and triggers

Administrative utilities to automate routine tasks

Develop ETL processes

Automation scripts for building non-prod and prod environments on Azure

Ensure;

SQL queries are efficient and are scalable on production environment

Accurate database indexing, archiving, reporting, and automation

SQL coding standards are followed by each team member

CI-CD is fully functional and reliable in all environments including Azure

Mentor more junior database administrators and software engineers

Provide leadership, technical guidance, and best practices to the solution design process and to other team members

Work closely with the IT, DevOps and Cloud team to support infrastructure enhancements and maintenance

Participate in periodic performance reporting, record performance metrics, analyze drifts based on known baseline data, trend analysis to support in growth monitoring and capacity planning

Implement and maintain database security, including database encryption, data masking and securing backups

Coordinate, monitor and manage all nightly data services jobs

Monitor database operations and performance using native and 3rd-party tools

Troubleshoot data-related issues while maintaining data integrity and accuracy

Document changes and follows existing processes, code, data flows and other key functions

Participate in continuous improvement efforts in enhancing database performance and providing increased functionality, including performing maintenance, monitoring activity, and documenting problems, changes, and solutions

Work on scheduled rotation involving after-hours tasks and routines

Skills & Qualifications

8+ years of experience in database administration or a related position

Proven expertise in production monitoring and troubleshooting (Production Support Lead)

Strong experience with Azure SQL databases

Proficient in writing stored procedures, queries, functions, and triggers using T-SQL

PowerShell scripting experience for automating routine database and infrastructure tasks

Skilled in Azure DevOps and SSDT Database projects

Hands-on experience with the full software development lifecycle

Proficient in Agile software development methodology

Experience working with cloud technologies (Azure and AWS preferred)

Strong communication and collaboration skills

Bachelor's Degree in a relevant major or equivalent years of experience

Pluses

Experience in infrastructure layout, provisioning, Azure cloud infrastructure with reference to provisioning, security, and management

Experience in B2B product development

Experience in designing multi-tenant SaaS database schema

PLANET DDS CORE IDEOLOGY

Mission :

Dental software is broken. We aim to fix it.

Vision :

To be the first choice for growth-minded dental businesses.

How do we get there?

To encourage measurable progress toward our vision and make the best decisions on behalf of employees and customers, we adopted a set of common values :

Collaborative – Working independently and across teams, we create scalable solutions to enable company growth

Empathetic – We are educated on the experience of our customers and feel vested in their success

Accountable – We feel ownership for the quality of our work and take pride in the positive outcomes

Trustworthy – We operate with integrity and honest, making promises we know that we can keep

Ambitious – We are driven by our ability to make a long-term, positive impact on the lives of dental market leaders

An Equal Opportunity Employer – Including Disability / Veterans

Powered by JazzHR

L6xmFqmhTD