Senior Oracle Database Administrator, ERP & Cloud

Royper Royco LLC; United States; Remote; USD 90,000 - 96,000; Full time

Job summary

Royper Royco LLC is seeking a Senior Oracle Database Administrator with ERP and cloud focus in the United States. You will oversee critical Oracle databases, ERP applications (CGI Advantage, InfoAdvantage), and cloud integrations across on-prem and cloud environments.

You will drive automation, disaster recovery, and modernization initiatives, collaborating with developers, infrastructure, and management to meet milestones and security requirements.

Qualifications

• Bachelor's degree in Information Technology, Engineering, or a related field; substitutions possible year-for-year.
• 10+ years supporting Oracle databases and 10+ years in Oracle security patch deployments.
• Experience deploying Oracle in on-prem and cloud (OCI, AWS, Azure) environments.

Responsibilities

• Administer, maintain, and optimize Oracle databases for CGI Advantage and InfoAdvantage.
• Strengthen security with patching, access controls, encryption, auditing, and key management.
• Plan deployments, upgrades, migrations, configurations, and maintenance across on-prem and cloud.
• Architect and manage Oracle availability and replication with RAC and Data Guard.
• Automate administration and maintenance via scripting and orchestration tools.
• Deploy, monitor, and secure databases in OCI and other clouds.
• Support PostgreSQL, MySQL, MariaDB, AWS Aurora and AWS RDS.
• Lead migrations of on-prem Oracle/SQL Server to cloud platforms.
• Collaborate with developers and stakeholders to define requirements and deliver solutions.

Skills

Oracle DBA

Cloud migrations

Automation

Disaster recovery

Oracle RAC/Data Guard

Security and patching

Oracle Cloud OCI

SQL/PLSQL scripting

Monitoring & EM

Education

Bachelor's degree in IT/Engineering

Tools

Dell/EMC AppSync

CommVault

Oracle Enterprise Manager

Toad

Zabbix

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Oracle Database Administrator, ERP & Cloud based in the United States.

The Senior Oracle Database Administrator will oversee complex enterprise database environments and ERP applications, ensuring their security, availability, performance, and reliability. This role combines advanced Oracle database administration with cloud infrastructure, automation, disaster recovery, and database modernization initiatives. You will support critical enterprise applications, including CGI Advantage and InfoAdvantage, while managing database deployments across on-premises and cloud environments.

The position also involves integrating diverse database technologies, supporting cloud migrations, and strengthening operational resilience through automation and robust recovery strategies. Working closely with developers, infrastructure specialists, management, and business stakeholders, you will help shape technical solutions and deliver key project milestones.

Accountabilities:

• Administer, maintain, and optimize Oracle databases supporting enterprise applications, including CGI Advantage and InfoAdvantage.
• Strengthen database security through patch management, access controls, encryption, auditing, and key management.
• Plan and execute database deployments, upgrades, migrations, configurations, and ongoing maintenance across on-premises and cloud environments.
• Architect and manage Oracle database availability and replication using Oracle RAC and Data Guard.
• Perform database backups, restores, cloning, and disaster recovery operations using Dell/EMC AppSync and CommVault.
• Automate database administration, deployment, and maintenance activities through scripting, scheduling, and orchestration tools.
• Deploy, administer, monitor, and secure databases within Oracle Cloud Infrastructure (OCI) and other cloud environments.
• Support PostgreSQL, MySQL, MariaDB, AWS Aurora, and AWS RDS database platforms.
• Integrate Oracle databases with Databricks using change data capture technologies.
• Lead or support migrations of on-premises Oracle and SQL Server databases to cloud platforms, including AWS PostgreSQL and MariaDB.
• Monitor database performance, availability, security, and operational health using appropriate administration and monitoring tools.
• Collaborate with application developers, infrastructure teams, management, and business stakeholders to define technical requirements, design solutions, and coordinate project delivery.
• Develop database schemas, system designs, and external-interface processes while ensuring alignment with enterprise architecture requirements.
• Coordinate project milestones, respond to stakeholder needs, and contribute to continuous improvements in database operations.

Requirements:

• Bachelor's degree in Information Technology, Engineering, or a related field. Additional qualifying professional experience may substitute for education on a year-for-year basis.
• At least eight years of experience in systems development, analysis, programming, or testing.
• At least ten years of experience supporting Oracle databases, including versions 12.x and later.
• At least ten years of experience planning, deploying, and managing Oracle security patch updates.
• At least ten years of experience architecting Oracle database deployments across Windows, Linux, Unix/IBM AIX, VMware infrastructure, and cloud environments.
• At least two years of experience with each of 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 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.
• PostgreSQL and MySQL administration across on-premises and cloud environments.
• Migration of on-premises Oracle or SQL Server databases to cloud database platforms.
• Infrastructure and database automation using Ansible, Jenkins, or Terraform.
• Strong database scripting skills, including experience with PSQL and PGSQL.
• Familiarity with database management and monitoring tools such as Oracle Enterprise Manager, Toad, and 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 and collaboration skills, with the ability to work effectively with technical and non-technical stakeholders.
• Excellent coordination and organizational skills, including the ability to manage requirements, meet project milestones, and respond effectively to customer needs.
• AWS, OCI, and Azure cloud certifications are valued.
• Active participation in or organization of open-source community projects and events, such as SCALE or similar communities, is an advantage.
• Hourly compensation: $65–$70 per hour.
• Remote work arrangement within the specified location eligibility.
• Opportunity to work with enterprise Oracle ERP systems and diverse cloud database technologies.
• Exposure to large-scale database modernization, cloud migration, automation, and disaster recovery initiatives.

We appreciate your interest and wish you the best!