SQL Server & PostgreSQL DBA

• 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, 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.

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., * 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