Sr Subject Matter Expert (Support&Ops)

About the role

Manage, administer, and maintain PostgreSQL database environments to ensure high availability, performance, and reliability. Perform database installation, configuration, upgrades, patching, and migration activities across development, test, and production environments. Monitor database health, performance, storage utilization, and capacity planning using appropriate monitoring tools.

What you'll do

• Manage, administer, and maintain PostgreSQL database environments to ensure high availability, performance, and reliability
• Perform database installation, configuration, upgrades, patching, and migration activities across development, test, and production environments
• Monitor database health, performance, storage utilization, and capacity planning using appropriate monitoring tools
• Troubleshoot and resolve complex database issues related to performance, locking, replication, connectivity, backups, and recovery
• Design and implement high-availability and disaster recovery solutions using PostgreSQL replication, clustering, and failover technologies

What you need

• 6–10 yrs of experience
• SQL
• SOP writing
• PostgreSQL
• Root cause analysis
• Documentation
• Python
• Any graduate

Good to have

• PowerShell
• AWS
• GCP
• Azure
• Linux