The role involves performing DBA activities for Oracle Retail applications, including installation, configuration, maintenance, and performance tuning for various Oracle Retail systems such as MOM Applications (ORMS, OReSA, OReIM, ORPM), Store Applications (XStore, XOffice, XEnvironment), Planning (RPAS, RDF, MFP, RPO, CatMan), and middleware (RIB). This includes managing WebLogic middleware, cloud environments, and various reporting and BI tools.
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.
- 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.
Top Skills
What We Do
Makro PRO is an exciting new digital venture by the iconic Makro. Our proud purpose is to build a technology platform that will help make business possible for restaurant owners, hotels, and independent retailers, and open the door for sellers. Makro PRO brings together the best talent across multi-nationals to transform the B2B marketplace ecosystem. We welcome bold, energetic, and thoughtful people who share our belief in collaboration, diversity, excellence, and putting customers at the heart of our work.
