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:

Intermediate - Senior Software Developer
Location: Johannesburg
Salary:
Our client, a leading systems integrator specializing in cutting-edge solutions for the measurement and control of fuel and high-value liquids to major mines, refineries, and distribution terminals across six continents and 30+ countries, is looking for a talented Software Developer to join their team.
Today

Software Developer
Location: Pretoria
Salary:
Software Developer (Contract), CenturionOur client uses innovative social behaviour change approaches to effectively engage youth and create demand for their health and well-being services. They offer a range of health services, currently focused on sexual and reproductive health, via a variety of convenient channels, primarily mobile vans. They also aim to connect youth via referrals and li...
5 days ago

Junior Developer
Location: Johannesburg
Salary: R16k - R18k p/m
The job function of a system application support role typically involves providing technical assistance and support related to software applications and systems used within an organization.
9 days ago

Intermediate SQL Developer
Location: Pretoria
Salary: 600 000 Annually
Are you an sql whiz with a knack for fintech innovation? Do you dream in data and thrive on building robust systems for e-commerce payment solutions? If you're ready to take your sql skills to the next level in a dynamic fintech environment, we've got the perfect opportunity for you!
11 days ago

Senior Back-End Developer
Location: Centurion
Salary: 70 000 Monthly
Our client is a prominent player in the automotive industry, dedicated to revolutionizing the car-buying experience. With a focus on innovation and customer satisfaction, our client is committed to providing a seamless and efficient platform for buying and selling vehicles. As they continue to lead the way in their industry, we are working closely with them to find a talented Senior C# .NET Back-E...
12 days ago

Application Developer
Location: Johannesburg
Salary:
13 days ago

Group IT Manager
Location: Johannesburg
Salary: Monthly
Our client in the manufacturing industry is currently looking to employ Group IT Manager based Johannesburg South. A wonderful career opportunity awaits you.Salary: R70 000 CTC monthly
15 days ago

IT Systems Administrator
Location: Midrand
Salary:
Our client, a global player in the mining supply industry, is looking for an IT Systems Administrator to join their team. In this role, you will play a pivotal role in managing and maintaining their organization's Financial Systems, ensuring their availability, security, and optimal performance. Your responsibilities will encompass system monitoring, troubleshooting, software installation, and pro...
19 days ago

BI Analyst
Location: Johannesburg
Salary:
21 days ago

Data Warehouse Manager
Location: Centurion
Salary:
Our client in the insurance industry is looking for a data warehouse manager. The Data Warehouse Manager must also establish and lead a world class data analytics/warehouse capability for Momentum Insure to enable future needs for advanced analytics and AI.
23 days ago

SQL Server Performance Tuning Specialist

Similar jobs you might be interested in:

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