Database Administrator

Job Description About Us 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. Read more about apexanalytix - https://www.apexanalytix.com/about/ Job Details Job Overview We are seeking a motivated and detailoriented mid to seniorlevel Database Administrator (DBA) with proven handson experience in PostgreSQL and Microsoft SQL Server (MSSQL). You will lead engineering efforts across both platformsowning design, implementation, operations, and continuous improvement for missioncritical databases. The role requires strong expertise in performance engineering, high availability, backup & recovery (including PostgreSQL WAL/PITR), and security hardening, while mentoring junior team members and driving standards in a collaborative, production environment. Responsibilities Database Implementation and Support - Lead and mentor the installation, configuration, and lifecycle management of PostgreSQL clusters (primary/replica, connection pooling) and MSSQL instances. - Own database architecture decisions (storage layout, parameter baselines, instance sizing) across environments (dev/QA/prod). - Design and deploy schema objects (tables, views, functions/procedures), enforcing standards and code review gates. - Define and enforce configuration baselines (e.g., PostgreSQL shared_buffers, work_mem, max_connections; MSSQL memory caps, TempDB layout). High Availability & Disaster Recovery - Design, implement, and operate PostgreSQL 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. - Continuously test backups and endtoend recovery (tablelevel, pointintime, and full site failover). Monitoring and Alerting - Establish SLIs/SLOs and proactive alerting for pg_stat_activity, replication lags, bloat, connection saturation, deadlocks, and longrunning 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. Capacity Planning - Forecast storage, compute, and connection capacity based on growth patterns and workload characteristics. - Perform index and data growth analysis, and recommend costefficient scaling approaches (vertical/horizontal, connection pooling). Backup and Recovery Operations - Own backup strategy and automation for PostgreSQL (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. Performance Tuning - Lead advanced tuning for PostgreSQL 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. Security and Access Control - Implement leastprivilege access, rolebased security, password policies/secrets management, and auditing for PostgreSQL and MSSQL. - Support audit/compliance requirements and periodic access reviews. Patching and Updates - Plan and execute minor/major upgrades (PostgreSQL versioning and inplace 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. Incident Handling - Lead troubleshooting and rootcause analysis for performance, availability, and data integrity incidents. - Create postincident reviews, implement preventative measures, and mentor the team on operational excellence. Automation and Scripting - Automate operations with SQL, Bash/PowerShell, and, where applicable, Python/Ansible/Kubernetes jobs. - Champion IaC/GitOps practices for database config and backup/restore orchestration. Team Collaboration - Partner with application, platform, and SRE teams to align database architectures with product goals. - Provide technical leadership and code reviews for schema changes, migration scripts, and data movement. Qualifications Education: - Bachelor's degree in Computer Science, Information Technology, or a related field. Experience - 812 years of progressive experience administering PostgreSQL (mandatory) and MSSQL in production. - Demonstrated ownership of HA/DR, performance tuning, and backup/recovery for large, missioncritical systems. Additional Skills (Preferred) - Experience with Babelfish for PostgreSQL for SQL Server migration usecases. - Familiarity with Kubernetes operators (e.g., Crunchy Data PGO) and cloud object storage for backups. - Scripting/automation using Bash, PowerShell, or Python; CI/CD/GitOps practices. Certifications - Microsoft (e.g., Azure/SQL) or equivalent (optional but preferred). - PostgreSQLfocused certifications (e.g., EDB, Cloudvendor specialty) are a plus. Communication - Strong verbal and written communication skills. - Ability to document processes, lead technical discussions, and drive consensus. Over the years, we've discovered that the most effective and successful associates at apexanalytix are people who have a specific combination of values, skills, and behaviors that we call The apex Way. Read more about The apex Way - https://www.apexanalytix.com/careers/ Benefits At apexanalytix we know that our associates are the reason behind our successes. We truly value you as an associate and part of our professional family. Our goal is to offer the very best benefits possible to you and your loved ones. When it comes to benefits, whether for yourself or your family the most important aspect is choice. And we get that. apexanalytix offers competitive benefits for the countries that we serve, in addition to our BeWell@apex initiative that encourages employees growth in six key wellness areas: Emotional, Physical, Community, Financial, Social, and Intelligence. With resources such as a strong Mentor Program, Internal Training Portal, plus Education, Tuition, and Certification Assistance, we provide tools for our associates to grow and develop.