SQL Server Database Administrator

Job Title:

SQL Server Database Administrator - 01-5265 •NO CTC - Please do not apply if you can't work directly for us Must be Local or willing to relocate from day one. Alternate weeks in Richmond VA office; other week remote. (5 days in office, 5 days remote, repeating). No 100% remote

Knowledge, Skills, Abilities, and Experiences:

The successful candidate will have 10+ years of hands-on experience as a SQL Server DBA and PostgreSQL DBA, with a strong focus on database performance monitoring, query optimization, and backup and recovery operations in enterprise environments. The candidate will demonstrate deep knowledge of SQL Server and PostgreSQL internals and best practices to ensure availability, performance, and data protection. The candidate will have direct experience with the following: Enterprise-level SQL Server and PostgreSQL DBA experience on Windows and Linux operating systems, supporting production environments Strong expertise in database performance monitoring and tuning across SQL Server and PostgreSQL, including: o Identifying and resolving blocking, deadlocks (SQL Server), and lock contention (PostgreSQL)o Analyzing execution plans (SQL Server) and

EXPLAIN/EXPLAIN ANALYZE

output (PostgreSQL)o Monitoring CPU, memory, disk I/O, wait statistics (SQL Server), and PostgreSQL metrics such as WAL activity, checkpoints, and vacuum processes Advanced experience managing backup and restore strategies, including: o

SQL Server:

full, differential, and transaction log backupso

PostgreSQL:

logical and physical backups using pg_dump, pg_basebackup, and WAL archivingo Restore testing and point-in-time recovery (PITR) for both platformso Disaster recovery readiness and validation Solid understanding of database internal architecture, including: o

SQL Server:

memory management, indexing, locking, and transaction loggingo

PostgreSQL:

MVCC (Multi-Version Concurrency Control), autovacuum, indexing strategies, and WAL (Write-Ahead Logging)o

SQL Server:

Availability Groups, replication, log shippingo

PostgreSQL:

streaming replication, logical replication, failover clustering solutions (e.g., Patroni, repmgr) SQL Server administration experience with SQL Server 2012 and above and PostgreSQL 11+ (or newer versions) Hands-on experience with installation, upgrades, patching, and maintenance for both SQL Server and PostgreSQL Experience managing High Availability and Disaster Recovery (HA/DR) solutions such as: Ability to write and optimize T-SQL and PostgreSQL (PL/pgSQL) queries for troubleshooting and performance analysis Scripting experience (PowerShell, Bash, or Python) to automate routine DBA tasks such as monitoring, maintenance, and reporting Experience supporting databases hosted on Azure, cloud platforms (e.g., Azure Database for Postgre

SQL, AWS RDS

), and on-prem environments High Level Project Overview / Responsibilities Provide day-to-day operational support for multiple SQL Server and PostgreSQL databases across Azure, Linux, and Windows environments Monitor database health and performance, proactively identifying and resolving performance issues at the database and query level across both platforms Perform query analysis and tuning to support application performance and stability for SQL Server and PostgreSQL workloads Design, implement, and maintain robust backup and recovery solutions, ensuring data integrity and recoverability across both systems Execute database restores for production support, testing, and disaster recovery scenarios Support and maintain HA/DR configurations, ensuring high availability and minimal downtime for both SQL Server and PostgreSQL Utilize monitoring tools (e.g., Spotlight, native PostgreSQL tools, pgAdmin, or third-party monitoring platforms) to track performance trends and respond to alerts Perform database patching, upgrades, and maintenance activities Collaborate with application teams and business units to troubleshoot complex database-related issues Participate in a 24x7 on-call rotation supporting a large enterprise database environment Ensure compliance with security, audit, and regulatory requirements Work independently on DBA tasks while also contributing effectively as part of a team Maintain high standards of accuracy, documentation, and attention to detail Communicate effectively with technical and non-technical stakeholders, both verbally and in writing

Required Years of Experience:

Minimum of 10+ years of directly related experience

Required Education:

Minimum of High School Diploma or equivalency Ideal experience? Preference for prior experience in a regulated industry Location = Richmond VA (parking not provided) Rate = $47-$54/hr a W2 contract Length = 1+ Years W2 Contract - Possible long term/extension for the right candidate

Job Types:

Full-time, Contract Pay:

$47.00 - $54.00 per hour

Experience:

SQL Server DBA :

7 years (Required)

PostgreSQL DBA:

4 years (Required) database performance monitoring : 2 years (Required)

Work Location:

Hybrid remote in Richmond, VA 23219