Oracle DBA

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.