Sql Database Specialist

Congruence Hr Solutions; Gauteng; On-site; ZAR 400 000 - 600 000; Full time

Job summary

A leading company in South Africa is looking for an experienced SQL Database Specialist to manage and optimize databases, ensuring data integrity and performance. The role involves query development, database maintenance, and generating reports using Power BI. Candidates should have strong skills in SQL Server management and T-SQL, with networking knowledge considered a plus.

Qualifications

• 3 years of experience in SQL Server database administration.
• Strong T-SQL skills for query writing and optimization.

Responsibilities

• Maintain, optimize, and secure SQL Server databases.
• Write, optimize, and troubleshoot complex SQL queries.
• Generate detailed reports and dashboards using Power BI.

Skills

SQL Server management

Query Development

Database Administration

Power BI

Networking Knowledge

Job description

We are seeking an experienced, highly skilled SQL Database Specialist to manage our databases, optimize performance, and ensure data integrity.

The ideal candidate must be proficient in SQL Server management, query development, and database administration.

Additionally, Power BI reporting skills and networking knowledge will be considered strong advantages.

Responsibilities and Duties Database Management Maintain, optimize, and secure SQL Server databases.

Query Development Write, optimize, and troubleshoot complex SQL queries.

Data Integrity & Performance Ensure database accuracy, security, and high performance.

Database Maintenance Regularly update, back up, and troubleshoot database issues.

Reporting & Insights Generate detailed reports and dashboards using Power BI.

Networking Knowledge Understanding of network infrastructure and security (a plus) Qualifications & Experience 3 years of experience in SQL Server database administration.

Strong T-SQL (Transact-SQL) skills for query writing and optimization.

Experience in database backup, recovery, and performance tuning.

Knowledge of database security best practices.

Power BI skills for creating reports and data visualizations.

Networking experience related to database connectivity and infrastructure (a plus).

Ability to work under pressure and troubleshoot database-related issues effectively.