SQL Server DBA

SQL Server DBARequired Qualifications:10+ years of experience as a SQL Server DBA5+ years experience with SQL Server HADR technologies like Always On, Replication, and/or Clustering, SQL Server Linking.2 + years of experience with Azure Cloud specially with setup of SQL Server VM with resiliency and High Availability setup, disk/network options and limitationsFamiliarity with SSIS, SSRS, SSAS, data management tools e.g. IBM VDPResponsibilitiesThis senior role requires expertise in database administration and the ability to work in a fast-paced collaborative environment. We provide support for on-premises and cloud databases (IaaS and DBaaS) including critical Tier 1 and Tier 2 systems that utilize high availability solutions with replication.This resource will support the design, implementation, and maintenance of database environments.You will ensure integrity and high availability of the database environments in your charge. Responsibilities include but are not limited to build/management of on-prem VM and as-a-service cloud implementations, monitoring/alerting setup and admin, application consulting, performance tuning, version upgrades, automations, architecture, access methods and reviews, backup/recovery, vendor coordination/ticketing, and team mentoring and knowledge sharing.As part of the DBA team you will collaborate with peer DBAs, project teams, application contacts to support and maintain current implementations as well as new builds/requirements. The role will assist in assuring that the Database implementations are secure, compliant, and adhere to minimum security requirements as set by CVS Health.You will use your knowledge and experience in the Database space to support application requirements and make recommendations for improving existing and future processes. You will aid in reviewing new enhancements, features, products for future use and planning.Common Required Qualifications:10 years of combined experience in Database Administration / EngineeringAdvanced knowledge of performance tuning, monitoring/alerting, observability, dashboardingAdvanced knowledge of process/query analysis, buffer tuning, client/server connectivity and database consistency checksAdvanced knowledge of maintenance routines, upgrades, patchingExperience in handling physical/logical backups & restores and data refreshes.Experience in Linux/Unix shell commands or Windows PowerShell or PythonExperience in OS fine tuning with regards to Network I/O, DiskShould be able to collaborate with DBA peers and mentor, work well in a team and independentlyShould be able to multi-task i.e. parallelize multiple environment build / data migrationShould be able to work off-hours for application release support, Linux patching support, maintenance windowsExperienced with security and data compliance aspects of databaseWell versed with latest version of databasePreferred qualificationsExperience with automation via Ansible, TerraformExperience with deployments (CI/CD) with GHA, GitHub, JenkinsRequired Skills: SQL ServerBasic Qualification:Additional Skills: Database Administrator, Big DataThis is a high PRIORITY requisition.