PL/SQL Analytics Consultant in St. Louis, MO at Signature Consultants

Date Posted: 2/6/2020

Job Snapshot

Job Description

PL/SQL Analytics Consultant Summary:

Signature Consultants has an opportunity for a PL/SQL Analytics Consultant. In this role the candidate will provide support for Oracle application development and database design staff for our client. This role will work with application development team members and DBAs to identify and remediate problematic SQL to reduce execution time and database load. Additional work with data modeling team to identify areas for database improvement including changes in indexing, partitioning, compression, etc. Individual will be responsible for documentation of best practices for SQL and PL/SQL development and tuning and working with modeling team members to enhance modeling standards.

Qualifications:

  • At least 2-4 years working in large (10TB +) Oracle databases
  • Strong experience tuning and refactoring Oracle SQL and PL/SQL
  • Expert in database performance tuning techniques such as partitioning, compression and indexing
  • Ability to run, review and tuning using Oracle explain plan
  • Good verbal and written communication skills a must
  • Resource must be capable of working both in a request model where application teams ask for assistance and also in a proactive model, analyzing existing workload to identify problem queries and reaching out to consumers to assist in refactoring statements.

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 15th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.