Senior Oracle Database Administrator, ERP & Cloud

Newhouse Project Consulting; Norwalk (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Newhouse Project Consulting seeks an experienced Oracle ERP Database Systems Administrator to support enterprise Oracle databases and ERP apps. You will manage security, backups, and DR across on‑prem and cloud environments.

The role requires extensive Oracle experience and collaboration with developers, infrastructure, management and business stakeholders. Strong automation and cross‑team communication are essential.

Qualifications

• Eight years of experience in systems development, analysis, programming, or testing.
• Ten years of experience in supporting Oracle databases and deployment/patch management.
• Two years of experience with Oracle Advanced Security Option and Data Guard.

Responsibilities

• Strengthen database security through patching, access controls, encryption, auditing, and key management.
• Administer Oracle databases for CGI Advantage and InfoAdvantage.
• Plan deployments, upgrades, and migrations across on‑premises and cloud environments.

Education

Bachelor’s degree in information technology or related field

Cloud certifications (AWS, OCI, Azure)

Tools

Oracle Enterprise Manager

Toad

Zabbix

Job description

We have an opportunity for an experienced Oracle ERP Database Systems Administrator to support enterprise database environments and ERP applications. This role combines database architecture, administration, security, automation, cloud migration, and disaster recovery.

The ideal candidate brings extensive Oracle experience and the ability to work closely with application developers, infrastructure teams, management, and business stakeholders.

What You’ll Do

• Strengthen database security through patching, access controls, encryption capabilities, auditing, and key management.
• Administer and support Oracle databases for enterprise applications, including CGI Advantage and InfoAdvantage.
• Plan and execute database deployments, upgrades, migrations, and ongoing maintenance across on-premises and cloud environments.
• Manage database availability and replication using Oracle RAC and Data Guard.
• Perform backups, restores, cloning, and disaster recovery using Dell/EMC AppSync and CommVault.
• Automate database administration tasks through scripting, scheduling, and deployment tools.
• Deploy, manage, and monitor databases in Oracle Cloud Infrastructure and other cloud environments.
• Support PostgreSQL, MySQL, MariaDB, AWS Aurora, and AWS RDS environments.
• Integrate Oracle databases with Databricks using change data capture.
• Migrate on-premises Oracle or SQL Server environments to cloud databases, including AWS PostgreSQL or MariaDB.
• Collaborate with technical and business teams to define requirements, develop system designs, and deliver project milestones.

Required Experience

At least eight years of experience in systems development, analysis, programming, or testing.

At least 10 years of experience in:

• Supporting Oracle databases, including versions 12.x and above.
• Planning, deploying, and managing Oracle security patch updates.
• Architecting Oracle database deployments across Windows, Linux, Unix/IBM AIX, VMware infrastructure, and cloud environments.

At least two years of experience in the following areas:

• Oracle Advanced Security Option.
• Database deployment, configuration, upgrades, and support for CGI Advantage and InfoAdvantage ERP solutions.
• Oracle replication technologies, including Data Guard.
• Database administration automation using tools such as Bash, Perl, Python, Jenkins, Ansible Tower, Control-M, and Oracle Enterprise Manager.
• Oracle database deployment, upgrades, administration, and monitoring in OCI.
• Backup, restore, cloning, and disaster recovery using Dell/EMC AppSync and CommVault.
• Oracle Audit Vault, Key Vault, Enterprise Manager, and RAC.
• Deployment, monitoring, administration, and security of MySQL, MariaDB, PostgreSQL, AWS Aurora, and AWS RDS databases.
• Oracle-to-Databricks integration using change data capture.
• PostgreSQL and MySQL administration across on-premises and cloud environments.
• Migration of on-premises Oracle or SQL Server databases to cloud database platforms.
• Automation using Ansible, Jenkins, or Terraform.

Additional Technical and Collaboration Skills

• Database scripting using technologies such as PSQL and PGSQL.
• Database management and monitoring using Oracle Enterprise Manager, Toad, or Zabbix.
• Knowledge of generative AI fundamentals.
• Experience with conceptual and detailed system design, database schema design, and external-interface jobs.
• Familiarity with JBoss Messaging and Spring JMS connectivity.
• Strong communication skills with management, developers, infrastructure teams, and business stakeholders.
• Ability to coordinate requirements and project milestones while responding promptly to customer needs.

Education and Professional Qualifications

• Bachelor’s degree in information technology, engineering, or a related field. Additional qualifying experience may substitute for the required education on a year-for-year basis.
• Cloud certifications in AWS, OCI, and Azure.
• Active participation in or organization of open-source community projects and events, such as SCALE or similar communities.