Senior Database Administrator for Cloud-Native High Availability Setup

Northbay Systems

Project-based · Remote · Flexible hours

About the role

Northbay Systems is modernizing a legacy production platform that must stay online 24/7. We need a Database Administrator to design, implement, and validate zero‑downtime migration strategies while keeping performance stable.

Key responsibilities

• Audit existing schema, indexes, and query patterns for bottlenecks
• Design a phased migration plan using logical replication or pg_upgrade
• Automate schema versioning and data validation scripts
• Implement monitoring dashboards to track latency and replication lag in real time
• Collaborate with developers to refactor queries for the new platform
• Conduct failover drills and document rollback procedures

Must-have skills

• Deep expertise in PostgreSQL administration and performance tuning
• Hands‑on experience with MongoDB and MySQL in production
• Proven track record of zero‑downtime migrations on high‑traffic systems
• Strong scripting abilities (Bash, Python) for automation

Nice to have

• Experience with containerized database deployments (Docker, Kubernetes)
• Familiarity with cloud‑native services (AWS RDS, Azure Database)