Senior Oracle Database Administrator, ERP & Cloud
About The Position
The Senior Oracle Database Administrator supports enterprise database environments and ERP applications, combining database architecture and administration with security, automation, cloud migration, and disaster recovery. The role works closely with application developers, infrastructure teams, management, and business stakeholders. The administrator supports Oracle databases and ERP solutions including CGI Advantage and InfoAdvantage, along with PostgreSQL, MySQL, MariaDB, AWS Aurora, and AWS RDS. The position plans and executes deployments, upgrades, migrations, and maintenance across on-premises and cloud environments; manages availability and replication; performs backup and recovery activities; automates database administration; and deploys, manages, and monitors cloud databases. The role also integrates Oracle databases with Databricks using change data capture and contributes to system designs and project delivery.
Requirements
- At least eight years of experience in systems development, analysis, programming, or testing.
- At least 10 years of experience supporting Oracle databases, including versions 12.x and above.
- At least 10 years of experience planning, deploying, and managing Oracle security patch updates.
- At least 10 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 Oracle Advanced Security Option.
- At least two years of experience deploying, configuring, upgrading, and supporting CGI Advantage and InfoAdvantage ERP solutions.
- At least two years of experience with Oracle replication technologies, including Data Guard.
- At least two years of experience automating Oracle database administration using tools such as Bash, Perl, Python, Jenkins, Ansible Tower, Control-M, and Oracle Enterprise Manager.
- At least two years of experience deploying, upgrading, administering, and monitoring Oracle databases in OCI.
- At least two years of experience with backup, restore, cloning, and disaster recovery using Dell/EMC AppSync and CommVault.
- At least two years of experience with Oracle Audit Vault, Key Vault, Enterprise Manager, and RAC.
- At least two years of experience deploying, monitoring, administering, and securing MySQL, MariaDB, PostgreSQL, AWS Aurora, and AWS RDS databases.
- At least two years of experience integrating Oracle databases with Databricks using change data capture.
- At least two years of PostgreSQL and MySQL administration experience across on-premises and cloud environments.
- At least two years of experience migrating on-premises Oracle or SQL Server databases to cloud database platforms.
- At least two years of experience with automation using Ansible, Jenkins, or Terraform.
- Database scripting experience using technologies such as PSQL and PGSQL.
- Experience with 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.
- 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.
Nice To Haves
- 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.
Responsibilities
- 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.
- Coordinate requirements and project milestones while responding promptly to customer needs.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
