Senior SQL DBA

2 months 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.
  • High Availability assessments and best-fit application (AOHA and Failover).
  • Disaster recover assessment and best-fit application (AOHA, log shipping, mirroring and replication)
  • 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.

  • Senior SQL Dba

    2 weeks 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...

  • Senior SQL DBA

    2 months ago

    Midrand, South Africa Jobted ZA C2 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...

  • Senior SQL DBA

    2 months 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....

  • Senior Database Administrator

    7 months ago

    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...

  • SQL Dba

    2 weeks ago

    Midrand, South Africa EOH Full time

    Build working relationships across teams and functional lines to enhance work delivery, collaboration and innovation - Provide resolution of database conflicts to align to quality standards and eliminate inappropriate data usage - Support the building of a scalable and resilient database system to mitigate disaster and performance risks - Design and create...

  • (SQL Dba) Data Base Administrator

    2 weeks ago

    Midrand, South Africa RJPersonnel Full time

    3years - Responsible to develop, implement, test, maintain and provide technical support of SQL database systems and related vendor products according to user / business requirements. - Review applicable IT company procedures/policies and processes and make changes or developments to the database were applicable. - Integrating systems, to customize databases...

  • Database Administrator

    2 weeks ago

    Midrand, South Africa StaffCentral Consulting Full time

    **Job Duties/Responsibilities will include**: Respond to customer requests Work with technical contacts from other teams or external partners on integration projects Ability to provide on-call and 24x7 DBA support when applicable Perform database administration, maintenance, performance tuning, security, and troubleshooting Provide daily health check...

  • Senior Mainframe Database Administrator

    2 days ago

    Midrand, South Africa RJPersonnel Full time

    8years Create and maintain business database objects within an IDMS and DB2 subsystem. Perform database tuning to ensure the DBMS functions at optimal levels. Schedule database maintenance tasks. Troubleshoot database and DBMS errors and provide solutions to support business when required. Provide input and implement operational and business strategies,...

  • ▷ [15h Left] Data Engineer

    1 month ago

    Midrand, South Africa Jobted ZA C2 Full time

    Position: Data Engineer Industry: Logistics Sector: Technology Location: Permanent Salary: Market related REQUIREMENTS: - Matric or equivalent qualification - A Bachelor's degree or several years of experience in computer science, data science, software development, or another related field; a master's degree is recommended - Solid understanding of common...

  • PostgreSQL Operations Specialist

    7 months ago

    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...

  • Senior Analytics Expert

    3 weeks ago

    Midrand, Gauteng, South Africa Tower Group Full time

    Tower Group: Senior Analyst RoleWe are seeking a Senior Analytics Expert to join our team at Tower Group.The estimated salary for this position is $120,000 - $180,000 per annum, based on the location and industry standards.Job Description:This role requires a strong analytical mindset and excellent communication skills. The successful candidate will work...

  • Mainframe Database Support Administrator

    1 week ago

    Midrand, South Africa RJPersonnel Full time

    8years - Create and maintain business database objects within an IDMS and DB2 subsystem. - Perform database tuning to ensure the DBMS functions at optimal levels. - Schedule database maintenance tasks. - Troubleshoot database and DBMS errors and provide solutions to support business when required. - Provide input and implement operational and business...

  • Data Engineer

    1 month ago

    Midrand, South Africa Hutech Head Office Full time

    Position: Data Engineer Industry: LogisticsSector: TechnologyLocation: Permanent Salary: Market related REQUIREMENTS:Matric or equivalent qualificationA Bachelor's degree or several years of experience in computer science, data science, software development, or another related field; a master's...

  • Data Engineer

    1 month ago

    Midrand, South Africa Hutech Head Office Full time

    Position: Data Engineer Industry: Logistics Sector: Technology Location: Permanent Salary: Market related REQUIREMENTS: Matric or equivalent qualification A Bachelor's degree or several years of experience in computer science, data science, software development, or another related field; a...

  • Senior Data Scientist

    3 weeks ago

    Midrand, Gauteng, South Africa Hutech Head Office Full time

    Job Title: Senior Data ScientistWe are seeking a highly skilled Senior Data Scientist to join our team at Hutech Head Office.About the Role:As a Senior Data Scientist, you will be responsible for designing and implementing advanced data models and algorithms to drive business growth and innovation.About You:You hold a Bachelor's degree or higher in Computer...

  • Senior Prepaid Insights Expert

    3 weeks ago

    Midrand, Gauteng, South Africa Tower Group Full time

    Senior Prepaid Insights ExpertTower Group is seeking a highly skilled Senior Prepaid Insights Expert to join our team. The successful candidate will have a strong background in prepaid analytics and be able to analyze market and industry-related activities to provide actionable insights.The role of the Senior Prepaid Insights Expert will involve working...

  • Senior BI Analyst

    7 months ago

    Midrand, South Africa JSRH Solutions Full time

    We are hiring: Senior BI Analyst Location: Midrand, Gauteng Working Model: On Site The 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 requirement analysis and design of key business...

  • Database Administrator IT

    4 months ago

    Midrand, South Africa Fidelity Services Group Full time

    **Position Title**: Database Administrator (DBA) **Location**: Midrand or Helderkruin **Department**: ICT **Reports To**: Group Infrastructure Manager **Qualifications**: - ** Bachelor’s or master’s degree in Computer Science,** Software Engineering, Information Technology, or a related field. - ** Certifications**: AWS Certified Database Specialty,...

  • Senior Specialist Prepaid Analytics

    3 months ago

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

    Role purpose: As a Senior Specialist Prepaid Analytics your role will require you to work closely with stakeholders to assist in evaluating the performance of various products, campaigns, and other initiatives and to provide detailed recommendations and next steps. Your role will also require you to analyse market and industry related activities and ideate...

  • Senior Database Administrator

    2 weeks ago

    Midrand, South Africa Premier Full time

    We are committed to creating a vibrant working environment where all employees are passionate and excited about their contribution. Our on-going aim is to be recognised as a leading FMCG employer and to create a working environment where people feel free to share ideas and goals. A career opportunity has arisen in the IT** Department - Premier Corporate -...