Note: The job is a remote job and is open to candidates in USA. Syntax is a leading Managed Cloud Provider for Mission Critical Enterprise Applications, providing comprehensive technology solutions since 1972. They are seeking a Senior Oracle Apps DBA who will take full responsibility for Oracle Application Management and manage 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.)
Skills
- 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 cloud, 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
Benefits
- 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
Company Overview