Oracle Database Engineer - DBA (12c, OEM, EBS)

Job Type : Full-time

Company Description

Founded in 1976, the company began modestly as a small business that provided payroll services to the commercial and music business. Today, with offices in Burbank, New York, Albuquerque, Atlanta, Baton Rouge, Detroit, Toronto, and Vancouver, it has grown into a leading provider of payroll service for the Motion Picture, Television, and Commercial Industries. The company provides these same industries with its highly regarded PSL family of production accounting software.

The company has developed the most stable and sophisticated production accounting software available on the market, thanks to its knowledgeable and experienced staff. It was the first in its field to provide 24 / 7 online support as well as electronic interfacing of payroll data with its proprietary software. PSL3 brings the convenience of the internet to production accounting.

Responsiveness is where client services begin. The company has built a reputation that's unmatched in its ability to respond quickly and address and resolve client issues promptly. This commitment is a trademark and absolute first priority. The company built long-lasting client relationships based on mutual reliance, integrity, and trust.

The people who work at the company are the hallmark of the company. Their vast knowledge and extensive experience in the industry are what make it the best in the business.

Job Description

The client builds software and cloud-based technologies used by many of Hollywood's largest film, television, and commercial production companies and is looking for an experienced Database Engineer to join their growing team. Working closely with the company's product development teams, this role is responsible for supporting their database environment.

The primary focus will be to maintain Oracle-based applications, including the core Production Payroll System and the Oracle Financial Accounting System (EBS v12.1). The role will also assist with cloud-based products on Postgres and MySQL-based applications.

The position will be part of the on-call rotation and will be expected to respond to critical support issues during non-business hours.

The responsibilities of the role include :

• Strong SQL, experience writing and tuning queries based on application requirements
• Actively participate as part of matrixed product development teams providing advice on design and tuning of database objects, queries, and overall data architecture
• Use of tools and utilities to load and unload data, generate and edit test data
• Database refreshes and testing
• Working knowledge of PL / SQL (designing, developing, and maintaining stored procedures, triggers, and user-defined functions)
• Work with different Technology and business team members to ensure that associated hardware resources are allocated to the databases and to ensure high availability and optimum performance
• Provide trend analysis to the service management team to enable them to make informed decisions regarding resource management
• Provide query and performance expertise in support of code development
• Monitor long-running transactions and have the ability to optimize query executions with index tuning and optimized T-SQL coding technique
• Problem escalation to development team and third parties as appropriate
• Implementation and release of database changes as submitted by the development team
• Documenting technical environments and processes as necessary

Qualifications

The ideal candidate will have the following core competencies :

The candidate should also have :

Additional Information

The company is an equal opportunities employer and welcomes applications from all qualified candidates.

J-18808-Ljbffr