8+ years of experience in Oracle Apps DBA activities
Expert knowledge of Oracle EBS R12 application administration
Familiarity with multi-node EBS environments and troubleshooting workflows
Proficient in Oracle 11g database administration and performance tuning
Experience with Oracle RAC, ASM, and CRS management
Knowledge of Oracle SOA Suite, Hyperion, and OBIEE administration
Strong written communication skills for policy development and SOP creation
Experience with Oracle DBCS and ExaCS, particularly in cloud environments
Responsibilities
Perform Oracle EBS Applications DBA tasks including patching and performance tuning
Maintain a multi-node e-Business Suite environment and troubleshoot issues
Utilize Oracle RAC for performance and resilience in a Linux environment
Administer Oracle SOA Suite and WebLogic Server for ERP integration
Develop and enforce database policies and standard operating procedures
Communicate effectively with clients and team members
Conduct analysis and performance tuning of various Oracle components
Benefits
Competitive, above-average compensation
Opportunity to work remotely or from abroad
Flexible working hours and home office options
Attractive benefits including a company pension scheme
Modern work environment with a focus on collaboration
Open feedback culture and flat hierarchies
Individual career planning with ongoing training and coaching
Full Job Description
Position Summary Reporting to the Manager - Oracle MS Operations, Syntax is currently seeking a Senior Oracle Apps DBA who will work remotely or in office. This individual will take full responsibility of the basic and more complex tasks associated with Oracle Application Management. The ideal candidate will be a hands-on self-starter who has a strong cloud computing background, as well as a proven track record of successfully implementing and managing complex Oracle E-Business Suite environments.
Responsibilities
Performs Oracle EBS Applications database administration (DBA) tasks including patching, creating backup and recovery strategies, upgrading, performance tuning/optimization of Oracle EBS systems.
Maintain a multi-node e-Business Suite environment with Shared File System, managing and administering Concurrent Managers, Concurrent Programs, Request Sets, Request Groups, Workflows, and troubleshooting Workflow Mailer/Notification issues
Utilizes (a) Oracle Real Applications Clusters (RAC) to maintain a clustered database to provide performance, scalability, and resilience with Oracle Automatic Storage Management (ASM) and Oracle Cluster Ready Services (CRS) in a Linux operating system (O/S); (b) Oracle Recovery Manager (RMAN) and Data Guard for backup and disaster recovery; (c) Oracle Application Manager (OAM) and Oracle Enterprise Manager (OEM) Grid Control for proactive monitoring and notification of system status; and (d) Procedural Language/Structured Query Language (PL/SQL) packages, shell, and Perl scripts for task automation.
Performs administration and maintenance of the Oracle Service Oriented Architecture (SOA) Suite, Oracle Hyperion, Oracle Business Intelligence (OBIEE), and Oracle WebLogic Server to support Oracle ERP system integration with legacy systems.
Reviews, develops, recommends, enforces, and adheres to database policies and standards for Syntax; these policies and standards include policies and procedures on high availability, replication, archiving, access, and security. Develops new standard operating procedures (SOPs) for Oracle EBS application software installation and configuration including high availability and disaster recovery solutions.
Communicates and interacts effectively with client contacts and Syntax's business contacts including, but not limited to, other members of the unit/team, other Syntax employees (such as managers, supervisors, and support staff), contractors, and vendors
Analysis and Performance Tuning (Oracle Database 12c/19c, WebLogic, Oracle Application Server, JVM Tuning, Application SQL and PL/SQL code tuning, etc.)
Qualifications
8+ years of working experience with Oracle Apps DBA activities
Comprehensive expert level knowledge of Oracle EBS R12 application administration, including installation, configuration, cloning, and upgrades, using Oracle EBS R12 Applications DBA (AD) utilities and other tools to apply patches and system updates.
Knowledge of the multi-node EBS environment to administer Concurrent Managers, Concurrent Programs, Request Sets, Request Groups, and Workflows and troubleshooting Workflow Mailer/Notification issues.
Expert level knowledge of Oracle 11g database administration, maintenance, security implementation, upgrade and patching, database performance tuning, sizing and capacity planning, database backup and recovery in a Linux O/S using RMAN and Oracle export/import utilities, administration, and maintenance to provide backup and disaster recovery.
Knowledge of installation, configuration, and maintenance of multi-node Oracle RAC enabled databases, including Oracle ASM and Oracle CRS management. Knowledge of PL/SQL packages, shell, and Perl scripts for task automation, and proactive database monitoring and notification using Oracle OEM Grid Control.
Knowledge of administration and maintenance of the Oracle SOA Suite, Oracle Hyperion, and OBIEE, including Oracle WebLogic Server to support Oracle ERP system integration with legacy systems.
Skill in written communication to understand written information (facts, descriptions, ideas, concepts, conflicting assertions and arguments), draw inferences, form hypotheses and develop logical arguments, and to express such information in writing so that others will understand, and concerning some issues, be convinced or persuaded. Examples include reviewing and editing established database policies and procedures and developing new SOPs for database software installation and configuration.
Design and implementation of high availability, capacity planning and performance fine-tuning of Oracle Applications Database and associated systems.
Must have experience in analyzing/troubleshooting various components of E-business Suite 11i and R12 like Concurrent managers, Database, Workflow Service Components, Discoverer, Apache and OC4J and recommending best practices.
Good experience on upgrading Oracle Database to 19c and EBS to 12.2.10 is must.
Good Knowledge on Oracle DBCS, ExaCS and experience in administering applications on public could, mainly Oracle Cloud Infrastructure (OCI) & AWS is preferred.
Experience in installing, configuring, and administering Oracle Demantra on both Windows and Linux platforms.
Having experience in managing EBS and standalone databases on Oracle Engineered Systems is an added advantage.
Why Syntax?
Become a part of our success story and work in a company with exciting innovation projects that are causing a stir across the industry. We recently launched one of the world's most advanced manufacturing facilities based on SAP S/4HANA Cloud and SAP Digital Manufacturing Cloud for Execution - for Smart Press Shop, a pioneering joint venture between Porsche and forming specialist Schuler.
Competitive, above-average compensation
Global tourist: With us, you can also work from abroad from time to time
Flexible working time models, home office
Attractive benefits, e.g. company pension scheme or various health offers
A modern environment in which the "you" is part of it
Open feedback culture, flat hierarchies and a motivated team
Individual career planning with continuous training and coaching on the job
You see a personal challenge in this responsible task? Apply now - and become part of the SYNTAX team!