Nodal Exchange

• Production PostgreSQL infrastructure across the full lifecycle: architecture, deployment, replication, monitoring, performance tuning, backup/recovery, and capacity planning • Streaming replication and high-availability configurations that meet the uptime expectations of a regulated financial exchange • Query and system-level performance analysis—diagnosing slow queries, optimizing execution plans, tuning shared_buffers, work_mem, and autovacuum, not just reading pg_stat output but knowing what to do about it • Backup and disaster recovery strategy using tools like Barman, including point-in-time recovery testing and validation • Data architecture evolution: modernizing data warehouse and reporting infrastructure, building ETL pipelines, and designing data flows that scale with the business • Data services across the organization: test data management, data obfuscation, data modeling, and supporting data needs for development, QA, and business teams • Operational support including on-call rotation for after-hours production database emergencies