More jobs:
Database Administrator; PostgreSQL & Microsoft SQL Server
Job in
Greensboro, Guilford County, North Carolina, 27497, USA
Listed on 2026-07-18
Listing for:
TCDI
Full Time
position Listed on 2026-07-18
Job specializations:
-
IT/Tech
Database Administrator
Job Description & How to Apply Below
- 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 Elastic Search:
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 Elastic Search
, 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.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×