• Serve as a PostgreSQL and AWS Aurora subject-matter expert for our internal system Skye’s operational database.
• Manage and improve a large relational schema with hundreds of tables, high volume operational data, and substantial historical data.
• Review database changes for correctness, performance, safety, indexing, grants, triggers, foreign keys, and migration hygiene.
• Analyze and triage production database issues, including slow queries, lock contention, blocking transactions, runaway queries, replication lag, and performance regressions.
•Improve query performance and indexing for large tables, reporting workloads, assignment/routing workflows, mobile API payloads, and internal operational dashboards.
• Automate routine database maintenance and operational tasks, such as repacking, cleanup, monitoring checks, and recurring reports.
• Support database refresh, backup, restore, staging, and release workflows in partnership with Infrastructure.
• Collaborate closely with Infrastructure, Software Development, and Data Science teams on reliability, performance, reporting, analytics, and operational data needs.
• Help maintain safe access patterns for reporting users, Metabase, developers, and sensitive/PII-bearing tables.
• Work with accounting-related data flows when needed, including invoices, payments, billing accounts, vendor/payee data, and ERP integration tables.