Senior SQL Server & PostgreSQL DBA

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 PostgreSQL, 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 

Salary : $50