I will sql server performance tuning, query optimization ,indexing by certified dba

Pakistan

I speak Urdu, English

Certified SQL Server DBA Developer TSQL Always On SSIS Azure Fabric

Microsoft Certified SQL Server DBA and Database Developer with 9+ years running high-load production databases. I fix slow queries, write complex T-SQL and stored procedures, set up and repair Always...
About this Gig

Microsoft Certified Azure DBA with 9+ years tuning busy SQL Server databases. 

Slow reports? CPU at 100%?


I tune high-load production databases every day. I find the real cause and 

fix it - not guesswork.


WHAT I DO


- Find your slowest and most expensive queries

- Read execution plans and remove bottlenecks

- Create, fix and remove indexes (missing, duplicate, unused)

- Rewrite slow queries and stored procedures

- Fix parameter sniffing, blocking and deadlocks

- Tune server settings: MAXDOP, cost threshold, memory, TempDB


WHAT YOU GET


- Before/after timings for every query I tune- Ready-to-run scripts with rollback- A short report in plain English


WHY ME


- 9+ years on large production systems- Microsoft Certified: Azure Database Administrator- Safe changes: tested first, nothing risky on live servers


Supported: SQL Server 2012-2022, Azure SQL.


Not sure which package fits? Message me before ordering - free quick review.

Database type:

Centralized database

•

Distributed database

Platform:

MS SQL

•

Oracle

•

PostgreSQL

•

SQL Server

Expertise:

Data warehouse

•

NoSQL

•

Performance

•

Query optimization