Required skills: MSSQL DBA
Desired skills: MSSQL DB Administration (Always ON, Backup/Recovery strategies, Performance tuning).
- Strong proficiency in deploying and managing Microsoft SQL Server technologies/features including SQL Server 2007 through 2019 , Integration Services, Reporting Services, Analysis Services, Always-on, merge replication, and HA clustering .
- Experience on Cloud knowledge is good to have.
- Experience in automation and infrastructure as code is highly preferable including leverage of Ansible and Terraform toolsets. Familiarity with Github and Jenkins is a plus.
- Solid hands-on experience in database patching, upgrades, and migrations.
- Proficiency in SQL optimization and coding techniques to code efficient stored procedures and triggers.
- Good architectural knowledge of relevant server OS, storage, networking, virtual machines, high availability.
- Design, implement, and maintain complex database systems following industry standards and best practices to ensure highly available, secure, performant and scalable database systems .
- Design and deploy high availability solutions, and proven disaster recovery and backup/recovery strategy. Create, maintain, and test backup and recovery processes and systems.
- Advanced knowledge of database design to produce sound logical and physical data models.
- Monitor and plan capacity and performance and proactively resolve problems.
- Troubleshoot a wide range of database problems with complex interdependencies and provide/drive issue remediation in timely and professional fashion.
- Strong aptitude to adopting standards and cloud native principles and best practices.
- Good verbal and written communication skills, providing clear and precise instructions for complex technical tasks, manages post-outage recovery, root cause analysis and remediation.
- Seasoned experience and skills in leading projects such as data center migrations, server consolidation, DR failover/failback, server configuration management, security, audit and compliance.
- Professional and timely technical support delivery and active engagement in IT incident lifecycle management
- Actively mentors less experienced team members, Regularly recommend process improvements and best practices.
- Bachelor degree or equivalent work experience. Certifications in related IT and MSSQL technologies preferred.