Senior Data Platform Engineer

$83,430 - $166,860/Yr

CVS Health - Frankfort, KY

Full-time - Mid Level

Remote - Frankfort, KY

Health and Personal Care Retailers

About the position

The Senior Data Platform Engineer at CVS Health is responsible for designing, developing, implementing, maintaining, upgrading, and automating solutions for managing and optimizing databases. This role requires expertise in SQL Server Technologies and programming to enhance the efficiency, reliability, and scalability of database systems. The engineer will collaborate with software development teams to integrate database automation processes into the software development cycle and provide 24/7 support for SQL Server Database Systems.

Responsibilities

• Perform troubleshooting and resolving database-related issues in collaboration with cross-functional teams, including system administrators, developers, and network engineers.
• Ensure high availability and optimal performance of production databases through effective automation strategies and monitoring techniques.
• Conduct regular performance analysis and capacity planning to optimize database resources.
• Document database processes, procedures, and configuration to ensure knowledge sharing and compliance with organization standards.
• Implement and maintain database automation frameworks, tools, and scripts to streamline database operations and enhance efficiency.
• Identify opportunities for process improvement and automation within the database environment and propose innovative solutions.

Requirements

• 5+ years of experience as a SQL Server Database Engineer or similar role, focusing on database concepts, principles, backup, recovery, deployments, best practices, and automation.
• 4+ years experience with Azure Cloud.
• 4+ years experience with HADR technologies like Always On, Replication, and/or Clustering.
• 3+ years of proficiency in scripting languages like Powershell, Python, etc for automation tasks.
• 3+ years of experience with database automation frameworks and tools like Octopus, Teamcity, Ansible, Jenkins.
• 2+ years of experience with source code management tools like GitHub and GitLab.
• 2+ years of experience with CICD tools and methodology.

Nice-to-haves

• Experience with SSIS, SSRS, SSAS.
• Thorough understanding of database architecture, replication, and high availability concepts.
• Proficiency in SQL and experience with other database technologies such as PostgreSQL, DB2 LUW, etc.
• Excellent problem solving and analytical skills with the ability to troubleshoot complex database issues.
• Effective communication skills and the ability to work effectively through collaboration with cross-functional teams.
• Attention to detail and commitment to delivering high-quality database automation solutions.

Benefits

• Full range of medical, dental, and vision benefits.
• 401(k) retirement savings plan.
• Employee Stock Purchase Plan.
• Fully-paid term life insurance plan.
• Short-term and long-term disability benefits.
• Numerous well-being programs.
• Education assistance and free development courses.
• CVS store discount and discount programs with participating partners.
• Paid Time Off (PTO) or vacation pay, as well as paid holidays throughout the calendar year.