Sql Server Dba

JOB DESCRIPTION

SQL Server DBA (3 Openings)
Required  Qualifications:
10+ years of experience as a  SQL  Server  DBA 
5+ 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 limitations 
Familiarity with SSIS, SSRS, SSAS, data management tools e.g. IBM VDP 
Responsibilities
This 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 / Engineering 
Advanced knowledge of performance tuning, monitoring/alerting, observability, dashboarding 
Advanced knowledge of process/query analysis, buffer tuning, client/server connectivity and database consistency checks 
Advanced knowledge of maintenance routines, upgrades, patching 
Experience in handling physical/logical backups & restores and data refreshes. 
Experience in Linux/Unix shell commands or Windows PowerShell or Python 
Experience in OS fine tuning with regards to Network I/O, Disk 
Should be able to collaborate with DBA peers and mentor, work well in a team and independently 
Should be able to multi-task i.e. parallelize multiple environment build / data migration 
Should be able to work off-hours for application release support, Linux patching support, maintenance windows 
Experienced with security and data compliance aspects of database 
Well versed with latest version of database 
  
Preferred qualifications
Experience with automation via Ansible, Terraform
Experience with deployments (CI/CD) with GHA, GitHub, Jenkins  
  
Required Skills : SQL Server
 Basic Qualification : 
 Additional Skills : Database Administrator,Big Data
Background Check : Yes 
 
Drug Screen : No