Technical Lead / Manager Oracle Applications DBA - Oracle Fusion

Overview

On Site
$160,000 - $165,000
Full Time

Skills

DBA
ERP
Oracle
Oracle Applications
R12

Job Details

NO SPONSORSHIP

 

Senior Technical Lead / Manager Oracle Applications DBA - Oracle Fusion

Salary estimate: $160-175K + Bonus

Location: Chelmsford, MA - on site

 

Job Summary

 

Immediate need for a Senior Technical Lead / Manager over Oracle Applications DBA - Oracle Fusion to join our team in Chelmsford, MA. This is all about Oracle EBS, 11i/R12. You will need 10 years E-Business Suite, Cloud platform, Oracle ERP applications. Production Support, performance tuning, OCI platform. Ability to manager and supervise a team

 

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.