SQL Db Administrator
4 days ago
Who are we?
Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology governance and risk orchestrator for technology across Sanlam. What will you do?
The Senior SQL DBA is expected to design, install, configure, administer, monitor, and troubleshoot all components of the SQL 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 Senior 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 Senior DBA will further be required to direct the tasks of other DBAs although the actual management of the members is not required. The Senior DBA will act as the expert for a specific database system and will unsure design of the database system, supporting database systems as well as the processes to support the database system. The Senior DBA is expected to perform research on industry trends related to the SQL DBMS to improve Sanlam systems. 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
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
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 the Application Development Life Cycle and development approaches like Agile Qualifications
Matric
Degree or Diploma in Information Technology
Database Administration Certification Knowledge and Experience
Working knowledge of SQL Server, Sound working knowledge of the operating system SQL reside on and SQL’s usage of underlying infrastructure.
Knowledge and understanding of general database concepts
Understanding up to SQL Server 2019
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 experience in IT Data Analysis
Knowledge and experience in working with Database Security
Knowledge and experience in Project Coordination
Knowledge and experience in IT Risk Management
At least 7 - 8 years of experience as a SQL DBA in a large enterprise environment
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, lasti
-
Database Administrator
7 months ago
Bellville, South Africa Hr Legend Full time**DATABASE ADMINISTRATOR - SQL (Bellville, Cape Town)** Market related package with benefits Bellville, Cape Town **REQUIREMENTS**: Minimum: - Grade 12 - Relevant tertiary qualification i.e. Bachelors Degree in a computer discipline or relevant SQL certification - 5 years of experience as a SQL Server DBA or similar role - 5 years of experience with...
-
Ops Spec: Database Administrator
7 months ago
Bellville, South Africa BCXP Full timeStructure, Grade & Reporting Job grade/level S6 Business Unit Digital Platform Solutions Business Unit Digital EXA Position reports to Manager: Delivery Span of Control 0 Level of Engagement Client, Employees and Line Manager Core Description To provide a stable and secure production database environment which performs in alignment with predefined standards...
-
Senior Database Administrator
1 week ago
Bellville, South Africa CareerfinderZA Full timeKey Performance Area: - Oversee all data generated, monitor server transaction speeds, and look for any service degradation in speeds due to SQL fragmentation or lack on maintenance - Oversee all SQL instances and databases - Ensure all databases of the same platform is up to data and the same - Ensure data is accurate and integrity is maintained with SQL...
-
Ops Spec: Database Administrator
1 week ago
Bellville, South Africa BCXP Full timeStructure, Grade & Reporting Job grade/level S6 Business Unit Digital Platform Solutions Business Unit Digital EXA Position reports to Manager: Delivery Span of Control 0 Level of Engagement Client, Employees and Line Manager Core Description To provide a stable and secure production database environment which performs in alignment with predefined standards...
-
Snr Database Administrator
2 weeks ago
Bellville, South Africa Progressive IT Resourcing Full time**What will you do?** - The DBA will 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...
-
Api Integration Specialist Ref: Zr
2 days ago
Bellville, South Africa Progressive IT Resourcing Full time**Permanent, Cape Town** **ROLE RESPONSIBILITIES** - Previous work experience in an Integration and/or API gateway platform - General understanding of good API Management practices - Ensuring stability in the API integration platform through appropriate DevOps practices (documentation, monitoring, performance monitoring, automated deployment, CI/CD...
-
Oracle Database Administrator
2 months ago
Bellville, South Africa Sanlam Full time**Who are we?** Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...
-
SAP Administrator
1 month ago
Bellville, South Africa Legates Group (pty) ltd Full time**Key Responsibilities**: - Collaborate with warehouse operations and IT teams to identify, analyze, and resolve SAP-related issues promptly. - Implement system enhancements and upgrades, ensuring mínimal disruption to operations and compliance with best practices. - Monitor system performance and conduct regular system audits to ensure data integrity and...
-
People Support Systems Administrator
7 months ago
Bellville, South Africa HR Talent Partner Full time**Job Overview**: **Date Posted**: Posted 2 days ago- **Location**: Bellville, Western Cape- **Job Title**: People Support Systems Administrator- **Education Level**: Bachelors Degree- **Job Level**: Intermediate- **Minimum Experience**: 3 - 5 Years**People Support Systems Administrator - Bellville, Cape Town.**: A renowned Cosmetics Company is looking for a...
-
Senior Tech Lead
2 weeks ago
Bellville, South Africa Sanlam Full timeWho are we? Sanlam Life and Savings (SLS) is focused on serving our retail and corporate clients in South Africa and further developing our strategic advantages in the South African market. Sanlam Life and Savings consists of three clusters - Sanlam Corporate, Sanlam Retail Mass and Sanlam Retail Affluent. The Sanlam Life and Savings Office provides...
-
Associate Architect
2 weeks ago
Bellville, South Africa Sanlam Full timeWhat will you do? Support all Architect domains and rotate between all Technical Domains: Infrastructure, Application Dev, Data, Security, Business. Provide backup to existing Architects to maintain Business delivery and continuity. - Support all Development, Data Engineering and Technical Agility teams with any Technical issues and solutions required....
-
Database Administrator
7 months ago
Bellville, South Africa Sanlam Full time**Who are we?** Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...
-
BI Dba Integration Specialist
15 hours ago
Bellville, South Africa Progressive IT Resourcing Full time**Meta Lake Data Management & Data Quality** As BI DBA Integration Specialist you will source relevant master data sources as required by service lines to land via SQL Service Integration Services into “Meta Lake” DBMS. You will document source data and Data Quality Requirements to be applied to daily DQS runs and report on data quality issues to the...
-
BI Dba Integration Specialist
15 hours ago
Bellville, South Africa Sanlam Full timeWhat will you do? Meta Lake Data Management & Data Quality As BI DBA Integration Specialist you will source relevant master data sources as required by SGT service lines to land via SQL Service Integration Services into “Meta Lake” DBMS. You will document source data and Data Quality Requirements to be applied to daily DQS runs and report on data...
-
Senior Data Analyst
7 days ago
Bellville, South Africa Momentum Metropolitan Holdings Full time-Introduction Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. Role Purpose Providing the business with...
-
IT Infrastructure Specialist
3 months ago
Bellville, South Africa Cape Peninsula University of Technology Full timeFaculty- Department- Cape Peninsula University of Technology -> Computer & Telecom Services- Campus/ Location- Bellville Campus - Bellville, Cape Town, WC ZA (Primary) - Job Type- Permanent- Occupational Function- Support / Admin- Number of Positions- 1- Annual Salary Package (incl. Medical Aid rate based on principal member only)- To be confirmed- Advert...
-
Application Support It
4 days ago
Bellville, South Africa CX-International Full time**Purpose of the Role** As part of this function working overtime from time to time is necessary in this role. **Role and Responsibilities** - A good IT technical knowledge across multiple areas to enable quick and accurate diagnosis of problems. - Ensure all system changes are undertaken to agreed standards of quality, service, procedures and security. -...
-
Iwms Specialist
6 months ago
Bellville, South Africa Excellerate Full timePosition title : IWMS Specialist Position reports to : Head of BI & Analytics Business Unit : Operations **Main purpose / objective of the position**: As an IWMS Specialist, you will be required to configure, customize, and integrate methods of Integrated Workplace Management Solutions (IWMS), including Planon (a fully web-based solution that allows...
-
BI Analyst
4 months ago
Bellville, South Africa University of the Western Cape Full timePost Number- 8027357- Faculty/Department- University of the Western Cape -> ICS Department -> Applications Development and Support- Type of Position- Permanent - Full Time- Length of Contract Period- Location- Main Campus - Bellville, WC ZA (Primary) - Closing Date- 13/10/2024**Role Clarification & Key Performance Areas** The University of the Western...
-
Analyst Programmer
4 months ago
Bellville, South Africa University of the Western Cape Full timePost Number- 8036586- Faculty/Department- University of the Western Cape -> ICS Department -> Applications Development and Support- Type of Position- Permanent - Full Time- Length of Contract Period- Location- Main Campus - Bellville, WC ZA (Primary) - Closing Date- 13/10/2024**Role Clarification & Key Performance Areas** The University of the Western...