Oracle Database Administrator
Metro-Goldwyn-Mayer Studios Inc
Beverly Hills, CAThis was removed by the employer on 8/24/2016 6:08:00 PM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the IS/IT Category
Search for Oracle Database Administrator jobs in Beverly Hills-CA
Search all Oracle Database Administrator postings
Full Time Job
The Database Administrator ( DBA) will work for the Manager of SAP Basis and DataBase Administration in providing Oracle and Microsoft SQL database support for MGM's key financial and production systems including SAP ECC, SAP CRM/IPM, Alliant, Essbase and other mission critical systems. The Applicant should have at least 5 years of administration experience with Oracle 10g/11g/12c running in a Linux/UNIX and MS Sql Server 2005/2008/2012 Windows environment. This position is part of the IS team which is responsible for the oversight for all Enterprise Database systems.
Responsibilities :
Maintain and administer a variety of database types including Oracle 10g/11g/12c and MS Sql Server 2005/2008/2012/2014.
Maintain and improve the various database environments, including installation, upgrades, performance, security, and change management.
Evaluate, Install, Configure and Test new release of database software and perform software patches on Physical and Virtual (Vmware) Servers
Define and maintain standard operating procedures specifically focused on database.
Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Troubleshoot problems regarding the databases, applications and development tools.
Implement and enforce security for all the Databases.
Monitor database growth, estimate growth and sizing requirements, implement changes to support growth.
Perform database administration including database reorganization, database copy and migration & performance tuning.
Participate in the System Performance tuning and make recommendations.
Perform backup and recovery of the database, data files and tables using hot and cold backup via backup agent such as Veritas Enterprise Netbackup.
Strong understanding of Unix/Linux/Windows Administration and EMC SAN Storage.
Work with IT staffs to gather requirements, support and troubleshoot the applications
Work with Application administrator, developer, UNIX and Windows System Administrator and functional representatives to solve database level issues.
Develop and maintain Unix/Linux Scripts for automation, capacity planning and monitoring.
Support interfaces to DataWarehouse, SAP ERP and CRM systems and to 3rd party tools such as MicroStrategy and Informatica.
Setup and maintain documentation, policies and standards
Participate in providing 24/7 off-hours support on a rotation basis.
Requirements :
5 years of Oracle Database Administration; multiple types of database administration skills preferred.
2 years of MS Sql Server Administration
BS/BA with an emphasis in Computer science or MIS, or equivalent, with a minimum of two years of experience in SAP Basis Administration in HP UNIX and Oracle environments.
Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle.
Proficient in SuSE LINUX, HP UNIX and Windows Operating System
Proficient in some Programming languages, i.e. UNIX/Linux Shell Script, PHP, Java, Perl, javascript
Skilled in using SQL, Pl/Sql, shell scripts in Linux, Unix and Windows
Custom batch scripting for automation tasks in Linux and Windows environment
Familiarity with OEM or other 3rd party database management tools like DBArtisan, Toad, etc
Solid knowledge of Database Management
Solid verbal, written and interpersonal communication skills.
Excellent analytical skills.
Willing to take on new challenges
Highly self-motivated in regards to learning new technologies and sharing knowledge with other team members.
Ability to manage multiple project assignments at a time
Maintain high standards in regards to work ethic and work quality.
Additional Skills Preferred :
Good understanding of Veritas Enterprise Netbackup and Backup Agent
Experience with EMC Timefinder for Snapshot
Knowledge of Data Warehouse database such as Teradata
Knowledge of ETL tools such as Informatica
Experience with Reporting Tools such as Microstrategy
Experience in a large scale Corporate/Enterprise environments.
Experience with small, medium and large databases.
Entertainment industry background
Knowledge of MySQL, Sybase Database
Solid knowledge of SAP's native tools and SAP transactions for Database Management (BRTools, brbackup, brarchive, etc)