About linqd.
We power growth for some of the biggest names in the building products industry, helping them connect with more customers, expand market share, and achieve measurable results.
We’re a 100% virtual organization built on relationships, accountability, and performance. We invest in our people with competitive compensation, healthcare options, continuous learning, and a supportive, performance-driven culture, because the work we do for our clients is only as strong as the team behind it.
About the Role
We are looking for a Senior Database Analyst to take ownership of two distinct sides of our data infrastructure:
- Stabilize and optimize our legacy SQL Server environment ('DMP'). Three Microsoft SQL Server instances, managed through Azure, hosting isolated per-client databases for our existing customer base. These servers need a clear-eyed operator to bring them back to health, fix accumulated performance issues, and keep them running reliably for the next several years while we transition workloads off them. These servers are also used for integrations with tools like Tableau, and through Azure functions, are responsible for syncing data to and from CRMs.
- Design the database layer for our modern platform. Greenfield architecture on AWS using PostgreSQL for transactional workloads and ClickHouse for analytical / OLAP workloads. You will work alongside our senior services architect to facilitate the implementation of a new structure for a long-term platform to eventually replace DMP in a modernized stack using ClickHouse, AWS, and Postgres.
What You'll Do
Legacy DMP Environment (Microsoft SQL Server / Azure)
- Audit the current state of the three DMP servers and produce a prioritized remediation plan for performance, stability, and maintainability.
- Diagnose and resolve accumulated issues: index bloat, missing/redundant indexes, parameter sniffing, lock contention, fragmented statistics, runaway jobs, and storage pressure.
- Enhance monitoring, baselining, and alerting on resource utilization, query performance, and job health through SolarWinds.
- Lead the rollout of Airflow on DMP to replace existing scheduling/orchestration that has caused us issues (e.g., lock contention from a SQL Server-based meta-scheduler).
- Manage the multi-tenant isolation model across per-client databases — backups, restores, capacity planning, and security.
- Keep DMP healthy for several years of continued production use while modern workloads migrate off it incrementally.
Modern Platform (PostgreSQL + ClickHouse on AWS)
- Work with our senior services Architect on our multi-phase long-term platform implementation. Translating application and business