Oracle PL/SQL Developer

Wells Fargo & Company 2 Reviews

Contract San Francisco, California, United States Posted 7 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Oracle PL/SQL Developer (Contract)

$85.00 / Hourly

San Francisco, California, United States

Oracle PL/SQL Developer

Contract San Francisco, California, United States Posted 7 years ago

Description

Minimum Qualifications710 years technical background and 56 years directly related Oracle(10g) & pl/sql experience Handson experience in unix shell scripting Should have experience in the usage of the bulk features of oracle Ability to support by carrying pager/cell and resolve issues during nonbusiness hours Skilled in authoring technical documentation and performing reviews, design, data manipulation, and creative problem solving Ability to take initiative and communication skills are essential Ability to work independently or collaboratively Ability to multitask in a fastpaced environment Excellent communication skills, both written and oral Bachelors degree in Computer Science or equivalent Preferred SkillsExperience in the usage of Autosys scheduler Experience in performance tuning sql query optimization

By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Wells Fargo & Company Vendors

( Login to see all the 63 vendors)
Comsys Information Technology Services Inc
Write a Review

4400 Post Oak Parkway #1800
Houston
Texas
www.comsys.com ( 112 vendors)

Capgemini
Write a Review

5 Times Square
New York
New York
www.capgemini.com ( 42 vendors)

Infosys Technologies Ltd
Write a Review

6607 Kaiser Drive
Fremont
California
www.infosys.com ( 27 vendors)

Job Summary

$85.00 / Hourly

Contract

San Francisco, California, United States

Experience Required : 4 Year/s

Posted : 7 years ago

Deadline : January 31, 2018 7 years ago

Job ID : Job0000011948

Wells Fargo & Company

420 Montgomery St

www.wellsfargo.com

