Job Summary The purpose of this position will be to provide technical support to the Payroll team for items such as: SQL Report Writing SQL query writing Extracting data Formula Building Technical Support Qualifications: BSc / BCom Information technology or similar Relevant Microsoft SQL certifications ideal MS Azure Administration (AZ 104) Experience and skills required: Advanced SQL skills - writing complex SQL queries Advanced data manipulation techniques (pivoting and unpivoting data is an advantage) Database Administration - performance monitoring, index maintenance, database optimisation Data Modelling - ability to design and implement logical and physical database models Database Security - ability to implement security measures - user authentication, authorisation and role-based access control Scripting and Automation - T-SQL, PowerShell Data Integration - Knowledge of data integration techniques (ETL), processes and tools like SSIS and familiarity with data import/export, data synchronization, and data cleansing techniques. Azure Cloud - Understanding of Azure SQL Database and its features, such as elastic pools, scaling, and geo-replication. Experience with Azure Data Factory for data integration and orchestration is an advantage Basic understanding of cloud concepts, such as scalability, elasticity, and serverless computing VB.NET/C# Programming advantageous - Experience and proficiency in VB.NET and/or C# programming languages. Understanding of object-oriented programming (OOP) concepts and design patterns. Knowledge of data access technologies like ADO.NET or Entity Framework for interacting with databases.
Elite Search
Recruiter
OR
Job Mail
MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.