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.
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.
