Snr Database Administrator
3 weeks ago
**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 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.
- The DBA will also do monitoring, maintenance and operational support of SQL BI environment and deployments of SSIS, SSRS, PBI, SSAS in various environments.
- The DBA will support and further enhance ETL, Reporting and Analysis processes as required for the companies Internal Data Platform. The Internal Data Platform comprises of centralizing Data Consumption, Capacity Management and Billing in regard to companies Services.
**What will make you successful in this role?**
- DBMS Knowledge
**MS SQL**
- 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 SQL 2012 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
**MS Business Intelligence**
- GIT: Knowledge of code repositories and code management and their integration into IDE such as Visual Studio 2019
- Visual Studio IDE knowledge in regard to BI tool-sets (SSIS, SSRS, Database Projects)
- SSIS: Support and develop project or package model ELT processes. Deploy to SSISDB\Catalog and environments.
- SSRS: Support and develop SSRS paginated reports with particularization and integrate with stored procedures.
- SSAS: Support and develop tabular or dimensional models and deploy these models to environments.
- PBI: Support and develop PBI Models and deploy to various environments.
**Core outputs**
**Responsibilities**
- Complete Jira development requests for SSIS SSRS SSAS PBI processes where required in the (IDP) Internal Data Platform with regards to Data Consumption, Capacity management and Billing pipelines.
- Handle incident and support request with regards to SSIS SSRS SSAS PBI in the various environments.
- Deploy via change management processes, changes to SSIS SSRS SSAS PBI environments for our clients
- 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 recover-ability, 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
-
-
Senior Database Administrator
2 weeks 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
2 weeks 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...
-
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...
-
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...
-
Intern : SAP Hana Database Administrator
4 days ago
Bellville, South Africa Sanlam Full timeWhat will you do? Summary The SAP HANA DBA is expected to administer, monitor, and troubleshoot all components of the SAP HANA Platform including the core database as well as the additional components and functionality. The SAP HANA DBA will also be responsible for security administration as well as administration tasks related to SDLC. The SAP HANA DBA will...
-
Bellville, South Africa Progressive IT Resourcing Full timeThe SQL Operational Database Administration Manager must be **People Orientated** - Prioritization of operational work delegated to the team - Managing workload in the team - assign tasks - Reviews and evaluates Teamwork and prepares performance agreements - Train and mentor junior team members on process and technology. - Cross skilling - enable everyone...
-
Junior SAP Hana Database Administrator
3 days ago
Bellville, South Africa Progressive IT Resourcing Full time**Our Client** This division 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...
-
Bellville, South Africa Sanlam Full timeWhat will you do? The SQL Operational Database Administration Manager is responsible to manage a team of SQL Database Administrators and Specialist which may be of Senior, Intermediate and Junior levels. The manager must be familiar with the general concepts of database management and is expected to manage across platforms and not be specific to a specific...
-
Intern : IBM Guardium Database Administrator
4 days ago
Bellville, South Africa Sanlam Full timeWhat will you do? Purpose of the role The Junior IBM Guardium Administrator is expected to administer, monitor, and troubleshoot components of the IBM Guardium Database Access Monitoring platform. The Junior IBM Guardium Administrator will also be responsible for security administration as well as administration tasks related to database access reviews. The...
-
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...
-
SQL Db Administrator
2 weeks ago
Bellville, South Africa Sanlam Full timeWho 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
3 months ago
Bellville, South Africa Legates Group Full timeA SAP Administrator plays a critical role in managing and maintaining SAP systems within an organization. The primary responsibilities, skills, and qualifications for this position typically include the following: Job Title: SAP Administrator Job Overview: Key Responsibilities: - **System Installation and Configuration**: - Manage system landscapes,...
-
Tracking Administrator
5 days ago
Bellville, South Africa CAR AUDIO WAREHOUSE Full timeWE ARE CURRENTLY IN THE MARKET TO EMPLOY A TRACKING ADMINISTRATOR. JOB RESPONSIBILITIES BUT NOT LIMITED TO: - SCHADULING TRACKING FITMENTS FOR TECHNICIANS. - CALLING AND LIASING WITH CLIENTS. - CHECKING STOCK. - ASSISTING WITH OFFICE DUTIES. - MAINTAIN RECORDS/ DATABASES/ FILING SYSTEMS. QUALIFICATION: - MATRIC - KNOWLEDGE OF ADMINISTRATIVE SERVICES. -...
-
Office and Administration Manager
7 months ago
Bellville, South Africa JSM Business Services Full timeOur client, an Electrical and Mechanical Engineering firm that provides safe and profitable engineering and renewable energy solutions, wants to appoint an experienced Office and Administration Manager. Duties and responsibilities: - Being the face of the business in the front of house - Answer phone calls and greet guests - Arrange and manage travel,...
-
Office and Administration Manager
7 months ago
Bellville, South Africa JSM Business Services Full timeOur client, an Electrical and Mechanical Engineering firm that provides safe and profitable engineering and renewable energy solutions, wants to appoint an experienced Office and Administration Manager. Duties and responsibilities: - Being the face of the business in the front of house - Answer phone calls and greet guests - Arrange and manage travel,...
-
Sales Account Administrator
7 months ago
Bellville, South Africa Pepkor Speciality Full timeSPCC, a division of Pepkor Trading (Pty) Ltd, is looking for a superstar Sales Account Administrator to join our dynamic team! You'll be the backbone of our sales force, providing critical administrative and organizational support to our Sales Account Manager. **Key Responsibilities**: - Track orders and ensure efficient processing - Coordinate with...
-
Administration Manager
7 months ago
Bellville, South Africa The Joblink Full timeContact person for this position: Ronel Bakker Job overview My client in the wholesale bakery industry, is looking for an experienced Administration Manager to join their team in Bellville. Areas of Responsibility (Your duties will include but are not limited to) - General administration duties as required, filing, invoicing, calls to clients,...
-
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...
-
Administrator (Cipc & Sars)
2 weeks ago
Bellville, South Africa Company Partners Full timeCompany Description Company Partners is an Online 1-stop-machine for start-up businesses who over the past 5 years, have served more than 15000 clients, of which 20% purchase additional services after 1 year, and a further 10% invested in monthly subscription packages. Company Partners holds South Africa’s largest variety of compliance services with over...
-
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...