SQL Server DBA

SQL Server DBA

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

This is a high PRIORITY requisition.