
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.