Tasks and responsibilities
Responsible for configuration management, performance tuning, and administration of multiple development, test, and production databases and Applications (such as EBS R12.)
Perform database reorgs, statistics and other applicable utilities to ensure proper database function and performance.
Runs and assists with analysis of AWR and ASH reports.
Install, configure, patch, and, clone Apps and Database
Integrate / collaborate with application development and support teams on various IT projects
Develop and improve procedures for monitoring (Enterprise Manager) and proactive intervention, preventing customer impact.
Plan and take logical and physical backups for development databases, perform test restores ensuring all databases and associated logs are being backed-up.
Assumes ownership of database related problems; pursues problem resolution and root cause analysis.
Participates in a 24X7 rotation for critical issues;
Learn and stay current on the key facets of the applications that leverage the databases being supported.
Required skills and abilities
5+ years' experience as an Oracle production and development DBA in a 24*7 environment
Experience in SQL and PL / SQL scripting and tuning
Experience with Linux (and Windows) required including Shell Scripting.
Knowledge of DB Tools / Utilities (e.g., Toad, Enterprise Manager, SQL Developer, RMAN, EXPDP etc.)
Must have strong analytical and problem solving skills
Must possess excellent verbal and written communication skills
Recommended skills, abilities, and certifications
Oracle Applications or Middleware Administration experience preferred
Ability to multitask and work under pressure
Strong ability to prepare and present technical documentation
Ability to communicate in a professional manner when interacting across staff levels and internal / external customers
Primary Location : CRI-Heredia
Function - IT Operations / Platforms
Schedule : Full time