Job Title: MS SQL Developer with NoSQL
Location: Gauteng or Remote
Salary: R800000 – R900000k
Overview
Our Client is looking for a highly skilled NoSQL Developer with strong SQL capabilities to join their dynamic development team. In this role, you’ll play a critical part in designing, optimizing, and maintaining both relational and non-relational databases that support scalable, high-performance applications. If you're passionate about data architecture, enjoy solving complex performance issues, and have hands-on experience with a range of modern database technologies, this role is for you.
What You'll Do
- Design, build, and maintain robust database systems using both SQL and NoSQL technologies.
- Develop optimized queries, stored procedures, views, and triggers to support application needs.
- Model and manage both relational (OLTP/OLAP) and NoSQL (document, key-value) data structures.
- Ensure data accuracy, security, and consistency across all platforms.
- Follow strict naming conventions and data standards as required by the business.
- Execute data migrations and develop ETL pipelines and data transformation processes.
- Monitor and tune database performance through indexing, query optimization, and capacity planning.
- Work closely with developers, analysts, and stakeholders to deliver database solutions that meet business and reporting needs.
- Document database architecture, schemas, and operational processes.
- Keep current with trends in database technology and suggest improvements to existing systems.
What You Bring
- 5+ years of hands-on experience working with both SQL and NoSQL databases in a production environment.
- Strong knowledge of at least one major RDBMS (e.g., PostgreSQL, MySQL, MS SQL Server, Oracle).
- Deep expertise in at least one NoSQL platform (e.g., Redis, MongoDB, Cassandra, DynamoDB, Couchbase).
- Proficient in data modeling, schema design, and performance tuning.
- Solid understanding of normalization, denormalization, and data architecture patterns.
Preferred Education
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical field.
Additional Skills & Competencies
- Expertise in writing and optimizing complex SQL queries.
- Skilled in analyzing and refactoring legacy SQL for better performance.
- Experience with administrative tasks such as database backups, replication, and recovery strategies.
- Familiarity with ETL tools (e.g., SSIS) and data pipeline frameworks.
- Knowledge of SQL Server features such as Synonyms, SQL Agent jobs, linked servers, and maintenance plans.
- Comfortable working in Agile environments and fast-paced teams.
- Strong troubleshooting and debugging skills.
- Awareness of data security and compliance best practices.
- Clear and effective communication skills—able to explain complex ideas to both technical and non-technical stakeholders.
- An analytical thinker who translates data insights into practical solutions.