Oracle Applications DBA

Oracle Applications DBA

Title: Oracle Applications DBA
Location: California-Santa Monica
Great Games Start with Great People!

Activision Blizzard is the umbrella organization over Activision Publishing and Blizzard Entertainment, providing corporate shared services, such as Legal, HR, Finance, IT, Accounting, Facilities and Sales. As the largest and most profitable third-party publisher, Activision Blizzard is a driving force shaping the future of entertainment. The company has a broad portfolio of industry leading brands and award-winning development talent. Activision is the premier worldwide publisher of interactive entertainment software. We maintain a diverse portfolio of products that span a wide range of categories and can be used on a variety of game hardware platforms and operating systems. We have created, licensed and acquired a group of highly recognizable brands, marketed to a growing variety of consumer demographics.

The Oracle Apps/Core DBA will be responsible for managing a broad range of activities, including but not limited to:

· Experience with Installation/Maintenance of Oracle ERP (11i, 11.0.3).
· Day to day activities for ERP: Cloning, Patching, Code Migration, Performance Tuning, Capacity Planning, Database monitoring, User Management, Backup/Recovery Management, TAR Management, Monitoring Applications and its services.
· Responsible for the overall database administration, monitoring and control all of the organization's enterprise databases - RAC and Non-RAC (Oracle).
· Responsible for the creation, configuration, upgrade, backup, tuning, capacity planning & administration of multiple Oracle (8i/9i/10g/11g) databases.
· Understand and familiar with PCP, RAC, DataGuard, RMAN and other related technologies.
· Act as liaison to Oracle ERP and other internal applications teams.
· Administer and maintain Oracle 8i, 9i, 10g and 11g on Solaris and Linux.
· Strong hands-on experience with scripting on SUN, HP, Linux using shell, perl.
· Responsible for providing database consultancy to internal groups in support of various applications (logical design, physical design, failover, DataGuard, etc.).
· Responsible for the day-to-day effective technical performance of the physical DBMS, including taking necessary action to improve performance and initiate recovery activities when system failure occurs.
· Responsible for database backup and recovery procedures to ensure the integrity of disaster recovery process using NetBackup, RMAN, DataGuard and/or SMO.
· Database Administration, tuning and support for the enterprise databases and systems.
· Maintain documentation and contribute to the ongoing development of new standards.
· Ensure that the proper disaster recovery procedures are in place and adhered to.
· Responsible for contribution and adherence to standards that ensure the integrity and security of the enterprise's data resources.
· Responsible for providing backend support for the development, testing and acceptance environments for Oracle ERP and new projects relying on Oracle.
· Undertakes the technical evaluation of new or prospective Oracle implementations.
· Perform database upgrades from Oracle 8.x/9.x/10.x to 11g.
· Migrating Data and/or databases using optimal technology - Export/Import, Data-pump, Transportable tablespaces.
· Responsible for EBS System Administration - User/Role Management, Responsibilities Management, Concurrent Manager/Requests Management.

Requirements:
· Key areas of expected competence: Architecture, Availability & Maintenance, Backup and Recovery, Business Processes & requirements and Security.
· Must have a minimum of 5 years relevant experience in database administration of large-scale systems and a BA/BS degree.
· Monitoring and tuning is an important part of this role and detailed understanding of the Oracle data dictionary, TKprof, Explain Plan, cost based, rule based optimizers, indexes, and SQL statement tuning are key.
· Must be proficient with the use of Oracle 8i/9i/10g/11g Database tools and their use in troubleshooting.
· Familiarity with the setup of database clustering, replication and experience with Oracle Real Application Clustering (RAC) and DataGuard.
· Must have SSO-EBS and IAMS experience.
· Must have solid hands-on database and operating system (Solaris, Linux, NT/Win2K) experience and knowledge.
· Must have experience and thorough understanding of backup, recovery, database reorg, data/database migration procedures/technologies for ERP and Non-ERP databases.
· Must provide organization with 24/7 support for production databases.
· Experience with data warehousing and financial reporting tools would be helpful.
· Understanding of Oracle Advanced Security and Directory Integration (IAMS, SSO, LDAP, etc.) is a real plus.
· Familiarity with RMAN and NetBackup is also a plus. Strong project planning, problem solving and communication skills (written and verbal) are all essential for success in this role.
· Excellent working knowledge of System Administration - User/Role management, Concurrent management, Oracle Workflow, Notification Mailer and other appropriate responsibilities
· Experience with tools such as OEM, TOAD
· Excellent Troubleshooting skills
· Excellent Communication

null