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
When to call me
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
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
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
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 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
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
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.