Sql Administrator Stellenbosch

Oxbridge Academy • Other • Stellenbosch, Cape Town, Western Cape, Western Cape, South Africa • $300 - $400 / year • 3h ago

Become part of a dream team at a successful distance learning college.

Job title: SQL Consultant / Administrator – Intermediate Level role

Reports to the Business Analysis and Dispatch Manager

Unlock Your Potential as an Intermediate SQL Database Administrator!

Ready to embark on a Learning experience? At Oxbridge Academy, we're on the lookout for an Intermediate SQL Database Administrator who thrives on optimizing performance, ensuring security, and driving excellence in our database systems.

What are we looking for:

We are seeking an intermediate SQL Database Administrator who excels in collaborative environments, embraces innovation, and thrives under pressure. Ideal candidates will have 2-3 years of experience and a desire to take ownership of their career.

If you're passionate about creating remarkable solutions and eager to contribute your expertise to a diverse and inclusive work community, we invite you to join us.

Responsibilities

Configure, fine-tune, and optimize SQL databases for peak efficiency.
Monitor performance, troubleshoot bottlenecks, and elevate query response times.
Implement robust backup and recovery strategies to safeguard crucial data.
Secure data with precise access controls, authentication, and authorization mechanisms.
Uphold data integrity.
Keep databases up-to-date and secure through regular updates and maintenance.
Plan for scalability by tracking growth trends and suggesting optimizations.
Collaborate across teams, contribute to disaster recovery planning, and automate tasks.
Manage improvements and new functionalities of the application in coordination with other applications.
Support users during budgetary and reporting campaigns.
Manage relationships with the IT team.
Prepare business requirements and ensure that the documentation is up-to-date.
Look for new reporting methods or build new reports to assist managers.
Exposure to SSRS.
Exposure to technical setups pertaining to SQL user creation and security permissions.

Skills

Critical thinking
Problem-solving
Decision-making
Proficiency in Excel
SQL

Expertise in SQL, deep understanding of relational database concepts, and proficiency in writing complex SQL queries. Proven experience in database design, development, and optimization, demonstrating a track record of success in managing medium to large-scale data systems. Proficiency in database management systems such as MySQL and Microsoft SQL Server, with a keen understanding of their respective features and functionalities. Familiarity with data modeling and schema design principles, enabling you to create efficient and maintainable database structures. Strong analytical and problem-solving abilities, empowering you to unravel data mysteries and optimize query performance.