Oracle DBA L2

Karnataka

IT Software/ Software Services

Oracle DBA required to work in global Level 2 support team supporting Global investment & French retail bank servers.
The successful candidate will be cross trained to manage MSSQL/Sybase administration first line support in addition to Oracle.
 Must Skills - Oracle DBA with 9i, 10g, 11g experience.
Unix (Solaris/Aix /Linux), Windows good working knowledge.
Should able to understand and analyze queries.
These skills are required especially when there are performance related issues on a databaseHands-on experience on incident, request, problem/change management tools Desirable Oracle Professional certified (OCP) Soft skills - Must have good team working skills balanced with ability to work in shifts (24x7 on rotation basis) / ability to work alone and a positive attitude.
Customer focus and communication skills4 + years of experience Working experience in banking domain.
Good in Oracle RDBMS 10g/11g architecture concepts Usage of data dictionary views Space management, Undo Management, User management Partitioning of tables Experience in database patching, up-gradation. Experience in migrating of database from 10g to 11g. Managing Redo log and Archive log files Working experience in RMAN, Sql loader & Data Pump Backup and recovery methods Logical backup and recovery using  data pump , export/import Oracle network configuration (listener and tnsnames) Trouble shooting database issues strong experience SQL and PL/SQL knowledge Shell scripting kshell, Born & c shell.
Performance tuning using AWR and Statspack.
Job Function: Installation and maintenance of database server (Primarily Oracle) Work closely with different development teams to understand database requirements and provide support Responsible for ensuring availability and performance of the databases that support the system Monitoring & responding  the database systems incidents to ensure secure production services to business Responsible for improvement and maintenance of the databases to include rollout and upgrades Responsible for implementation and release of database changes, as submitted by the development team Support for Development environments Refresh of UAT/Staging/pre-prod environments Database troubleshooting and problem root cause analysis Experience in performance monitoring, reporting and tuning of Oracle databases Work with infrastructure team (co-ordinate with application support team) to ensure that the associated hardware resources are allocated to the database to ensure high availability and optimum performance