Published date Posted on Indeed on Jun 21, 2022 (11 d ago)

Planet DDS is the leading provider of cloud-enabled dental software solutions serving over 10,000 practices in North America with over 60,000 users. The company delivers a complete platform of solutions for dental practices including Denticon Practice Management, Apteryx XVWeb Digital Imaging, and Legwork Patient Relationship Management. Planet DDS is committed to creating value for its dental practice clients by solving the most urgent challenges facing today’s dental practices in North America.

Overview

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

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

(This position can be remote but must sit within the Pacific Time Zone)

Responsibilities & Duties

  • 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
  • Break down large projects into tasks then estimate and commit to tasks and manage your time to deliver as committed
  • 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
  • Learn about on the latest tools and patterns consistent with your role
  • Participate in our Agile processes—from updating Jira to reflecting meaningfully in retrospectives and everything in between
  • Work on scheduled rotation involving after-hours tasks and routines
  • Other duties as assigned

Qualifications

  • 8 years or more of experience in a database administration/data engineering role
  • 6 years or more of experience in at least one of the following:
    • Microsoft SQL Server
    • Microsoft Azure SQL
  • 6 years or more of experience:
    • Writing stored procedures, queries, functions, and triggers in T-SQL
    • Monitoring, troubleshooting and performance tuning database operations
    • Delivering database code via CI/CD
    • Troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention issues, resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues, etc.
  • 5 or more years of experience in the full software development lifecycle
  • 3 or more years of experience working with cloud technologies (plus for Microsoft Azure)
  • 2 or more years of experience working with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience in at least one Agile software development methodology (e.g. Scrum, Kanban)
  • Strong collaboration and communication skills
  • Ability to engage throughout the department and the company to achieve goals
  • Bachelor’s Degree in a relevant major or equivalent years of experience
  • Any of the following would be a plus:
    • Dental industry knowledge
    • Experience in B2B product development
    • Experience in designing multi-tenant SaaS database schema
    • Experience in infrastructure layout, provisioning, Azure cloud infrastructure with reference to provisioning, security, and management
    • Experience in SQL Managed Instance and Azure Synapse or Data Factory

About You

  • You respect and share our values
  • You love working with teams of smart and driven people who are excited to solve challenging problems
  • You believe that code-reviews, giving them and asking for them, are important to delivering quality a product
  • You love to cover your code with adequate unit, integration, and performance tests
  • You take data driven decisions and deliver
  • You are adamant about instrumenting and measuring the performance of code to find bottlenecks and improve performance
  • You exhibit dogged determination to get to the root of problems
  • You care about best-practices and evangelizing them with the team
  • You care about mentoring juniors team members
  • You care about automating routine operations.
  • You can clearly convey your thoughts, enjoy presenting what you’ve done, and can cater your message to audiences both technical and non-technical

Behavior and Scope

  • You raise issues early when you see obstacles to achieving a goal and work to find solutions.
  • You volunteer to get involved in the solution even if it is beyond your own team or role.
  • You evangelize good practices both on and off of your team.
  • You actively help solve cross-team issues by assisting other teams
  • You speak up on more broad issues in the domain beyond your own work, such as processes, company issues or large projects.
  • You guide the team in designing major components of systems and products.
  • You lead the design and development of large and critical areas of the product.
  • You’re able to reason about the purpose of each component in a system and how they interact with each other to support the product.
  • You often lead and guide other team members.
  • You actively mentor others and seek accountability
  • You take responsibility for your actions and recognize your own mistakes.
  • You effectively incorporate feedback from other members of the team.
  • You rely on input and direction daily or multiple times per day from more experienced team members to achieve success.


PLANET DDS CORE IDEOLOGY

Why we exist

  • To radically improve the practice of dentistry through innovative technology

Our vision

  • To be the obvious choice for dental practices that are shifting to the cloud

Our values

  • We encourage autonomy but we understand the need to hold people accountable for results
  • We recognize the importance of communication—with each other and with the outside world
  • We deliver what we promise; we are open and honest with our customers
  • We value innovation and flexibility
  • We create things we can believe in that help solve our customers’ problems; we care about their success

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Please read this post in its entirety so we do not waste each other's time. This is NOT for a DBA. At present we cannot sponsor any candidates for this position. You must be in CST or EST time zones and work EST hours in the USA.We are in search of one.

Aries Solutions Aries Solutions |
7 d ago

SQL DBA -100% RemoteThis position is responsible for the implementation and enhancement of vendor software and/or hardware package applications, providing overall business function knowledge to projects and support, incorporating a scaled agile framework..

Planet DDS Planet DDS |
11 d ago

Planet DDS is the leading provider of cloud-enabled dental software solutions serving over 10,000 practices in North America with over 60,000 users. The company delivers a complete platform of solutions for dental practices including Denticon Practice.

1.This job opportunity is for employment type W2 .2. Candidates who are willing to apply must hold US work authorization.SQL Server DBA with Oracle DBA expLocation: RemoteDuration: Long term10+ years of DBA experience with atleast 3 years working with.

TekSynap TekSynap |
Yesterday

Overview:We are seeking a Program Manager to join our team supporting the Defense Logistics Agency on a telework basis. This Task Order includes operations, and sustainment support for applications within the Recruit Training Center (RTC) Supply Chain.

More jobs by this company

Planet DDS is the leading provider of cloud-enabled dental software solutions serving over 10,000 practices in North America with over 60,000 users. The company delivers a complete platform of solutions for dental practices including Denticon Practice.

legwork legwork |
11 d ago

Planet DDS is the leading provider of cloud-enabled dental software solutions serving over 10,000 practices in North America with over 60,000 users. The company delivers a complete platform of solutions for dental practices including Denticon Practice.

Planet DDS is the leading provider of cloud-enabled dental software solutions serving over 10,000 practices in North America with over 60,000 users. The company delivers a complete platform of solutions for dental practices including Denticon Practice.

Planet DDS is the leading provider of cloud-enabled dental software solutions serving over 10,000 practices in North America with over 60,000 users. The company delivers a complete platform of solutions for dental practices including Denticon Practice.