Back
Aug 05, 2020

Junior SQL DBA

  • Sanlam Group
  • Bellville, Cape Town, South Africa
Full time Information Technology

Job Description

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 Junior DBA is expected to administer, monitor, and troubleshoot all components of the MSSQL platform including the core database as well as the additional components and functionality. The Junior DBA will also be responsible for security administration as well as administration tasks related to SDLC. The Junior DBA will also be expected to escalate and consult with team members in troubleshooting and improving performance of the DBMS.

What will make you successful in this role?
Responsibilities:

Ongoing maintenance tasks to ensure database system is available
Ongoing maintenance tasks to ensure database system is secure
Ongoing maintenance tasks to ensure database performance
Review and tracking of database performance
Review and tracking of ongoing suspicious transactions on database
Review and tracking of health of underlying operating system
Response to analysis of Incidents of database
Perform patching of database
Escalation of performance, security or availability issues
Deployment of add-ons, plug-ins or enhancements as allowed on the platforms
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
Ensure backups of DBMS or databases take place in line with design
Ensure replication of DBMS or databases take place in line with design
Ensure restore of DBMS or databases are actioned in line with design and policy
Log urgent or complex events or incidents with Database provider ensuring necessary supporting information is available
Ensure data in database conform to Regulations and relevant company policies and the maintenance of data (including data deletion)
Execute process required to promote code and structures between databases in line with SLDC and company policies
Execute refresh of data in Dev and QA databases in line with guidelines
Education

Degree or Diploma or Database Administration certification
Knolwledge

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
nderstanding 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 Queries and Reports
Database Security
Applications Database Knowledge
Data Analysis
Compliance
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
Being resilient - Contributing independently
Collaborates - Contributing independently
Cultivates innovation - Contributing independently
Customer focus - Contributing independently
Drives results - 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.


Apply Now