You will get a SQL Server Health Check & Replication Audit + action plan


Project details
Is your SQL Server slow, fragile, or one failure away from a crisis? I'll find out before it breaks.
With 15+ years managing business-critical SQL Server environments in production — including transactional replication between on-premises and Azure running 24/7 — I'll review your server and deliver a clear, prioritized report: what's healthy, what's risky, and exactly what to fix first.
What I review: configuration and best practices (memory, tempdb, maintenance), backup strategy and recovery readiness, SQL Agent jobs and failures, index health and slow queries (Standard+), replication health (Standard+), and security basics.
You get a written report in plain language: findings ranked by risk, each with a concrete recommended action. No jargon walls, no scare tactics — just what a 15-year production DBA would tell a colleague. Check the attached sample report to see exactly what you'll receive.
The review is read-only: I never make changes without your approval. Production never breaks on my watch.
With 15+ years managing business-critical SQL Server environments in production — including transactional replication between on-premises and Azure running 24/7 — I'll review your server and deliver a clear, prioritized report: what's healthy, what's risky, and exactly what to fix first.
What I review: configuration and best practices (memory, tempdb, maintenance), backup strategy and recovery readiness, SQL Agent jobs and failures, index health and slow queries (Standard+), replication health (Standard+), and security basics.
You get a written report in plain language: findings ranked by risk, each with a concrete recommended action. No jargon walls, no scare tactics — just what a 15-year production DBA would tell a colleague. Check the attached sample report to see exactly what you'll receive.
The review is read-only: I never make changes without your approval. Production never breaks on my watch.
Database Type
MS SQLWhat's included
| Service Tiers |
Starter
$150
|
Standard
$300
|
Advanced
$500
|
|---|---|---|---|
| Delivery Time | 3 days | 5 days | 7 days |
Number of Revisions | 1 | 1 | 2 |
Query Debugging | - | - | - |
Query Optimization | - | - | |
Query Scheduling | - | - | - |
Query Analysis | - | ||
Source Code | - | - | - |
Frequently asked questions
About Oscar Alejandro
Legacy Modernization Specialist | .NET 8, Angular, React, SQL Server
Salta, Argentina - 12:48 am local time
For more than 15 years, I have worked across the complete software lifecycle: understanding inherited code, stabilizing production systems, designing modern replacements, deploying controlled releases, and supporting what runs in production.
I can help you with:
• Assessing and stabilizing .NET Framework, Web Forms, Visual FoxPro, and Visual Basic 6 (VB6) applications
• Planning and executing incremental migrations to .NET 8, REST APIs, Angular, React, and Next.js
• Designing maintainable solutions with Clean Architecture, Entity Framework Core, Dapper, and secure integrations
• Diagnosing SQL Server performance, replication, availability, and data integrity issues
• Building CI/CD pipelines and managing controlled deployments with Azure DevOps
• Working with GitFlow, code reviews, release branches, rollback plans, monitoring, and production support
My background includes leading a five-developer IT team in an agro-industrial organization with more than 700 employees, as well as developing and maintaining billing and integration platforms for the insurance sector.
My main strength is connecting both worlds. I can recover the knowledge hidden inside a legacy system, identify what must be preserved, and move it toward a modern architecture through small, testable, and reversible stages. I do not treat production as a laboratory: every release is planned around continuity, data integrity, observability, and recovery.
I provide clear written updates, structured technical documentation, and scheduled meetings. I adapt to the client's workflow while keeping changes traceable through source control, review, testing, and documented decisions.
If you need to stabilize a critical system, understand an inherited codebase, or plan a safe modernization, we can begin with a paid technical assessment and a prioritized action plan.
Steps for completing your project
After purchasing the project, send requirements so Oscar Alejandro can start the project.
Delivery time starts when Oscar Alejandro receives requirements from you.
Oscar Alejandro works on your project following the steps below.
Revisions may occur after the delivery date.
Kickoff & scope
You share environment details and your main concern; I confirm scope within 24 hours
Diagnostics collection
Read-only access or you run the scripts I send and share the output.