MS SQL & NoSQL Developer

Johannesburg - South Africa

Monthly Salary: Not Disclosed

Posted on: 21 hours ago

Vacancies: 1 Vacancy

Job Summary

Our client is Southern Africas leading integrated tourism group operating businesses which range from travel management companies hotels lodges and restaurants to craft curio and jewellery shops and foreign exchange bureaux. They are driven by a commitment to exceptional quality service and value; its people-centred business philosophy; the development of mutually rewarding partnerships; constant innovation; and world-class technology.

Role Overview

Our client is seeking an experienced SQL & NoSQL Developer to join their development team. The ideal candidate will have a strong background in both relational and non-relational database systems with a proven ability to design develop optimize and maintain complex data structures and queries. This role requires a mix of analytical thinking performance tuning expertise and real-world experience building scalable high-performance data solutions in the travel technology space.

Job Location: Bryanston

Job Type: Full-time

Workplace: Hybrid

Requirements

Bachelors degree in Computer Science Information Technology Engineering or a related field.
Proven ability to write complex SQL queries and optimize them for performance.
Proven ability to read understand and amend existing complex SQL queries and optimize them for performance.
Experience with database administration tasks including backups replication and disaster recovery.
Familiarity with ETL tools (SSIS) and frameworks.
Comfortable working in Agile environments.
Excellent problem-solving and troubleshooting skills.
Knowledge of data security best practices.
Experience with linked servers.
Solid experience in database performance and debugging.
Database maintenance SQL agents SQL jobs backups restores and database sizing.
Solid experience in SQL maintenance and being able to investigate and find issues.
Solid experience in MS SQL Synonyms.
Strong verbal and written communication skills and enjoy working in a team.
Excellent verbal and written skills with a knack for simplifying technical ideas for diverse audiences.
Analytical mindset with a track record of turning insights into actionable solutions.

Responsibilities

Design implement and maintain SQL and NoSQL database systems for applications.
Develop efficient and optimized queries stored procedures views and triggers.
Implement and maintain data models including both relational (OLTP/OLAP) and document/key-value structures.
Ensure data integrity consistency and security across platforms.
Follow a very specific naming convention as required by the business.
Perform data migrations ETL (Extract Transform Load) processes and data transformations as needed.
Monitor and optimize database performance including indexing query tuning and capacity planning.
Collaborate with developers and managers to meet application and reporting requirements.
Maintain up-to-date documentation of database structures and processes.
Stay informed on latest trends and best practices in database technologies and recommend improvements.
Qualifications and Expertise
5 years of hands-on experience in both SQL and NoSQL database development.
Strong expertise in at least one RDBMS (Relational Database Management System) (e.g. PostgreSQL MySQL MS SQL Server Oracle).
Strong knowledge of at least one NoSQL database (e.g. MongoDB Cassandra Couchbase DynamoDB Redis Dragonfly). Preferably Redis/Dragonfly expertise.
Solid experience with data modeling normalization/denormalization and schema design.

Benefits

Competitive salary and benefits package
Flexible work environment (remote/hybrid options)
Opportunities for professional growth and development
Collaborative and inclusive team culture
Knowledge transfer in tourism technologies
Large variety of projects and technologies in the travel sector