Job Profile :
Database Administrator, Oracle


Job Location :
Pune


Experience Required :
2-3 yrs


:
Task List
User creation and Deactivation
User account unlock or Password reset
Scheduler Job Creation
Scheduler Job modification
Scheduler Job Enable/Disable
DB Backup scheduling
Privilege Grant/Revoke
Backup jobs monitoring
Scheduler Job monitoring
Restoration testing
DB alert monitoring and action
DB growth and Space addition
Purge log files and release filesystem space
Stats gathering
ASM monitoring and disk addition
Goldengate replication monitoring
Goldengate addition of new objects or servers
DB Cluster monitoring and Management based on the capabilities of the tools
Preprod backend component deployment
Production backend component deployment
Database health checks
Month end activity support
DB report generation
Troubleshooting user complaints or slowness
DB restart requests
User Connectivity Issues
DB connectivity Issues
Server Connectivity issues
DB User access review for audit
Support for various Audits Internal, Quarterly, Annual
Support for IRDAI, UIDAI, ISO audits
Documentation required for Audit and Compliance
Monitoring and Managing log shipping to DR
Configure log shipping to DR
Ensuring data replication and DR readiness
DR drill activity
Patching for VAPT
DB Security Patches
DB Release updates
DB upgrades based on the sop provided by application and OEM
Installation and configuration of database servers
Non-Prod Databases refreshes
Script execution on Production