Principal System Analyst, Managed Services

syntax•Durham, NC

3d•Hybrid

About The Position

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 and resilient private, public or hybrid cloud. With strong technical and functional consulting services, and world-class monitoring and automation, Syntax serves 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. You must be legally entitled to work in Canada and/or in the U.S. This role will be in either Shift - Tuesday to Saturday or Sunday to Thursday. 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.

Requirements

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.

Nice To Haves

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.

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