About the role

Senior DataOps Developer operating high-availability PostgreSQL databases on AWS for Upgrade's core financial systems. Involves complex SQL operations and collaboration with engineering teams.

Responsibilities

Operate and maintain high-availability PostgreSQL databases on AWS RDS supporting core financial systems
Execute complex SQL operations safely in production environments with a zero-downtime mindset
Monitor database health and performance using CloudWatch, Grafana, and observability tooling
Analyze query performance and implement optimizations including indexing, partitioning, and schema improvements
Support and troubleshoot data replication and synchronization pipelines using tools such as AWS DMS and Fivetran
Manage and triage operational database requests during East Coast business hours
Participate in a shared on-call rotation to support mission-critical production systems
Collaborate with data engineering and platform teams to ensure reliable data pipelines and downstream analytics systems
Contribute to operational standards and procedures that improve performance, scalability, security, and data integrity

5+ years of experience operating production OLTP PostgresQL databases
Strong experience administering PostgreSQL on AWS RDS
Deep knowledge of: SQL query execution and optimization, indexing strategies, table partitioning, schema design and evolution
Experience with PostgreSQL replication and backup strategies
Hands-on experience performing database upgrades, patching, and recovery
Strong troubleshooting and incident response skills in high-traffic production environments
Excellent documentation and communication skills
Ability to think systematically and carefully when working with production data
Work from Canada East Coast (EST/EDT) to support business operations