Senior Database AdministratorHenry Schein One • Auckland, Auckland, NZ

Senior Database Administrator

Henry Schein One • Auckland, Auckland, NZ

30+ days ago

Job type

Quick Apply

Job description

We are a leading provider of dental technology solutions, and we are committed to developing innovative products and services that help dental professionals deliver the best possible care to their patients.

If you are passionate about dental technology and want to be part of a team that is making a difference, then Henry Schein One is the place for you. We offer a variety of career opportunities, from software development to customer support. We are always looking for talented and motivated individuals to join our team.

Together, we can change the future of dental care.

Here are some of the ways we are changing the future of dental technology :

We are developing cloud-based practice management software that makes it easier for dental professionals to manage their practices.
We are developing artificial intelligence-powered tools that help dentists diagnose and treat dental conditions more accurately.
We are developing teledentistry solutions that make it possible for dentists to provide care to patients in remote areas.
We are developing virtual reality and augmented reality tools that help dentists train and educate their patients.

We are just getting started. We are committed to changing the future of dental care, and we need your help. Join us and be part of the team that is making a difference.

Who we are

Henry Schein One provides advanced, market-leading software solutions that help dental teams manage their practice effectively so that they can focus on delivering the best possible care to their patients.

What you’ll be doing

Server and Cluster Operations

Manage RDS parameter groups, option groups, and cluster settings.

Monitor system metrics (CPU, memory, disk, network, IOPS, replication lag).

Configure and validate backups, snapshots, PITR, and cross-region disaster recovery.

Oversee patching and minor version upgrades, including rollback plans.

Maintain replication slots, subscriptions, and logical / physical replication health.

Control instance class sizing and Aurora Serverless v2 scaling policies.

Query Performance and Optimization

Collect and analyze pg_stat_statements and Performance Insights.

Monitor query latency, CPU waits, lock contention, and replication slot usage.

Identify slow queries, missing indexes, and inefficient joins.

Tune parameters (work_mem, shared_buffers, effective_cache_size, autovacuum settings).

Recommend and apply indexing strategies (B-tree, GIN, BRIN).

Validate query plans using EXPLAIN / EXPLAIN ANALYZE.

Maintenance

Schedule and monitor autovacuum and analyze processes.

Rebuild or reindex bloated indexes.

Detect table / index bloat with pgstattuple or pg_class stats.

Update statistics proactively to prevent plan regressions.

Clean up orphaned replication slots, temp tables, and unused schemas.

Application and Proxying Layers

Operate RDS Proxy or Heimdall / RDS Proxy alternatives for connection pooling.

Validate application prepared statements usage and prevent plan cache flooding.

Manage query routing for read replicas (Aurora reader endpoints).

Monitor transaction pool health and idle connection behavior.

Performance Tuning

Optimize schema design for multi-tenant workloads (partitioning, indexing, foreign keys).

Minimize impact of bulk loads (disable triggers / constraints, drop / rebuild indexes).

Monitor Aurora storage I / O metrics (DataFileRead, commit latency).

Benchmark workload changes before and after application releases.

Observability

Integrate CloudWatch metrics, alarms, and enhanced monitoring.

Use Performance Insights and pg_stat_activity for active monitoring.

Track query execution trends and resource consumption.

What you’ll be working on

Our industry leading cloud practice management system, Dentrix Ascend - https : / / www.dentrixascend.com /

Migration to our modern technology stack

Your technical skills

5+ years hands-on experience in PostgreSQL performance tuning and query plan analysis

5+ years hands-on experience in RDS / Aurora administration and scaling in AWS.

Index and statistics management (vacuum, analyze, reindex, parameter group settings, etc.)

Connection pooling, proxying queries, and result caching (e.g. Heimdall, RDS Proxy)

Backup, recovery, and replication (CDC) strategies in managed environments

SQL development, optimization, and schema design for high-volume workloads

Experience with both OLTP and OLAP architectures

Hands-on experience with observability and monitoring tools :

PostgreSQL : pg_stat_statements, pg_stat_activity, EXPLAIN ANALYZE

AWS CloudWatch for Aurora PostgreSQL monitoring

Application Performance Monitoring (APM) tools like Dynatrace, Splunk, SolarWinds Database Performance Analyzer (DPA)

Experience with rigorous change control process

Your personal attributes

You take ownership and get things done, driving projects with a bias for action and a commitment to delivering value incrementally.

You learn rapidly from setbacks and adapt your approach to continuously improve.

You transform ambiguous problems and abstract ideas — not rigid specifications — into delightful, high-quality, and remarkably simple solutions. You are driven by true craftsmanship, creativity, and a relentless pursuit of excellence in everything you build.

You possess a genuine passion for continuous learning and self-improvement. You actively seek and value diverse perspectives, recognizing the limitations of your own viewpoint.

You champion a "One Team" philosophy, effective in working with multiple teams towards shared goals. You believe in transparent collaboration, actively engaging with the team through huddles, interactive reviews, and whiteboarding.

You have strong opinions, loosely held — you thrive in technical discussions, confidently propose and debate ideas, and drive well-reasoned solutions to help the team achieve the best outcomes. You're not one to just go with the flow; you help drive us forward.

