Installation and configuration

• This person will play a key role in insuring the Oracle environment is architected to meet business and IT demands for availability, performance and manageability.
• The DBA will be responsible for production databases in support of IT applications.

Principal Responsibilities

• Implements standards relative to all aspects of Oracle database management
• Provides solutions mapped to business/user and application development needs
• Develops technical and organizational specifications for systems
• Advise on best data coding practices, review critical SQL explain plans and validate database scripts for launch and assist in production launch.
• Maintain database documentation
• Responsible for communication and notification to IT support groups and management of all new database requirements and standards.

Requirements:

• Having at least 5 years of experience in production database support and an expertise in Oracle 9i and 10g/SQL Server 2000 and 2005.
• Experienced in performing installation and configuration.
• Experienced in patching, upgrading, migrating, database maintenance and troubleshooting.
• Experienced in backup and recovery (RMAN), high availability (standby logical/physical clustering, RAC, etc), performance tuning and VLDB maintenance.
• Knowledge of incident and change management will be an added advantage.
• Proficiency in Optimizing Databases/database servers, Backup/Recovery (point-in-time recovery), Security architecture, Oracle Standby, Database clusters, I/O sub-system tuning for best performance (data file layout, RAID configuration etc.), various trace flag settings and performance-tuning of database SQL code (procedures/packages etc.)
• Minimum 1-2 years on 10g RAC, ASM, Oracle partition and Oracle Data Guard.
• Good communication skills.