Job description

Senior Database Specialist

a0MaA000000b8Zh.1_1738256915

Job Opportunity: Database Specialist
Location: Remote with required travel to Stellenbosch
Department: IT and Internet
Position: Full-time, Permanent, Remote



About the Role:

We are seeking a highly skilled and experienced Database Specialist to join our clients team, offices are based in Stellenbosch. As a Database Specialist, you will be responsible for managing and maintaining the company's SQL Server databases, ensuring optimal performance, availability, and security. You will work closely with our Finance department, contributing to the seamless operation of our business systems.



Key Responsibilities:



*

Database Administration:

* Install, configure, and patch MySQL and PostgreSQL instances.
* Manage database users and permissions.
* Implement database schema design and data modelling.
* Perform database backups and recovery operations.
* Monitor database performance and resolve bottlenecks.
* Optimise queries and database structures for efficient data access.

*

SQL Expertise:

* Write complex SQL queries for data manipulation and retrieval.
* Utilize advanced SQL features like stored procedures, triggers, and functions.
* Troubleshoot SQL errors and performance issues.

*

Security:

* Implement database security best practices, including user access controls, encryption, and auditing.
* Monitor for suspicious database activity and potential security threats.

*

Performance Tuning:

* Analyse database performance metrics and identify areas for improvement.
* Implement optimisation techniques like indexing, query optimisation, and partitioning.

*

High Availability & Disaster Recovery:

* Set up replication and fail over mechanisms to ensure database availability.
* Develop disaster recovery plans and conduct testing procedures.

*

Automation & Scripting:

* Write scripts to automate repetitive tasks like backups, monitoring, and data migration.
* Utilise automation tools to streamline database management.

What We Are Looking For:

*

Experience:

* 10+ years of database administration, with at least 3 years of specific PostgreSQL experience.
* Proficient in both MySQL and PostgreSQL SQL syntax and administration.
* Familiarity with cloud-based database services (e.g., AWS RDS, Azure Database).
* Strong knowledge of database design, replication, high availability, and security practices.
* Experience with database monitoring tools and troubleshooting.
* Scripting skills (e.g., Bash, Python) for automation.
* Excellent problem-solving and analytic skills.

*

Education:

* Grade 12.
* BSc in Information Systems (or related field).
* Microsoft SQL Server certification is an advantage.



Why Join Our Client?

This is a fantastic opportunity to work in a dynamic and forward-thinking company, with opportunities for growth and development. You'll play a critical role in maintaining the high performance and security of our databases, all while working with cutting-edge technologies.

If you're looking for a challenging role where you can make a significant impact, we'd love to hear from you. Please send us your CV to apply, or feel free to refer any qualified candidates who may be interested in this opportunity.

Apply through the link or email your CV to m.price@tenthrevolution.com.

I look forward to hearing from you!Apply