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

͏