Own and operate AWS Aurora (PostgreSQL) in a high-load production environment Design and evolve schemas for large transactional domains Implement and maintain table partitioning strategies Implement and maintain advanced indexing Implement and maintain query optimization and execution-plan tuning Handle databases with millions of new records per month Analyze and optimize slow queries and production metrics Identify and resolve lock contention, vacuum issues, connection pool saturation, and long-running queries Proactively prevent performance regressions Design high-performance search solutions for large operational datasets Implement efficient search strategies Work with event and log data pipelines Decide data placement between transactional and analytical stores Enable fast, real-time insights Ensure data integrity and consistency in financial workflows Define and monitor database health metrics Plan and execute safe schema changes and migrations on large tables Participate in incident analysis Work in backups, replication, and disaster-recovery strategies