Senior Database Administrator
Henry Schein One Asia PacificAuckland, Auckland, New Zealand7 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.
Position
Senior Database Administrator
Henry Schein One Asia Pacific
About the Company
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
Mid‑Senior level
Employment Type
Full‑time
Job Function
Information Technology
Referrals increase your chances of interviewing at Henry Schein One Asia Pacific by 2x
Get notified about new Senior Database Administrator jobs in Auckland, Auckland, New Zealand .
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Create a job alert for this search
Senior 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 moreLast updated: 14 days ago
Datacom works with organisations and communities across Australia and New Zealand to make a difference in people’s lives and help organisations use the power of tech to innovate and grow.Senior Clo...Show moreLast updated: 28 days ago
Senior Database Administrator
Henry Schein OneAuckland, Auckland, NZQuick Apply
- Promoted
Senior Business Analyst - Workday Implementation
TalentAuckland, Auckland, New Zealand Senior Business Analyst - Workday ImplementationJoin to apply for the Senior Business Analyst - Workday Implementation role at TalentSenior Business Analyst - Workday Implementation3 days ago Be am...Show moreLast updated: 30+ days ago
- Promoted
- New!
Contracts Database Administrator
Westpac New Zealand LimitedWorkFromHome, Auckland, New Zealand This opportunity would ideally suit a student with a basic understanding of contracts, perhaps someone studying law or a related field, but we welcome anyone with an interest in admin, contracts, o...Show moreLast updated: 13 hours 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: 17 days ago
- Promoted
Real Estate Office Administrator
REAP RecruitmentNorth Shore City, Auckland, New Zealand Ray White Mairangi Bay are currently seeking an experienced Real Estate Office Administrator with a can-do attitude to join their team.
Ray White is the fastest-growing real estate brand on the Nort...Show moreLast updated: 22 days ago
- Promoted
Senior Data Engineer
RandstadAuckland, 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 moreLast updated: 30+ days ago
- Promoted
Principal Engineer, Data Reliability
XeroAuckland, Auckland, New Zealand Join to apply for the Principal Engineer, Data Reliability role at Xero.At Xero, we're here to help supercharge small businesses by automating routine tasks, surfacing actionable insights and conne...Show moreLast updated: 30+ days ago
- Promoted
Senior Systems Owner
New Zealand GovernmentAuckland, Auckland, New Zealand Discover a career with purpose at MBIE.Looking for your next opportunity? This role comes with plenty of challenge and potential for growth, whilst playing a key role in supporting the success of a...Show moreLast updated: 4 days ago
Senior Cloud Platform Specialist
DatacomAuckland, Auckland, NZQuick Apply
- Promoted
Azure Architect
Comspek InternationalAuckland, Auckland, New Zealand Our client is seeking an Azure Architect with strong DevOps and engineering experience who can work directly with clients.
Location : Auckland / Wellington OR Christchurch.Lead discovery and design s...Show moreLast updated: 15 days ago
- Promoted
- New!
Cloud Infrastructure Architect
Fisher & Paykel Appliances LtdWorkFromHome, Auckland, New Zealand The Role • •Fisher & Paykel is an iconic New Zealand brand, a global company with a strong local heritage.Our origins inspire our culture of curiosity and passion to develop solutions designed around...Show moreLast updated: 13 hours ago
- Promoted
Senior Cloud Systems Administrator
BecaAuckland, Auckland, New Zealand Senior Cloud Systems Administrator – Beca.Join Beca’s Enterprise teams during a critical growth and implementation phase as we replace and update the systems that form the backbone of our enterpris...Show moreLast updated: 30+ 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: 14 days ago
- Promoted
Senior Data Analyst
KamiAuckland, Auckland, New Zealand Kami is a thriving organisation filled to the brim with talented, creative, and passionate people! It’s hard not to love what you do when our leading digital classroom platform offers meaningful so...Show moreLast updated: 27 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: 27 days ago
- Promoted
Snowflake Data Architect
Accenture New ZealandAuckland, Auckland, New Zealand Accenture is a leading global professional services company committed to inclusion, diversity, and supporting the whole person.
Our core values include Stewardship, Best People, Client Value Creatio...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Engineer
DigitalgarageAuckland, Auckland, New Zealand This is a fantastic Senior Data Engineer contracting opportunity, migrating on-prem to Azure Cloud and implementing Fabric.
You'll be stepping into a massive cloud migration project, helping to move...Show moreLast updated: 30+ days ago
- Promoted
Billing Administrator
Hunter CampbellAuckland, Auckland, New Zealand This NZ owned Tech company has developed sophisticated hardware and software to enable more sustainable and cost-efficient farm management.
The Opportunity : High growth Tech business and a New Zealan...Show moreLast updated: 30+ days ago