Senior Database Developer

One Connect Technologies; Centurion; On-site; ZAR 600,000 - 900,000; Full time

Job summary

One Connect Technologies is seeking a Senior Database Developer to transform how businesses harness data and drive innovation. The role requires developing high-performance data systems, optimizing database performance, engaging with stakeholders, and ensuring data integrity. Candidates should have extensive experience in SQL development, data management, and governance. This position offers the opportunity to mentor junior members and work with advanced cloud database solutions while making a significant impact on the organization’s data strategy.

Qualifications

• Minimum 6 years of experience in requirements gathering, project management, technical writing, database design and implementation, SQL development on MSSQL platform, reporting/dashboarding using PowerBI, SRSS, and MSSQL, data quality assurance.
• Minimum 3 years of experience in data management, migrations, data warehousing, and data modelling.
• Minimum 2 years of experience in data governance.
• Experience in gathering and translating requirements into technical solutions.
• Mentoring experience and familiarity with cloud database solutions in Azure is an advantage.

Responsibilities

• Develop SQL scripts and optimize database performance using techniques like indexing, partitioning, and query optimization.
• Engage with business stakeholders to collect, document, and review business requirements.
• Design, implement, and manage complex databases and data structures that meet business needs, considering scalability, reliability, and performance.
• Understand data modelling concepts and create logical and physical data models to support database design.
• Migrate data between sources, ensuring data integrity and accuracy throughout the process.
• Manage and maintain large datasets, ensuring data quality, accuracy, and security.
• Ensure data integrity through verification and validation models.
• Develop reports and dashboards to visualize trends, patterns, and predictions based on data sets.
• Develop data warehousing solutions, including data integration, cleaning, and design.
• Prepare and maintain technical documentation and specifications.
• Follow project management standards and best practices.
• Implement processes and policies to ensure data integrity and security.
• Support and guide junior team members on data-related tasks.

Job description

We’re transforming how businesses harness data to drive innovation. We provide scalable data solutions and mission-critical platforms to clients around the globe. We’re looking for a Senior Database Developer who thrives in a fast-paced, collaborative environment and is passionate about designing robust, high-performance data systems.

Position Details:

• SQL Development: Develop SQL scripts and optimize database performance using techniques like indexing, partitioning, and query optimization. Write complex queries, stored procedures, and triggers to support business operations.
• Requirements Gathering: Engage with business stakeholders to collect, document, and review business requirements.
• Database Design and Implementation: Design, implement, and manage complex databases and data structures that meet business needs, considering scalability, reliability, and performance.
• Data Modelling: Understand data modelling concepts and create logical and physical data models to support database design. Maintain data models to ensure data consistency and accuracy.
• Data Migration: Migrate data between sources, ensuring data integrity and accuracy throughout the process.
• Data Management: Manage and maintain large datasets, ensuring data quality, accuracy, and security. Review reports and performance metrics.
• Data Quality Assurance: Ensure data integrity through verification and validation models.
• Reporting and Dashboarding: Develop reports and dashboards to visualize trends, patterns, and predictions based on data sets.
• Data Warehousing: Develop data warehousing solutions, including data integration, cleaning, and design.
• Technical Writing: Prepare and maintain technical documentation and specifications.
• Project Management: Follow project management standards and best practices.
• Data Governance: Implement processes and policies to ensure data integrity and security.
• Mentoring: Support and guide junior team members on data-related tasks.

Qualifications:

• Minimum 6 years of experience in requirements gathering, project management, technical writing, database design and implementation, SQL development on MSSQL platform, reporting/dashboarding using PowerBI, SRSS, and MSSQL, data quality assurance.
• Minimum 3 years of experience in data management, migrations, data warehousing, and data modelling.
• Minimum 2 years of experience in data governance.
• Experience in gathering and translating requirements into technical solutions.
• Mentoring experience and familiarity with cloud database solutions in Azure is an advantage.

Please apply now!