Title: Lead Administrator - L1
Job Description
Role Summary
As a L2 resource of his /her team, he /she:
• Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s.
• Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
• Proposes service improvements for all Oracle/EBS services supported throughout the organization.
• Provides technical knowledge, supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA.
• Works in line with policies based on LEAN-CA-CIB best practices.
• Actively engages during any high severity issue and drives for issue resolution.
• Reviews technology changes to identify potential risks.
• Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
• Is aware of the global IT structure so that he/she anticipates interrelationships within the organization.
• Engages with technical peer, Development team, Service managers, Architect and project teams on technology roadmap and projects.
• Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements.
• Guarantees the production readiness.
• Is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role.
• Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations.
͏
Must Have Skills
• RAC/Exadata/Exacc Administration
• Knowledge on OCI,DBASS utilities
• Exacc patching (DOM0,DOMU,GRID,DATABASE)
• Installation, Upgrade & configuration of Oracle software.
• Should have knowledge of Oracle RAC installation and configuration & management.
• Must have Oracle ASM/ACFS implementation skills.
• Good understanding of UNIX scripts .
• Expertise on backup utilities like RMAN, EXPDP/IMPDP, and Networker.
• Good understanding on performance tuning in Oracle database.
• Should have knowledge of Oracle OEM 12C/13C.
• Expertise in query fine tuning and troubleshooting.
• Implement backup and recovery of Oracle DB.
• Administration over DB Objects including Tables, Clusters, Views, Procedures etc.
• Good in Impact Analysis of DB
• Strong experience on configure and troubleshoot physical standby database using dataguard broker.
• Implement backup and recovery of Oracle databases for various scenarios.
• In-depth understanding of Advanced Architectures (Multi-Node, RAC, ASM, EXACC).
• Good understanding of core support processes and change management, maintain documentation standards.
• Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc.
• Responsible for installation, upgrades (Database, EXACC and RAC), patches, SR support, database tuning.
• Capable of delivering under critical environment pressure, resolve complex production issues & provide support when required;
• Proven track record for BAU tasks
• Excellent verbal and written communication skills;
• Independent and strong team player with good inter-personal skills.
Good to Have Skills
• Good scripting(shell/ANSIBLE/PYTHON) skills to automate regular DBA admin tasks.
Oracle EBS knowledge/experience added advantage.
• Strong experience on configures and troubleshoot golden gate replication components.
• EBS Administration
• Banking domain experience will be added advantage
• Installation, Upgrade & configuration of EBS.
͏
Deliver
No | Performance Parameter | Measure |
1 | Operations of the tower | SLA adherence Knowledge management CSAT/ Customer Experience Identification of risk issues and mitigation plans Knowledge management |
2 | New projects | Timely delivery Avoid unauthorised changes No formal escalations |
͏