Intermediate SQl Database Administrator

Curiska; Johannesburg; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A reputable company in Johannesburg is seeking an Intermediate Database Administrator (DBA) to join their IT team. The role involves ensuring the reliability and performance of database systems, collaborating with development teams, and optimizing database performance. Candidates should have at least 3 years of experience in database management, a Bachelor's degree in Computer Science, and strong SQL programming skills. This position offers opportunities for growth in a dynamic environment.

Qualifications

• At least 3 years of experience in database administration and management.
• Experience in a financial or regulated industry is a plus.

Responsibilities

• Install, configure, and maintain database systems.
• Monitor database performance and implement tuning strategies.
• Work closely with development teams to design scalable database solutions.
• Create strategies for disaster recovery and data archiving.
• Plan and manage database storage for future growth.
• Support users with database access and troubleshooting.
• Maintain detailed documentation of database configurations.
• Use scripting languages to automate database configurations.
• Provide mentorship to junior team members.
• Perform data analysis and create reports.

Skills

SQL programming

Performance tuning

Query optimization

Database security

Backup and recovery processes

Automation tools

Scripting languages

Education

Bachelor’s Degree in Computer Science

Tools

PowerShell

Linux

Job description

Hiring : Inetrmediate Sql Database administrator.

Our client is looking for a skilled Intermediate Database Administrator (DBA) to join their IT team. In this role, you will play a crucial part in ensuring the reliability, performance, and security of our database systems. You’ll be involved in everything from database installation and optimization to troubleshooting and supporting development teams. This position offers great opportunities for growth in a fast-paced environment, with experience in both Windows and Linux systems (Linux experience is a plus but not required).

Key Responsibilities :

Database Setup & Maintenance : Install, configure, and maintain database systems to ensure they meet our business requirements.

Performance Optimization : Monitor database performance, identify areas for improvement, and implement tuning strategies to enhance efficiency.

Collaboration : Work closely with development teams to design and implement scalable and high-performance database solutions.

Disaster Recovery & Data Backup : Create and implement strategies for disaster recovery and data archiving to safeguard data integrity.

Capacity & Storage Management : Plan and manage database storage, ensuring scalability and readiness for future growth.

User Support : Provide support to users for database access, troubleshooting, and resolution of issues.

Documentation : Maintain detailed documentation of database configurations, processes, and policies.

Automation : Use PowerShell or other scripting languages to automate database infrastructure and configurations.

Mentorship : Provide guidance and support to junior team members and help solve complex database issues.

Continuous Improvement : Stay up-to-date with emerging technologies and trends to continuously improve database management practices.

Data Analysis & Reporting : Perform data analysis, create reports, and design dashboards to support business decisions.

Data Quality : Ensure data accuracy and consistency through validation processes and checks.

Cross-Functional Teamwork : Collaborate with various teams to understand data needs and deliver tailored database solutions.

Qualifications :

Education : Bachelor’s Degree in Computer Science, Information Technology, or a related field (or equivalent experience).

Experience : At least 3 years of experience in database administration and management.

Technical Skills :

Strong SQL programming, performance tuning, and query optimization skills.

Experience with database security, backup, and recovery processes.

Familiarity with Linux systems is advantageous.

Experience with automation tools and scripting languages (e.g., PowerShell).

Industry Experience : Experience in a financial or regulated industry is a plus.