SQL Server DBA

Softpath System, LLC

Richmond, VA, United States

3 months ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Microsoft Windows Microsoft Azure Bash Shell Cloud Computing Databases Concurrency Controls Linux Disaster Recovery Memory Management Failover Clustering Python (Programming Language) PostgreSQL

+15 more

Microsoft SQL Server SQL Azure Windows PowerShell Query Optimization Data Streaming Transact-SQL Backup and Restore Data Logging Scripting System Availability Database Optimization Database Performance Indexer Amazon Relational Database Service SQL Server Management Studio (SSMS)

Requirements

Do you have experience in Windows?, 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 validationo 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)

Solid understanding of database internal architecture, including:
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 PostgreSQL, AWS RDS), and on-prem environments