Packaged App Development Analyst
ACCENTURE SERVICES Pvt. Ltd.
05.2021 - Current
- Worked under the environment of 24X7 DBA support.
- In-depth knowledge of Oracle Database architecture.
- Database health checkups and monitoring alert logs.
- Database upgrade from 11g to 12c.
- Checking the concurrent manager status.
- Configured Notification mailer in Application.
- Applying the CPU patches on regular intervals.
- Purging the old trace / log files and temp files.
- Configuring SSO in EBS Application using OID/OAM.
- Monitoring tablespace size, alert log, trace files.
- Applying the EBS Patches (online and offline patches).
- Affectively used patch wizard for the pre-patch analysis.
- Used AD Utilities like adadmin, adctrl, adpatch, adrelink etc...
- User creation and assignment of roles and Responsibilities with sys admin.
- Creating the monitoring scripts like long running, DB blocking sessions etc..
- Worked with Jenkins tool to deployed code and new file transfer job setup based on vendor requirement.
- Mentoring Database activities like tablespace and datafile etc on OEM tool and scheduling PROD backups.
