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.