Job Description
📋 Description Serve as PostgreSQL and AWS Aurora SME, guiding architecture and performance. Manage and optimize large relational DBs with complex schemas and high data volume. Review changes, migrations, and schema updates for safety and scalability. Investigate production DB issues: slow queries, locking, replication challenges. Improve SQL performance with indexing, execution plans, and tuning. Automate recurring DB maintenance and monitoring workflows. 🎯 Requirements 5+ years with production relational DBs; 8+ years preferred. Strong PostgreSQL experience; AWS Aurora PostgreSQL required. Advanced SQL: joins, CTEs, indexes, transactions, locking. Experience with large-scale databases and real-world workloads. Diagnose performance via query costs, locks, indexing gaps, usage patterns. Knowledge of migrations, schema design, access controls, safety, risk management. 🎁 Benefits Competitive salary $140,000–$150,000 Fully remote opportunity with flexible Mon–Fri schedule Health, dental, vision; 401(k) with matching Paid time off, holidays, floating holidays Life/AD&D, long-term disability; FSA options EAP and pet insurance; impactful tech work
