Senior SQL Dba

2 weeks ago


Midrand, Gauteng, 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 enduser database access control levels.
  • Develop routines for endusers 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 uptodate 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, Gauteng, South Africa Pollock and Associates Full time

    Senior Database Administrator ICTMidrand - Gauteng - South AfricaAre 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 a...


  • Midrand, Gauteng, South Africa Sabenza IT Full time

    PostgreSQL Operations Specialist DBA (SQL), Database Administrator - ITMenlyn - Gauteng - South Africa, Midrand - Gauteng - South AfricaGet 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 the...

  • Senior BI Analyst

    2 weeks ago


    Midrand, Gauteng, South Africa JSRH Solutions Full time

    We are hiring: Senior BI AnalystLocation: Midrand, GautengWorking Model: On SiteThe BI Analyst is responsible for turning data into information, information into insight, and insight into business decisions. Responsibilities include conducting full life-cycle activities for business intelligence, from requirementanalysis and design of key business metrics to...


  • Midrand, Gauteng, South Africa Vodafone Full time

    Role purpose:As a Senior Specialist Prepaid Analytics and Commercial Management your role will require you to work closely with various stakeholders to assist in conceptualisation campaigns and products and analysing direct marketing campaigns, as well as to identify and present results. Your role will also require you to analyse competitor activities and...


  • Midrand, Gauteng, 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 of user...

  • Senior Java Developer

    2 weeks ago


    Midrand, Gauteng, 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, Gauteng, 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 for data...


  • Midrand, Gauteng, 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 for data...

  • Senior Manager

    2 weeks ago


    Midrand, Gauteng, South Africa Markalao Recruitment Full time

    Purpose of the RoleDisplay a good understanding of the transitioning of Late-Stage accounts into (Legal, EDC collections, Tracers, Litigation, Debt Counselling, Insurance, Prescription, In-duplum, Write off and Debt Sale). Ensure delinquency, flow and recovery targets for the Late-Stage portfolio are consistently achieved. Set targets and identify key...

  • Senior Data Analyst

    2 weeks ago


    Midrand, Gauteng, South Africa SavageOne Pty Ltd Full time

    Experience: 8+ yearsStart Date: ImmediateApply only if you possess the following skills within the Insurance and Finance sector:These skills are mandatory for the role.SkillsDatabrix - Compulsory Spark Framework - required ETL - required Scripting - required SQL - required Python - required AWS - required SAS - required Job Description:We are seeking an...


  • Midrand, Gauteng, South Africa Recru-it Full time

    African, Indian and Coloured - preference African candidatesNon-negotiables: Advanced proficiency in multiple programming languages such as Java, C#, Golang, Python and SQL.Advanced experience in one or more of the following database technologies: Postgres, Mongo, Redis, DB2, MS SQL, OracleDeep technical knowledge and an understanding of diverse...

  • Senior Data Analyst

    2 weeks ago


    Midrand, Gauteng, South Africa SavageOne Pty Ltd Full time

    Experience: 8+ yearsStart Date: ImmediateApply only if you possess the following skills within the Insurance and Finance sector:These skills are mandatory for the role.SkillsDatabrix - Compulsory Required 4 Years Spark Framework - Required 4 Years ETL - Required 4 Years Scripting - Required 4 Years SQL - Required 4 Years Python - Required 4 Years AWS...


  • Midrand, Gauteng, 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, Gauteng, South Africa Vodafone Full time

    :When it comes to putting people first, we're number 1.The number 1 Top Employer in South Africa.Certified by the Top Employer Institute 2024.Role Purpose/Business Unit: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...


  • Midrand, Gauteng, 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. Following...


  • Midrand, Gauteng, South Africa Carlysle Human Capital Full time

    Key Responsibilities:Develop and upkeep Smartsheet applications.Apply JavaScript and Microsoft SQL for application development purposes.Execute solutions utilizing Power Apps and Power BI.Collaborate with cross-functional teams to gather requirements and formulate solutions.Deliver solution presentations to clients, demonstrating clear and confident...

  • Senior Developer

    2 weeks ago


    Midrand, Gauteng, South Africa XET SOLUTIONS Full time

    Join Our Team as a Java Developer!We are seeking a proactive individual to handle operating and business model analysis, collaborating with other business entities, creating capability maps, assisting in technology enablement, and more.Qualifications:National Diploma in IT, IS, or Computer EngineeringValid Java CertificateExperience Required:Minimum of 5...


  • Midrand, Gauteng, South Africa Vodafone Full time

    Role purpose:To ensure that user requirements for the business are documented, developed, and delivered on.Your responsibilities will include:Solution Design & ArchitectureDesign / Architect / Implement Solutions and Develop Blueprints too:Technology - Cloud Automation: Applications will utilize the DevOps tool chain to ensure automation and rapid deployment...


  • Midrand, Gauteng, South Africa MiWay Full time

    About the JobThe role provides exposure to a broad spectrum of corporate actuarial and risk management work. The individual will also engage with senior management, the HAF and external parties. Qualifications and ExperienceMinimum qualification required Bachelor's degree in Actuarial Science. Good progress towards qualifying as an AMASSA and / or...

  • Senior Developer

    2 weeks ago


    Midrand, Gauteng, South Africa XET SOLUTIONS Full time

    Job Title: Software Development LeadCompany: Tech Solutions Inc.We are in search of an individual to take on the role of operating and business model analysis, collaborating with other business entities, developing capability maps, and contributing to the technology enablement of core capabilities and value streams with a fresh perspective and proactive...