Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
We're on the lookout for a highly skilled individual to join our team, taking the helm in ensuring the performance, availability, and security of our SQL Server databases. Beyond routine maintenance, you'll play a crucial role in planning, designing, and implementing database strategies that align seamlessly with our evolving business needs.
- Manage and monitor SQL Server / MySQL databases to ensure optimal performance, availability, and security.
- Implement and maintain database backup and recovery strategies to minimize data loss and downtime.
- Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning.
- Proactively identify and resolve database performance issues and bottlenecks.
- Collaborate with developers, system administrators, and other stakeholders to ensure efficient and effective use of database resources.
- Develop and implement database security policies and procedures to protect sensitive data.
- Monitor and analyse database performance metrics and provide recommendations for improvement.
- Plan and execute database migration and upgrade projects.
- Troubleshoot and resolve database-related problems in a timely manner.
- Document database configurations, procedures, and troubleshooting steps.
Job Requirements
- Strong experience as a SQL Server/MySQL DBA.
- In-depth knowledge of SQL Server/MySQL database administration, including database design, installation, configuration, and maintenance.
- Proficiency in writing complex SQL queries, stored procedures, triggers, and functions.
- Experience with database performance tuning and optimization techniques.
- Familiarity with high availability and disaster recovery solutions, such as database mirroring, log shipping, and clustering.
- Understanding of relational database management systems and their principles.
- Knowledge of database security best practices and the ability to implement and enforce security measures.
- Strong problem-solving and troubleshooting skills.
- Excellent communication and collaboration skills.
- Bachelor's degree in computer science, information technology, or a related field.
- Certification in SQL Server administration (e.g., MCSA: SQL Server or MCSE: Data Management and Analytics) is preferred.
- Proven experience in managing large-scale SQL Server / MySQL databases in a production environment.