Senior Database Administrator

At apexanalytix, we’re lifelong innovators! Since the date of our founding nearly four decades ago we’ve been consistently growing, profitable, and delivering the best procure-to-pay solutions to the world. We’re the perfect balance of established company and start-up. You will find a unique home here.

And you’ll recognize the names of our clients. Most of them are on The Global 2000. They trust us to give them the latest in controls, audit and analytics software every day. Industry analysts consistently rank us as a top supplier management solution, and you’ll be helping build that reputation.

We are seeking a motivated and detail‑oriented mid to senior‑level Database Administrator (DBA) with proven hands‑on experience in Postgre

SQL and Microsoft SQL Server (MSSQL). You will lead engineering efforts across both platforms—owning design, implementation, operations, and continuous improvement for mission‑critical databases. The role requires strong expertise in performance engineering, high availability, backup & recovery (including Postgre

SQL WAL/PITR), and security hardening, while mentoring junior team members and driving standards in a collaborative, production environment.
This role requires onsite work at our Greensboro, N.C. office.

• Lead and mentor the installation, configuration, and lifecycle management of Postgre
  
  SQL clusters (primary/replica, connection pooling) and MSSQL instances.
• Design and deploy schema objects (tables, views, functions/procedures), enforcing standards and code review gates.
• Define and enforce configuration baselines (e.g., Postgre
  
  SQL , , ; MSSQL memory caps, TempDB layout).

• Design, implement, and operate Postgre
  
  SQL HA (streaming replication, synchronous/asynchronous, failover orchestration, read scaling).
• Implement PITR with WAL management and retention policies; validate restores and disaster scenarios regularly.
• Own MSSQL HA/DR (Failover Cluster Instances, Log Shipping, Always On Availability Groups) including DR runbooks and RTO/RPO targets.

• Establish SLIs/SLOs and proactive alerting for _activity, replication lags, bloat, connection saturation, deadlocks, and long‑running queries.
• Configure and tune monitoring for MSSQL wait stats, TempDB health, I/O latency, index fragmentation, and blocking chains.
• Derive actionable insights and lead incident response using metrics, logs, and query plans.

• Forecast storage, compute, and connection capacity based on growth patterns and workload characteristics.
• Perform index and data growth analysis, and recommend cost‑efficient scaling approaches (vertical/horizontal, connection pooling).

• Own backup strategy and automation for Postgre
  
  SQL (e.g., pgBackRest) including full/incremental, WAL archiving, and verified restores.
• Define and manage MSSQL backup/restore strategies (full/diff/log), and validate restores via automated drills.
• Document recovery playbooks and ensure compliance with RPO/RTO objectives.

• Lead advanced tuning for Postgre
  
  SQL using EXPLAIN/ANALYZE, plan caching, statistics maintenance, vacuum/autovacuum tuning, and bloat management.
• Optimize MSSQL workloads via index strategy, parameter sniffing mitigation, memory/parallelism settings, and plan forcing when appropriate.
• Define performance baselines; guide developers on query design and access patterns.

• Implement least‑privilege access, role‑based security, password policies/secrets management, and auditing for Postgre
  
  SQL and MSSQL.
• Support audit/compliance requirements and periodic access reviews.

• Plan and execute minor/major upgrades (Postgre
  
  SQL versioning and in‑place vs. logical migrations; MSSQL CU/SP strategy) with minimal downtime.
• Evaluate new features/extensions (e.g., Babelfish for SQL migration paths) and drive adoption where relevant.

• Lead troubleshooting and root‑cause analysis for performance, availability, and data integrity incidents.
• Create post‑incident reviews, implement preventative measures, and mentor the team on operational…