The Senior Database Analyst will optimize a legacy SQL Server environment and design a modern platform using PostgreSQL and ClickHouse. Responsibilities include auditing server performance, designing database schemas, managing multi-tenant databases, and improving data ingestion methods.