Senior Technical Consultant - Cloud Infrastructure
Blue Yonder Pvt LtdJob Description
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.
Experience Level
Senior LevelJob role
Job requirements
About company
Similar jobs you can apply for
Telecalling / BPO / Telesales
Customer Care Executive
EarlyjobsCustomer Support Executive
Victa Earlyjobs Technologies Private Limited
Customer Care Officer
EarlyjobsCustomer Care Executive
Muthoot Finance
Customer Success Executive
Earlyjobs
Customer Support Executive
EarlyjobsYou can expect a minimum salary of 0 INR. The salary offered will depend on your skills, experience and performance in the interview.
The candidate should have completed the required education and people who have 7 to 10 years are eligible to apply for this job. You can apply for more jobs in Bengaluru/Bangalore to get hired quickly.
The candidate should have sound communication skills and sound communication skills for this job.
Both Male and Female candidates can apply for this job.
No, it's not a work from home job and can't be done online. You can explore and apply for other work from home jobs in Bengaluru/Bangalore at apna.
No work-related deposit needs to be made during your employment with the company.
Go to the apna app and apply for this job. Click on the apply button and call HR directly to schedule your interview.
The last date to apply for this job is . For more details, download apna app and find Full Time jobs in Bengaluru/Bangalore . Through apna, you can find jobs in 64 cities across India. Join NOW!