Note: The job is a remote job and is open to candidates in USA. Vertafore is a leading provider of digital systems for the insurance industry, focused on enhancing operational efficiency through innovative technology. They are seeking a Senior Database Administrator to design and manage PostgreSQL environments, lead database modernization efforts, and ensure high availability and reliability of database services.
Responsibilities
- Design, administer, and support enterprise PostgreSQL environments in AWS and on-premises environments
- Manage Amazon RDS PostgreSQL, Aurora PostgreSQL, and Amazon Redshift platforms
- Lead database modernization and migration initiatives from legacy database platforms to PostgreSQL
- Implement Infrastructure as Code (IaC) solutions using Terraform for database provisioning and management
- Improve database performance, scalability, availability, reliability, and security
- Develop automation solutions for database patching, deployments, monitoring, backup validation, and maintenance
- Integrate database deployments with CI/CD pipelines and DevOps processes
- Implement monitoring and observability using CloudWatch, Dynatrace, Grafana, and custom automation
- Establish PostgreSQL standards, governance, and operational best practices
- Provide architectural guidance for application teams adopting PostgreSQL and cloud-native database services
- Design and maintain HA/DR solutions, replication technologies, and recovery strategies
- Optimize AWS database costs and resource utilization while maintaining performance objectives
- Mentor junior DBAs and engineers and lead strategic database initiatives
- Provide 24x7 production support for mission-critical applications and services
Skills
- 8+ years of experience designing, administering, automating, and supporting mission-critical PostgreSQL, SQL Server, AWS RDS, Aurora PostgreSQL, and Amazon Redshift environments across cloud and on-premises platforms
- Experience in database modernization, cloud migrations, Infrastructure as Code (Terraform), performance tuning, high availability, disaster recovery, observability, and automation
- AWS Certified professional with a strong focus on reliability engineering, operational excellence, and DevOps practices
- AWS Certified Solutions Architect – Associate
- AWS Certified Database – Specialty (or equivalent database certification)
- AWS Certified Cloud Practitioner
- HashiCorp Certified: Terraform Associate
- EDB PostgreSQL Associate / PostgreSQL Administration Certification
- PostgreSQL, AWS RDS PostgreSQL, Aurora PostgreSQL, Amazon Redshift, SQL Server, Terraform, CI/CD, Python, PowerShell, Bash, CloudWatch, Dynatrace, Grafana, High Availability, Replication, Backup & Recovery, Disaster Recovery, Capacity Planning, Database Automation, Database Reliability Engineering (DBRE)
- Travel required up to 10% of the time
- Located and working from an office location
- Occasional lifting and/or moving up to 10 pounds
- Frequent repetitive hand and arm movements required to operate a computer
- Specific vision abilities required by this job include close vision (working on a computer, etc.)
- Frequent sitting and/or standing
- Microsoft Certified: Azure Database Administrator Associate
Benefits
- Bonus
- Vertafore is a Flexible First working environment which allows team members to work from home as often as you’d like, while using our offices as a place for collaboration, community, and teambuilding.
- Travel required up to 10% of the time.
- Vertafore is a drug free workplace and conducts preemployment drug and background screenings.
Company Overview