Oracle Database Engineer

Title: Oracle Database EngineerLocation:Berkeley Heights, NJPosition SummaryWe are seeking an experiencedOracle Database Engineerto design, implement, migrate, and support mission-critical Oracle database environments across on-premises data centers and Oracle Cloud Infrastructure (OCI), includingExadata Cloud@Customer (ExaCC)andExadata Cloud Service (ExaCS)platforms. This role will be responsible for database engineering, performance optimization, high availability, disaster recovery, automation, security, and cloud migration initiatives while ensuring minimal to zero application downtime through technologies such asOracle Data Guard, GoldenGate, and Zero Downtime Migration (ZDM).The ideal candidate will possess strong expertise in Oracle database administration, cloud technologies, automation, performance tuning, backup and recovery, and enterprise-scale database operations.Required QualificationsBachelor’s degree in information technology, Computer Science, Engineering, or a related field (or equivalent experience).Minimum 5 years of hands-on experience in Oracle Database Administration and Engineering.Proven experience managing large-scale Oracle database environments in both on-premises and cloud infrastructures.Strong understanding of database architecture, high availability, security, networking, storage, and disaster recovery solutions.ResponsibilitiesEngineer and migrate Oracle database environments from on-premises platforms to Oracle Cloud Infrastructure, including ExaCC and ExaCS.Design and implement highly available database solutions utilizing Oracle RAC, ASM, Data Guard, Active Data Guard, and GoldenGate.Monitor, analyze, and optimize database performance using Oracle Enterprise Manager, AWR, ADDM, and other diagnostic tools.Perform database upgrades, patching, maintenance, failover testing, and disaster recovery validation.Implement and maintain backup and recovery strategies for critical databases.Automate operational processes using scripting and infrastructure automation tools.Collaborate with application, infrastructure, storage, networking, and security teams to troubleshoot and resolve complex issues.Ensure compliance with enterprise security standards, including encryption, key management, and data protection practices.Technical RequirementsOracle Database Technologies5+ years installing, configuring, and administering Oracle Databases (11g, 12c, 19c, and newer versions).5+ years supporting Oracle databases in OLTP and Data Warehouse environments.5+ years administering Oracle ASM and RAC.3+ years administering Oracle Multitenant (CDB/PDB) architecture.5+ years performing database migrations, upgrades, and rehosting activities with minimal downtime.5+ years of performance tuning, troubleshooting, and root cause analysis in enterprise Oracle environments.Operating Systems & InfrastructureAIXLinuxStorage conceptsNetworking fundamentalsSAN environmentsBackup platforms (IBox, DDBoost)Exacc, Exadata is a plusHigh Availability & Replication3+ years implementing and administering Oracle Data Guard and Active Data Guard.3+ years implementing Oracle GoldenGate replication, including bidirectional replication, Conflict Detection and Resolution (CDR), and Automatic CDR.Experience with Oracle Streams and other enterprise replication technologies.Experience conducting disaster recovery testing and failover exercises.Cloud & Migration TechnologiesMinimum 1 year of hands-on experience migrating Oracle databases to OCI ExaCS/ExaCC using Oracle Zero Downtime Migration (ZDM) and other cloud migrations, like AWS , AZURE.Experience designing and supporting hybrid cloud and cloud-native database architectures.Understanding of cloud networking, security, encryption, and storage services within OCI.Backup & Recovery5+ years managing backup and recovery solutions for databases larger than 5TB.Experience with RMAN, Oracle Recovery Manager, and enterprise backup platforms including NetBackup, EMC NetWorker, and DD Boost.Experience designing and validating disaster recovery and backup recovery procedures.Monitoring & ManagementExtensive experience implementing and administering Oracle Enterprise Manager (OEM).Experience monitoring and managing enterprise-scale database and middleware environments.Demonstrated expertise using AWR, ADDM, Diagnostics Pack, and Tuning Pack.Middleware & Oracle TechnologiesExperience administering Oracle Fusion Middleware, Oracle Application Server, and WebLogic Suite.Experience with Oracle technologies including:Oracle Advanced SecurityOracle Label SecurityOracle Configuration ManagementPL/SQL DevelopmentOracle APEXData Warehousing SolutionsScripting & AutomationExperience developing automation using:Shell Scripting (Bash/KornShell)PythonJavaScriptStrong focus on operational automation, process standardization, and infrastructure-as-code principles.Modern Application & Integration TechnologiesKnowledge of:JSON, XML, REST APIs, SOAP Web ServicesMicroservices architecture and implementation patternsCloud-native integration technologiesAdditional Database TechnologiesExperience administering MySQL and PostgreSQL databases.Hands-on experience with MongoDB or other NoSQL database platforms.Security3+ years implementing and administrating Oracle Transparent Data Encryption (TDE).Experience managing Hardware Security Module (HSM)-based encryption key storage and lifecycle management.Knowledge of database security best practices, compliance requirements, and enterprise data protection standards.IT Service ManagementExperience working within ITIL-based operational environments.Experience using ServiceNow, Remedy, or equivalent IT service management platforms for incident, change, and problem management.Preferred QualificationsExperience with Oracle Exadata, Exadata Cloud@Customer (ExaCC), and Exadata Cloud Service (ExaCS).Oracle Cloud Infrastructure (OCI) certifications.Experience with DevOps practices and CI/CD pipelines.Strong communication and stakeholder management skills.Passion for emerging database technologies, automation, and continuous improvement.