Sr Technical Consultant - Cloud - PostgreSQL DBA, Oracle, Performance Troubleshooting, Backup/Restore, Replication

Scope

• The role requires strong technical ownership, production support experience, and the ability to contribute to database reliability, automation, and migration initiatives.
• The candidate should be responsible for database administration, performance tuning, backup and recovery, replication, high availability, monitoring, troubleshooting, patching, security, and operational support.

What You’ll Do

• Administer, maintain, and support PostgreSQL databases across production and non-production environments.
• Perform PostgreSQL installation, configuration, upgrades, patching, and version lifecycle management.
• Manage backup, restore, point-in-time recovery, replication, high availability, and disaster recovery configurations.
• Troubleshoot performance issues related to queries, indexes, vacuum, autovacuum, bloat, locking, blocking, memory, connections, and storage.
• Perform query tuning, index optimization, execution plan analysis, capacity planning, and database health checks.
• Support database migrations, data refreshes, data movement, and platform modernization activities.
• Monitor database availability, performance, replication lag, storage growth, logs, and alerts.
• Work with application, infrastructure, cloud, and support teams for incident resolution and RCA.
• Support change management, incident management, problem management, and production deployment activities.
• Contribute to automation, operational documentation, dashboards, SOPs, and reliability improvements.
• Provide Oracle DBA support as a secondary skill, including administration, troubleshooting, backup/recovery awareness, and production support.

What We Are Looking For

• 5 to 10 years of overall database administration experience.
• Strong hands-on experience in PostgreSQL administration in production environments.
• Good understanding of PostgreSQL architecture, MVCC, WAL, vacuum/autovacuum, indexing, partitioning, replication, backup/recovery, and security.
• Experience with PostgreSQL HA/DR solutions such as streaming replication, logical replication, Patroni, pgBackRest, Barman, repmgr, or similar tools.
• Strong SQL tuning and execution plan analysis skills.
• Experience troubleshooting locks, long-running queries, connection exhaustion, replication lag, bloat, and storage issues.
• Working knowledge of Oracle Database administration.
• Good scripting knowledge using Shell, Python, or similar automation tools.
• Strong experience in production support, incident handling, RCA, and operational governance.

Our Values If you want to know the heart of a company, take a look at their values. Ours unite us. They are what drive our success – and the success of our customers. Does your heart beat like ours? Find out here: Core Values All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.