Database Administrator (PostgreSQL & Microsoft SQL Server)TCDI • Greensboro, North Carolina, United States
This job offer is no longer available
Database Administrator (PostgreSQL & Microsoft SQL Server)
TCDI
- Greensboro, North Carolina, United States
- Greensboro, North Carolina, United States
About
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.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.