Senior SQL Dba

1 week ago


Midrand, South Africa Data Centrix Full time

**Qualifications**:

- Matric and IT Diploma/Degree
- MCSE - Certified Solutions Expert.
- Certified Solutions Associate: SQL Server
- Certified IT Professional: Database Administrator

**Functional Support**:

- Oversee the maintenance, configuration, and implementation of everything that has to do with databases.
- Respond to and resolve database access and performance issues.
- Performance troubleshooting with recommended improvements.
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
- Monitor, optimize and allocate physical data storage for database systems.
- Plan and coordinate data migrations between systems.
- Perform database transaction and security audits.
- Establish appropriate end-user database access control levels.
- Develop routines for end-users to facilitate best practices database use.
- Provide solution to any complex IT related challenges in the organization

**Enterprise Tasks**
- Benchmark, analyse and test new technologies.
- SQL flavour requirements, upgrades and downgrades (Enterprise through to Express).
- Data and/or server migrations.
- SQL patching and Rollup installations and planning.
- Facilitate enterprise integrations with SXi and other vendors
- Evaluate new software releases and products.
- Ensure regular updates, plan future rollouts.

**Data Maintenance**:

- SQL server configuration for Data Warehousing and capacity planning.
- Backup and recovery strategies (PIT and PID, Restore point objective and restore time objective).
- Database hardware requirements (Capacity Planning).

**Reporting and Continuous Improvement**:

- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Create, or support creation of, required reports in response to business user needs.
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Keep up with trends in the constantly evolving information technology industry.
- Perform regular IT audit to discover areas of weaknesses and fortify them.

**Administration and Knowledge**:

