Senior Oracle Cloud Architect/Engineer/ OCI/DBA

ZOLL Medical Corporation•Chelmsford, MA

3d•$140,000 - $170,000

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). Essential Functions 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. This is an important function of this role. 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.

Requirements

BA in Computer Science or similar required
10+ years of experience as Oracle ERP APPS DBA and 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.
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.
Responsible for providing day-to-day status and maintenance for Oracle Cloud.