Oracle Database Administration

Roles & Responsibilities : - Oracle standalone/RAC Installations and Upgrades in LINUX and Windows environments - DB User creation/password management/profile management - Tablespace management(Adding/resizing datafile & adding tablespace) - Configuring and maintaining RMAN catalog, - Take manual RMAN backup (Incremental/full backup) - Restore database backups using RMAN - Check the Dataguard Standby Sync status - Troubleshoot dataguard sync lag issues - Add datafiles on dataguard standby servers - Perform db failover to dataguard standby server and vice-versa - Check the goldengate Sync status - Troubleshoot goldengate sync lag issues - Analyzing AWR/ASH & ADDM reports to identify db performance issues, - Able to generate trace files using the Tkprof & O.S Watcher tools - Should have good knowledge of Oracle RAC - Perform database PSU/RU/OJVM patches on RAC and standalone dbs. - Export/Import of db/table/schema using the Datapump - Perform database Housekeeping (Purging (partition & non partition table)/defragmentation/index rebuild) Professional & Technical Skills : - Must To Have Skills : Proficiency in Oracle Database Administration (DBA). - Strong understanding of statistical analysis and machine learning algorithms. - Experience with data visualization tools such as Tableau or Power BI. - Hands-on implementing various machine learning algorithms such as linear regression, logistic regression, decision trees, and clustering algorithms. - Solid grasp of data munging techniques, including data cleaning, transformation, and normalization to ensure data quality and integrity. (ref:hirist.tech)

Location: noida, IN

Posted Date: 11/21/2024