PostgreSQL core: Internals (MVCC, WAL, autovacuum, query planner), PL/pgSQL (dynamic SQL, exception handling, cursors), advanced SQL (recursive CTEs, window functions, MERGE/ON CONFLICT, JSONB), triggers, materialized views, COPY bulk loading. You will lead onshore and offshore development and PROD support teams, make architectural decisions, resolve upstream and downstream data issues, and work directly with business stakeholders to deliver reliable analytical reporting.