Sql Support Engineer

Details of the offer

Required Qualifications: Matric plus Diploma/Degree in Information Technology or Computer Science Microsoft SQL certification Responsibilities: 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: Adzuna_Ppc

Requirements

Security Engineer: Digital Trust Services

Introduction: Leaders in Digital Security solutions are looking for a Security Engineer with experience in Digital Trust Services to help build, maintain, an...


From Oasis Health Services - Gauteng

Published a month ago

Senior Software Engineer

Let's Write Africa's Story Together! Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this. Job Description A season...


From Old Mutual - Gauteng

Published a month ago

Data Scientist / Machine Learning Engineer

If you are a curious, creative and innovative person with a passion for challenging, meaningful work, this role is for you! This is a unique opportunity to d...


From Pillango Placements - Gauteng

Published a month ago

Data Scientist Data Engineer - Gauteng, Johannesburg

Are you based in Canada? Select your country to see jobs specific to your location. Data Scientist Data Engineer - Gauteng, JohannesburgJob Specification: Te...


From Chosen Online - Gauteng

Published a month ago

Built at: 2024-11-07T10:01:48.471Z