Senior Database Analyst – SQL DBA & PostgreSQL

Title

Senior Database Analyst - SQL DBA & PostgreSQL

Richmond, VA (onsite every other week)

12 months

We are seeking a highly experienced Senior Database Analyst with expertise in SQL Server and Postgre

SQL to join our team. The ideal candidate will have over a decade of hands‑on experience in database administration, performance monitoring, query optimization, and backup and recovery operations in enterprise environments. This role requires a deep understanding of database internals, high availability, and disaster recovery solutions. The candidate will work in a hybrid schedule, alternating one week in‑office and one week remote, and participate in a 24x7 on‑call rotation.

• Provide operational support for SQL Server and Postgre
  
  SQL databases across Azure, Linux, and Windows environments.
• Monitor database health and performance, identifying and resolving performance issues at the database and query levels.
• Perform query analysis and tuning to ensure application performance and stability.
• Design, implement, and maintain robust backup and recovery solutions for both SQL Server and Postgre
  
  SQL.
• Execute database restores for production support, testing, and disaster recovery scenarios.
• Support and maintain high availability and disaster recovery configurations for minimal downtime.
• Utilize monitoring tools 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.
• Ensure compliance with security, audit, and regulatory requirements.
• Maintain high standards of accuracy, documentation, and attention to detail.
• Communicate effectively with technical and non‑technical stakeholders.

• 10+ years of hands‑on experience as a SQL Server and Postgre
  
  SQL DBA in enterprise environments.
• Expertise in database performance monitoring, query optimization, and backup and recovery operations.
• Deep knowledge of SQL Server and Postgre
  
  SQL internals, including memory management, indexing, and transaction logging.
• Experience with SQL Server 2012+ and Postgre
  
  SQL 11+ on Windows and Linux operating systems.
• Proficiency in high availability and disaster recovery solutions such as SQL Server Availability Groups and Postgre
  
  SQL replication.
• Ability to write and optimize T‑SQL and PL/pgSQL queries for troubleshooting and performance analysis.
• Scripting experience in Power Shell, Bash, or Python for automating DBA tasks.
• Experience with databases hosted on Azure, AWS RDS, and on‑prem environments.
• Minimum of a high school diploma or equivalency; preference for candidates with experience in regulated industries.