SQL Server Administrator

We are looking for a skilled SQL Server Administrator to manage, maintain, and optimize our SQL Server databases. The ideal candidate will be responsible for ensuring the availability, performance, security, and integrity of our database systems. This role requires both technical expertise in SQL Server and the ability to collaborate with development and operations teams.

Responsibilities

• Database Installation and Configuration:
• Install, configure, and upgrade SQL Server instances, ensuring best practices are followed.
• Set up and configure database environments in development, testing, and production.
• Performance Monitoring and Tuning:
• Monitor database performance, identify bottlenecks, and implement tuning recommendations.
• Optimize SQL queries and stored procedures to enhance performance.
• Backup and Recovery:
• Develop, implement, and maintain backup and recovery strategies to prevent data loss.
• Regularly test backup and recovery procedures to ensure data integrity and availability.
• Security Management:
• Implement and maintain database security measures, including user access control and encryption.
• Monitor database security vulnerabilities and address them promptly.
• Database Maintenance:
• Perform routine database maintenance activities, such as integrity checks, index rebuilding, and statistics updates.
• Automate maintenance tasks using SQL Server Agent and other tools.
• Troubleshooting:
• Diagnose and resolve database-related issues promptly, including connectivity problems and performance degradation.
• Collaborate with application development teams to troubleshoot application-related database issues.
• Documentation:
• Maintain comprehensive documentation for database configurations, procedures, and changes.
• Create standardized processes to facilitate knowledge transfer and training.
• Collaboration and Support:
• Work closely with development and operations teams to support application deployments and upgrades.
• Provide support for database queries and assist in database design and architecture discussions.
• Capacity Planning:
• Monitor database growth and plan for future capacity requirements.
• Recommend hardware and software upgrades as needed to support increased demand.
  
  

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Proven experience (5+ years) as a SQL Server Administrator or in a similar role.
• Strong knowledge of SQL Server database management and maintenance, including T-SQL.
• Familiarity with high availability solutions (e.g., Always On, Clustering, Replication).
• Understanding of database security practices and data governance principles.
• Experience with performance tuning and optimization techniques.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills to collaborate effectively with teams.
• Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: SQL Server Database Administration are a plus.