Request Technology - Chelmsford, MA

posted 4 months ago

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

About the position

The Oracle Applications DBA Tech Lead/Manager position is a hands-on role focused on managing and leading the technical aspects of Oracle ERP applications, particularly Oracle EBS (11i/R12) and Oracle Fusion Cloud. The successful candidate will be responsible for ensuring the availability, performance, and security of multi-database and application environments that handle large volumes of data. This role requires a deep understanding of both physical and application-level database management, including storage, security, networking, and application-related issues such as queries and user management. In this position, you will be tasked with sizing database resources appropriately and developing design strategies to maintain optimal database health. You will manage the Oracle Cloud OCI platform, ensuring ongoing integrations and configurations are maintained effectively. Routine DBA tasks such as database maintenance, backups, recovery, and upgrades will be part of your responsibilities. You will also conduct periodic health checks on databases, recommend changes for optimal performance, and collaborate with various infrastructure, security, and IT teams to support environment setup and maintenance. Additionally, you will be responsible for monitoring system performance, diagnosing software and hardware failures, and providing patch management to mitigate new threats. Your role will include creating and testing data backups, ensuring data integrity, and implementing access controls. You will perform database configuration, monitoring, and tuning, as well as routine maintenance tasks such as problem defect analysis, space management, and physical database layout management. You will also maintain Oracle Quarterly Releases and patch management schedules, support systems development, migration, and integration efforts, and contribute significantly to security analysis and recommendations.

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.
  • 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 multiple infrastructure, security, and IT teams for environment setup and maintenance.
  • Plan and respond to service outages, including backup and restore processes.
  • Monitor system performance and diagnose software and hardware failures to resolution.
  • Provide patch management and distribution capabilities to minimize infrastructure impacts.
  • Create and test data backups, ensuring data integrity and implementing access controls.
  • Perform database configuration, monitoring, and tuning.
  • Conduct routine maintenance including problem defect analysis, space management, and physical database layout management.
  • Support logs and alerts, access rights, and database instance version control.
  • Monitor memory usage, configure database parameters, and ensure system health and technical security.
  • 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.
  • 10+ years of experience with Oracle EBS (11i/R12).
  • Minimum of five (5) years in ERP Cloud platform.
  • 20+ years of experience as an Oracle ERP APPS DBA.
  • Experience executing a minimum of two Upgrade cycles with a focus on cutover downtime reduction.
  • Excellent knowledge in cloning, patching, backup recovery of ERP applications, including knowledge of ODI, FAW/ADW, performance tuning, and SQL profiling.
  • Hands-on experience with RMAN, backup management, and various recovery techniques.
  • Experience in designing and implementing disaster recovery plans.
  • Support experience for Oracle Cloud and EBS developers for custom coding and code migration.
  • Knowledge of system administration functionality within Oracle Cloud ERP and Unix Shell Scripting skills on Oracle ODA's and OVM's.
  • Ability to manage and supervise DBA staff.

Nice-to-haves

  • Experience with Oracle Cloud infrastructure management.
  • Familiarity with security analysis and recommendations in database environments.

Benefits

  • Health insurance coverage.
  • 401k retirement savings plan.
  • Paid holidays and vacation time.
  • Professional development opportunities.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service