SQL Server Performance Tuning Specialist

 

Recruiter:

Sochin Technologies

Job Ref:

SOIT:SQLDBA_112021

Date posted:

Wednesday, November 10, 2021

Location:

Johannesburg, South Africa

Salary:

Market Related


SUMMARY:
SQL Server Performance Tuning Specialist

POSITION INFO:

We are looking for an experienced SQL Server Performance Tuning Specialist with solid experience in the field of Microsoft SQL server database (SQL Server 2017, on-premise) performance optimisation, pro-active performance and database growth monitoring, and reporting across all of these.

The focus area will be on the detailed configuration settings, identifying and resolving performance bottle necks and assisting with the implementation of a long-term monitoring and maintenance strategy to keep the database running optimally.

 

Duties and responsibilities:

  • Review all CCMS SQL server instance configuration setting to identify and remediate any gaps or non-optimal settings.
  • Review and remediate any current database performance issues:
    • Identify any database locking / blocking issues
    • Identify regular offending queries causing locks / blocks or any performance bottlenecks
    • Assist developers with query tuning and schema refinement
    • Recommend indexing strategy where applicable or non-optimal
    • Review relevant operating system configuration settings that might impact on SQL performance
    • Implement a monitoring strategy together with the CCMS team to baseline and measure performance
    • Implement automatic notification of any abnormal long running queries, blocks, incomplete jobs.
    • Assist with reviewing security configuration and implementation of any gaps / issues identified.
    • Track and prioritise issues to be resolved and document all changes and impact thereof.
    • Provide regular reports which documents and provide an historical view of:
      • SQL instance configuration and configuration changes
      • CCMS database health and performance statistics, highlighting bottlenecks to action
      • Backup and recovery jobs (successful and failed jobs)

 

SQL Server DBA requirements and qualifications:

  • 10 years of experience as a SQL Server DBA, working in a development environment or similar role
  • 10 years of experience with Performance Tuning and Optimization (PTO) with a solid knowledge of SQL Extended Events and Dynamic Management Views.
  • Solid experience in a development operations environment, interacting with development teams, DBA''s and project managers.
  • Deadline driven with a sense of ownership and pride in your performance
  • Critical thinker with problem-solving skills
  • Good time-management skills
  • Great interpersonal and communication skills


 

NB! This job is now closed. You can apply for other jobs by uploading your CV.



 

 

 

Similar jobs you might be interested in:

Senior BI Developer
Location: Johannesburg
Salary: 450000 Annually
Are you a data-driven problem solver who thrives on building robust BI solutions and turning complex data into meaningful insights? We’re looking for a Senior BI Developer to join a dynamic and fast-paced environment where innovation, collaboration, and continuous improvement are key.
5 days ago


Business Intelligence Developer
Location: Johannesburg
Salary: 400000 Annually
New Opportunity: BI Developer - Gauteng
6 days ago


Senior Network Engineer (Level 3)
Location: Johannesburg
Salary:
6 days ago


SQL Developer
Location: Johannesburg
Salary: CTC
sql Developer
8 days ago


IBM DB2 Support Specialist
Location: Pretoria
Salary:
The successful candidates will play a key role in administering, monitoring, optimising and supporting DB2 database environments within a complex, high-availability mainframe environment. This opportunity is ideal for seasoned DB2 professionals seeking to contribute to a large-scale transformation programme.  This is a 24-month fixed term contract role.
12 days ago


SQL Applications Support Manager
Location: Midrand
Salary:
Datacentrix is looking for an Applications Manager who will be responsible for leading the Applications Support Team, ensuring the stability, performance and continuous improvement of business applications. The role requires strong technical expertise in sql and Ivanti, combined with leadership capabilities to manage a team responsible for application support, troubleshooting, and system optimizat...
14 days ago


Senior Full Stack Developer (.NET & React)
Location: Cape Town
Salary:
Are you a seasoned Full Stack Developer with strong .NET and React experience? Join a globally recognised leader in cinema technology and be part of an innovative engineering team shaping the future of digital entertainment.
18 days ago


IT Support Technician
Location: Germiston
Salary:
20 days ago


Head of IT Infrastructure - Windows & Linux
Location: Johannesburg
Salary:
21 days ago


Senior .NET Developer (Azure DevOps) – Contract
Location: Johannesburg
Salary: 800000
Senior .NET Developer (Azure DevOps) – Contract
22 days ago


Create a free job alert for SQL Server Performance Tuning Specialist in Johannesburg

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions