Apps DBA – SENIOR SPECIALIST L2

Job Description

• Excellent communication and conversation skills (Verbal and Written)

• Good working knowledge of MS OFFICE.

• Good documentation skills Installation of Oracle Software/Database Pre-requisites.

• Oracle Database Basic Administration and Latest Features.

• Maintain instance parameters and system settings Migrating databases using various tools such as SQL Loader, Import/Export and Data pump.

• Applying and Testing security patches to the databases. Managing User Accounts. Experience in cloning using cold backup, hot-backup and RMAN backup.

• Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery. Experience in basic Performance Tuning and Monitoring using various tools such as AWR, TKPROF and Explain Plan.

• Database Resource Management and Task Scheduling. Scheduling Database Backups, taking Logical Backups & Physical Backups. Implementing Database Security Policy.

• Experience with Database Migration, Installation, Upgrades and Patching experience in PL/SQL and worked on ER Diagrams.

• OCA(Essential),OCP(Desired) Skill / Role: Oracle L3, Relevant Experience:

• 6+yrs in Oracle, Qualification: Bachelors / Masters / Equivalent Key Skills Required:

• Excellent communication and conversation skills (Verbal and Written) Good working knowledge of MS OFFICE Evaluate the Database Server Hardware. Define/Recommend/Maintain database Standards and Architecture.

• Future Release management for database/instance and Impact Analysis. 3rd Party Vendor Support and Interaction (including TAR and OS) and can handle Client Independently Should be able to mentor L1 and L2 DBAs.

• Should be able to diagnose clustered environment.

• Advance Database Performance Tuning Applications, Instance/Kernel Parameters and Tuning Memory.

• Usage of AWR and ADDM, translate this and suggest the improvement based on this. Recommend and Review Backup and Recovery Strategies using RMAN or tools.

• Knowledge of Advanced Replication, Queuing and Streams.

• Good Working experience of Installation & administration of RAC 9i, 10g (Real Application Clusters). Flash Recovery Features & Flash back query.

• Having experience of DR setup through various synch methods.

• Designing strategy towards Capacity Management (Growth) for DB tracks. Designing/Recommending Database Security Policy. Knowledge of Data warehousing and Other Technologies (RDBMS).

• Experience on Sun / Veritas / Microsoft Cluster. Experience with Database Migration, Installation, Upgrades and Patching. OCP(Essential), OCE(Desired)

• To provide support for on call escalations and doing root cause analysis of given issue

• To independently resolve tickets within agreed SLA of ticket volume and time

• To adhere to quality standards, regulatory requirements and company policies

• Work on value adding activities such Knowledge base update and management, Training freshers, coaching analysts

• To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases