73 Database Solutions jobs in South Africa

Database Developer
Johannesburg - Rosebank

We are seeking a highly skilled and experienced Database Developer to join our dynamic team. As a Database Developer, you will play a pivotal role in designing, implementing, and optimizing database structures, ensuring efficient data storage and retrieval. You will be instrumental in creating and maintaining performative database code while adhering to SQL best practices. This role requires a strong problem-solving aptitude, excellent communication skills, and the ability to collaborate effectively with various teams across the organization.

Responsibilities:

• Design and implement database structures and data analytical patterns.
• Participate in product development lifecycle from ideation to deployment and beyond.
• Resolve incidents related to database functionality.
• Write efficient SQL queries, procedures, and functions.
• Plan, estimate, and deliver database-related tasks within project timelines.
• Conduct code reviews and peer reviews to ensure quality and adherence to best practices.
• Provide solutions for third-party integrations using data.
• Create concise technical specifications and conduct detailed unit testing.
• Integrate database functionalities into the API layer with Java/Spring.
• Collaborate with cross-functional teams including Delivery Leads, Business Analysts, Quality Assurance, Project Managers, Product Owners, and other Developers.

Requirements:

• 7+ years of experience in MS SQL development.
• Proficiency in data modeling, data warehousing, and building ETL pipelines.
• Strong problem-solving and communication skills.
• Experience in batch environments is advantageous.
• Proficient in TSQL, SSIS, SSAS, SSRS.
• Bachelor’s degree in IT or related field.
• Exposure to Agile methodology.
• Microsoft certifications in SQL Server or Azure SQL database preferred.

• A relevant ICT degree or equivalent qualification
• Requirements gathering - minimum five (6) year experience
• Project management - minimum five (6) year experience
• Technical writing minimum five (6) year experience
• Database design and implementation - minimum five (6) year experience
• SQL development - minimum five (6) year experience in developing data solutions on MSSQL platform
• Reporting and dashboarding - minimum five (6)) year experience developing reports and dashboard using PowerBI, SRSS and MSSQL
• Data quality assurance - minimum five (6) year experience
• Data management - minimum three (3) year experience
• Data migrations - minimum three (3) year experience
• Data Warehousing minimum three (3) year experience
• Data modelling - minimum three (3) year experience
• Data Governance minimum two (2) year experience
• Requirements gathering - minimum two (2) years experience in gathering and translating requirements into technical designs and solutions
• Mentoring experience in providing mentoring to junior resources
• Working experience in developing cloud database solutions with databases and platforms in Azure cloud environments is an advantage

• Requirements Gathering: Engage with business to collect, document, and review requirements.
• Database Design & Modelling: Design, implement, and manage scalable, reliable databases; create and maintain logical and physical data models to ensure consistency and accuracy.
• SQL Development: Write complex SQL queries, stored procedures, and triggers; optimise performance using indexing, partitioning, and query optimisation techniques.
• Data Migration: Ensure accurate, secure migration of data between sources.
• Data Management & Quality: Manage large data sets, ensuring quality, accuracy, security, and validation through defined QA models.
• Reporting & Analytics: Develop reports and dashboards to highlight trends, patterns, and predictions.
• Data Warehousing: Build data warehouse solutions, including integration, cleaning, and design.
• Documentation: Maintain clear technical documentation and specifications.
• Project Management: Apply project management standards and techniques to all work.
• Data Governance: Implement governance processes and policies to ensure data integrity and compliance.
• Mentoring: Provide guidance and support to junior team members.

• A relevant ICT degree or equivalent qualification.
• Requirements gathering - minimum five (6) year experience.
• Project management - minimum five (6) year experience.
• Technical writing minimum five (6) year experience.
• Database design and implementation - minimum five (6) year experience.
• SQL development - minimum five (6) year experience in developing data solutions on MSSQL platform.
• Reporting and dashboarding - minimum five (6)) year experience developing reports and dashboard using PowerBI, SRSS and MSSQL
• Data quality assurance - minimum five (6) year experience.
• Data management - minimum three (3) year experience.
• Data migrations - minimum three (3) year experience.
• Data Warehousing minimum three (3) year experience
• Data modelling - minimum three (3) year experience.
• Data Governance minimum two (2) year experience
• Requirements gathering - minimum two (2) years experience in gathering and translating requirements into technical designs and solutions.
• Mentoring experience in providing mentoring to junior resources.

• Requirements gathering through engagement with business i.e., collect, document, and review business requirements.
• Database design and implementation design, implement manage complex databases and data structures that meet business requirements, taking scalability, reliability and performance into consideration.
• Database modelling understanding of data modelling concepts and create logical and physical data models to support database design. create and maintain data models and data structures, ensuring data consistency and accuracy.
• SQL development - develop SQL scripts and optimise database performance using techniques like indexing, partitioning, and query optimization. including writing complex queries, stored procedures and triggers to support business operations.
• Data migration migrate data from one data source to another, ensuring data integrity and accuracy during the migration process.
• Data management manage and maintain large amounts of data and ensure data quality, accuracy, and security. Reviewing reports and performance indicators.
• Data quality assurance ensuring the integrity and accuracy of data through well-defined verification and validation models.
• Reporting and dashboarding - develop reports and dashboards providing a view on trends, patterns, focus and prediction based on relevant data sets.
• Data Warehousing - develop data warehousing solutions, including data integration, data cleaning, and data warehousing design.
• Technical writing develop and maintain comprehensive technical documentation and specifications and related technical specifications.
• Project management adhere to project management standards and techniques in the line of work.
• Data Governance - implement data governance processes and policies to ensure data integrity and security.
• Mentoring guide and support junior resources on data related tasks.

Reference: JHB002481-TR-1

Minimum Requirements:

1. 5 years of proven and practical experience in MS SQL 2012 or higher.
2. Entity Relationship Diagrams, Data Flow Diagrams, Stored Procedures, Functions, Views, SQL scripts and Queries, Triggers.
3. Microsoft Certification in designing, developing and managing Databases using MS SQL Server.

Advantageous:

1. Showcase of Data Warehousing Development, data integration Development, data Normalization Development.
2. Data Warehousing Development.
3. NQF 6 or above within the related Field.

Database Developer
Johannesburg - Rosebank

We are seeking a highly skilled and experienced Database Developer to join our dynamic team. As a Database Developer, you will play a pivotal role in designing, implementing, and optimizing database structures, ensuring efficient data storage and retrieval. You will be instrumental in creating and maintaining performative database code while adhering to SQL best practices. This role requires a strong problem-solving aptitude, excellent communication skills, and the ability to collaborate effectively with various teams across the organization.

Responsibilities:

• Design and implement database structures and data analytical patterns.
• Participate in product development lifecycle from ideation to deployment and beyond.
• Resolve incidents related to database functionality.
• Write efficient SQL queries, procedures, and functions.
• Plan, estimate, and deliver database-related tasks within project timelines.
• Conduct code reviews and peer reviews to ensure quality and adherence to best practices.
• Provide solutions for third-party integrations using data.
• Create concise technical specifications and conduct detailed unit testing.
• Integrate database functionalities into the API layer with Java/Spring.
• Collaborate with cross-functional teams including Delivery Leads, Business Analysts, Quality Assurance, Project Managers, Product Owners, and other Developers.

• 7+ years of experience in MS SQL development.
• Proficiency in data modeling, data warehousing, and building ETL pipelines.
• Strong problem-solving and communication skills.
• Experience in batch environments is advantageous.
• Proficient in TSQL, SSIS, SSAS, SSRS.
• Bachelor’s degree in IT or related field.
• Exposure to Agile methodology.
• Microsoft certifications in SQL Server or Azure SQL database preferred.