Senior SQL Server & PostgreSQL DBA

Senior SQL Server & PostgreSQL DBA Computer Enterprises Inc - 3.3 Richmond, VA Job Details Contract $50 an hour 1 day ago Benefits Health insurance Dental insurance Vision insurance 401(k) matching Qualifications Data replication Server optimization Azure High availability solutions design Query plan analysis Database backup and recovery Data retrieval time improvement Data recovery Server backup and recovery Operating system updates Software installation Server updates Database server management AWS IT monitoring tools Patch management Server installation Contingency planning Data backup Failover clustering Database migration or upgrading Linux Managing cloud database deployments System tuning RDS database Automation tools Database installation High availability T-SQL System performance monitoring Full Job Description SQL Server & PostgreSQL DBA Job at a

Glance Title:

SQL Server & PostgreSQL DBA Location:

Richmond, VA Contract:

W2 only, 12-month contract with potential for extension or conversion to full time

Pay:

$50/hour + optional medical, dental, vision, 401(k) match Overview 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. This role involves supporting production environments across Azure, Linux, and Windows, ensuring database availability, performance, and data protection. Key Responsibilities Provide operational support for SQL Server and PostgreSQL databases across Azure, Linux, and Windows Monitor database health and resolve performance issues Perform query analysis and tuning Design and maintain backup and recovery solutions Execute database restores for production and DR scenarios Maintain HA/DR configurations Use monitoring tools (Spotlight, pgAdmin, native tools, third-party platforms) Perform patching, upgrades, and maintenance Partner with application teams to troubleshoot database issues Participate in 24x7 on-call rotation Ensure compliance with security and regulatory requirements Maintain strong documentation and accuracy Communicate with technical and non-technical stakeholders Required Skills 10+ years of hands-on experience as a SQL Server DBA and PostgreSQL DBA Enterprise-level SQL Server and PostgreSQL DBA experience on Windows and Linux operating systems Database performance monitoring and tuning across SQL Server and PostgreSQL Identifying and resolving blocking, deadlocks (SQL Server), and lock contention (PostgreSQL) Analyzing execution plans (SQL Server) and

EXPLAIN/ANALYZE

output (PostgreSQL) Monitoring CPU, memory, disk I/O, wait statistics (SQL Server), and PostgreSQL metrics such as WAL activity, checkpoints, and vacuum processes Backup and restore strategies including full, differential, and transaction log backups (SQL Server), logical and physical backups using pg_dump, pg_basebackup, and WAL archiving (PostgreSQL) Restore testing and point-in-time recovery (PITR) for both platforms Disaster recovery readiness and validation Database architecture knowledge including memory management, indexing, locking, transaction logging (SQL Server), MVCC, autovacuum, indexing strategies, WAL (PostgreSQL) Installation, upgrades, patching, and maintenance for SQL Server and PostgreSQL High Availability / Disaster Recovery experience: SQL Server (Availability Groups, replication, log shipping), PostgreSQL (streaming replication, logical replication, failover clustering) Query development and optimization: T-SQL, PL/pgSQL Scripting for automation (PowerShell, Bash, or Python) Experience with Azure, cloud platforms (Azure Postgre

SQL, AWS RDS

), and on-prem environments Preferred Skills Experience with disaster recovery planning and validation Strong communication skills for stakeholder engagement Knowledge of security and regulatory compliance standards Why Should I Apply? This role offers the opportunity to work with enterprise-level database systems supporting critical environments. You will be part of a team that values expertise in SQL Server and PostgreSQL, with a focus on performance, reliability, and security.

About CEI:

As a trusted technology partner, CEI delivers solutions that help our customers transform their business and achieve meaningful results. From strategy and custom application development through application management - our technology and digital experience services are tailored to meet each unique need of our customers. Our staffing solutions bring specialized skills to complement our customers' workforce and project requirements. #ZR #INDGEN