Senior Oracle Cloud Architect/Engineer/ OCI/DBA

ZOLL Medical•Chelmsford, MA

About The Position

The Senior Oracle Cloud DBA will ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security (physical and data). This role is responsible for the physical and technical oriented aspects such as storage, security, and networking, as well as handling all application-related issues like queries, users, and embedded SQLs. The DBA will ensure database resources are sized properly, develop a design strategy for maintaining healthy component sizes, and ensure the availability and performance of multi-database and application environments with very large volumes and sizes. They will manage the Oracle Cloud OCI platform, maintain ongoing integrations and configurations, and perform routine DBA tasks like database maintenance, backups, recovery, table space management, and upgrades. The role involves maintaining Oracle's standard architecture and best practices throughout the cloud, executing periodic health checks, recommending changes for optimal performance, and interacting with multiple infrastructure, Security, and IT teams. Responsibilities include planning and responding to service outages, monitoring system performance, diagnosing software and hardware failures, providing patch management, creating and testing data backups, providing data cleansing services, verifying data integrity, implementing access controls, executing cloning in SaS and OCI, performing database configuration, monitoring, and tuning, and supporting logs, alerts, access rights, roles, database instance version control, new IDs, authorizations, audits, and memory usage monitoring. The position also ensures system health, maintenance, technical security, recovery, and basic application technical tuning, maintains Oracle Quarterly Releases and patch management schedules, and supports Systems Development, Migration, and Integration efforts. This role is a significant contributor to work plans for security analysis and recommendations.

Requirements

BA in Computer Science or similar required
10+ years of experience as Oracle ERP APPS DBA
a minimum of 5 years as Oracle Cloud engineer and managing Cloud OCI platforms
Must have executed a minimum of two Upgrade cycles in the past.
Will be responsible for Cutover Downtime reduction through process improvements in each Upgrade iteration
Must have experience in Cloud OCI architecture, Concurrent managers, Workflow, layout of application on infrastructure, etc.
Must have excellent knowledge in cloning, patching, backup recovery of ERP application including knowledge of ODI, FAW/ADW, Performance tuning, SQL profiling
Must have hands-on experience of Backup Management and different Recovery techniques.
Design and Implement disaster recovery plans.
Support Oracle Cloud developers for custom coding, code migration, workflow and concurrent requests
Knowledge of system administration functionality within Oracle Cloud ERP
Unix Shell scripting skills on Oracle ODA’s and OVM’s
Excellent interpersonal communication skills
Ability to work with team members located in multiple geographies and time zones.
Responsible for providing day-to-day status and maintenance for Oracle Cloud.
Ability to work with multiple application teams and developers.

Responsibilities

Support the following levels: Physical – you will be responsible for the physical and technical oriented aspects e.g., storage, security, networking and more; Application – you will handle all application-related issues (e.g., queries, users, embedded SQL’s etc.)
Ensure database resources are sized properly, and a design strategy is developed to make sure that all components are maintained at a healthy size.
Ensure availability and performance of multi database and application environments with very large volumes and sizes.
Responsible to manage Oracle Cloud OCI platform and maintain the ongoing integrations and configurations to keep the Cloud platform in a healthy condition.
Manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc.
Maintain Oracle’s standard architecture and best practices throughout the cloud.
Execute periodic health checks for databases and systems and recommend changes that should be executed in the production environment to ensure optimal performance.
Interact and work with multiple infrastructure, Security and IT teams as part of environment setup, maintenance and support.
Plans and responds to service outages including backup and restore.
Monitors system performance diagnosing software and hardware failures to resolution
Provides patch management and distribution capabilities to prevent new threats with minimized physical infrastructure impacts.
Creates and tests data backups.
Provides data cleansing services, verifies data integrity, and implements access controls.
Executes Cloning in SaS and OCI.
Performs database configuration, monitoring, and tuning.
Routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management.
Supports logs and alerts, access rights and roles, database instance version control.
New IDs, roles, authorizations, audits, locked/unlocked status, revocation.
Performs memory usage monitoring, database parameter configuration, database resources, I/O distribution.
Ensures system health, maintenance, technical security, recovery, and basic application technical tuning.
Maintains Oracle Quarterly Releases and patch management schedules.
Supports Systems Development, Migration, and Integration efforts as needed.
Significant contributor to work plans for security analysis and recommendations.