Job Description :
Performing DB migrations from lower Oracle versions to higher Oracle versions
Participating in binaries installation, DB builds such as DB creation, configuration, upgrades and patching activities
Providing ongoing operational support for Databases in all application specific environments (Dev to Prod)
Assist in manual and automated application code deployments (DDLs and DMLs)
Conducting performance tuning to maintain system stability (using Oracle RDBMS tools)
Troubleshooting to capture incident data and analyze for root cause issues
Serving as a team player by working with colleagues and clients to identify and address overall system problems as needed
Participating in 24x7 on-call rotation with other colleagues on a weekly rotation basis
Influencing management to adopt new ideas, products, and/or approaches as appropriate
Perform refreshes
What software tools/skills are needed to perform these daily responsibilities?
Datapump EXPDP/IMPDP data migrations
RMAN restores/refreshes
RAC
Oracle Dataguard (Standby) creation and troubleshoot
DB creation and configuration (script way as well DBCA)
What skills/attributes are a must have?
Experience with Data migrations (RMAN restore, EXPDP/IMPDP)
Experience with Database RMAN backup/recovery skills (TSM/TDPO/DDomain)
Experience with Capacity management (space utilization, archive/purge data)
Exposure to monitoring and creating alerts in OEM
Understanding of job scheduling
Experience with User Security/Administration