12 hours ago
Job title : SQL Database Administrator
Job Location : Western Cape, Cape Town
Deadline : November 15, 2024
Quick Recommended Links
Responsibilities
What will you do?
- Database Management:
- Install, configure, and maintain SQL Server instances to support business applications.
- Monitor the health and performance of database systems, identifying and resolving issues to maintain uptime and efficiency.
- Implement automation for routine maintenance tasks to enhance system performance and reduce manual effort.
- Database Development and Optimization:
- Develop complex SQL queries, stored procedures, and functions to support various business requirements.
- Collaborate with software developers to integrate database functions into applications and to provide SQL-related support.
- Conduct code reviews and provide feedback to ensure high-quality database solutions.
- Security and Compliance:
- Implement security measures to protect sensitive data and database systems.
- Ensure adherence to data protection regulations and internal policies through regular audits and assessments.
- Develop and maintain documentation for security practices and procedures.
- Performance Tuning:
- Analyze and troubleshoot database performance issues, implementing solutions to optimize system performance.
- Adjust database configurations and optimize SQL queries to enhance responsiveness and efficiency.
- Utilize indexing and other optimization techniques to improve query execution times.
- Backup and Recovery Planning:
- Develop and execute comprehensive backup strategies to ensure data protection and availability.
- Conduct regular recovery tests to validate backup processes and minimize potential data loss.
- Maintain data integrity through consistent monitoring and validation of backup processes.
- Collaboration and Communication:
- Work with various teams to understand their data needs and provide appropriate database solutions.
- Communicate effectively with stakeholders to keep them informed of database-related updates and issues.
- Document database configurations, processes, and policies to maintain clear and accessible records.
- Cloud Integration (Preferred):
- Manage SQL Server databases within AWS cloud environments, utilizing services such as RDS and EC2.
- Assist in planning and executing the migration of databases from on-premises systems to the cloud.
- Optimize database performance in cloud settings and ensure effective integration with cloud-based applications.
- Operational Requirement:
- In-Hours Hotseat:
- Serve as the primary point of contact for urgent database-related issues during regular business hours.
- Respond promptly to high-priority incidents and coordinate with other team members to ensure swift resolution.
- Monitor database systems closely and proactively address potential problems to minimize disruptions.
- After-Hours Standby:
- Be available on a rotational basis for after-hours support to address critical database incidents that may arise outside regular working hours.
- Provide timely and effective responses to after-hours alerts to maintain system availability and performance.
- Coordinate with the IT team and other stakeholders to manage and resolve after-hours issues as required.
- This requirement ensures that our database infrastructure remains reliable and available, supporting the continuous operation of the organization’s critical business processes.
Qualifications
Who are we looking for?
- Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Experience: 3-5 years as a Database Administrator with expertise in SQL Server.
- Technical Proficiency:
- In-depth knowledge of SQL Server versions 2014 through 2019.
- Knowledge of working with “Availability groups” and “Recovery Models”
- Advanced skills in T-SQL and experience with database performance tuning and optimization.
- Familiarity with database development and scripting practices.
- Understanding of database security protocols, backup strategies, and disaster recovery processes.
- Experience with AWS or Azure cloud services is highly advantageous.
- RDS, EC2, and S3,
Key Competencies:
- Strong analytical and problem-solving capabilities.
- Effective communication and interpersonal skills.
- Detail-oriented with a strong focus on organization and process.
- Ability to manage multiple priorities and projects concurrently.
- Willingness to continuously learn and adapt to evolving technologies and methodologies.
How to Apply for this Offer
Interested and Qualified candidates should Click here to Apply Now
- ICT jobs