PostgresSQL

PostgresSQL

Exp- 5 to 11 years

Location- Chennai/Bangalore

This senior role requires expertise in Postgres 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.

About the Role

This resource will support the design, implementation, and maintenance of Postgres environments. You will ensure integrity and high availability of the Postgres environments in your charge.

Responsibilities

• 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
• Team mentoring and knowledge sharing

As part of the opensource DBA team you will work 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 the Postgres implementations are secure, compliant, and adhere to minimum security requirements as set by CVS Health. You will use your knowledge and experience in the Postgres space to support application requirements and make recommendations for improving existing and future processes. You will aid in reviewing new Postgres enhancements, features, products for future use and planning.

Qualifications

• 5+ years of experience with Postgres
• 2+ years of experience with Azure/GCP PaaS instances
• 5 years of combined experience in Database Administration / Engineering

Required Skills

• Advanced knowledge of performance tuning, monitoring/alerting, observability, dashboarding
• Advanced knowledge of process/query analysis
• Advanced knowledge of maintenance routines, upgrades, patching
• Ability to collaborate with DBA peers and mentor, work well in a team and independently
• Experience with automation via Ansible, Terraform
• Experience with deployments (CI/CD) with GHA, GitHub, Jenkins
• Ability to work off-hours for application release support, Linux patching support, maintenance windows