
Website Sanlam
Job Description:
Sanlam Developing Markets [SDM] (a wholly-owned subsidiary of Sanlam Life Limited) is one of the top financial services providers in the South African entry-level and emerging middle market. It aims to understand the unique requirements of clients and offers a wide range of simple and affordable financial solutions that cover needs such as funeral insurance, savings for education, life cover and personal accident plans. In terms of the Sanlam Group Governance Policy, SDM is managed by the SA Retail Mass cluster, which is part of the Sanlam Life and Savings cluster within the Sanlam Group. The cluster focusses on retail porducts, as well as group schemes.
Job Responsibilities:
- Enabling business
- Responsible for supporting the business by ensuring that all SQL environments are running optimally
- Take responsibility for capacity management and performance tuning of a database
- Security and risk management of the SQL estate
- Communication
- Interface with multiple business users across the organization.
- Work closely with the development teams – assist with any queries (performance tuning, best practices, troubleshoot logic issues etc)
- Coaching
- Review team members’ code and advise on enhancements
- Assist with up skilling team members by assisting Jnr staff, system analysts, and application developers and showcasing new and interesting technologies/methodologies
- Deployments
- Ensure stable releases to Test and/or Live environments.
- Manage ETL environment, assist in project deployments
Job Requirements:
- Matric
- Relevant tertiary qualifications
- Minimum 10 years extensive working experience in a SQL DBA role
- Must have work experience with SQL security and a very good understanding on how to design and implement security roles for enterprise type databases
- Must have experience in designing and building large/high volume transactional and analytical Databases
- SQL SSAS deployment, security models and design knowledge are advantageous
- Extensive knowledge of SSRS, SSAS, T-SQL and SSIS.
- A solid understanding of how the SQL engine works
- Solid understanding of performance tuning principles within SQL, SSAS, SSRS.
- SQL High availability experience is critical. 5+ years of experience on SQL HA.
- Must have SQL performance tuning experience on large systems
- Must have solid T-SQL development skills.
- Must have 2-3 years team lead/management experience, leading SQL DBAs
- Degree or Diploma with 10 to 12 years related experience.
- Database Knowledge
- IT Data Analysis
- Data Security
- Risk Management
- Reporting and Administration
Job Details:
Company: Sanlam
Vacancy Type: Full Time
Job Location: Johannesburg
Application Deadline: N/A
jobstrivia.xyz