Oracle DBA
Detail posisi
The role involves performing DBA activities for Oracle Retail applications, including installation, configuration, maintenance, and performance tuning for various Oracle Retail systems.
Kewajiban
Key Responsibilities:
• Perform DBA activities for Oracle Retail applications including MOM, Store, Planning, and middleware (RIB).
• Administer Oracle WebLogic middleware and manage multiple Oracle Retail environments.
• Install, configure, patch, upgrade, and maintain Oracle Retail applications and their interfaces.
• Monitor and support Oracle Retail applications, including RIB and related systems.
• Perform performance tuning, indexing, and partitioning for Oracle Retail and database systems.
• Install, configure, and maintain security applications (OID, OIM) and replication software (e.g., GoldenGate).
• Maintain Oracle database systems, including managing replication, backup, and disaster recovery setups (Oracle RAC, Data Guard, RMAN).
• Create and manage database objects, shell scripts, and PL/SQL files required by Oracle Retail applications.
• Schedule and monitor batch jobs using UC4, Cron jobs, and Oracle database.
• Troubleshoot and resolve complex database issues, ensuring high availability, security, and performance.
• Use Oracle support (Metalink) for service request creation, follow-up, and resolution.
• Install and maintain reporting and BI applications like OBIEE, BI Publisher, MicroStrategy.
• Administer cloud platforms (Oracle, AWS, Azure) and Oracle Exadata environments.
Kualifikasi
Requirements:
• Bachelor’s degree or higher in Computer Science or a related field.
• Minimum of 5 years as a Database Administrator (Oracle, MSSQL, MySQL, etc.).
• Proficiency in system administration of Oracle Exadata, Cloud platforms (Oracle, AWS, Azure), and PaaS (Oracle Autonomous/AWS RDS).
• Experience with Oracle multitenant (Container/Pluggable DBs), RAC (Active-Active environments), and database performance tuning.
• Knowledge of Oracle ASM, Oracle security applications (OID, OIM), and replication tools (GoldenGate).
• Familiarity with Linux or UNIX environments and disaster recovery solutions (Oracle RAC, Data Guard and RMAN).
• Performs upgrades of databases (Patch, Export-Import Data Pump and Data Guard).
• Experience with virtualization technologies both on-premises and on the cloud.
• Strong knowledge of database installation, partitioning, performance tuning, and backup/recovery strategies.
• Ability to diagnose, troubleshoot, and resolve complex issues with Oracle databases and cloud services.
• Familiarity with automation and scripting (PL/SQL, Shell, Pro*C).
• Experience with cloud database environments (AWS RDS, Oracle Autonomous).
• Strong communication skills with the ability to collaborate with both technical and non-technical stakeholders.
• Excellent interpersonal skills and ability to work well in a team environment.