Sql Database Administrator

Signaturegroup; Johannesburg; On-site; ZAR 40 000 - 80 000; Full time

Job summary

An established industry player is looking for a skilled SQL Database Administrator to join their dynamic team in Johannesburg. This role is crucial for maintaining and optimizing SQL database environments for financial services clients. You will be responsible for database administration, performance tuning, and ensuring data integrity and compliance. If you have a strong background in SQL Server and enjoy problem-solving in a collaborative environment, this opportunity is perfect for you. Join a forward-thinking company where your expertise will make a significant impact in the IT and financial sectors.

Qualifications

• 3+ years of experience as a SQL Database Administrator in production environments.
• Proficiency in SQL Server administration, including performance tuning and security.

Responsibilities

• Perform regular database maintenance tasks and optimize SQL queries.
• Collaborate with development teams for database design and performance enhancements.

Skills

SQL Server Administration

Performance Tuning

Backup and Recovery

Database Security Management

Analytical Skills

Problem-Solving Skills

Education

Bachelor's Degree in Computer Science

Tools

Microsoft SQL Server

Oracle

MySQL

PostgreSQL

Azure SQL Database

Amazon RDS

Job description

PURPOSE OF THE JOB

We are seeking a talented SQL Database Administrator with intermediate-level experience to join our dynamic team.

The SQL DBA will play a pivotal role in maintaining, optimizing, and securing SQL database environments for our esteemed financial services clients.

Location: Permanent role, based in Woodmead, Johannesburg.

Requirements

1. Bachelor's degree in computer science, Information Technology, or a related field.
2. 3+ years of hands-on experience as a SQL Database Administrator in a production environment, preferably within the financial services industry.
3. Proficiency in SQL Server database administration, including backup and recovery, performance tuning, and security management.
4. Solid understanding of relational database concepts, SQL query optimization techniques, and database normalization principles.
5. Experience with database monitoring tools and performance tuning utilities.
6. Strong analytical and problem-solving skills with the ability to troubleshoot complex database issues.
7. Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.

Preferred Skills

1. Certification in Microsoft SQL Server (e.g., MCSA: SQL Server, MCSE: Data Management and Analytics) or equivalent.
2. Familiarity with other RDBMS platforms such as Oracle, MySQL, or PostgreSQL.
3. Experience with database replication, clustering, and high availability solutions.
4. Knowledge of cloud-based database services such as Azure SQL Database or Amazon RDS.
5. Understanding of data warehousing concepts and ETL processes.

Duties & Responsibilities

1. Database Administration
   • Perform regular database maintenance tasks such as backups, restores, and recovery procedures.
   • Monitor database performance and proactively optimize SQL queries and database structures for improved efficiency.
   • Implement and maintain database security protocols to ensure compliance with industry standards and client requirements.
   • Troubleshoot and resolve database-related issues in a timely manner, minimizing downtime and ensuring maximum availability.
2. Database Development Support
   • Collaborate with development teams to design, implement, and optimize database schemas, stored procedures, and triggers.
   • Assist in database design reviews and provide recommendations for performance enhancements and scalability.
   • Conduct database performance tuning and query optimization to support high-volume transaction processing.
3. Data Integrity and Compliance
   • Implement data integrity constraints and enforce data quality standards to ensure accuracy and consistency of financial data.
   • Support regulatory compliance efforts by implementing auditing mechanisms and assisting in compliance audits as needed.
   • Document and stay updated on industry regulations and best practices related to database security and compliance requirements.
4. Documentation and Training
   • Maintain comprehensive documentation of database configurations, procedures, and troubleshooting steps.
   • Provide training and guidance to junior DBAs and development teams on best practices for SQL database administration and performance optimization.

Note

APPLY NOW. Please note: We work in the Information Technology and Financial Services Industry.

We are not the Cosmetics Company!

J Ljbffr

Create a job alert for this search