TCDI

Job Summary

We are seeking a Database Administrator to design, troubleshoot, and optimize databases that support litigation technology and eDiscovery workflows. This role is focused on schema/data modeling, query design and performance, database programming (PL/pgSQL and T-SQL), ETL tasks, and evaluating/improving high availability and backup/restore approaches for PostgreSQL, Microsoft SQL Server, and ElasticSearch.

You will partner with Technical Application Engineers who automate and operate the underlying infrastructure and deployment pipelines. You will be responsible database correctness, performance, and resilience patterns.

What You’ll Do

• Design and evolve database schemas and data models to support new features, scale, and maintainability.
• Write, review, and optimize SQL for PostgreSQL and SQL Server:
• execution plan analysis, indexing strategy, query refactors, and performance baselines.
• Build database-side logic and utilities:
• PL/pgSQL functions/procedures/triggers/views and T-SQL objects as needed.
• Troubleshoot complex production issues:
• performance regressions, locking/blocking/deadlocks, resource contention, connectivity issues, and reliability problems.
• Develop operational tooling and automation in Python (required) plus Bash (preferred) and database scripting.
• Evaluate, test, and improve backup/restore and disaster recovery procedures:
• retention, security, restore validation, and recovery runbooks.
• Evaluate and improve high availability / clustering approaches appropriate to Postgres, SQL Server, and ElasticSearch:
• replication/failover concepts, testing failure modes, and documenting operational procedures.
• Collaborate with engineering and platform teams during releases:
• migration planning, rollout/rollback strategy, risk assessment, and production readiness.

What We’re Looking For (Required)

• Hands-on database experience in production environments.
• Practical expertise in PostgreSQL, Microsoft SQL Server, and ElasticSearch, including:
• schema/data modeling, indexing, query tuning, and execution plan analysis
• transactions and concurrency/locking fundamentals
• operational practices (maintenance concepts, capacity/performance troubleshooting)
• Advanced SQL skills: ability to design and tune complex queries and explain performance tradeoffs.
• Database programming experience:
• PL/pgSQL and T-SQL
• Python proficiency (required) for tooling/automation (scripts, data analysis, API integrations as needed).
• Backup/restore and DR competence:
• ability to define and validate restores, document procedures, and improve reliability.
• Strong troubleshooting discipline and clear written communication (runbooks, change notes, incident findings).
• Ability to maintain confidentiality and follow secure handling practices.

Nice to Have

• Experience with Postgres replication/failover tooling and/or SQL Server HA patterns relevant to your environment.
• Familiarity with Postgres backup tooling and WAL/archiving and SQL Server backup strategies.
• Experience integrating database migrations into CI/CD.
• Strong Linux and Windows operational familiarity for end-to-end troubleshooting (storage, metrics, performance counters).
• Observability experience building actionable DB monitoring/alerting.
• Familiarity with Relativity or similar eDiscovery platforms is a plus, not required.

Work Expectations

• Participation in an on-call rotation and occasional after-hours maintenance windows (as required for production support).
• Background check required due to sensitive client data handling.
• Occasional travel may be required.

Application Question(s):

• This is a US-based position. Do you live in the the US with appropriate work authorization?

Work Location: Remote