Oracle Applications DBA Tech Lead/Manager

Request Technology - Billerica, MA

Full-time - Senior

Billerica, MA

Administrative and Support Services

About the position

A prestigious company is seeking an Oracle Applications DBA Tech Lead/Manager for a permanent full-time role. This position is hands-on and will focus on all Oracle ERP applications, with a significant emphasis on Oracle EBS (11i/R12). The ideal candidate will possess extensive experience with Oracle Fusion Cloud and will be responsible for overseeing both the physical and application aspects of the database environment. This includes managing storage, security, networking, and ensuring that database resources are appropriately sized and maintained for optimal performance. In this role, you will ensure the availability and performance of multi-database and application environments that handle large volumes of data. You will manage the Oracle Cloud OCI platform, maintaining ongoing integrations and configurations to keep the Cloud platform in a healthy state. Routine DBA tasks such as database maintenance, backups, recovery, and upgrades will be part of your responsibilities. You will also execute periodic health checks for databases and recommend necessary changes to enhance production environment performance. Collaboration is key in this position, as you will interact with multiple infrastructure, security, and IT teams to support environment setup and maintenance. You will plan and respond to service outages, monitor system performance, diagnose software and hardware failures, and provide patch management to mitigate new threats. Additionally, you will create and test data backups, perform data cleansing, verify data integrity, and implement access controls. Your role will also involve database configuration, monitoring, tuning, and routine maintenance tasks such as problem defect analysis, space management, and ensuring system health and security. You will maintain Oracle Quarterly Releases and patch management schedules while supporting systems development, migration, and integration efforts as needed. This position is crucial for ensuring the smooth operation of Oracle EBS and ERP Cloud applications, making you a significant contributor to the overall success of the IT infrastructure.

Responsibilities

• Support physical and technical aspects of Oracle ERP applications including storage, security, and networking.
• Handle application-related issues such as queries, user management, and Embedded SQL's.
• Ensure proper sizing of database resources and develop design strategies for database maintenance.
• Maintain availability and performance of multi-database and application environments with large volumes.
• Manage Oracle Cloud OCI platform and maintain ongoing integrations and configurations.
• Perform routine DBA tasks including database maintenance, backups, recovery, and upgrades.
• Execute periodic health checks for databases and recommend changes for optimal performance.
• Collaborate with infrastructure, security, and IT teams for environment setup and maintenance.
• Plan and respond to service outages, including backup and restore operations.
• Monitor system performance and diagnose software and hardware failures to resolution.
• Provide patch management and distribution capabilities to prevent new threats.
• Create and test data backups, perform data cleansing, and verify data integrity.
• Implement access controls and perform database configuration, monitoring, and tuning.
• Conduct routine maintenance including problem defect analysis and resolution.
• Support logs and alerts, access rights, and database instance version control.
• Manage memory usage monitoring and database parameter configuration.
• Ensure system health, maintenance, technical security, recovery, and application tuning.
• Maintain Oracle Quarterly Releases and patch management schedules.
• Support systems development, migration, and integration efforts.

Requirements

• Bachelor's Degree in Computer Science or a similar field required.
• 10+ years of experience with Oracle EBS (11i/R12).
• Minimum of five (5) years in ERP Cloud platform.
• 20+ years of experience as Oracle ERP APPS DBA.
• Experience executing a minimum of two Upgrade cycles in the past.
• Knowledge of EBS Application architecture, Concurrent managers, and Workflow.
• Excellent knowledge in cloning, patching, backup recovery of ERP applications.
• Hands-on experience with RMAN, Backup Management, and recovery techniques.
• Ability to design and implement disaster recovery plans.
• Support Oracle Cloud and EBS developers for custom coding and code migration.
• Knowledge of system administration functionality within Oracle Cloud ERP.
• Unix Shell Scripting skills on Oracle ODA's and OVM's.
• Ability to manage and supervise DBA staff.

Nice-to-haves

• Experience with Oracle Fusion Cloud applications.
• Familiarity with performance tuning and SQL profiling.
• Experience in managing large-scale database environments.