Senior Database AdministratorHenry Schein One UK • Auckland, Auckland, New Zealand
Senior Database Administrator
Henry Schein One UK • Auckland, Auckland, New Zealand
30+ days ago
Job descriptionMonitor 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 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 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 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 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 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 – 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 Hands‑on experience with observability and monitoring tools : 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. Mid‑Senior level Full‑time Information Technology Software Development
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.
Collect and analyze pg_stat_statements and Performance Insights.
Schedule and monitor autovacuum and analyze processes.
Operate RDS Proxy or Heimdall / RDS Proxy alternatives for connection pooling.
Optimize schema design for multi‑tenant workloads (partitioning, indexing, foreign keys).
Integrate CloudWatch metrics, alarms, and enhanced monitoring.
What You’ll Be Working On
Your Technical Skills
PostgreSQL : pg_stat_statements, pg_stat_activity, EXPLAIN ANALYZE
Your personal attributes
Seniority Level
Employment Type
Job function
#J-18808-Ljbffr
Create a job alert for this search
Administrator • Auckland, Auckland, New Zealand
Related jobs
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 ...Show more
Senior Database Administrator
Henry Schein One • Auckland, Auckland, NZ
Quick Apply
Last updated: 30+ days ago
Delivery Solutions Architect
Menlo Ventures • 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 Databricks Data Intelligence Platform.
As a Delivery Solutions Architect (DSA...Show more
Last updated: 6 days ago • Promoted
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
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: 13 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 Digital Infrastructure BA : Lead Data-Driven Projects
Auckland Airport • Auckland, Auckland, New Zealand
A leading international airport in Auckland is seeking a Technical Business Analyst to work on digital initiatives in construction projects.
The ideal candidate will have over 5 years of experience ...Show more
Last updated: 7 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: 7 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: 3 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: 19 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: 14 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: 9 days ago • Promoted
Senior Database Administrator
Henry Schein One Uk • Auckland, 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 more
Last updated: 29 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 Data Engineer
Fulcrum Decision • 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 Database Administrator
Henry Schein One Asia Pacific • Auckland, 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 more
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: 12 days ago • Promoted
Senior IBM Storage Platform Lead | Hybrid / Remote
Datacom • WorkFromHome, Auckland, New Zealand
A leading IT services provider in New Zealand is seeking a Senior Cloud Platform Specialist to lead IBM storage operations for key clients.
The role requires 5-10 years of experience in managing IBM...Show more
Last updated: 4 days ago • Promoted