Overview
Design, deploy, maintain, manage, tune, and troubleshoot the Microsoft SQL servers and database components that are hosted on-premises and in the cloud (IaaS/PaaS). Install and upgrade MS SQL (Windows-based systems and servers), managing access to the servers, and maintaining the security and stability of the MS SQL Server infrastructure.
Responsibilities
Operational Work:
Troubleshoot and resolve SQL Server system and database issues, including root cause analysis and mitigation of future issues
Collaborate and communicate with support personnel with internal departments and vendor partners
Provide timely and efficient support to assigned operations
Coordinate day-to-day operations of Microsoft SQL environments including servers, services, and security
Apply security patches and hotfixes
Handle weekly on-call rotation shifts as well as act as escalation for MS SQL services from other on-call staff members
Architect/Design Work
Work with stakeholders and other technical teams to collect business and technical requirements and present enterprise or department/application specific solutions
Scope, plan, design, document, implement, and align a globally distributed Microsoft SQL Server services infrastructure, including maintenance plans, backups, upgrades, performance monitoring and tuning, and migration as per company policy for large scale organizations.
Documentation And Compliance
Create and maintain documentation of new and existing Microsoft SQL environments, processes, workflows, troubleshooting, licensing, etc for global enterprise
Assist in ensuring alignment with PAC policies and procedure
Support audits (internal/external) for all Microsoft SQL Server subject areas.
Assist in ensuring alignment with PAC policies and procedures
Support audits (internal/external) for all Microsoft SQL Server subject areas.
Knowledge And Requirements
Strong understanding of architecting, implementing, configuring, and supporting Microsoft SQL Server technologies in a global enterprise environment with 24/7/365 availability, including High Availability and Fault Tolerance technologies.
Ability to create, customize, debug, and deploy scripts (PowerShell, TSQL, etc.).
Familiarity with VMware virtualization platform and Azure-based IaaS/PaaS Microsoft SQL Server solutions.
Familiarity with storage subsystems as they relate to Microsoft SQL Server operations.
Qualifications
Bachelor's degree in a related field and/or Microsoft SQL certifications.
5+ years of enterprise experience as a Microsoft SQL Server database administrator for SQL Server 2012 and later.
2+ years of Azure SQL database operations background strongly preferred.
REQ-143372