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

PSG Global Solutions; Burbank (CA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Awarded 7th Best Places to Work in Los Angeles

Job summary

A leading payroll services provider is seeking an experienced Database Engineer to maintain Oracle-based applications and support cloud-based products. The role involves SQL query tuning and database object design in a team environment. Ideal candidates should have at least 5 years of Oracle Database Administration experience, web services management, and a good understanding of Agile methodologies. This position is part of the on-call rotation for critical issues, requiring excellent communication and problem-solving skills.

Qualifications

• Proven Oracle Database Administration experience – minimum of 5 years.
• Ability to maintain Oracle-based applications including Payroll and Financial Accounting Systems.
• Experience working in a team that delivers a high availability service.

Responsibilities

• Maintain Oracle-based applications and assist with cloud-based products.
• Participate in design and tuning of database objects.
• Monitor long running transactions and optimize query executions.

Skills

Strong SQL

PL/SQL

Oracle Database Administration

Postgres

MySQL

Agile SDLC

Communication skills

Education

Oracle Certification (OCP preferred)

Tools

Oracle Enterprise Manager Cloud Control

Job description

• Full-time

Company Description

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

Thanks to our knowledgeable and experienced staff, it has developed the most stable and sophisticated production accounting software available on the market. We were the first in our field to provide 24/7 on-line support as well as electronic interfacing of payroll data with our proprietary software. PSL3 brings the convenience of the internet to production accounting.

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

The people who work at it are the "hallmark" of the company. Their vast knowledge and extensive experience in the industry are what makes 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 they are 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 their Oracle-based applications including the core Production Payroll System and the Oracle Financial Accounting System (EBS v12.1). The role will also assist with their 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.

Responsibilities

• 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 the different Technology and business team members to ensure that the 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

Core Competencies

• Good oral communication skills and is comfortable in group or small team settings

Relationship Building

• Builds excellent working relations with all Technology colleagues and business users, works effectively with department and executive management and maintains a professional relationship with outside clients

Business Acumen and Process Knowledge

• Demonstrates a continually growing knowledge of Company’s internal business practices, processes and the daily IT operational needs of the users
• Effectively plans and organizes daily work following priorities set by the Senior DBA Lead and help desk tickets when appropriate
• Demonstrates strong follow-up and follow-through skills in ensuring timely completion of projects and end user support
• Self-starter who actively takes responsibility to resolve technical problems but also knows when to ask questions to avoid major delays in delivery of work product

Experience and Skills

• Proven Oracle Database Administration experience – minimum of 5 years
• Oracle Enterprise Manager Cloud Control (OEM)
• Oracle in a cloud environment
• Experience with Postgres, MySQL and/or MSSQL and familiarity with Amazon RDS
• Experience working in a team that delivers a high availability service
• Working knowledge of Agile SDLC process
• Experience with managing internal and external SQL database security is a plus
• Experience working in a DevOps environment with continuous delivery is a strong plus
• Experience working with Big Data is a plus
• Oracle Certification, preferably OCP

Additional Information

JENALYN BERNARDO | Prosum | Technical Recruiter

Awarded 7th “Best Places to Work in Los Angeles”