Responsibilities:ย
Migrate databases from HP Unix to Solaris OS Platformย
Upgrade databases to Oracle 12cย
Install, Configure Golden gate for data replicationย
Install, Configure RAC databases for high availablityย
Provide support on all the stages of database implementation and/or database related deploymentsย
Participate in project meetings, as necessary, to understand application and database requirementsย
Ability to work independently and to resolve complex Oracle issuesย
Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.ย
Troubleshoot Oracle performance and non-performance related issues either independently or in conjunction with other DBAsย
Manage backup/recovery for Oracle instancesย
Management of database and resource capacity planning.ย
Implement and enforce database security based upon best practice, SOX regulations, and company policiesย
Installation of new Oracle instances and upgradesย
Setting up and resolving issues with Oracle Data Guard environmentsย
Scripting language (ksh, perl)ย
Requirementsย
Min. experience of 10+ yr. Oracle DBA requiredย
Proficient and experienced with Oracle RAC (design, configuration, installations and tuning), including version Oracle 12c.ย
Proficient and experienced with Golden Gate technology.ย
Proficient and experienced with ASM, RMAN and Active Data Guard database technologies.ย
Strong production support experience & customer service skillsย
Oracle 11G and 12c Database Administration and Management on HP/Solaris and Linux environmentsย
Oracle internalsย
Oracle Database Tuning and Performance - usage of statspack, AWR, ADDM, ASH and UNIX native commandsย
Oracle backup and recovery configuration and proceduresย
Oracle Enterprise Manager/Grid Control for environment standardizationย
Knowledge of enterprise data architecture principlesย
Ability to develop data requirements and configure database parameters accordinglyย
Exadata experience a huge plus
Experience with system administration of the following products:ย
Oracle E-Business Suite R12.2ย
Oracle Agile/PLM R9.3.3ย
Oracle GRCย
Oracle WebLogicย
List of qualifications in order of preference:ย
At least 1 year hands-on Oracle Agile/PLM R9.3.3 installation, administration and support experienceย
At least 1 year hands-on Oracle GRC (AACG 8.6.5) installation, administration and support experienceย
At least 2 years hands-on Oracle EBS (R11.5, 12.1, 12.2) installation, administration and support experienceย