SQL DB Administrator (Re Run)

Apply now »

Date: 10-Jun-2021

Location: Bellville, Western Cape, South Africa

Company: Sanlam Group

Who are we?

Sanlam Group Technology and Information (GTI) is responsible for Group-wide Technology and Information Governance, Technology Architecture oversight and guidance as well as the Group’s Cyber Security oversight and governance.  GTI is also responsible for IT Shared services to businesses in the Group which is provided through three units namely Infrastructure-, Application- and Security shared services. The shared service business model is based on commercial principles and the foundation of the model is a constant drive for consolidation, standardisation, automation and optimisation.  As such, GTI has accountability for the design and implementation of agreed IT controls, governance frameworks, policies, standards and solutions to ensure business continuity and minimise information security risks.

What will you do?

The DBA is expected to design, install, configure, administer, monitor, and troubleshoot all components of the MSSQL platform including the core database as well as the additional components and functionality. The DBA will also be responsible for security administration as well as administration tasks related to SDLC. The DBA will also be expected to consult with developers and other parties to ensure the appropriate design and implementation in line with business requirements. The DBA is expected to continuously improve knowledge on the use and operation of the MSSQL DMBS system.

What will make you successful in this role?

Responsibilities:

  • Implementation of New Databases in line with design, including installation of DBMS
  • Assistance with database design together with Client
  • Design of supporting functions to ensure a functioning database (e.g. backup, replication, patching)
  • Design of supporting processes to ensure a functioning database (e.g. user access, performance monitoring
  • Response to analysis of Incidents of database
  • Perform patching of database
  • Troubleshooting of incidents and events up to second level
  • Escalation of performance, security or availability issues
  • Engage database vendor on troubleshooting urgent or complex incidents or events and troubleshoot till resolution
  • Responsible for the definition, creation and maintenance of Client application database structures 
  • Analyze, test, and implement physical database designs supporting business applications.
  • Ensure data recoverability, database availability, data integrity, agreed level of performance and capacity planning for physical databases.
  • Research on latest practices related to the deployment and support of DBMS
  • Ensure maintenance plans and documentation are in place, re-visited and updated at least once quarterly or after changes impacting the application area.
  • DBA performance enhancements
  • Process enhancements and improvements in supporting the database
  • Assist overall troubleshooting and incident resolution on group wide outages.
  • Ensure documentation of database design and work practices (e.g. DR design, database design, installation instruction)
  • Reference best practices of DBMS reference documentation
  • Establish and execute policies to ensure data in database conform to Regulations and relevant company policies and the maintenance of data (including data deletion)
  • Create database scripts to assist in the operation of the database
  • Troubleshoot Security administration components including LDAP and Kerberos
  • User and security administration on the DBMS
    • Create and change users, assign and remove role assignments, perform password resets, lock and unlock accounts.
    • Create and change security roles by adding and removing relevant permissions
    • Create, change and troubleshoot analytical privileges (data dependent authorizations) 
    • Troubleshoot security issues 
    • Log reviews and ongoing reviews of user privileges to databases
  • Design and execute process required to promote code and structures between databases in line with SLDC and company policies
    • Create design and execute instructions for refresh of data in Dev and QA databases
  • Design, and set up of monitoring tools of the DBMS
  • Support application development teams in choosing and configuring database correctly in support of application performance and security
  • Support the Application Development Life Cycle and development approaches like Agile

Education

  • Database Administration certification

DBMS Knowledge

  • Working knowledge of SQL Server, Sound working knowledge of the operating system SQL reside on and SQL’s usage of underlying infrastructure.
  • Knowledge of general database concepts
  • Understanding up to SQL Server 2017
  • Working knowledge and understanding of SQL2012 to 2019
  • Working knowledge and sound understanding of all available products, services and resources in the SQL Server suite of products
  • Knowledge to advise and execute on integration to the MS SQL environment including REST, SOAP, ODBC, JDBC, ODBO and other MSSQL supported connectors.
     
Knowledge and Skills
Database Knowledge
IT Data Analysis
Data Security
Risk Management
Reporting and Administration
Personal Attributes
Interpersonal savvy - Contributing independently
Decision quality - Contributing independently
Plans and aligns - Contributing independently
Optimises work processes - Contributing independently
Build a successful career with us

We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping  our employees to realise their worth. Through its business clusters – Sanlam Personal Finance, Sanlam Emerging Markets, Sanlam Investments, Sanlam Corporate, Santam, Miway, as well as the Group Office – the group provides many opportunities for growth and development.

Core Competencies
Cultivates innovation - Contributing independently
Customer focus - Contributing independently
Drives results - Contributing independently
Collaborates - Contributing independently
Being resilient - Contributing independently
Turnaround time

The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers. 

Our commitment to transformation

The Sanlam Group is committed to achieving transformation and embraces diversity.  This commitment is what drives us to achieve a diverse, inclusive and equitable workplace as we believe that these are key components to ensuring a thriving and sustainable business in South Africa.  The Group's Employment Equity plan and targets will be considered as part of the selection process.