Oracle Application Database Architect

Houston, TX, United States

Job Description:

The successful candidate will be responsible for designing, implementing, and managing the architecture and operations for Oracle EBS ERP applications, application platforms supporting Oracle applications, any additional applications utilizing the Oracle Database platform, the supporting hardware and storage platforms, server operating systems, server virtualization platforms, application client software operating on end user computing platforms and any other supporting hardware and software.

As a key member of the IT team, you will collaborate with Business Analysts, and IT Security, Enterprise Application and Infrastructure Architects to ensure the alignment of IT solutions to meet the company cybersecurity and business objectives.

Key Responsibilities:

Architecting, designing, implementing, managing and supporting Oracle EBS applications and associated applications and databases

Timely assessment, prioritization and implementation of security and application patches to assure secure and reliable operation of all Oracle application and database platforms.

Timely troubleshoot and resolve Oracle application and database issues and as necessary open, manage and implement Oracle application and DBA related SRs working with Oracle support

Securing access control by developing and maintaining access policies, procedures and controls

Monitor and troubleshoot Concurrent Manager problems, performance, and errors

Monitor and resolve tablespace alerts, blocking sessions, mount point issues in all the instances

Delivery and management of operating and project instances, as required

Plan, implement, enhance, and timely review database monitoring and alerts

Create and maintain DBA Standards, Processes and other necessary documents (DBA Run book, Cloning, Upgrades, Issues/Resolutions)

Implement, enforce and adhere to Disaster Recovery plan for supported Oracle applications and databases

Basic Qualifications:

10+ years of experience designing, implementing, and managing the architecture and operations for Oracle EBS ERP applications, application platforms supporting Oracle applications, any additional applications utilizing the Oracle Database platform, the supporting hardware and storage platforms, server operating systems, server virtualization platforms, application client software operating on end user computing platforms, preferably with a B.S. degree in an engineering, computer science, or information technology related discipline.

Oracle EBS application v12.2.x and Oracle 12c and 19c database implementation, upgrade and support experience

Expertise in Oracle application and database performance tuning and optimization and ability to efficiently and effectively troubleshoot problems to root cause

Expertise in Oracle EBS Sysadmin setup tasks for Oracle applications like responsibility, forms, function, menu, user setup, buyer, employee, etc.

Strong knowledge of RedHat Linux administration, including server deployment, configuration management, OS patching, access management, and security hardening.

Experience with UNIX/Shell/Perl scripting

Solid understanding of enterprise application architectures, including web applications, middleware and databases

Must have experience working on large scale projects as well as handling day-to-day operational requests from the business

Strong project management, ability to successfully manage multiple tasks at any given point

Strong relationship building skills & communication skills

Preferred Skills/Experience

Advanced Linux Administration Skills:

Experience implementing and supporting Oracle Linux and Oracle Virtual Machine (OVM)

Experience with Linux security hardening, intrusion detection/prevention systems, and compliance standards (e.g., PCI DSS, HIPAA).

Enterprise Application Architecture:

Understanding of enterprise application architectures, including web applications, databases (Oracle), and middleware (e.g., application servers, web servers, message queues).

Experience with application deployment strategies, containerization (e.g., Docker, Kubernetes), and orchestration tools.

Knowledge of cloud computing platforms (e.g., AWS, Azure, GCP) and their integration with enterprise applications.

Security and Compliance Knowledge:

Familiarity with cybersecurity best practices, threat detection/prevention techniques, and security incident response procedures.

Understanding of regulatory compliance requirements (e.g., GDPR, SOX, CCPA) and their implications for IT infrastructure, application and data protection.

Experience implementing security controls and conducting security assessments (e.g., segregation of duties analysis, privileged access review, vulnerability scanning, penetration testing).

Scripting and Automation Skills:

Proficiency in scripting languages such as Bash, Python, or PowerShell for automation tasks and system administration.

Experience with configuration management tools (e.g., Ansible, Puppet, Chef) for managing and provisioning infrastructure resources.

Backup and Recovery Expertise:

Experience designing and implementing application backup and recovery solutions using Veritas NetBackup or similar backup technologies, including the ability to incorporate Oracle database logs as part of backup and recovery to reduce potential data loss.

Knowledge of backup policies, scheduling, retention strategies, and data deduplication techniques.

Familiarity with backup encryption, compression, and replication for secure data protection.

Disaster Recovery Planning and Execution:

Ability to develop comprehensive disaster recovery plans and procedures to ensure business continuity in the event of a disaster.

Experience conducting disaster recovery exercises and simulations to validate recovery capabilities and identify areas for improvement.

Communication and Collaboration Abilities:

Excellent verbal and written communication skills for effectively communicating technical concepts to non-technical stakeholders.

Ability to collaborate with cross-functional teams, including functional and technical developers, business analysts, system administrators, business stakeholders and consultants, to achieve common goals.

Strong problem-solving skills and the ability to work independently and as part of a team in a fast-paced environment.

#J-18808-Ljbffr