Description

Responsibilities:

  • 10+ years of Oracle DBA, focused on multitenancy, PDB backups, restores, db upgrades from 19c to 23ai, applying PSU patches using OEM fleet management, Oracle OCI, DBAAS setup.
  • 10+ Years of IT Experience as an Oracle DBA in a Linux environment Solid experience in Apex/ORDS administration and support (Preferably Apex 19 or higher and ORDS 19 or higher).
  • 5+ Years of experience in Oracle OCI cloud, DBaaS, cloud shell scripting, automation etc.
  • Good understanding of linux Administration with respect to supporting oracle database and application servers (Weblogic/fusion middleware/OHS/reports servers).
  • Hands on experience in shell scripting and job scheduling Created shell scripts to automate jobs.
  • 6.5+ years working experience in setting up weblogic 12.2.1.3/12.2.1.4/14.1.2, upgrade weblogic and setup Oracle OHS OHS12213, OHS14120 on Linux.
  • Proven working experience in handling Production Oracle 19c environments including PL/SQL, OEM, RMAN, Data Guard.
  • Proven working experience in managing Oracle databases using multi-tenant architecture (CDB/PDB)/backup/restore.
  • Hands on experience setting up Oracle Apex 19 and above, Oracle ORDS 18 and above on weblogic, interfacing with Oracle OHS to standup applications. 
  • Hands on experience performing database upgrade and applying quarterly PSU Patching for oracle database using OEM Provisioning Tool/fleet maintenance on OEM 13c.
  • Expertise with Loading data using sql* Loader / Data Pump utilities.
  • Expertise with Oracle performance tuning and rewriting sql's.
  • Experience with database character set migration.
  • Experience with managing and upgrading Oracle Enterprise Manager 13c and higher.
  • Expertise in Oracle database performance tuning and troubleshooting.
  • Strong experience in Backup and Recovery of large databases from RMAN online backups.
  • Working knowledge of Tablespace Encryption and Oracle Advanced security tools.
  • Proficient with using sqldeveloper/ TOAD and Grid control tools and Designer experience. (desired).
  • Solid Expertise in Configuring and managing Oracle Fusion Middleware, Web Tier, Apache, and Tomcat Servers.
  • Expertise in configuring mod pl/sql,ORDS and Apex Administration 5.0 or higher.
  • Experience with Restful Web Services.
  • Proven understanding of the Cloud environments OCI/AWS/Azure and have managed large scale environments in Cloud.
  • Hands on work experience in Oracle OCI, migrating applications from on-prem to OCI.
  • Strong experience in building and managing Oracle Databases using AWS RDS.
  • Experience in AWS Cloud Technologies specifically RDS, EC2, ELB, S3.
  • Solid Expertise in Oracle database reorg procedures.
  • Solid experience knowledge in Apex/ORDS related application stack and setting up ORDS in weblogic managed server preferred.
  • On-call work on weekends, evenings, and holidays required.
  • Experience working with large enterprise-wide systems.
  • Degree in Engineering or Software Applications or equivalent combination of training and/or experience.
  • Knowledge on Printer configuration on apps servers.
  • Experience in customizing Apache FOP to creating PDF.
  • Experience in customizing Apex instance and workspace settings.


Requirements:

  • Oracle database 19c and above.
  • Oracle DBA Experience.
  • Oracle grid control to include version 13c.
  • Tomcat / Oracle Weblogic 12c and above with fusion middleware experience.
  • Oracle apex 19c and above administration and support.
  • Experience with configuring and managing applications using Oracle ORDS.
  • Oracle database backup/restore/rman/dataguard.
  • Oracle performance tuning/database maintenance/management.
  • On-call production support.
  • 19c multi tenancy, CDB/PDB, clone backup/restore, TDE encryption.
  • Create complex shell scripts, scheduling jobs.
  • Oracle enterprise manager fleet maintenance to apply PSU patching to 19c databases and above

Education

Any Gradute