Sql Support Engineer

Details of the offer

Required Qualifications:Matric plus Diploma/Degree in Information Technology or Computer ScienceMicrosoft SQL certificationResponsibilities:High Availability and Clustering:Design, configure, and implement high-availability database clustering solutions using technologies such as SQL Server AlwaysOn, Windows Server Failover Clustering, or other relevant clustering solutions.Monitor and manage clustered databases to ensure continuous availability, failover readiness, and data integrity.Troubleshoot and resolve clustering-related issues, including failovers, connectivity problems, and synchronization errors.Disaster Recovery and Log Shipping:Design and maintain robust disaster recovery strategies using log shipping techniques to ensure data protection and rapid recovery in case of failures.Configure and manage log shipping processes, monitor synchronization, and troubleshoot any replication discrepancies.Regularly test and validate log shipping procedures to ensure readiness for disaster recovery scenarios.Database Mirroring:Implement and manage database mirroring solutions to provide real-time data replication and failover capabilities.Monitor and troubleshoot database mirroring synchronization, connectivity, and failover scenarios.Performance Optimization:Identify and address performance bottlenecks within high-availability environments, optimizing database performance and responsiveness.Implement best practices for indexing, query optimization, and resource utilization to enhance cluster and replica efficiency.Security and Compliance:Collaborate with the security team to implement and maintain database security measures, access controls, and compliance standards within clustered and mirrored environments.Monitoring and Alerting:Configure and manage monitoring tools to proactively track the health, performance, and synchronization status of clustered databases and replicas.Establish and manage alerting mechanisms to quickly respond to potential issues and incidents.Capacity Planning and Scaling:Assess database growth patterns and usage trends to forecast capacity requirements and recommend scaling strategies for clustered and mirrored databases.Documentation and Knowledge Sharing:Maintain comprehensive documentation of clustering, log shipping, and mirroring configurations, processes, and troubleshooting procedures.Provide knowledge sharing and training to team members and stakeholders on best practices for high availability and disaster recovery.Collaboration and Communication:Work closely with cross-functional teams, including developers, system administrators, and network engineers, to ensure the seamless operation of clustered and mirrored databases.


Nominal Salary: To be agreed

Source: Whatjobs_Ppc

Requirements

Divisional Ict Executive

Location:  Johannesburg (On-site) - Permanent Position Role Summary: The Divisional ICT Executive is a strategic leadership position focused on optimizing IC...


From Boardroom Appointments - Gauteng

Published a month ago

Data Engineer

We help our clients understand the rich data we collect from the traditional retail market in South Africa and Africa broadly. The ideal candidate will have ...


From Capital Recruit - Gauteng

Published a month ago

Cloud Specialist

JOB DESCRIPTION Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence a...


From Ntt - Gauteng

Published a month ago

Senior Application Modernization And Ai Developer

Senior Application Modernization and AI Developer Location: Johannesburg Model: Hybrid Job Overview Technical Skills: .Net Development: Proficiency in develo...


From Netsurit - Gauteng

Published a month ago

Built at: 2024-11-07T10:15:27.430Z