Request history8.1.31PHP Version2.67sRequest Duration687MBMemory UsageGET {slug}Route
    • Booting (2.14s)time
    • Application (526ms)time
    • 1 x Booting (80.27%)
      2.14s
      1 x Application (19.73%)
      526ms
      3 templates were rendered
      • frontend.job-viewjob-view.blade.php#?blade
      • admin.flash_msgflash_msg.blade.php#?blade
      • layouts.themetheme.blade.php#?blade
      uri
      GET {slug}
      middleware
      web
      controller
      App\Http\Controllers\JobController@view
      namespace
      prefix
      where
      as
      job_view
      file
      app/Http/Controllers/JobController.php:482-507
      11 statements were executed263ms
      • JobController.php#484clientfyi_final10.88msselect * from `jobs` where `job_slug` = 'Job0000011948' limit 1
        Bindings
        • 0: Job0000011948
        Backtrace
        • app/Http/Controllers/JobController.php:484
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • User.php#78clientfyi_final87.06msselect `id`, `company` from `users` where `user_type` in ('employer', 'agent') order by `id` desc
        Bindings
        • 0: employer
        • 1: agent
        Backtrace
        • app/Models/User.php:78
        • app/Http/Controllers/JobController.php:491
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#493clientfyi_final750μsselect * from `users` where `users`.`id` = 6364 limit 1
        Bindings
        • 0: 6364
        Backtrace
        • app/Http/Controllers/JobController.php:493
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • Vendor.php#57clientfyi_final1.31msselect count(*) as aggregate from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 6364
        Bindings
        • 0: 1
        • 1: 6364
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • Vendor.php#57clientfyi_final2.23msselect `vendors`.*, `users`.`website`, `users`.`company`, `users`.`address`, `users`.`city`, `states`.`state_name`, `countries`.`country_name`, (SELECT (SUM(ratings)/COUNT(id)) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_rating, (SELECT COUNT(id) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_count, (SELECT COUNT(id) FROM vendors as b WHERE b.employer_id = vendors.vendor_id) as vendor_count from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 6364 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 6364
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#500clientfyi_final380μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 6364
        Bindings
        • 0: 1
        • 1: 6364
        Backtrace
        • app/Http/Controllers/JobController.php:500
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • job-view.blade.php#17clientfyi_final7.92msselect DISTINCT email from `job_applications` where `category_id` = 56 and `status` = 1
        Bindings
        • 0: 56
        • 1: 1
        Backtrace
        • view::frontend.job-view:17
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • job-view.blade.php#450clientfyi_final380μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 11948 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 11948
        Backtrace
        • view::frontend.job-view:450
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#101clientfyi_final710μsselect * from `categories` where `job_count` >= 1 order by `job_count` desc
        Bindings
        • 0: 1
        Backtrace
        • view::layouts.theme:101
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#102clientfyi_final61.63msSELECT jobs.state_id,jobs.state_name, COUNT(*) AS numberOfSales FROM jobs JOIN states ON states.id = jobs.state_id GROUP BY jobs.state_id,jobs.state_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:102
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#103clientfyi_final89.51msSELECT jobs.city_id,jobs.city_name, COUNT(*) AS numberOfcities FROM jobs JOIN cities ON cities.id = jobs.city_id GROUP BY jobs.city_id,jobs.city_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:103
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Category
      138Category.php#?
      App\Models\Job
      1Job.php#?
      App\Models\User
      1User.php#?
          _token
          IHgjMAhDtdbEwwv6ODvnJaMv2aZmswJuu2bkPdjE
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000011948" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000011948
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:25 [ "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "priority" => array:1 [ 0 => "u=0, i" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cf-connecting-ip" => array:1 [ 0 => "3.134.117.239" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "cf-ray" => array:1 [ 0 => "917d113d787faef5-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.134.117.239" ] "x-real-ip" => array:1 [ 0 => "172.69.17.48" ] "host" => array:1 [ 0 => "pingjob.com" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Wed, 26 Feb 2025 04:07:19 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndxWHZMQWc2L1hMUjJBQ3ZjYmNONnc9PSIsInZhbHVlIjoiZStRbVg4UGdHQjJCckJPMTNOeDJOWTlUeFltV3dqcXRueWxYSEdnYmt2Y0JwY2JFdzl6MG5JajYrcWJpSTZsWkFuclNvWTU3cy8xY1IwWUpJQlBvanI1L0ZXbTIxVldEQVpad2ZPSjhQWGFmVHVMRjR2dCsyZjVKdDRpZUI5SFciLCJtYWMiOiJiMzJjYWVmODI4N2E0OTQyNDVkMjA2YzBiMDdhMzk4NWFiMjU5MTkyNjcxN2NkYTA2MzM3OGVmMjU3ZDcwYWQyIiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 06:07:20 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IndxWHZMQWc2L1hMUjJBQ3ZjYmNONnc9PSIsInZhbHVlIjoiZStRbVg4UGdHQjJCckJPMTNOeDJOWTlUeFltV3dqcXRueWxYSEdnYmt2Y0JwY2JFdzl6MG5JajYrcWJpSTZsWkFuclNvW" 1 => "laravel_session=eyJpdiI6IlBMK0ErQ1JoS1JWdEhvWjNONU1KWUE9PSIsInZhbHVlIjoiN1dUaHFkZnNLMTRZQXRTV1lrczIzZTRIVFZUMGZUakNxMEJpRXdBWmFkVnVLOERxK1dGNFNoVm5iZVRWR21yNElzK2ZNZVpJRVRpcjdQTlAwM1RMZ3FOQ1lpRVJLV3MxLzZqWDBBaXE3Rm5jWUpUOXRZSVdEMDk1SWpRZHdEWVgiLCJtYWMiOiJlOTAyZDQ2YzhmOTVmZjMzMTc5NTZhMjQ2ZDIxMjEwMTgwNGQzMmY1YTRhOTg2ZTU4Nzk2ZDE2NTQ3N2M4MzQ2IiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 06:07:20 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlBMK0ErQ1JoS1JWdEhvWjNONU1KWUE9PSIsInZhbHVlIjoiN1dUaHFkZnNLMTRZQXRTV1lrczIzZTRIVFZUMGZUakNxMEJpRXdBWmFkVnVLOERxK1dGNFNoVm5iZVRWR21yNElz" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndxWHZMQWc2L1hMUjJBQ3ZjYmNONnc9PSIsInZhbHVlIjoiZStRbVg4UGdHQjJCckJPMTNOeDJOWTlUeFltV3dqcXRueWxYSEdnYmt2Y0JwY2JFdzl6MG5JajYrcWJpSTZsWkFuclNvWTU3cy8xY1IwWUpJQlBvanI1L0ZXbTIxVldEQVpad2ZPSjhQWGFmVHVMRjR2dCsyZjVKdDRpZUI5SFciLCJtYWMiOiJiMzJjYWVmODI4N2E0OTQyNDVkMjA2YzBiMDdhMzk4NWFiMjU5MTkyNjcxN2NkYTA2MzM3OGVmMjU3ZDcwYWQyIiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 06:07:20 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IndxWHZMQWc2L1hMUjJBQ3ZjYmNONnc9PSIsInZhbHVlIjoiZStRbVg4UGdHQjJCckJPMTNOeDJOWTlUeFltV3dqcXRueWxYSEdnYmt2Y0JwY2JFdzl6MG5JajYrcWJpSTZsWkFuclNvW" 1 => "laravel_session=eyJpdiI6IlBMK0ErQ1JoS1JWdEhvWjNONU1KWUE9PSIsInZhbHVlIjoiN1dUaHFkZnNLMTRZQXRTV1lrczIzZTRIVFZUMGZUakNxMEJpRXdBWmFkVnVLOERxK1dGNFNoVm5iZVRWR21yNElzK2ZNZVpJRVRpcjdQTlAwM1RMZ3FOQ1lpRVJLV3MxLzZqWDBBaXE3Rm5jWUpUOXRZSVdEMDk1SWpRZHdEWVgiLCJtYWMiOiJlOTAyZDQ2YzhmOTVmZjMzMTc5NTZhMjQ2ZDIxMjEwMTgwNGQzMmY1YTRhOTg2ZTU4Nzk2ZDE2NTQ3N2M4MzQ2IiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 06:07:20 GMT; path=/; httponlylaravel_session=eyJpdiI6IlBMK0ErQ1JoS1JWdEhvWjNONU1KWUE9PSIsInZhbHVlIjoiN1dUaHFkZnNLMTRZQXRTV1lrczIzZTRIVFZUMGZUakNxMEJpRXdBWmFkVnVLOERxK1dGNFNoVm5iZVRWR21yNElz" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "IHgjMAhDtdbEwwv6ODvnJaMv2aZmswJuu2bkPdjE" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000011948" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-02-26 04:07:20GET/Job0000011948311140