Senior Oracle Database Administrator, ERP & Cloud

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.

• 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.

  • 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.

  • 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.