{"schemaVersion":"jobsearcher.job.v1","id":"01f2d24546cc72797e473375","url":"https://jobsearcher.com/jobs/01f2d24546cc72797e473375","canonicalUrl":"https://jobsearcher.com/jobs/01f2d24546cc72797e473375","title":"Database Administrator (PostgreSQL & Microsoft SQL Server)","description":"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.\nYou 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.\n\nResponsibilities\nRequired Skills\nPreferred Skills\nWork Expectations\nDesign and evolve database schemas and data models to support new features, scale, and maintainability.\nWrite, review, and optimize SQL for PostgreSQL and SQL Server:\nExecution plan analysis, indexing strategy, query refactors, and performance baselines.\nBuild database-side logic and utilities:\nPL/pgSQL functions/procedures/triggers/views and T-SQL objects as needed.\nTroubleshoot complex production issues:\nPerformance regressions, locking/blocking/deadlocks, resource contention, connectivity issues, and reliability problems.\nDevelop operational tooling and automation in Python (required) plus Bash (preferred) and database scripting.\nEvaluate, test, and improve backup/restore and disaster recovery procedures:\nRetention, security, restore validation, and recovery runbooks.\nEvaluate and improve high availability / clustering approaches appropriate to Postgres, SQL Server, and ElasticSearch:\nReplication/failover concepts, testing failure modes, and documenting operational procedures.\nCollaborate with engineering and platform teams during releases:\nMigration planning, rollout/rollback strategy, risk assessment, and production readiness.\nHands-on database experience in production environments.\nPractical expertise in PostgreSQL, Microsoft SQL Server, and ElasticSearch, including:\nSchema/data modeling, indexing, query tuning, and execution plan analysis\nTransactions and concurrency/locking fundamentals\nOperational practices (maintenance concepts, capacity/performance troubleshooting)\nAdvanced SQL skills: ability to design and tune complex queries and explain performance tradeoffs.\nDatabase programming experience:\nPL/pgSQL and T-SQL\nPython proficiency (required) for tooling/automation (scripts, data analysis, API integrations as needed).\nBackup/restore and DR competence:\nAbility to define and validate restores, document procedures, and improve reliability.\nStrong troubleshooting discipline and clear written communication (runbooks, change notes, incident findings).\nAbility to maintain confidentiality and follow secure handling practices.\nExperience with Postgres replication/failover tooling and/or SQL Server HA patterns relevant to your environment.\nFamiliarity with Postgres backup tooling and WAL/archiving and SQL Server backup strategies.\nExperience integrating database migrations into CI/CD.\nStrong Linux and Windows operational familiarity for end-to-end troubleshooting (storage, metrics, performance counters).\nObservability experience building actionable DB monitoring/alerting.\nFamiliarity with Relativity or similar eDiscovery platforms is a plus, not required.\nParticipation in an on-call rotation and occasional after-hours maintenance windows (as required for production support).\nBackground check required due to sensitive client data handling.\nOccasional travel may be required.\nIf 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.","company":"Technologyconcepts","rawCompany":"technologyconcepts","city":"Denver","state":"CO","isRemote":false,"isActive":false,"createdAt":"2026-08-15T12:48:58.063Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Database Administrator (PostgreSQL & Microsoft SQL Server)","description":"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.\nYou 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.\n\nResponsibilities\nRequired Skills\nPreferred Skills\nWork Expectations\nDesign and evolve database schemas and data models to support new features, scale, and maintainability.\nWrite, review, and optimize SQL for PostgreSQL and SQL Server:\nExecution plan analysis, indexing strategy, query refactors, and performance baselines.\nBuild database-side logic and utilities:\nPL/pgSQL functions/procedures/triggers/views and T-SQL objects as needed.\nTroubleshoot complex production issues:\nPerformance regressions, locking/blocking/deadlocks, resource contention, connectivity issues, and reliability problems.\nDevelop operational tooling and automation in Python (required) plus Bash (preferred) and database scripting.\nEvaluate, test, and improve backup/restore and disaster recovery procedures:\nRetention, security, restore validation, and recovery runbooks.\nEvaluate and improve high availability / clustering approaches appropriate to Postgres, SQL Server, and ElasticSearch:\nReplication/failover concepts, testing failure modes, and documenting operational procedures.\nCollaborate with engineering and platform teams during releases:\nMigration planning, rollout/rollback strategy, risk assessment, and production readiness.\nHands-on database experience in production environments.\nPractical expertise in PostgreSQL, Microsoft SQL Server, and ElasticSearch, including:\nSchema/data modeling, indexing, query tuning, and execution plan analysis\nTransactions and concurrency/locking fundamentals\nOperational practices (maintenance concepts, capacity/performance troubleshooting)\nAdvanced SQL skills: ability to design and tune complex queries and explain performance tradeoffs.\nDatabase programming experience:\nPL/pgSQL and T-SQL\nPython proficiency (required) for tooling/automation (scripts, data analysis, API integrations as needed).\nBackup/restore and DR competence:\nAbility to define and validate restores, document procedures, and improve reliability.\nStrong troubleshooting discipline and clear written communication (runbooks, change notes, incident findings).\nAbility to maintain confidentiality and follow secure handling practices.\nExperience with Postgres replication/failover tooling and/or SQL Server HA patterns relevant to your environment.\nFamiliarity with Postgres backup tooling and WAL/archiving and SQL Server backup strategies.\nExperience integrating database migrations into CI/CD.\nStrong Linux and Windows operational familiarity for end-to-end troubleshooting (storage, metrics, performance counters).\nObservability experience building actionable DB monitoring/alerting.\nFamiliarity with Relativity or similar eDiscovery platforms is a plus, not required.\nParticipation in an on-call rotation and occasional after-hours maintenance windows (as required for production support).\nBackground check required due to sensitive client data handling.\nOccasional travel may be required.\nIf 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.","datePosted":"2026-08-15T12:48:58.063Z","dateModified":"2026-08-15T12:48:58.063Z","hiringOrganization":{"@type":"Organization","name":"Technologyconcepts","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Denver","addressRegion":"CO","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"01f2d24546cc72797e473375"},"url":"https://jobsearcher.com/jobs/01f2d24546cc72797e473375"}}