Associate Lead Consultant - SQL DBA Job

Experience

8 - 12+ Years

Job Description

Key Responsibilities

• Own technical discovery and assessment of the SQL Server reporting environment.
• Understand the BHSDB and LTDS architecture, data lifecycle and reporting data-retrieval flow.
• Analyze slow reports, associated SQL queries, stored procedures, tables and database objects.
• Perform SQL Server performance analysis covering CPU, I/O, waits, blocking, deadlocks, memory and other relevant indicators.
• Analyze actual/estimated execution plans and identify inefficient operators, scans, joins, sorting, aggregation and excessive data retrieval.
• Optimize complex T-SQL queries and stored procedures where the required change is within the database layer.
• Assess indexing strategy, including clustered/non-clustered indexes, missing indexes, redundant indexes, index utilization and covering-index opportunities.
• Analyze statistics and parameter-related performance issues, including parameter sniffing where applicable.
• Establish performance baselines and capture before/after measurements for significant optimizations.
• Perform evidence-based root-cause analysis for report/database performance issues.
• Prepare a comprehensive technical assessment report with findings, evidence, root causes, recommendations, priorities and dependencies.
• Clearly identify application/business-logic issues that require action by the client development team.
• Develop implementation and rollback scripts for approved database/DB-server changes.
• Implement approved database and SQL Server-level changes in Test and Production in accordance with client change-management procedures.
• Validate implemented changes and document performance results.
• Coordinate technically with client DBA, development, reporting and infrastructure teams.
• Provide technical status, risks, issues and dependencies to the Project/Delivery Manager.
  
  

Required Technical/ Functional Competencies

Required Technical Skills

SQL Server - Strong hands-on SQL Server DBA experience in enterprise environments

T-SQL - Advanced T-SQL, complex queries, stored procedures, views, CTEs, temp objects and query optimization

Performance Tuning - Execution plans, Query Store, DMVs, wait statistics, CPU/I/O analysis, blocking and deadlocks

Query Optimization - Query rewrites, access paths, joins, predicates, aggregation, sorting and high-cost operations

Indexing - Clustered/non-clustered indexes, covering indexes, included columns, missing/duplicate/unused indexes and index utilization

Diagnostics - SQL Server Profiler/Extended Events, Query Store, DMVs and other performance diagnostic methods

Database Administration - Database health, configuration, statistics, maintenance, backup/restore and production support fundamentals

Root-Cause Analysis - Ability to move from symptoms to evidence-based technical root cause and measurable remediation

Documentation - Ability to produce clear, comprehensive technical assessment and recommendation reports

Client Interaction - Strong technical communication and ability to work with DB, application, reporting and infrastructure teams

Preferred / Good-to-Have Skills

• Experience with SSRS and enterprise reporting environments.
• Experience with high-volume databases and performance-sensitive reporting workloads.
• Azure SQL / SQL Server on Azure experience.
• PowerShell or SQL-based automation/scripting.
• Experience working closely with application development teams on database performance issues.
• Experience with formal change-management and production implementation processes.
  
  

Mandatory Experience Profile

• 8–12+ years of overall SQL Server experience, with significant hands-on DBA responsibilities.
• Strong recent experience in SQL Server performance tuning and optimization.
• Demonstrated experience troubleshooting production performance issues.
• Ability to independently analyze execution plans, queries, stored procedures and indexing problems.
• Experience delivering measurable performance improvements.
• Strong written and verbal communication skills.
• Comfortably working directly with client technical stakeholders.
  
  

Accountability

Required Behavioral Competencies

• Takes responsibility for and ensures accuracy of results and deadlines of the function and/or team and in completing own work.
  
  

Collaboration

• Reaches out to others in team to ensure connections are made and team members are working together.
• Looks for ways to integrate work with other teams, identifying similarities and opportunities, making necessary changes in work to ensure successful integration.
  
  

Agility

• Demonstrates openness to the possibilities that change presents and begins to plan for how role may change.
• Works with others to prepare for change.
  
  

Customer Focus

• Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.
  
  

Communication

• Communicates well-organized ideas, information, and data to broad and diverse audiences across the Organization (through formal and informal presentations).
• Helps others identify their appropriate audience.
  
  

Drives Results

• Sets realistic stretch goals for self & others and perseveres to follow through with resilience and remains calm in a crisis or stressful situation to exceed organization/client expectation.
  
  

Resolves Conflict

• Identifies and understands the source of conflict, addresses, and overcomes.
  
  

Certifications

ITIL V4, TOGAF V2, Certified, Cloud Solution Architect

NCX - Nutanix Certified Expert