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.
Here you’ll get to:
-
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.
About you:
-
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.