You are self-motivated, consistently seeking opportunities to contribute more, and take on greater responsibilities to propel the team forward.

You demonstrate strong interpersonal awareness, understanding team dynamics and the impact of your interactions.

Create a job alert for this search

Administrator • Auckland, Auckland, NZ

Related jobs

Senior Architect - Data Engineering

Slalom Build • Auckland, Auckland, New Zealand

Senior Architect, Data Engineering.As a Senior Architect in Data Engineering (DE), you will be focusing on deep Engineering and building out the Platform to support data lifecycles and processes.Th...Show more

Last updated: 30+ days ago • Promoted

Senior Data Engineer

SkyCity Entertainment Group • Auckland, Auckland, New Zealand

SkyCity is one of Australasia's most popular casino and hospitality destinations who welcome and delight millions of customers each year. Our ICT Department is constantly looking at new and innovati...Show more

Last updated: 30+ days ago • Promoted

Delivery Solutions Architect

Databricks • WorkFromHome, Auckland, New Zealand

CSQ327R17 At Databricks, we are on a mission to empower our customers to solve the world’s toughest data problems through the Databricks Data Intelligence Platform. As a Delivery Solutions Architect...Show more

Last updated: 12 days ago • Promoted

Senior Data Engineer

Fulcrum Decision Limited • WorkFromHome, Auckland, New Zealand

Data Engineers, ETL Developers and Data Consultants.Data Engineering practice in Auckland as we grow in 2025.Fulcrum Decision has been providing. Business Intelligence, Data Warehouse and Data Integ...Show more

Last updated: 30+ days ago • Promoted

Senior Data Engineer

Randstad • Auckland, Auckland, New Zealand

Senior Data Engineer – Contract Role (Auckland-Based).Auckland | Contract | Immediate Start | Hybrid Working.Are you an experienced Senior Data Engineer looking to create meaningful impact through ...Show more

Last updated: 30+ days ago • Promoted

Solutions Architect - IBM Software

Ingram Micro • WorkFromHome, Auckland, New Zealand

Solutions Architect - IBM Software page is loaded## Solutions Architect - IBM Softwareremote type : Hybridlocations : Auckland, New Zealandtime type : Full timeposted on : Posted Todayjob requi...Show more

Last updated: 30+ days ago • Promoted

Database Administrator

Eden Tech Trading Limited • Auckland, Auckland, New Zealand

Eden Tech Trading Limited is a New Zealand–based technology company specialising in point-of-sale (POS) solutions and digital business management systems for the hospitality and retail industries.O...Show more

Last updated: 6 days ago • Promoted

Senior Data Reliability Engineer, Cloud‑Native DB Leader

Roman Health Pharmacy LLC • Auckland, Auckland, New Zealand

A leading healthcare company in Auckland is seeking a Senior Engineer to ensure the stability and quality of databases.The role includes advising product teams on database design and architecture w...Show more

Last updated: 1 day ago • Promoted

Senior Database Administrator

Henry Schein One UK • Auckland, Auckland, New Zealand

Last updated: 28 days ago • Promoted

Database Administrator

Neuwell International Holdings Limited • Auckland City, Auckland, New Zealand

Neuwell International Holdings Ltd operates.New Zealand–based financial services company that provides affordable personal loans tailored for Pacific Island workers and communities.The company’s mi...Show more

Last updated: 17 days ago • Promoted

Delivery Solutions Architect

Databricks Inc. • WorkFromHome, Auckland, New Zealand

At Databricks, we are on a mission to empower our customers to solve the world's toughest data problems by utilizing the the Databricks Data Intelligence Platform. As a Delivery Solutions Architect ...Show more

Last updated: 13 days ago • Promoted

Database Administrator

EDEN TECH TRADING LIMITED • Auckland, Auckland, New Zealand

Last updated: 8 days ago • Promoted

Senior Database Administrator

Henry Schein One Uk • Auckland, Auckland, New Zealand

Last updated: 27 days ago • Promoted

Senior Software Engineer, Data Platform

SmarterDx • WorkFromHome, Auckland, New Zealand

We are looking for a data and backend-oriented Senior Software Engineer to help us advance our clinical AI by designing and building core systems that handle, process, and analyze clinical data at ...Show more

Last updated: 30+ days ago • Promoted

Senior Software Engineer

Leonardo.Ai • WorkFromHome, Auckland, New Zealand

Join the revolution at Leonardo.Ai, we’re on a mission to unleash the world’s creativity through cutting‑edge generative AI. We're an Australian startup building tools that reimagine how people desi...Show more

Last updated: 30+ days ago • Promoted

Senior Data Engineer

Fulcrum Decision • WorkFromHome, Auckland, New Zealand

Last updated: 30+ days ago • Promoted

Senior Database Administrator

Henry Schein One Asia Pacific • Auckland, Auckland, New Zealand

Last updated: 30+ days ago • Promoted

Solution Architect

Digitalgarage • WorkFromHome, Auckland, New Zealand

Seeking a hands‑on Solution Architect to modernise banking & payments systems.Long-term transformation programme, with a major uplift over the next 12–18 months. Initial 6‑month contract with multip...Show more

Last updated: 11 days ago • Promoted