Core Technical Skills:
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.
