Reference #: Robyn
Location Type: Chelmsford, MA
Travel: 0%
Salary: 160-175K + Bonus
Visa Requirement:
US Citizenship / Permanent Resident
Recruiter: Robyn Honquest
Email: robyn@requesttechnology.com

Overview

NO SPONSORSHIP

Senior Manager Oracle DBA

Salary estimate: $160-175K + Bonus

Location: Chelmsford, MA – on site

Job Summary

Immediate need for a Senior Manager Oracle Applications DBA to join our team in Chelmsford, MA. This is an exciting full-time opportunity to work in a fast-paced team environment. The selected candidate 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

· You will 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.)

· You will ensure database resources are sized properly and a design strategy is developed to make sure that the database is maintained at a healthy size.

· You will 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.

· You will manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc.

· You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure optimal performance.

· You will 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.

· 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

Required Experience

· Bachelor’s Degree 

· 10+ years Oracle EBS (11i/R12)

· Minimum five (5) years in ERP Cloud platform

· 20+ years of experience as Oracle ERP APPS DBA

Knowledge, Skills and Abilities

· Must have executed a minimum of two Upgrade cycles in the past. Will be responsible for Cutover Downtime reduction thru process improvements in each Upgrade iteration, Must have experience in EBS Application 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 RMAN, Backup Management and different Recovery techniques. Design and Implement disaster recovery plans.

· Support Oracle Cloud and EBS 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 manage and supervise DBA staff in the team.

· Responsible for providing day-to-day status and maintenance for Oracle EBS and ERP Cloud.

· Work with multiple application teams and developers.

 

Tagged as: cloud, ERP, oracle