Request Technology - Billerica, MA

posted 4 months ago

Full-time - Senior
Billerica, MA
Administrative and Support Services

About the position

The Senior Manager Oracle Applications DBA position at our prestigious enterprise company is a permanent, full-time, onsite role that requires a hands-on approach to ensure the production uptime service levels are maintained according to requirements. This includes critical functions such as backup, recovery, refresh, performance tuning, and security for both physical and data aspects. The successful candidate will be responsible for supporting various levels of database management, including physical and application-related issues. This role demands a strategic mindset to ensure that database resources are appropriately sized and that a design strategy is developed to maintain the database at a healthy size. In this role, you will ensure the availability and performance of multi-database and application environments that handle very large volumes and sizes. You will manage the Oracle Cloud OCI platform, maintaining ongoing integrations and configurations to keep the Cloud platform in optimal condition. Routine DBA tasks such as database maintenance, backups, recovery, and table space management will be part of your responsibilities. You will also execute periodic health checks for databases and recommend necessary changes to the production environment to ensure optimal performance. Collaboration is key in this position, as you will interact with multiple infrastructure, security, and IT teams as part of environment setup, maintenance, and support. You will plan and respond to service outages, monitor system performance, diagnose software and hardware failures, and provide patch management to prevent new threats while minimizing impacts on physical infrastructure. Your role will also involve creating and testing data backups, providing data cleansing services, verifying data integrity, and implementing access controls. You will perform database configuration, monitoring, and tuning, along with routine maintenance tasks such as problem defect analysis, space management, and physical database layout management. Additionally, you will support logs and alerts, access rights, and roles management, ensuring system health and technical security. The position also requires maintaining Oracle Quarterly Releases and patch management schedules, supporting systems development, migration, and integration efforts as needed. As a significant contributor to work plans for security analysis and recommendations, you will play a crucial role in the overall success of the database management team.

Responsibilities

  • Ensure production uptime service levels are maintained according to requirements including backup, recovery, refresh, performance tuning, and security.
  • Support physical and technical aspects such as storage, security, and networking.
  • Handle application-related issues including queries, users, and Embedded SQLs.
  • Ensure database resources are sized properly and develop a design strategy for database maintenance.
  • Manage Oracle Cloud OCI platform and maintain ongoing integrations and configurations.
  • Perform routine DBA tasks like database maintenance, backups, recovery, and table space management.
  • Execute periodic health checks for databases and recommend changes for optimal performance.
  • Interact and work with multiple infrastructure, security, and IT teams for environment setup and maintenance.
  • Plan and respond to service outages, including backup and restore.
  • 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, provide data cleansing services, and verify data integrity.
  • Perform database configuration, monitoring, and tuning.
  • Conduct routine maintenance including problem defect analysis and resolution, space management, and physical database layout management.
  • Support logs and alerts, access rights, and roles management.
  • Maintain Oracle Quarterly Releases and patch management schedules.
  • Support systems development, migration, and integration efforts as needed.

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.
  • Experience in 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 different Recovery techniques.
  • Experience in designing and implementing disaster recovery plans.
  • 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.

Nice-to-haves

  • Experience with ODI, FAW/ADW, Performance tuning, and SQL profiling.
  • Experience supporting Oracle Cloud and EBS developers for custom coding, code migration, and workflow.

Benefits

  • Bonus eligibility for the position.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service