Description:
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