Oracle DBA Lead (L3 Support)

The role holder will be responsible for providing overall L3 Database administration support for the team.

Certifications: OCA, OCP Must and OCE / OCM added advantage & ITIL Mandatory

Qualification & Experience

• B. Tech / BE
• 7 + years of relevant experience
• Delivery of quality, cost-effective infrastructure services in a complex & high-availability environment
• Proven ability to plan and execute workload in a pressurized & dynamic environment.
• ITIL Certified or a strong working knowledge of ITIL Incident, Problem, and Change Management disciplines.

Skills Required:

• Strong Knowledge in Database administration processes and concepts.
• Knowledge of configuring and setting up maintenance activities for DB.
• Ability to direct and guide the team to resolve crises within prescribed SLAs.
• Ability to provide consultation for new projects, functionalities, migrations, and upgrades.
• Ability to direct and guide the team to resolve crises within prescribed SLAs.

Process skills

• Ability to resolve service requests. Strong attention to detail and the ability to follow processes.
• Strong Knowledge of ITSM processes

Other skills

• Documentation and reporting skills.
• Should be a quick learner and have good communication and interpersonal skills.
• Should be willing to work in a 24*7 environment and be a good team player.

Roles and Responsibilities:

• User management and maintenance of all database users like granting a subset of privileges as per clients policy.
• Resolving User-related queries in Production and Test Databases.
• As per client request creating new users and assigning profiles in production databases.
• 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 the RMAN status of all production databases.
• Monitoring the uptime of all production & staging databases including and SMS databases
• Monitoring Database and listener status for Production and DR side.
• Monitoring of alert logs, identifying errors, and Initiate approval for necessary action
• Monitoring Disk utilization for Production and DR Database.
• Monitoring Table space Size in the database level.
• Monitoring for DC and DR sync status and checking status archival apply status
• Monitoring the number of active sessions in the database.
• Monitoring CPU utilization and I/O wait on the Production database.
• Providing out-of-hours cover as agreed with the Team Leader
• 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