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

  • Senior SQL DBA

    4 days ago

    Midrand, South Africa ManpowerGroup SA Full time

    Reference: CPT -AK-1 Our client is seeking a Senior SQL DBA to support data analysis and troubleshooting for issues raised from the applications. Duties & Responsibilities Responsibilities: Operating SQL database platform and troubleshooting any issues impacting the environments as well as analyzing error logs. Analyzing queries and advising on efficiency...

  • Senior Sql Dba Midrand

    4 days ago

    Midrand, South Africa ManpowerGroup SA Full time

    Reference: CPT -AK-1 Our client is seeking a Senior SQL DBA to support data analysis and troubleshooting for issues raised from the applications. Duties & Responsibilities Responsibilities: Operating SQL database platform and actively troubleshooting any issues impacting the environments as well as analysing error logs. Analysing queries and advising on...

  • SQL and Oracle Microsoft DBA

    4 days ago

    Midrand, South Africa ManpowerGroup SA Full time

    Reference: CPT -AK-1 You will be responsible for supporting end users on SQL Database used in the company environment. Support data analysis and troubleshooting for issues raised from the applications. Duties & Responsibilities Responsibilities: Operating Oracle and SQL database platform and actively troubleshooting any issues impacting the environments as...

  • Microsoft Dba Midrand

    4 days ago

    Midrand, South Africa ManpowerGroup SA Full time

    Job Reference: CPT -AK-1 You will be responsible for supporting end users on SQL Database used in the company environment, including data analysis and troubleshooting for issues raised from the applications. Duties & Responsibilities Responsibilities: Operating Oracle and SQL database platforms and actively troubleshooting any issues impacting the...

  • SQL Dba

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

  • Senior Database Administrator

    2 days ago

    Midrand, South Africa NielsenIQ Full time

    Overview Senior Database Administrator at NielsenIQ. This role involves developing and maintaining deployed application software and ensuring high data integrity and security standards. Job Description Develop and maintain the deployed application software. Collaborate with product managers and designers to ensure a successful, high-quality product and great...

  • Senior Database Administrator

    7 days ago

    Midrand, South Africa TLT Appointing Full time

    A technology company in Midrand is looking for a software developer to enhance and maintain application software. Candidates should have over 3 years of DBA experience and 5 years in user interface analysis. Knowledge of Agile methodologies and technical tools like ASP.NET and SQL is essential. This role involves close collaboration with product managers and...

  • Senior SQL Consultant

    4 days ago

    Midrand, South Africa Deloitte Africa Full time

    Company Description At Deloitte , our Purpose is to make an impact that matters for our clients, our people, and society. This is the lens for which our global strategy is set. It unites Deloitte professionals across geographies, businesses, and skills. It makes us better at what we do and how we do it. It enables us to deliver on our promises to...

  • Senior SQL Consultant

    4 days ago

    Midrand, South Africa Deloitte Africa Full time

    Company Description At Deloitte , our Purpose is to make an impact that matters for our clients, our people, and society. This is the lens for which our global strategy is set. It unites Deloitte professionals across geographies, businesses, and skills. It makes us better at what we do and how we do it. It enables us to deliver on our promises to...

  • Senior Database Administrator

    1 week ago

    Midrand, Gauteng, South Africa TLT Appointing Full time R400 000 - R800 000 per year

    Company DescriptionAbout Us: TLT Appointing provides recruitment serves via a team of specialist recruitment consultants in the following areas Finance, HR, IT & Telecommunications, Financial Services, Engineering, FMCG & Retail, Consulting & Professional Services, Public Sector, Executive SearchJob DescriptionDevelop and maintain the deployed application...