🏠 Home 👤 About 💎 Why Choose Dipak 🤝 For Partners 🧠 Expertise 📊 Case Studies 📚 Knowledge Hub 🏆 Credentials
✉️ Get in touch
SQL Server · Azure SQL · Always On · Migrations

SQL Server Consultant
Auckland & NZ

Senior Microsoft SQL Server consulting for production environments that need deep troubleshooting, Always On HA/DR review, performance and index tuning, version upgrades, or migration to Azure SQL and AWS RDS for SQL Server.

Available immediately for contract & partner subcontracting · Auckland / Remote ANZ

NZ-based senior specialistAuckland presence, ANZ remote delivery.
Oracle + PostgreSQL depthOCM background with AWS database focus.
Production-first deliveryAssessment, change control, rollback and runbooks.
Partner friendlyContracting, subcontracting and advisory support.

When to call me

Production issue

SQL Server is affecting operations

Performance regressions, blocking/deadlocks, Always On availability issues, replication gaps or slow incident recovery need experienced SQL Server judgement.

  • Root-cause review
  • Safe remediation
  • RCA handover
Modernisation

SQL Server needs to move or change

Version upgrade, consolidation, or migration to Azure SQL / AWS RDS for SQL Server requires realistic complexity assessment before timelines are promised.

  • Upgrade/migration assessment
  • Dependency review
  • Cutover planning
HA/DR

Resilience needs proof

Backups, restore testing, Always On failover, monitoring and runbooks need to be validated, not assumed.

  • DR review
  • Restore validation
  • Operational readiness

SQL Server areas I cover

Core DBA

Always On, HA/DR and performance

SQL Server 2012 to 2022 background, Always On Availability Groups, failover clustering, query/index tuning, deadlock and workload diagnosis and availability patterns.

  • Always On
  • SQL tuning
  • Operational support
Azure cloud

Azure SQL hands-on delivery

Real Azure SQL experience from enterprise consulting: Azure SQL Database and Managed Instance, migration assessment, performance and cost tuning, and HA/DR design on Azure for SQL Server workloads.

  • Azure SQL DB / MI
  • Migration & assessment
  • Cloud HA/DR
Enterprise platforms

Replication and integration services

Experience across transactional/merge replication, log shipping, SSIS data flows, high-availability platforms and regulated production environments.

  • Replication context
  • Replication posture
  • Change control
Migration bridge

SQL Server source to modern target

Assess T-SQL, schema, SQL Agent jobs, data volume, integrations and performance-critical queries before choosing Azure SQL, AWS RDS for SQL Server, PostgreSQL or another pathway.

  • Source complexity
  • Target fit
  • Azure SQL / RDS
  • Risk register

Typical deliverables

Operational outputs

  • Health and risk review
  • Performance findings
  • Backup/restore or DR recommendations
  • Incident RCA and remediation plan

Migration/upgrade outputs

  • Source complexity assessment
  • Upgrade or migration roadmap
  • Cutover and rollback plan
  • Validation checklist

Handover

  • Runbooks and support notes
  • Stakeholder summary
  • Knowledge transfer
  • Next-step options

Best-fit engagement

Suitable for urgent SQL Server triage, fixed-scope health checks, HA/DR reviews, upgrade planning and migration-readiness work.

Where SQL Server depth still matters

High-value legacy systems

Many SQL Server estates still carry core business logic, reporting dependencies and availability requirements that need senior care even during modernisation.

Migration source truth

A safe migration starts by understanding the Oracle source properly: performance-critical SQL, packages, jobs, replication, backup and recovery behaviour.

Resilience and recovery

Always On, failover clustering, backups, restore testing and operational procedures should be reviewed as real recovery mechanisms, not just architecture labels.

Developer Toolkit
Ctrl + T to open anytime
🐘
SQL Formatter
Beautify & indent SQL queries
📋
JSON Formatter
Pretty-print & validate JSON
🔐
Base64 Encode/Decode
Encode or decode Base64
⏱️
Timestamp Converter
Unix ↔ Human-readable dates
Cron Translator
Explain cron expressions
🔍
Regex Tester
Test patterns live
🆔
UUID Generator
Generate v4 UUIDs instantly
🔒
Hash Generator
SHA-256, MD5, SHA-1
📝
Text Diff
Compare two text blocks
🔗
URL Encode/Decode
Encode or decode URLs
🎨
Color Converter
HEX ↔ RGB ↔ HSL
🛡️
Password Generator
Secure random passwords
Services & fast links
Contract / SubcontractFast partner-ready delivery ☁️AWS DatabaseRDS, Aurora, DMS, production ops RDS & AuroraManaged PostgreSQL architecture 🔄Oracle → PostgreSQLSCT, DMS, cutover, rollback 📦Database MigrationAssessment, migration, validation 🐘PostgreSQL TuningSlow SQL, vacuum, bloat, locks 🔶Oracle DBARAC, Data Guard, Exadata, GoldenGate🟦SQL ServerAlways On, tuning, HA/DR, Azure SQL / AWS RDS 🏗️Cloud ArchitectureHA/DR, platform design, governance 🤖AI-SDLCAI-assisted engineering workflows 📊Case StudiesProof, outcomes and delivery examples 📚Knowledge HubGuides, notes and resources 🤝Partner SupportSubcontracting and bid support
Request help / availability →