Senior Oracle ERP Database Architect & Cloud Security Lead

Newhouse Project Consulting; Oregon; Hybrid; USD 120,000 - 180,000; Full time

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.