Job Description
Minimum of 5 to 7 years experience with Oracle EBS and Oracle Custom Applications with Oracle DB versions 9i, 10g, and/or 11g (experience with Oracle EBS 11 and Oracle DB 11g preferred).
Job Specification
• Install and maintain Linux and Windows Server operating systems including UNIX shell script programming.
• Create and administer database servers including backup (RMAN), recovery, monitoring and tuning
• Administer database accounts according to the security and account management policies.
• Ability to install, backup, restore, reorganize, plan capacity, recover, tune performance and design.
• Monitor and manage the growth of tablespace and datafiles.
• Analyze tables and schemas, collecting system statistics, reorganizing tables and indexes,
• Monitor locks, sessions and queries using OEM.
• Experience building schemas, developing stored procedures and database triggers in PL/SQL.
• Regularly monitor alert log files for errors and warnings.
• Take periodic full cold backups and export database dumps.
• Provide support to programmers in day to day database operations.
• Experience in SQL * Net and SQL * Loader
• Experience in Oracle RAC (Real Application Cluster) setup and tuning to achieve fault tolerance and load balancing
• Capable of configuring SAN with clustered Linux servers and simplify the storage using Oracle ASM
• Create and maintain physical and logical standby databases.