Senior Database Analyst

Job Title: Senior Database Analyst - SQL DBA & PostgreSQL

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 backups
o PostgreSQL: logical and physical backups using pg_dump, pg_basebackup, and WAL archiving
o Restore testing and point-in-time recovery (PITR) for both platforms
o Disaster recovery readiness and validation
• Solid understanding of database internal architecture, including:
o SQL Server: memory management, indexing, locking, and transaction logging
o PostgreSQL: MVCC (Multi-Version Concurrency Control), autovacuum, indexing strategies, and WAL (Write-Ahead Logging)
• 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:
o SQL Server: Availability Groups, replication, log shipping
o PostgreSQL: streaming replication, logical replication, failover clustering solutions (e.g., Patroni, repmgr)
• 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

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

Are there any specific companies/industries you'd like to see in the candidate's experience?
• Preference for prior experience in a regulated industry

Preferred Interview Process Overview (High level):
• Teams Interview - Camera On