Database Administrator (PostgreSQL / MySQL / MSSQL) - L2

Job description

**Your Role and Responsibilities:** Role: Database Administrator (PostgreSQL / MySQL / MSSQL) L2 Experience: Minimum 4+ years of experience on PostgreSQL along with either MYSQL or MSSQL can be considered for this position. Key Responsibilities Database Administration - Install, configure, upgrade, and maintain PostgreSQL, MySQL, and MS SQL Server databases. - Manage database objects, schema design, storage, users, roles, and security policies. - Troubleshoot complex database performance and availability issues. Performance Monitoring & Optimization - Monitor databases using native tools and third-party platforms. - Perform advanced tuning of queries, execution plans, memory usage, Index optimization, partitioning strategies and statistics maintenance. - Memory, cache, and connection tuning (shared\\_buffers, innodb\\_buffer\\_pool\\_size, MAXDOP, TempDB optimization). - Resolve blocking, deadlocks, lock waits, replication lag, and slow query issues. - Query tuning using EXPLAIN / EXPLAIN ANALYZE (Postgres), EXPLAIN FORMAT=JSON (MySQL), Query Store (MSSQL) Backup, Recovery & High Availability - Implement and manage HA/DR solutions: - PostgreSQL: Streaming/Logical Replication, Patroni, pgBackRest - MySQL: Replication (async/semi-sync), Group Replication, InnoDB Cluster, Percona XtraDB Cluster (PXC) / Galera. - MS SQL: AlwaysOn AG, Log Shipping, Mirroring, Clustering (WSFC) and Replication (Transactional/Snapshot/Merge). - Perform backup strategy design, restore tests, and DR drills. o pg\\_basebackup, PITR, pgBackRest, barman (Postgres) o mysqldump, Percona XtraBackup, MySQL Enterprise Backup. o SQL Server Full/Diff/Log backups, VSS, Recovery Advisor. o Disaster Recovery planning and RTO/RPO adherence. Security & Compliance - Implement encryption (TDE, SSL/TLS), auditing, and access controls. - Ensure compliance with company and regulatory standards (SOX, PCI-DSS, GDPR). - Perform vulnerability remediation and patch management. Maintenance & Automation - Automate routine tasks using Shell/PowerShell/Python scripts. - Perform routine maintenance: vacuum, reindexing, statistics updates, integrity checks. - Create runbooks, SOPs, and documentation. Collaboration & Support - Provide L2 support for incidents, change requests, and planned maintenance. - Work with development, DevOps, and infrastructure teams to ensure database reliability. - Participate in on-call rotation for 247 support. Migration & Cloud - Database migration using pg\\_dump/restore, logical replication, DMS. - Migrate workloads to AWS RDS/Aurora, Azure SQL, Google Cloud SQL. - Experience in cross-platform migrations (MySQL PostgreSQL, SQL Server PostgreSQL, etc.) **Required Education:** Bachelor's Degree **Preferred education** Bachelor's Degree **Required Technical and Professional Expertise:** Minimum 4+ years of experience on PostgreSQL along with either MYSQL or MSSQL can be considered for this position **Preferred Technical and Professional Experience:** In addition to 4+ year of overall experience , candidate should have Hands-on experience in PostgreSQL (On prem, Native and RDS), MySQL, and MS SQL Server Database administration. Strong knowledge of replication, HA/DR, performance tuning, and backup tools. Strong SQL debugging and optimization capabilities. Experience with Linux and Windows OS. Knowledge of AWS/Azure/GCP hosted database services (preferred). Scripting proficiency (Shell / PowerShell / Python) - PostgreSQL Professional / EDB - MySQL DBA - Microsoft DP-300 / SQL Server certification - Cloud certifications (AWS/Azure) ****Years of Experience:**** 4 - 6