Ms Sql Dba

Location: Irving,TX or Irvine, CA (Onsite Day 1) Type: Contract Job summary-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 d -Experience 7to10yrs -Required Skills Technical Skills- ,SQL Server DB Administration Domain Skills- -Nice to have skills Techincal Skills- Domain Skills- ,Data Management -Technology MultiCloud PGRoles & Responsibilities-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 incid