I was working as a Specialist and solved issues faced by team. Developed future plan of database upgrade and migration Developed shell script to automate routine DBA tasks Designed and configured RMAN backup and recovery for any physical failure and restore. Backup Design is such that recovery can be done in minimum time Provide database disk usage so that disk procurement can be done in timely fashion to meet the future need. Developed procedure to migrate non CDB to CDB
Upgraded OEM Developed procedure for patching Exadata Implemented data redaction for masking Social Security Number and date of birth field of customer so that when call center employees retrieve the customer data, they will see only last 4 digits of SSN and for DOB only month and date will be shown. Created multiple redaction policies for different user requirements. Implemented data masking and susetting.
Environment: Oracle Exadata X6, Oracle Exalogic, Linux 6, Oracle RAC 12.2, Securecrt, IBM Maximo