ROle: MSSQL DBA
Location : Irving TX ; Irvine CA
Onsite position
Required skills: MSSQL DBA
Desired skills: MSSQL DB Administration (Always ON, Backup/Recovery strategies, Performance tuning).
Job Description:
Roles & 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 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.