Sql Technical Specialist / Bi Developer

South Africa, South Africa

Job Description


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

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1247721
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    South Africa, South Africa
  • Education
    Not mentioned