- High Availability health checks and regular failover tests.
- DMV maintenance Outdated index updates and tuning of existing.
- SQL performance monitoring (General, Locks, Buffer) managers.
- Troubleshoot integration packages execution failure.
- Troubleshoot SSAS packages job failure executed the previous night.
- Review error mails on replication errors and spot check a few instances.
- Keep QA and DEV databases up-to-date with PROD for testing.
- Deploy new/existing code and patches for SQL to running software (C++/C#).
- Storage management (Log and log files that needs shrinking).
- Verify SQL backups to disk.
- Design, architect, and build SQL solutions from determining business requirements.
- Write and troubleshoot complex stored procedures used to manage SQL environments.
- Develop innovation, strategies, processes, and best practices.

**Human Resources**
- Manage and mentor small team of DBAs.
- Work closely with programming staff on database design changes to meet business requirements.
- Delegate duties and tasks within the team
- Review completed tasks to ascertain compliance with standards.



  • Midrand, South Africa Pollock and Associates Full time

    Senior Database Administrator ICT Midrand - Gauteng - South Africa Are you an experienced Senior SQL DBA with a passion for database design, performance optimization, and troubleshooting? Our client is looking for you to take on a challenging and rewarding role reporting directly to the Senior IT Manager. You will have approximately 8 years of experience as...


  • Midrand, South Africa Sabenza IT Full time

    PostgreSQL Operations Specialist DBA (SQL), Database Administrator - IT Menlyn - Gauteng - South Africa, Midrand - Gauteng - South Africa Get your career into gear! Our clients in the Automotive space are looking for a PostgreSQL Operations Specialist to fuel their team! Drift your way across the world and experience a great Hybrid position that comes with...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: To support business and drive growth and profitability through advanced analytics and insights To monitor product performance, and support product development and product enhancements through advanced analytics and insights To highlight process inefficiencies through advanced analytics and insights To make data-driven adjustments through...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: The Senior Specialist: VBCVM Intelligent Selling Capability provides strategic business analysis outputs to VBCVM key stakeholders and directly to the Intelligent Selling Capability Squad. The Senior Specialist: VBCVM Intelligent Selling Capability maximizes the effectiveness of the Product Owner and CVM Leaders by supporting the creation...


  • Midrand, South Africa Premier Full time

    **Purpose of the job**: To create and maintain insightful business reports based on structured and unstructured data by using our online data services and data warehouse or data marts. This includes operation, analytical and predictive reporting. Support the report consumers in the use of these reporting services. To ensure that the reporting services are...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: To re-engineer month-end reporting process through optimised scripting and automation To integrate daily performance into month-end predictions and analytics To radically enhance the month-end analytics through the introduction of anomaly detection To build advanced data models to support critical regulatory & strategy projects To partner...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: Represent their business function on the Data Governance Committee. Involved in making business critical decisions about the data they own. Responsible for data privacy and cyber security assessments. Own the risk of sharing data outside of the organization. Accountable for approving data retention and extensions if required. Accountable...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: With Vodacom Financial Services commitment to pushing the boundaries in Fintech innovation and our recently launched Vodapay app, we are looking for the highest calibre individuals to help drive our reporting and analytics activities within our Consumer Fintech. This role will deliver the analytics and reporting requirements necessary for...

  • Senior Java Developer

    Found in: Talent ZA C2 - 2 weeks ago


    Midrand, South Africa Lim Personnel Full time

    Senior Java Developer - Gauteng (Hybrid role)ESSENTIAL SKILLS REQUIREMENTS:At least 8 years’ worth of experience:Cloud Knowledge in AWS / Azure (Preferable)Java / Java EE / Rest-API / JPAHTML / CSS / Typescript (Javascript) / Angular 4+DPostgreSQL / SQL (JPQL) / ScriptsJenkins / Flyway (DB Migration) / Docker / OpenshiftMicroservices / Integration /...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: The Senior Specialist: Internal Audit, Tech is responsible for executing Technology and Integrated audits and ad hoc management requests across the Vodacom Group footprint in support of strengthening the control environment. The audit work must be performed in line with the Vodacom Internal Audit methodology and professional standards....

  • Database Administrator

    Found in: Whatjobs ZA C2 - 6 days ago


    Midrand, South Africa A 1L Realization (Pty) Ltd Full time

    Database Administrator: We are currently looking for a Database Administrator that will be responsible for the implementation, maintenance, performance, integrity, and security of several Oracle databases. Duties will include the design and creation of databases, planning and maintenance of data configuration, implementation and enforcement of database...

  • Database Administrator

    Found in: Talent ZA 2A C2 - 2 weeks ago


    Midrand, South Africa A 1L Realization (Pty) Ltd Full time

    Database Administrator:We are currently looking for a Database Administrator that will be responsible for the implementation, maintenance, performance, integrity, and security of several Oracle databases. Duties will include the design and creation of databases, planning and maintenance of data configuration, implementation and enforcement of database...

  • Database Administrator

    Found in: Adzuna ZA B C2 - 1 week ago


    Midrand, South Africa Adzuna ZA B C2 Full time

    Database Administrator:We are currently looking for a Database Administrator that will be responsible for the implementation, maintenance, performance, integrity, and security of several Oracle databases. Duties will include the design and creation of databases, planning and maintenance of data configuration, implementation and enforcement of database...

  • Senior Software Developer

    Found in: Talent ZA C2 - 2 weeks ago


    Midrand, South Africa Datacentrix Full time

    Requirements: Relevant IT Diploma/Degree 7 years solid experience in Microsoft C# .NET. Latest web technology (HTML5 – native web components, JavaScript (ES6+), CSS3+, Bootstrap3+, MVC4+. C++, Java, SignalR, Entity Framework 7 years experience in web back-end technologies - SOAP, WCF. 7 years experience in relational database queries and stored...


  • Midrand, South Africa Markalao Recruitment Full time

    **Description**: Advanced financial modelling: develop statistical models that can be used to quantify the correlation between risk and overall portfolio dynamics (i.e. migrations, volume/balance transitions between the respective collections states, overall risk emergence, etc.); cash-flow forecasting on existing and expected new sales portfolios....


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: Responsible for ensuring high data quality and performance in all D&A data solutions through SQL standardization, driving use of version control and designing and implementing DQ controls in reporting scripts. Support adhoc business requests for data analysis where data is not available in central data lake environments. Responsible for...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: The senior data intelligence specialist role focuses on the development and implementation of advanced data analytics and data intelligence solutions enabling data-driven decision-making, uncovering hidden insights, and identifying opportunities for growth and operational improvements across various business functions. This role ensures...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: Manage and deliver customer life cycle programs and activities in order to maximize the customer lifetime value of the enterprise customers (revenue / margin). Develop and manage bundle engagement programme using triggers and behavioural analytics Plan, design and execute direct marketing campaigns Research and develop methods for measuring...


  • Midrand, South Africa Vodafone Full time

    **Role purpose**: The senior business intelligence specialist has an end-to-end ownership responsibility for the development, implementation, and management of business intelligence solutions related to the Tower Company Internet of Things (IoT) platform, while leveraging the IoT platform by transforming raw data into actionable information through...


  • Midrand, South Africa AdaptIT Full time

    **Listing reference**: adapt_000130**Listing status**: Online- **Position summary** **Industry**:IT & Internet - **Job category**:IT and Telecommunications**Location**:Midrand - **Contract**:Fixed Term Contract**EE position**:Yes**About our company** - A provider of leading specialised software and digitally-led business solutions that assist clients across...