Oracle ERP Database Systems Administrator

JRD Systems; Downey (CA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

JRD Systems, Downey, CA, is seeking an Oracle ERP Database Systems Administrator for a 12-month hybrid engagement. The role involves managing complex Oracle ERP database systems, implementing secure patches, and ensuring high availability across Windows/Linux environments.

The candidate should be comfortable with scripting, automation, and cloud-adjacent practices. The position requires experience with Oracle performance tuning, Data Guard replication, and enterprise monitoring tools, with a

Qualifications

• Bachelor's degree in IT-related or Engineering field.
• Experience with Oracle databases and ERP deployments.
• Experience designing DB schemas and automating DB tasks.
• Experience with external interfaces and DevOps tooling.

Responsibilities

• Architect system using prototyping and proofs of concepts.
• Develop product roadmaps, backlogs and measurable success criteria; write user stories.
• Coordinate with business stakeholders and cross-functional teams.
• Ensure alignment of technical design with business growth and direction.

Skills

Oracle performance tuning

Automation scripting

Data replication (Data Guard)

Generative AI foundations

Education

Bachelor's degree in IT or Engineering

Tools

AppSync Copy Data Management

CommVault

Oracle Enterprise Manager

Toad

Zabbix

Jenkins

Ansible

Job description

Job Title – Oracle ERP Database Systems Administrator

Location – Downey, CA(Hybrid)

Duration – 12 months

Only Candidates on w2

JOB DETAILS:

Position Description

A Technical Architect will serve as the manager of complex technology implementations, with an eye toward constant reengineering and refactoring to ensure the simplest and most elegant system possible to accomplish the desired need; understand how to maximize leverage of the open source community to deploy systems on Infrastructure as a Service (IaaS) providers; be comfortable sharing knowledge across a multi-disciplinary team and working within various methodologies; and be a full partner in the determination of vision, objectives, and success criteria. The Technical Architect will architect the overall system by using prototyping and proof of concepts, which may include: modern programming languages (e.g., Ruby, Python, Node.js) and web frameworks (e.g., Django, Rails), modern front-end web programming techniques (e.g., HTML5, CSS3, RESTful APIs) and frameworks (e.g., Twitter Bootstrap, jQuery), relational databases (e.g., PostgreSQL), and “NoSQL” databases (e.g., Cassandra, MongoDB), automated configuration management (e.g., Chef, Puppet, Ansible, Salt), continuous integration/deployment, and continuous monitoring solutions; use version control systems (e.g., Git and GitHub); ensure strategic alignment of technical design and architecture to meet business growth and direction, and stay on top of emerging technologies; decompose business and system architecture to support clean-interface multi-team development; develop product roadmaps, backlogs, and measurable success criteria, and write user stories (i.e., can establish a path to delivery for breaking down stories) and clearly communicate and work with stakeholders at every level.

Skills Required

The Technical Architect will possess knowledge and experience in analyses and development of conceptual designs and detail designs; developing JBOSS Messaging and connectivity with Spring-JMS connectivity; designing DB schema as per the requirements and in sync with the old system; implementing the daily and weekly jobs that interact with external interfaces; coordinating with business stakeholders to understand their requirements; communicate with cross-divisional personnel at both team and executive levels to understand performance measurement methodologies; and direct team members in compiling business requirements and executing project milestones.

Additional Skills Required

• Skilled in Oracle database performance tuning.


• Knowledge in database cloning using Dell/EMC AppSync Copy Data Management and CommVault.


• Knowledge in Cloud monitoring and logging services.


• Ability to deploy Oracle database security patches following industry best practices.


• Knowledge of high availability and disaster recovery architectures and implementations.


• Possess excellent communication skills to effectively interact with internal and external management teams, developers, network and infrastructure teams.


• Skilled in Foundations of Generative Artificial Intelligence.


• Proactive attention to customer requests and projects providing speed reliability and value.


• Skilled in using automation technology such as Ansible or Jenkins for database administration tasks.


• Skilled in database scripting technologies such as PSQL and PGSQL; Skilled in provisioning and managing database management and monitoring tools such as Oracle Enterprise Manager, Toad, or Zabbix.


• Skilled in architecting and managing database systems in Cloud environments.

Experience Required

• This classification must have a minimum of eight (8) years of experience in systems development, analysis, programming or testing.

Additional Experience Required

• 10+ years in the following:
  
  
  • Supporting Oracle versions 12.x and above.
  
  
  • Planning, deploying, managing Oracle Patch Security Updates.
  
  
  • Architecting Oracle database system deployments on Windows O/S, Linux, Unix, running on IBM AIX and VMware infrastructures and Cloud environments.
  
  
  
  


• 2+ years in the following:
  
  
  • Configuring, deploying and managing Oracle Advanced Security Option for database security.
  
  
  • Deploying, configuring, upgrading and supporting databases for ERP solutions using CGI Advantage and InfoAdvantage.
  
  
  • Utilizing Oracle replication methods such as Data Guard.
  
  
  • Developing scripts using tools such as Bash Shell, Perl, Python, Jenkins, Ansible Tower, Control-M, and Oracle Enterprise Manager to automate manual database administration tasks.
  
  
  • Deploying, upgrading, managing, and monitoring Oracle databases in Oracle Cloud Infrastructure (OCI) platform.
  
  
  • Performing database backups, restores, cloning, disaster recovery processes using Dell/EMC AppSync Copy Data Management and CommVault solutions.
  
  
  • Configuring Oracle Audit Vault, Key Vault, and Oracle Enterprise Manager.
  
  
  • Configuring and managing Oracle RAC.
  
  
  • Deploying, configuring, monitoring, securing MySQL, MariaDB, PostgreSQL, AWS Aurora Database and AWS RDS database servers.
  
  
  • Interfacing Oracle databases to Databricks systems using CDC.
  
  
  • Deploying, managing and monitoring PostgreSQL and MySQL database systems on premise and Cloud environments.
  
  
  • Migrating on premise Oracle or SQL Server database systems to Cloud database systems like AWS PostgreSQL or MariaDB.
  
  
  • Creating and deploying automation technologies such as Ansible, Jenkins or Terraform.
  
  
  
  

Education Required

• This classification requires the possession of a bachelor’s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Additional Education Required

• Hold AWS, OCI, Azure Certifications. Active member or organizer of an Open-Source Community Projects and Events, such as Scale or similar.