Infrastructure Engineer - Oracle DBA

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.