
The Oracle DBA is primarily responsible for installation, configuration, monitoring, troubleshooting, performance tuning, maintenance, support and enhancements to the Oracle database environments within online business environment as well as backup environment. He will be responsible for creating and maintaining the strategy for Oracle database optimization, upgrades, backups and patching. Other responsibilities include:
--Installation, configuration and upgrading of Oracle server software and related products
--Evaluate Oracle features and Oracle related products
--Maintain database performance by monitoring space, CPU usage, fragmentation of data, and by tuning queries, setting alerts, etc
--Create and implement a strategy for patching Oracle databases
--Work with application owners to migrate databases from one release to the next, if necessary
--Work with security team to establish standards and policies to ensure enterprise information assets are properly secured and protected by appropriate access management and privacy controls. Furthermore, He is to Support and implement audit requirements
--Develop, communicate, and carry out procedures designed to facilitate recovery from database failure, such as online backups, archiving, and exports
--Plan, document and provide support for Disaster Recovery of the Oracle database environments.
--Provide regular feedback to the Management regarding system performance conditions as well as identify possible future challenges to be addressed for smooth functioning of DB and related application
Required SkillsKey skills required for the job are:
--Proven Track record of experience in managing a medium to Large Scale DB
--Relevant Oracle Certification
--Experience in managing a multi-node RAC environment
--A DBA should have strong knowledge of Oracle Application
Data Guard configuration and administration- Backup Procedures and recovery
--ASM management
--Should have sound communication skills with management, development & application teams, vendors and systems administrators
--Should have the ability to handle multiple projects and deadlines and possess a sound understanding of the business
--Should be a good team player.