Database AdministratorPostgres Required Qualifications:5+ years of experience in managing VM based Postgres with HA setup i.e. replication with master-slaveExperience to manage and monitor database with tools like pgadmin, or monitor with tools like PgHero or PGBadgerPerforming optimization activity i.e. auto vaccum and usage of tools like pg_statPerforming backup/restore with utilities like Baman or pgBackRestPreferred familiarity with Percona Toolkit2+ years of experience with Azure Flex Server/GCP CloudSQL instances/AWS AuroraResponsibilities: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:8 years of combined experience in Database Administration / EngineeringAdvanced knowledge of performance tuning, monitoring/alerting, observability, dashboardingAdvanced knowledge of process/query analysis, buffer tuning, client/server connectivity and database consistency checksAdvanced knowledge of maintenance routines, upgrades, patchingExperience in handling physical/logical backups & restores and data refreshes.Experience in Linux/Unix shell commands or Windows PowerShell or PythonExperience in OS fine tuning with regards to Network I/O, DiskShould be able to collaborate with DBA peers and mentor, work well in a team and independentlyShould be able to multi-task i.e.