PostgresMySQL DBA

Postgres Required Qualifications:

• 5 years of experience in managing VM based Postgres with HA setup i.e. replication with masterslave

• Experience to manage and monitor database with tools like pgadmin or monitor with tools like PgHero or PGBadger
• Performing optimization activity i.e. auto vac and usage of tools like pgstat
• Performing backup/restore with utilities like Baman or pgBackRest
• Preferred familiarity with Percona Toolkit
• 2 years of experience with Azure Flex Server/GCP CloudSQL instances/AWS Aurora

Responsibilities

This senior role requires expertise in database administration and the ability to work in a fastpaced collaborative environment. We provide support for onpremises 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 onprem VM and asaservice cloud implementations monitoring/alerting setup and admin application consulting performance tuning version upgrades automations architecture access ods 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 ist in uring 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:

• 8 years of combined experience in Database Administration / Engineering
• Advanced knowledge of performance tuning monitoring/alerting observability dashboarding
• Advanced knowledge of process/query ysis 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 s commands or Windows PowerS 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 multitask i.e. parallelize multiple environment build / data migration
• Should be able to work offhours 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 Ss : MySQL

Basic Qualification :

Additional Ss : Database AdministratorBig Data

Background Check : Yes

Drug Screen : No