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 needed.
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.
Required skills: MSSQL DBA
Desired skills: MSSQL DB Administration (Always ON, Backup/Recovery strategies, Performance tuning), GCP, Ansible, Terraform, Jenkins