Database Administration: Installing, configuring, patching, and upgrading Oracle Databases.
· Backup and Recovery: Expertise in Oracle Recovery Manager (RMAN) for data protection, Data Pump (EXPDP/IMPDPD)
· SQL & PL/SQL: High proficiency in querying and scripting to manage data.
· Performance Tuning: Monitoring, diagnosing, and optimizing SQL queries and database instances.
· Operating Systems: Proficiency in Linux/Unix environments.
· Security & Compliance: Managing user access, roles, privileges, auditing, and encryption.
· Proficient in shell scripting to create/update Cron jobs.
Oracle Forms and Reports administration:
· Installation & Configuration: Setting up Oracle Forms/Reports, running the Repository Creation Utility (RCU), and configuring domains using the Configuration Wizard.
· Monitoring & Performance: Using Oracle Enterprise Manager Fusion Middleware Control to monitor Reports Server, manage job queues, and optimize performance.
· Security Management: Securing applications with Oracle Internet Directory (OID) and Oracle Access Manager (OAM).
· Environment Setup: Managing, configuring and setting up file transfers.
· Deployment: Deploying and managing forms, reports, and ensuring proper connectivity to the Oracle Database.
· Experience/Knowledge in Apex/BI Publisher Migration, Installing, configuring, and maintaining.
Advanced & Cloud Skills
· Cloud Infrastructure: Experience with Oracle Cloud Infrastructure (OCI), AWS RDS, or Azure.
· Data Guard/RAC: Managing Oracle Real Application Clusters (RAC) and Data Guard for high availability and disaster recovery.
· Automation: Scripting (Shell, Python) to automate routine maintenance tasks.
· Data Modeling & Warehousing: Understanding database design, ETL processes, and warehousing.
· Knowledge on Batch scheduling tools (EX: CA Workload Automation).
Soft Skills
· Problem-Solving: Troubleshooting critical production issues under pressure.
· Communication: Interacting with developers, system admins, and management.
· Project Management: Time management for upgrades and migrations.
Common Certifications/Roles
· Roles: Oracle Database Administrator, Production DBA, Application DBA.
· Certifications: Oracle Database SQL Certified Associate, Oracle Database Administration Certified Professional.
.jpg%3Fformat%3Dwebp&w=1080&q=75)
Never miss an opportunity! Create an alert based on the job you applied for.