Senior Oracle Database Administrator

Job Description : - Managing Oracle 11g and 12c, 19c databases on ExaCs, OCI, Oracle Linux and LINUX environments.- Influence the design, capacity planning tuning and the actual build out of Exadata DB instances on Oracle Cloud infrastructure.- Work towards automating key operational activities.- Middleware environment administration (Install, configure, migrations, tuning, patching, administration & monitoring) on any middleware platform such as Oracle.- Ensure the effective daily operation of the production / Middleware applications and provides administrative support for new implementations, upgrades, and migrations- Ensure the DB system is always up to date and patched to the latest version in an automated fashion- Develop solutions that ensure DB health check are done in an automated and proactive fashion- Interact with customers and developers for any priority situations and react/respond timely manner- Play a key role in the design of HA/DR solutions for the new Identity cloud service- Get involved in Performance, Scalability and Reliability Analysis and database query tuning- Troubleshoot HA/DR and Database Performance issues on the existing cloud service- Work with architects and development managers in requirements specification definition and detailed engineering analysis from data requirements perspective- Own database/schema design documentation at component and product level- Participate in rapid delivery in planning, building, configuring, deploying, monitoring and documenting for Oracle Cloud projects- Automating routine maintenance tasks as appropriate utilizing OEM, Shell scripting and PL/SQL batch processing;- Support the production environment on 11g,12c, 19c databases on Oracle Linux and RHEL.- Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.- Manage, troubleshoot and resolve oracle database and applications issues.- Perform database and application tuning through the use of AWR and ADDM- Experience with Oracle enterprise manager 13c- Assist the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance.- Experience in RAC and Multi-tenant (CDB-PDB) environments and performance tuning as well.- Perform and develop the PL/SQL code for automation process.- Working knowledge of Exadata- Manager and troubleshoot and resolve Oracle database and Performance its issues.- Familiars with Cloud platform (preferred OCI, AWS, Azure)- Experience on WebLogic Administration Forms and Reports- Exposure to PostgreSQL database administration is Have : : - University Graduate degree (Btech, B.E)- Knowledge of ITSM tools like Service Now- Oracle Database Administration Certification- Linux Administration- Excellent command over written and spoken English (mandatory)- Good understanding of Network and Storage concept- ITIL Foundation certification Skills : - Oracle 11g and 12c, 19c databases Administration on ExaCs, OCI, Oracle Linux and LINUX environments.- Installation, configuration, patching and upgrading Oracle database software, applications and related products.- Troubleshooting skills and resolve oracle database and applications issues.- Perform database and application tuning through the use of AWR and ADDM- OEM tool skills- Performance tuning and optimization- Perform and develop the PL/SQL code for automation process.- Working knowledge of Exadata- Familiars with Cloud platform (preferred OCI, AWS, Azure)- Experience on WebLogic Administration Forms and Reports- Exposure to PostgreSQL database administration is required- Knowledge of SQL, PLSQL- Awareness of Unix / Linux platforms Change/Problem /Incident Management Process (ref:hirist.tech)