Burbank, CA On-site Full-time

Prosum is hiring an Oracle Database Engineer - DBA (12c, OEM, EBS)

Responsibilities

  • Supporting their database environment
  • Maintain their Oracle-based applications including the core Production Payroll System and the Oracle Financial Accounting System (EBS v12.1)
  • Assist with their cloud-based products on Postgres and MySQL-based applications
  • Be part of the on-call rotation and respond to critical support issues during non-business hours
  • 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
  • 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

Requirements

  • Strong SQL, experience writing and tuning queries based on application requirements
  • Working knowledge of PL/SQL (designing, developing and maintaining stored procedures, triggers, and user-defined functions)

Additional Information

  • Position will be part of the on-call rotation
  • Expected to respond to critical support issues during non-business hours
Required Skills
PL/SQL
Job Details
Location Burbank, CA
Work mode On-site
Employment Full-time
Category other
Posted 18 days ago
or drop your CV first
About company
Prosum logo

Prosum is a people-first IT recruiting and staffing firm that puts the human touch back into tech. We make technology human. We are a tech staffing and recruiting agency started by technology leaders who wanted a better experience recruiting and hiring IT talent. Once strictly Los Angeles technical recruiters, we now offer recruitment and IT contract staffing services across the Western United States, including in Phoenix, AZ and Denver, CO. We partner with our clients to match them with quality IT talent so they can focus on growing their business. We take the time to understand the company culture, position, projects, and deliverables to support your talent acquisition strategy.

We offer information technology staffing and recruiting services in Phoenix, Denver and Southern California. We are committed to excellence in every engagement and can match exceptional talent to the needs of our clients. This has made us a trusted industry partner for dynamic and growing organizations in the Western United States and across the country. Whether you’re a tech expert looking for a professional IT job or career, or an organization looking for top-level IT staffing services and solutions, Prosum can help.

We have a diverse leadership team, amazing clients, and great connections to the best IT talent in the industry. Prosum is where tech talent turns when they want new challenges, and where great companies look when they need to build strategic teams. That combination continues to help us build strong, long-term relationships with our clients and consultants.

All jobs at Prosum Visit website