The Role
Administer and architect enterprise Oracle ERP database environments across on-premises and cloud platforms. Responsibilities include security patching, access controls, encryption, auditing, RAC and Data Guard availability, backup and disaster recovery, automation, cloud migration, monitoring, and support for Oracle, PostgreSQL, MySQL, MariaDB, AWS, and Databricks integrations. The role also collaborates with technical and business teams on requirements, system designs, deployments, and project milestones.
Summary Generated by Built In
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.
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.
- 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.
- 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.
Skills Required
- At least eight years of experience in systems development, analysis, programming, or testing.
- At least ten years supporting Oracle databases, including version 12.x and above.
- At least ten years planning, deploying, and managing Oracle security patch updates.
- At least ten years architecting Oracle database deployments across Windows, Linux, Unix/IBM AIX, VMware, and cloud environments.
- At least two years of experience with Oracle Advanced Security Option.
- At least two years deploying, configuring, upgrading, and supporting CGI Advantage and InfoAdvantage ERP solutions.
- At least two years with Oracle replication technologies, including Data Guard.
- At least two years automating database administration with Bash, Perl, Python, Jenkins, Ansible Tower, Control-M, and Oracle Enterprise Manager.
- At least two years deploying, upgrading, administering, and monitoring Oracle databases in Oracle Cloud Infrastructure.
- At least two years performing backup, restore, cloning, and disaster recovery using Dell/EMC AppSync and CommVault.
- At least two years with Oracle Audit Vault, Key Vault, Enterprise Manager, and RAC.
- At least two years deploying, monitoring, administering, and securing MySQL, MariaDB, PostgreSQL, AWS Aurora, and AWS RDS databases.
- At least two years integrating Oracle databases with Databricks using change data capture.
- At least two years administering PostgreSQL and MySQL across on-premises and cloud environments.
- At least two years migrating on-premises Oracle or SQL Server databases to cloud database platforms.
- At least two years automating infrastructure or database processes using Ansible, Jenkins, or Terraform.
- Database scripting experience using PSQL and PGSQL.
- Database management and monitoring experience 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.
- Bachelor's degree in information technology, engineering, or a related field; additional qualifying experience may substitute year-for-year.
- 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.
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Newhouse Project Consulting (NPC) is a boutique San Francisco Bay Area consulting firm focused on organizational excellence and sustainable transformation. It provides change-management strategy and adoption support, staff augmentation for temporary or long-term needs, AI advisory services, and Salesforce-partner expertise spanning requirements analysis through post-implementation operations. NPC also promotes mental-health literacy and ESG initiatives, helping organizations achieve lasting operational and societal outcomes.
