Oracle DBA Administrator
L2/L3 Support
Mumbai - Belpaur
Work from Office Setup Only
Must have experience in Oracle RAC, Dataguard - 12 C & 19 C.
Roles & Responsilbilites
- Resolving User related queries in Production and Test Databases.
- As per client request creating new users and assigning profiles in production databases.
- User management and maintenance of all database users like granting a subset of privileges as per client's policy.
- Logical backup using Export-Import and Data Pump utility as per user request.
- Database bug-patching on requirement
- Creating Sql tuning sets and sql tuning advisory reports using OEM 12C for Improving performance of the database.
- Executing weekly analyzer on database for performance improvement.
- Monthly purging activity to gain database level space improvement
- Archival activity for performance improvement.
- Performance monitoring, Database installation and configuration
- Schedule RMAN backup and monitor RMAN status of all production databases.
- Interface proactively with other Infrastructure support teams such as UNIX, Windows, Network, Storage, Monitoring etc
- Document issues and associated resolutions to problems
- Prepare documentation and presentation of progress reports to customers
- Conduct user's, customer's and Team's training
- Guide/Mentor the team members on technical problems which cannot be resolved at their level
- Ensure that Systems, Organization processes, & Unit practices adhere to Organization policies
- Active participation in Organization and Unit level initiatives
Skills: Dataguard, Rman Backup, Windows, Oem 12c, Unix, Storage, Network, Oracle Rac, Data Pump, Monitoring
Experience: 2.00-3.00 Years