REF # 20161
Views:

 191 total views,  2 views today

Location:
Cape Town

SQL Tech Lead (AA Only)

Enquire / Apply
ENVIRONMENT:
Your strong leadership & technical expertise as a SQL Tech Lead is sought by a renowned Investment Firm to join a team with a mission to provide innovative and effective long-term solutions ensuring stability, consistency and scalability. Your core role will be to manage the technical aspects of the solution delivery & systems as well as the Devs within the domain, whilst also making a personal contribution to tech solutions. You must possess a Degree/Diploma in Computer Science/Computer Engineering/Information Systems or related discipline, 8 years’ Development experience, exceptional skills in writing SQL for Microsoft SQL Server, including Stored Procedures, UDF’s and other T-SQL Querying, SSIS, SSAS, SSRS, Power BI & have successfully managed a development team. Please note this is an Employment Equity position ONLY.
DUTIES:
  • Manage the technical aspects of the solution delivery and systems within the domain.
  • Understand the focus and direction of the business area; prioritising and driving delivery that helps to achieve this.
  • Define the technical direction for the domain and ensure design of solutions and delivery.
  • Work closely with the Domain Owner of the domain.
  • Involvement in the running of the domain, including sprint planning, design, drive delivery, retros, understanding root cause of issues/instability.
  • Responsible for the quality of technical solutions, maintenance of standards and managing impact/risk introduced by changes across domains.
  • Review code and approve changes before deployment to production.
  • Assist with technical analysis, root cause analysis and design preventative actions.
  • Oversee the choice of application and approach to development for the delivery of new system/technical solutions by the developers.
  • Work with the Architect, other Tech Leads and Development Manager to understand and drive the strategic direction of the technologies within Institutional IT.
  • Ensure domain technical direction is aligned with overall tech direction/architecture for Institutional IT, and overall tech direction caters for needs of the domains.
  • Identify areas for continuous improvement of both systems and architectural standards and help drive implementation.
  • Timeous, clear tracking, management and appropriate escalation of issues and risks.
  • Ensure systems documentation for support are produced as required.
  • Ensure a stable and sustainable technical platform is in place to support the business area.
  • Manage the developers in the domain.
  • Lead a team of developers (+/- 5 developers) in the domain, according to skill set.
  • Carry out all aspects of people management i.e. staff performance appraisals, approve leave, recruit, train, develop and mentor staff.
  • Responsible for assigning work to the developers, determining estimates, overseeing technical design and driving delivery according to our SDLC procedures and standards.
  • Ensure the correct technical skills are in place in the domain to meet business needs.
  • Make a personal contribution to technical solutions.
  • Develop key solutions that add to the central technical stack or contribute to initiatives.
REQUIREMENTS:
Qualifications –
  • Degree or Diploma in Computer Science, Computer Engineering, Information Science or related technical discipline.
Experience/Skills –
  • At least 8 years’ worth of professional development experience – able to perform at a Senior Developer level.
  • Managing a development team and driving team delivery.
  • Knowledge of Computer Science fundamentals in Object-Oriented design, data structures and algorithms.
  • Experience interacting with business users to understand their requirements and managing the implementation of system changes.
  • Exceptional skills in writing SQL for Microsoft SQL Server, including Stored Procedures, UDF’s and other T-SQL Querying.
  • Analysing data and performing complex data manipulation using Microsoft SQL.
  • Data integration, validation and reconciliation (SSIS or similar).
  • Creating and maintaining cubes (SSAS).
  • Expert knowledge of reporting technologies (SSRS, Power BI or similar).
  • Design and implement relational and dimensional database structures.
Advantageous –
  • Experience working in AWS Cloud implementation.
  • Exposure to PostgreSQL.

    While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.

     

    COMMENTS:

    When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence.

Tags
Affirmative Action, Degree, Permanent

Please complete the following form.

Upload Your CV (MS Word)