Database Adminstrator
3 weeks ago
Database Administrator - Support Office - IS & T
The Building Company
2024/12/17 Airport Industria
Job Reference Number: 4032906001
Department: Corporate Office - IS & T
Industry: Information Technology
Job Type: Permanent
Positions Available: 1
Salary: Market Related
The purpose of this role is to manage, maintain, and support the Microsoft SQL Server environment within the IS / IT environment and the business by leveraging your skills in SQL scripting, data architecture methodologies and best-practices, as well as big-data to provide accurate datasets to a multitude of systems and applications, assisting our stakeholders with decision-making.
Job Description- SQL Servers and Database management: Manage and maintain SQL Server/s and database/s within development and production environments.
- Configure and optimize database servers: Responsible for configuring and optimising database servers and related processes to ensure high availability, performance, and on-going operations of the SQL environment.
- Patch maintenance: Perform scheduled maintenance and routine patching and upgrades from time-to-time.
- Process refinement: Automate and refine processes, track issues, and document environment configurations and changes.
- Monitor relevant environments: Contribute to the maturation of proactive monitoring of the relevant environments to prevent issues from occurring in future.
- Report writing: Responsible for reporting on SQL scripting, SSIS, SSRS.
- Facilitating with 3rd parties: Facilitating resolution of bugs and issues identified in SQL scripting, SSIS, SSRS applications and environments with 3rd parties.
- Data modelling: Ensure development and implementation efforts meet integration and performance expectations.
- Customer Service: Provide support for critical production systems and end-of-day processing.
- To uphold and promote the company values and culture.
- Grade 12
- MCSA: SQL Server 2012/2014 or later
- MCTS, MCITP certification (advantageous)
- Minimum of 5 years' experience administering Microsoft SQL Servers and databases; SQL scripting; big-data and business intelligence applications such as Qlik and IBM COGNOS.
- Experience with backups, restores, and recovery models.
- Experience with Performance Tuning and Optimization (PTO) using native monitoring and tooling.
- Experience working with Kerridge Commercial Systems ERP (advantageous).
- Experience working with Windows Server, Active Directory, and Azure (advantageous).
- Experience with scripting languages such as C#, C++, Java (advantageous).
-
Database Adminstrator
2 weeks ago
Cape Town, Western Cape, South Africa The Building Company Full timeSQL Servers and Database management: Manage and maintain SQL Server/s and database/s within development and production environmentsConfigure and optimize database servers: Responsible for configuring and optimising database servers and related processes to ensure high availability, performance, and on-going operations of the SQL environmentPatch maintenance:...
-
Adminstrative/Accounts Clerk
1 week ago
Cape Town, Western Cape, South Africa Buenos Aires Marriott Full timeAdminstrative/Accounts Clerk - Protea Hotel Fire & Ice by Marriott Cape Town3 days ago Be among the first 25 applicantsPosition SummaryEnter and retrieve information contained in computer databases using a keyboard, mouse, or trackball to update records, files, reservations, and answer inquiries from guests. Transmit information or documents using a...
-
Administration Clerk
2 weeks ago
Cape Town, South Africa Truworths Full timeAt Truworths, you'll find a dynamic business environment where our staff is constantly challenged to reinvent the way we do business in order to keep us at the forefront of the South African fashion industry. Truworths Design Division has an exciting opportunity for an Admin Clerk. Purpose of the role: To ensure all invoices and credit notes are captured for...