Senior Oracle Database Administrator, ERP & Cloud

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.

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

  Benefits:

  • Hourly compensation: $65–$70 per hour.

  • Contract engagement.

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