Job Description

Home / Careers / Database Administrator (PostgreSQL & Microsoft SQL Server)

Database Administrator (PostgreSQL & Microsoft SQL Server)

TCDI is 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.

APPLY HERE
  • 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.
  • 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.
  • 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.
  • 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.

If you are interested in joining TCDI and being a part of a flexible and dynamic team of legal and technology professionals, please submit a resume and brief cover letter to postings@tcdi.com.

APPLY HERE