• Installation, Configuration, and Maintenance: Oversee the installation, configuration, and ongoing maintenance of Microsoft SQL Server instances across development, testing, and production environments. Ensure adherence to best practices and standards for optimal performance and reliability.
• High Availability Implementation: Design, implement, and manage high availability solutions such as Always-on Availability Groups and database mirroring to ensure continuous access to critical data and minimize downtime in case of failures or disasters.
• Database Security Implementation: Implement robust database security measures, including role-based security and encryption, to protect sensitive data and ensure compliance with regulatory requirements. Regularly review and update security policies to address emerging threats.
• Backup and Disaster Recovery: Establish and maintain comprehensive backup and disaster recovery strategies to safeguard data integrity and minimize potential data loss. Conduct regular backup tests and drills to validate the effectiveness of recovery procedures.
• Performance Monitoring and Optimization: Monitor database performance metrics and proactively identify areas for optimization. Optimize SQL queries, indexes, and server configurations to enhance overall system performance and responsiveness.
• Issue Resolution and Troubleshooting: Troubleshoot and resolve database-related issues, including performance bottlenecks, connectivity problems, and data corruption. Utilize diagnostic tools and techniques to identify root causes and implement effective solutions.
• Collaboration with Application Developers: Collaborate closely with application developers to design and implement database schemas, stored procedures, and triggers that align with application requirements. Provide guidance on database design best practices and performance optimization techniques.
• Automated Setup and Configuration: Develop and maintain automated scripts and tools for the setup and configuration of SQL Server instances and environments. Streamline deployment processes and reduce manual intervention to improve efficiency and consistency.

Education: Bachelor's degree in computer science, engineering, or related field; relevant certifications preferred.Experience: 3+ years of experience as a Microsoft SQL Server Database Administrator in a production environment, with a focus on high availability solutions and automated setup.Technical Skills: Proficiency in installing, configuring, and maintaining Microsoft SQL Server instances (SQL Server 2014 and above). Strong knowledge of SQL Server high availability solutions, automated deployment tools, and scripting languages.Security Expertise: Experience implementing database security measures and ensuring compliance with industry standards and regulations.Backup and Recovery: Demonstrated proficiency in designing and implementing backup and disaster recovery strategies to ensure data integrity and availability.Performance Tuning: Strong skills in database performance monitoring and optimization, including SQL query tuning and server configuration.Troubleshooting Abilities: Excellent troubleshooting skills and the ability to diagnose and resolve complex database issues in a timely manner.Communication and Collaboration: Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.