***We are unable to sponsor for this permanent full-time onsite role***
***Position is bonus eligible***
Prestigious Enterprise Company is currently seeking an Senior Manager Oracle Applications DBA. Candidate will be very hands-on, and will be ensuring production up-time service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security (physical and data).
Responsibilities:
- 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
Qualifications:
- Bachelor's Degree Computer Science or similar required
- 10+ years Oracle EBS (11i/R12)
- Minimum five (5) years in ERP Cloud platform
- 20+ years of experience as Oracle ERP APPS DBA
- 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.