Day to Day Activities & Brief About Yourself

Day to Day Activities & Brief About Yourself

I am XYZ.

Currently i'm working with XYZ company, I have around 4.2 years of experience as Oracle Apps DBA,  I have worked on different projects like supporting, up-gradation, implementation & migration projects.

Though my involvement was not end-end on these projects, but my roles are major like:
-collecting information of servers.
-collecting information of databases
-collecting OS and mounpoint information
-database versions
-checking the required rpms on the servers and specially documenting and presenting to lead.

My current project is on support and I support 2 production instances, & that related we have UAT, TEST and DEVELOPMENT instances, all instances are running non-rac with single instance.

Third party applications are integrated with production servers like, SOA, OBIEE, Informatica and DOCSAVI.

Day to day Responsibilities:

- checking the critical alerts (maybe some services, mount-point full, datafiles resize, listener issues)
- checking the handover emails (maybe some scheduled activities like patching, clone, code deployments etc)
- checking the scheduled backup status.
- Perform cloning activity on users request, on few instances we clone every week.
- Sometimes getting a request to apply patch.
- code migrations
-creating SR's and follow-up with pending SR's
- doing Sanity checks on production servers. Depending on the priority basis I will start the work. If there is any pending in the work I will handover to next shift people.
- checking the calendar notes for any scheduled activities assigned in the shift
- Monthly performance Report
- Troubleshooting activities:
*users unable to connect to database
*listeners went down
*concurrent managers not coming up after clone.
* immediately after clone users are complaining that permissions and grants are missing.
*creating users and assigning roles in the new clone.