Intermediate SQl Database Administrator

Curiska; Johannesburg; On-site; ZAR 200,000 - 300,000; Full time

Job summary

A prominent IT company in Johannesburg is seeking an Intermediate SQL Database Administrator. The ideal candidate will have strong SQL programming skills and at least 3 years of experience. Responsibilities include database setup, performance optimization, and collaboration with development teams. Familiarity with Linux and automation tools like PowerShell is advantageous. This role offers excellent growth opportunities in a dynamic environment.

Qualifications

• At least 3 years of experience in database administration and management.
• Strong SQL programming and query optimization skills.
• Experience with automation tools and scripting languages is preferable.

Responsibilities

• Install, configure, and maintain database systems to meet business requirements.
• Monitor database performance and implement tuning strategies.
• Collaborate with development teams for scalable database solutions.
• Create strategies for disaster recovery and data archiving.

Skills

SQL programming

Performance tuning

Query optimization

Database security

Backup and recovery

Automation with PowerShell

Education

Bachelor's Degree in Computer Science

Job description

Overview

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).

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.
• Technical Skills: Experience with database security, backup, and recovery processes.
• Technical Skills: Familiarity with Linux systems is advantageous.
• Technical Skills: Experience with automation tools and scripting languages (e.g., PowerShell).
• Industry Experience: Experience in a financial or regulated industry is a plus.