Oracle Applications Dba

**Oracle Applications DBA**
- Permanent
- US or Canada (ET/CT)

Syntax is a leading Managed Cloud Provider for Mission Critical Enterprise Applications and has been providing comprehensive technology solutions to businesses of all sizes since 1972. Syntax has undisputed strength to implement and manage ERP deployments (Oracle, SAP) in a secure, resilient, private, public or hybrid cloud. With strong technical and functional consulting services, and World Class Monitoring & Automation, they serve some of North America’s largest corporations across a diverse range of industries. Syntax has offices worldwide, and partners with Oracle, SAP, AWS, Microsoft, IBM and other global technology leaders.

**Position Summary**

**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.
- 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
- 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.
- 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.

**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.**

You must be legally entitled to work in Canada and/or in the U.S. We are unable to sponsor at this time.

NOTE: Unfortunately, we will not be able to reply to applicants who do not meet the above criteria.