The overall purpose is to design databases and ensuring their stability, reliability and performance.Work closely with other engineers optimizing in application SQL statements as necessary, andestablishing best practices.
Assist in solving database usage issues and advise on how to avoid anyproblems in the future. DUTIES AND RESPONSIBILITIES :
Development of high-quality database solutions.
Develop, implement and optimize stored procedures, functions and views using T-SQL.
Develop database schemas, tables and dictionaries.
Review and interpret ongoing business report requirements.
Research required data to identify the source of the data. Collaborate with the SoftwareEngineers.
Perform code reviews of SQL, SSRS and Power BI.
Build appropriate and useful reporting deliverables using SSRS and Power BI.
Analyse existing SQL queries and procedures for performance improvements.
Implement indexing and other techniques to improve database and report performance.
Maintain data quality and oversee database security.
Resolve and troubleshoot complex issues.
Adhere to Microsoft SQL best practices.
Create ad hoc data extracts using T-SQL.
Develop packages and scripts for ETL and data migration using T-SQL and SSIS.
Perform implementations / execute scripts in a production environment.
Support Software Engineers to optimize in-application SQL statements.
Occasionally assist with database administration tasks.
Employ and assist in development of best practices for database design and developmentactivities.REQUIRED SKILLS / EXPERIENCE & QUALIFICATIONS
At least 6 years’ experience as a SQL Engineer.
Excellent understanding of T-SQL programming.
Bachelor’s Degree in Computer Science or related subject.
Excellent understanding of Microsoft SQL Server.
Exceptional knowledge of Microsoft SQL best coding practices.
Experienced in working with production environments, dealing with risks, challenges andprocedures associated with production implementations.
Familiar with tools that can aid with profiling server resources usage and optimizing it.
Some C# programming experience within SSIS packages.
At least 2 years’ experience with Power BI and DAX.
At least 5 years’ experience with SQL Server Integration Services.
At least 5 years’ experience with SQL Server Reporting Services.
Some experience with SQL Server Analysis Services.
Experience with Source Control Systems like Git.
Familiarity with NoSQL databases like Cosmos DB or MongoDB.
Experience with Microsoft Excel.
Database Administration experience advantageous.
Experience with Azure advantageous.
Sense of ownership and pride in your performance and its impact on company’s success.
Critical thinker and problem-solving skills.
Good time-management skills.
Great interpersonal and communication skills. Please note that by submitting your personal information to Deka Minas you free-willingly issue the business consent to make use of such data for the specific purpose of securing you either permanent or temporary employment.
Our business makes use of a POPIA compliant database and you have the right to access, right to correction and right to deletion of your personal information