Oracle Database Administration (4-6 yrs)

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.