Oracle Database Administrator (Chennai)

Role: L2 Database Administrator (Oracle/ Cloud / Automation) Required Technical Skill Set :Primary Oracle Database Administration, RMAN, Dataguard Secondary MSSQL, MySQL, PostgreSQL Desired Experience Range :6 8 years Location: Chennai Desired Competencies (Technical/Behavioural Competency) 1. Must-Have Key Responsibilities:
- User management:
- Create, modify and manage database users, roles and privileges. Ensure security compliance and access control across the environment.
- Space & Tablespace management:
- Monitor tablespaces, manage datafiles, perform space allocation, resizing and capacity planning.
- Performance Tuning & SQL Optimization:
- Analyse AWR/ASH reports, identify top SQL queries, tune SQL queries and improve the database performance.
- RMAN Backup & Recovery:
- Perform full/incremental backups, restoration, recover and validate backup integrity. Manage retention policies and recovery catalog.
- Database Refresh & Migration:
- Handle export/import using Data Pump, perform schema/database refresh and support migration activities across the environments.
- Data Guard Administration:
- Configure and maintain standby databases, monitor sync, perform switchover/failover.
- Ticket Handling & Production Support: Handle tickets, troubleshoot issues and ensure SLA compliance. Required Skills and Qualifications:
- Solid expertise in Oracle DBA activities.
- Handson experience in RMAN backup & recovery .
- Experience in performance tuning and SQL Optimization, Oracle database installation and migration and data guard configuration.
- Scripting: PowerShell, UNIX shell scripting.
- Experience Level: Typically, 6–8 years in database administration. Good-to-Have
- Knowledge of MsSQL, MySQL & PostgreSQL Basics.
- Experience with additional cloud DB engines (AWS RDS, AWS EC2, Azure).
- Exposure to monitoring tools: CloudWatch, SolarWinds, OEM, Commvault backup tool, SCOM. Role descriptions / Expectations from the Role 1 Should have excellent communication skills to handle overseas customers. 2 Should be capable of multi-tasking whenever required. 3 Should be capable of handling multiple customers and their deliverables on time. 4 Should be willing to come in 24x7 shifts and support the customers 5 Should be a good mentor for the L1 members Apply on Kit Job: kitjob.in/job/4n9egj