Senior PostgreSQL Architect for MultiTenant Platform

Verra Mobility Corporation; Phoenix (AZ); On-site; USD 140,000 - 170,000; Full time

Job summary

Verra Mobility Corporation seeks an experienced Senior Database Engineer to own the relational data platform supporting mobility products. You will design schemas, ensure migration safety, and optimize performance on AWS-based, multi-tenant workloads.

You will collaborate with software, DevOps, and security teams to guarantee data durability, plan migrations with zero downtime, and scale the data tier for hundreds of microservices and real-time data needs.

Qualifications

• Bachelor's degree or equivalent with 6+ years in database engineering or production DB administration.
• 6+ years of experience in database engineering, data platform engineering, or production database administration.
• Deep PostgreSQL expertise: plan analysis, indexing, partitioning, autovacuum, and lock/deadlock diagnosis.
• Production experience with managed cloud databases (Aurora PostgreSQL or RDS) including backup, PITR, read replicas, failover.
• Hands-on experience with schema migration tooling integrated into CI/CD and zero-downtime change patterns.

Responsibilities

• Own relational schema for core operational platform, including normalization, constraints, indexes, and versioned data artifacts.
• Author and review migrations as code, ensuring backward compatibility and zero-downtime deployments.
• Maintain migration history, drift detection, and reconciliation across environments and tenants.
• Define data integrity standards and enforce constraints, foreign keys, and nullability at the database level.
• Profile and tune high-volume OLTP workloads and optimize queries and indexing.
• Lead consolidation of data access toward typed domain services and reduce external data-layer dependencies.
• Build observability for the data tier and participate in on-call incident responses.
• Collaborate with architecture on separation of transactional and analytical workloads and data warehouse feeds.

Skills

PostgreSQL

AWS

Database tuning

Schema design

Migration tooling

Education

Bachelor's degree in Computer Science or related field

Tools

Flyway

Liquibase

Alembic

Sqitch

Terraform

Job description

Verra Mobility Corporation seeks an experienced Senior Database Engineer to own the relational data platform supporting mobility products. You will design schemas, ensure migration safety, and optimize performance on AWS-based, multi-tenant workloads.

You will collaborate with software, DevOps, and security teams to guarantee data durability, plan migrations with zero downtime, and scale the data tier for hundreds of microservices and real-time data needs.