01
TRCD-26-04206
Senior SQL Server DBA (Performance Tuning / Performance Engineering)
Senior, hands-on SQL Server DBA focused on performance engineering for a reporting environment (slow reports/queries). The role leads technical discovery, performance assessment, evidence-based root-cause analysis, and technical reporting, then implements approved database/SQL Server–level optimizations in Test and Production with rollback plans and measurable before/after validation. Emphasis is on execution plans, Query Store/DMVs, wait stats, CPU/I/O analysis, indexing strategy, statistics/parameter sniffing, and tuning complex T-SQL/stored procedures; not routine ops-only DBA work and not application code changes.
Position summary
- Location
- India
- Workplace
- On-site
- Employment
- Contract
- Experience
- Minimum 10 years and Maximum 12 years
Role overview
Why This Role Matters.
Senior, hands-on SQL Server DBA focused on performance engineering for a reporting environment (slow reports/queries). The role leads technical discovery, performance assessment, evidence-based root-cause analysis, and technical reporting, then implements approved database/SQL Server–level optimizations in Test and Production with rollback plans and measurable before/after validation. Emphasis is on execution plans, Query Store/DMVs, wait stats, CPU/I/O analysis, indexing strategy, statistics/parameter sniffing, and tuning complex T-SQL/stored procedures; not routine ops-only DBA work and not application code changes.
Your Impact
Deliver Enterprise Value
Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.
Collaboration
Work Across Teams
Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.
Growth
Learn Continuously
Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.
Career Path
Grow With Ubique
Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.
Responsibilities
What You'll Be Doing.
Every role at Ubique contributes directly to solving meaningful business challenges for our clients.
02
Understand the BHSDB and LTDS architecture, data lifecycle and reporting data-retrieval flow.
03
Analyze slow reports, associated SQL queries, stored procedures, tables and database objects.
04
Perform SQL Server performance analysis covering CPU, I/O, waits, blocking, deadlocks, memory and other relevant indicators.
05
Analyze actual/estimated execution plans and identify inefficient operators, scans, joins, sorting, aggregation and excessive data retrieval.
06
Optimize complex T-SQL queries and stored procedures where the required change is within the database layer.
07
Assess indexing strategy, including clustered/non-clustered indexes, missing indexes, redundant indexes, index utilization and covering-index opportunities.
08
Analyze statistics and parameter-related performance issues, including parameter sniffing where applicable.
09
Establish performance baselines and capture before/after measurements for significant optimizations.
10
Perform evidence-based root-cause analysis for report/database performance issues.
11
Prepare a comprehensive technical assessment report with findings, evidence, root causes, recommendations, priorities and dependencies.
12
Clearly identify application/business-logic issues that require action by the client development team.
Technology stack
Tools & Technologies.
The platforms and technologies you'll use to build modern, enterprise-grade solutions.
01
SQL Server
Required
02
Microsoft SQL Server
Required
03
T-SQL
Required
04
Stored Procedures
Required
05
Execution Plans
Required
06
Query Store
Required
07
DMV
Required
08
Dynamic Management Views
Required
09
Wait Stats
Required
10
Extended Events
Required
11
SQL Server Profiler
Required
12
Indexing
Required
13
Clustered Index
Required
14
Nonclustered Index
Required
15
Covering Index
Required
16
Included Columns
Required
17
Statistics
Required
18
Parameter Sniffing
Required
19
Blocking
Required
20
Deadlocks
Required
Requirements
Skills & Experience.
We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.
Essential
Required Qualifications
Microsoft SQL Server (enterprise DBA experience)
SQL Server performance tuning and optimization (recent, hands-on)
Advanced T-SQL (complex queries, stored procedures, views, CTEs, temp objects)
Execution plan analysis (actual/estimated)
Query Store usage for performance troubleshooting
DMVs for diagnostics and performance analysis
Wait statistics analysis
CPU and I/O performance analysis
Blocking and deadlock analysis
Indexing strategy (clustered/non-clustered, covering indexes, included columns, missing/duplicate/unused indexes, index utilization)
Statistics analysis and maintenance
Parameter sniffing / parameter-sensitive plan behavior troubleshooting
SQL Server diagnostics tooling (Extended Events and/or SQL Server Profiler)
Root-cause analysis with evidence and measurable remediation
Documentation: comprehensive technical assessment/recommendation reporting
Change management execution: implement approved DB/SQL Server changes in Test and Production with rollback scripts
Production troubleshooting and performance issue resolution
Strong technical communication with client stakeholders and cross-functional teams
Preferred
Nice to Have
SSRS (SQL Server Reporting Services) / enterprise reporting environments
High-volume databases and performance-sensitive reporting workloads
Azure SQL and/or SQL Server on Azure
PowerShell automation/scripting (or SQL-based automation)
Experience partnering closely with application development teams on DB performance issues
Formal change-management and production implementation process experience
What you'll gain
More Than Just A Job.
We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.
Global Exposure
Collaborate with international clients and multicultural teams on enterprise programmes.
Continuous Learning
Expand your expertise through mentoring, certifications and hands-on project experience.
Career Growth
Take ownership, develop leadership skills and grow your consulting career over time.
Flexible Working
Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.
People First
Join a supportive culture where collaboration, respect and long-term relationships come first.
Enterprise Projects
Work on meaningful technology initiatives for leading organisations across industries.
Apply
Apply for Senior SQL Server DBA (Performance Tuning / Performance Engineering)
One page, about two minutes. We only ask for what we actually need to have a first conversation.