Senior Database Administrator
Henry Schein OneAuckland, Auckland, NZ3 days ago
Job type
- Quick Apply
Job descriptionManage 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. 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. 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. 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. 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. Integrate CloudWatch metrics, alarms, and enhanced monitoring. Use Performance Insights and pg_stat_activity for active monitoring. Track query execution trends and resource consumption. Our industry leading cloud practice management system, Dentrix Ascend - https : / / www.dentrixascend.com / Migration to our modern technology stack 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 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 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.
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
Query Performance and Optimization
Maintenance
Application and Proxying Layers
Performance Tuning
Observability
What you’ll be working on
Your technical skills
Hands-on experience with observability and monitoring tools :
Your personal attributes
Create a job alert for this search
Senior Administrator • Auckland, Auckland, NZ
Related jobs
- Promoted
Database Analyst
Arcadia Kitchen Group LimitedAuckland, Auckland, New Zealand Arcadia Joinery Limited is a New Zealand–owned company specialising in designing, building, and installing premium kitchens, vanities, and interior outfits.
Our products are 100% locally made, using...Show moreLast updated: 30+ days ago
- Promoted
Senior Solution Architect
ANZ Talent HubWorkFromHome, Auckland, New Zealand Lead end-to-end solution architecture and design for complex billing and revenue management systems.Translate business objectives into scalable, secure, and cost-efficient technical solutions align...Show moreLast updated: 4 days ago
- Promoted
Senior Software Engineer
FederatoWorkFromHome, Auckland, New Zealand Federato is on a mission to defend the right to efficient, equitable insurance for all.We enable insurers to provide affordable coverage to people and organizations facing the issues of today - the...Show moreLast updated: 23 days ago
- Promoted
Database Administrator
UnicomsecurityAuckland, Auckland, New Zealand We've established Unicom Solar Security CCTV with a singular vision – to empower clients whether individuals or businesses with innovative, sustainable, easy to access and reliable security solutio...Show moreLast updated: 14 days ago
- Promoted
Administrator - Reo
HyndsAuckland - other, Auckland, New Zealand Our Pokeno Reinforcement team is seeking an experienced Administrator to actively provide administrative support to the National Project Manager and wider team.
This is a fast paced and role that ...Show moreLast updated: 5 days ago
- Promoted
Senior Administrator
Rocket LabAuckland, Auckland, New Zealand Rocket Lab is a global leader in launch and space systems.The rockets and satellites we build and launch enable some of the most ambitious and vital space missions globally, supporting scientific e...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Engineer
Robert Walters New ZealandAuckland, Auckland, New Zealand Work with cutting-edge Microsoft technologies, including Azure Databricks, Azure Data Factory, and Azure SQL in a collaborative environment that values continuous learning.You'll design and build r...Show moreLast updated: 30+ days ago
- Promoted
Solutions Architect - IBM Software
Ingram MicroWorkFromHome, 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 moreLast updated: 27 days ago
- Promoted
Senior Database Administrator
Henry Schein One groupUpper Harbour, Auckland, New Zealand 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 p...Show moreLast updated: 2 days ago
- Promoted
Senior Cloud Systems Administrator
Beca GroupAuckland, Auckland, New Zealand Te whiwhinga mahi | The opportunity • • It is an exciting time of growth and implementation for Beca’s Enterprise teams as we replace and update the systems that form the backbone of our enterprise-...Show moreLast updated: 3 days ago
- Promoted
Senior Database Administrator
Henry Schein One GroupAuckland, New Zealand 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 p...Show moreLast updated: 1 day ago
- Promoted
Senior Cloud Systems Administrator
BecaAuckland, Auckland, New Zealand Senior Cloud Systems AdministratorIt is an exciting time of growth and implementation for Beca's Enterprise teams as we replace and update the systems that form the backbone of our enterprise-wide ...Show moreLast updated: 30+ days ago
- Promoted
Architect (Data)
ASB BankAuckland, Auckland, New Zealand At ASB, we're all about doing what we can to help our customers get "One Step Ahead" by giving them the tools they need to manage their lives and plans for their families and future.Our products do...Show moreLast updated: 7 days ago
- Promoted
Senior Administrator
Space TalentAuckland, Auckland, New Zealand Rocket Lab is a global leader in launch and space systems.The rockets and satellites we build and launch enable some of the most ambitious and vital space missions globally, supporting scientific e...Show moreLast updated: 30+ days ago
- Promoted
Senior Software Engineer
CIN7 Ltd.WorkFromHome, Auckland, New Zealand NZ Hi-Tech Company of the Year 2023, Cin7 is a fast-growing global software company that provides solutions for modern-day product sellers.
We help these sellers keep track of their inventory at sca...Show moreLast updated: 30+ days ago
- Promoted
Senior Consultant
InfosysAuckland, Auckland, New Zealand Role Name : Database Administrator (Oracle).Infosys is a global leader in next-generation digital services and consulting.
We enable clients in more than 50 countries to navigate their digital trans...Show moreLast updated: 30+ days ago
- Promoted
Senior Software Engineer, Data Platform
SmarterDxWorkFromHome, 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 moreLast updated: 23 days ago
- Promoted
Senior Software Engineer
Cin7WorkFromHome, Auckland, New Zealand NZ Hi-Tech Company of the Year 2023, Cin7 is a fast-growing global software company that provides solutions for modern-day product sellers.
We help these sellers keep track of their inventory at sca...Show moreLast updated: 30+ days ago