CVS Health - Albany, NY

posted 4 months ago

Full-time - Senior
Remote - Albany, NY
Health and Personal Care Retailers

About the position

As a Senior Database Automation Engineer on our Data Platform Engineering team, you will be responsible for designing, developing, and implementing automated solutions for managing and optimizing databases within an organization. This role combines expertise in Open Source (PostgreSQL, MySQL, MariaDB) and DB2 LUW database technologies, CI/CD pipelines, programming, and automation to enhance the efficiency, reliability, and scalability of database systems. This position is remote and can be based anywhere in the United States. In this role, you will design, develop, and maintain automated solutions for Open Source and DB2 LUW database deployments, configuration, backup and recovery, monitoring, and performance tuning. You will collaborate with software development teams to integrate database automation processes into the software development cycle. Additionally, you will implement and maintain database automation frameworks, tools, and scripts to streamline database operations and enhance efficiency. You will identify opportunities for process improvement and automation within the database environment and propose innovative solutions. Troubleshooting and resolving database-related issues in collaboration with cross-functional teams, including system administrators, developers, and network engineers, will also be a key part of your responsibilities. Ensuring high availability and optimal performance of production databases through effective automation strategies and monitoring techniques is crucial. Regular performance analysis and capacity planning to optimize database resources will be part of your routine tasks. You will also document database automation processes, procedures, and configurations to ensure knowledge sharing and compliance with organizational standards. Keeping up to date with the latest industry trends and advancements in database automation technologies is essential for this role.

Responsibilities

  • Design, develop and maintain automated solutions for Open Source and DB2 LUW database deployments, configuration, backup and recovery, monitoring and performance tuning.
  • Collaborate with software development teams to integrate database automation processes into the software development cycle.
  • 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.
  • 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 automation processes, procedures and configuration to ensure knowledge sharing and compliance with organization standards.
  • Keep up to date with the latest industry trends and advancements in database automation technologies.

Requirements

  • 7+ years work experience as a Database Engineer or similar role, with a focus on automation, including mentoring more junior level staff.
  • 4+ years of experience with database concepts, principles, and technologies of Open Source (PostgreSQL, MySQL, MariaDB) and DB2 LUW database technologies.
  • 4+ years of proficiency in scripting languages like Python or Bash for automation tasks.
  • 4+ years of experience with database automation frameworks and tools like Ansible, Puppet, Chef or Terraform.
  • 2+ years of experience with source code management tools like GitHub/Actions and GitLab.
  • 2+ years of experience with CI/CD tools and methodology.
  • 2+ years experience with Cloud, e.g., Azure, GCP, etc.

Nice-to-haves

  • Experience with CI/CD tools and methodologies.
  • Thorough understanding of database architecture, replication, and high availability concepts.
  • Proficiency in SQL and experience with other database technologies such as: Oracle, SQL Server, PostgreSQL, AlloyDB, Spanner, etc.
  • Experience with AI/ML use cases.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service