MS SQL/ No SQL Developer at Ntice Search - Gauteng, Gauteng
Our Client is looking for a highly skilled NoSQL Developer with strong SQL capabilities to join our dynamic development team.
In this role you will play a critical part in designing, optimizing, and maintaining both relational and non-relational databases that support scalable, high-performance applications.
If you are 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, Dragonfly, 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.
Desired Skills
#J-18808-Ljbffr