Want to know if this job is worth applying to?
Bengaluru, Karnataka, India
Hybrid
Your role:
We are seeking an Infrastructure Engineer to aid in our transition from outsourced database management to an in-house model. This role is critical in stabilizing our legacy Oracle environments while driving our modernization strategy across our multi-cloud footprint. A major focus of this role will be spearheading the architectural shift of our database workloads from Oracle to PostgreSQL and modernizing our technology stack.
Database Modernization & Migration: Architect, plan, and execute the complex migration of legacy Oracle workloads to PostgreSQL. Serve as the in-house Subject Matter Expert (SME) for PostgreSQL design, implementation, and administration.
Multi-Cloud Infrastructure: Lead the strategy and execution of migrating and managing database workloads in managed cloud services across our multi-cloud environment (heavy emphasis on AWS and GCP, with minor support in Azure).
Performance Tuning & Optimization: Analyze complex queries, optimize database server settings across both Oracle and PostgreSQL platforms, and leverage enterprise performance monitoring tools to proactively tune systems.
Compliance, Security, & Licensing: Ensure databases comply with strict SOX guidelines. Implement encryption, access controls, and oversee quarterly account reviews. Maintain a general awareness of Oracle licensing and compliance to mitigate financial risks during the transition period.
Capacity Planning & DR: Determine and implement robust backup and recovery strategies (RTO/RPO), test automated failover procedures, and automate backup tasks using native cloud tooling.
High-Level Support: Provide expert, Level III escalation support for critical production incidents, including after-hours integration support and on-call rotations.
Experience in Oracle Database Administration (11g/12c/19c) across heterogeneous environments (Linux and Windows).
Proficiency in PostgreSQL database administration, including hands-on experience migrating enterprise-scale workloads from Oracle to PostgreSQL.
Proven track record of managing databases in multi-cloud environments (strong proficiency in AWS and GCP is required; experience with Azure is a plus).
Knowledge of or experience managing Microsoft SQL Server (MSSQL) environments is a strong plus.
General understanding of Oracle License Management Services (LMS) and compliance strategies.
Experience with enterprise automated job scheduling and database performance monitoring platforms.
Deep knowledge of database design, logical data models, and data normalization.