Administer Oracle 9i adn SQL server 2000 Databases with performance tuning

Smith & Nephew

Contract Memphis, Tennessee, United States Posted 9 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Administer Oracle 9i adn SQL server 2000 Databases with performance tuning (Contract)

$90.00 / Hourly

Memphis, Tennessee, United States

Administer Oracle 9i adn SQL server 2000 Databases with performance tuning

Contract Memphis, Tennessee, United States Posted 9 years ago

Description

Administer Oracle 9i adn SQL server 2000 Databases with performance tuning

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

Smith & Nephew Vendors

( Login to see all the 4 vendors)
Sogeti USA Corporation
Write a Review

7735 Paragon Road
Dayton
Ohio
www.sogeti.com ( 24 vendors)

Harvey Nash PLC
Write a Review

1680 Rte 23 North Suite 300
Wayne
New Jersey
www.harveynash.com ( 3 vendors)

Randstad North America
Write a Review

2015 South Park Place
Atlanta
Georgia
www.randstad.com ( 1 vendors)

Job Summary

$90.00 / Hourly

Contract

Memphis, Tennessee, United States

Experience Required : 10 Year/s

Posted : 9 years ago

Deadline : November 5, 2015 9 years ago

Job ID : Job0000002755

Smith & Nephew

160 Dascomb Road

www.smith-nephew.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.69sRequest Duration692MBMemory UsageGET {slug}Route
    • Booting (2.44s)time
    • Application (255ms)time
    • 1 x Booting (90.55%)
      2.44s
      1 x Application (9.45%)
      255ms
      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 executed185ms
      • JobController.php#484clientfyi_final3.05msselect * from `jobs` where `job_slug` = 'Job0000002755' limit 1
        Bindings
        • 0: Job0000002755
        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_final82.92msselect `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_final560μsselect * from `users` where `users`.`id` = 14433 limit 1
        Bindings
        • 0: 14433
        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_final490μsselect 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` = 14433
        Bindings
        • 0: 1
        • 1: 14433
        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_final830μsselect `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` = 14433 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 14433
        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_final280μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 14433
        Bindings
        • 0: 1
        • 1: 14433
        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_final8.9msselect DISTINCT email from `job_applications` where `category_id` = 172 and `status` = 1
        Bindings
        • 0: 172
        • 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_final330μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 2755 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 2755
        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_final780μ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_final46.67msSELECT 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_final40.65msSELECT 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
          aBKqUKpZTX6Qpb8AXbIRV33npWXqENdYf9f4DU2h
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000002755" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000002755
          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 => "18.220.47.149"
  ]
  "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 => "9206ef692d16f865-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.220.47.149"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.131.150"
  ]
  "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 => "Fri, 14 Mar 2025 21:41:29 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ims3QThEeUR0U1RaM2VVencyU2NWdmc9PSIsInZhbHVlIjoidXVacTA2YXhMdHd4SHNEbVB0WHhxTWR5VFNqOGZ0YVE0YVVjYWdUU2lvcGZXV1A1eWhZcWFDMzdOQTBwYmxpaDJVRmY5bmJtOFBRNWZTbDdvdzRoV204bVJlakZPU3gvS2VtSWx4Z3VTZVY4d2tYOUJvVkhkLzZFb1FrK3YwQXUiLCJtYWMiOiI1NWFhODBjMzE1MjkyY2QwNjE5OGFmZjNiMGIzOWI0YzBkZDUyNzRhYmZmNTQxYWFmNDExNjc5ZDFjZTE3NjI2IiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 23:41:29 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ims3QThEeUR0U1RaM2VVencyU2NWdmc9PSIsInZhbHVlIjoidXVacTA2YXhMdHd4SHNEbVB0WHhxTWR5VFNqOGZ0YVE0YVVjYWdUU2lvcGZXV1A1eWhZcWFDMzdOQTBwYmxpaDJVRmY5b ▶"
    1 => "laravel_session=eyJpdiI6IjQ5YnBhOWJkQ2QxR2RzSGcvWURQc1E9PSIsInZhbHVlIjoiS3Jsb2lObHZPTU9DUDJMbmtFTENPYUxjZFdKNFB2cE1KaTQyR0M0MDJTNGsyUzAzbGkzaGVhU2d6V0dwNjJiSWdRVHJwQmtBQzQ0aGhMTm1zNFhmeXZQaWJKeERBOXRSa0htVUZPZlRqS3pEZDVyVk1Ka3hPR3l6VmNqdzJWYWciLCJtYWMiOiI3M2MyOGM2Y2JmY2NhYTcxOWUzNmUzMzViNzUwOGU0M2RkODFmMWE2NjVmMTg3MmE0NzZiNGIxY2E0MjM3OTIzIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 23:41:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjQ5YnBhOWJkQ2QxR2RzSGcvWURQc1E9PSIsInZhbHVlIjoiS3Jsb2lObHZPTU9DUDJMbmtFTENPYUxjZFdKNFB2cE1KaTQyR0M0MDJTNGsyUzAzbGkzaGVhU2d6V0dwNjJiSWdR ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ims3QThEeUR0U1RaM2VVencyU2NWdmc9PSIsInZhbHVlIjoidXVacTA2YXhMdHd4SHNEbVB0WHhxTWR5VFNqOGZ0YVE0YVVjYWdUU2lvcGZXV1A1eWhZcWFDMzdOQTBwYmxpaDJVRmY5bmJtOFBRNWZTbDdvdzRoV204bVJlakZPU3gvS2VtSWx4Z3VTZVY4d2tYOUJvVkhkLzZFb1FrK3YwQXUiLCJtYWMiOiI1NWFhODBjMzE1MjkyY2QwNjE5OGFmZjNiMGIzOWI0YzBkZDUyNzRhYmZmNTQxYWFmNDExNjc5ZDFjZTE3NjI2IiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 23:41:29 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ims3QThEeUR0U1RaM2VVencyU2NWdmc9PSIsInZhbHVlIjoidXVacTA2YXhMdHd4SHNEbVB0WHhxTWR5VFNqOGZ0YVE0YVVjYWdUU2lvcGZXV1A1eWhZcWFDMzdOQTBwYmxpaDJVRmY5b ▶"
    1 => "laravel_session=eyJpdiI6IjQ5YnBhOWJkQ2QxR2RzSGcvWURQc1E9PSIsInZhbHVlIjoiS3Jsb2lObHZPTU9DUDJMbmtFTENPYUxjZFdKNFB2cE1KaTQyR0M0MDJTNGsyUzAzbGkzaGVhU2d6V0dwNjJiSWdRVHJwQmtBQzQ0aGhMTm1zNFhmeXZQaWJKeERBOXRSa0htVUZPZlRqS3pEZDVyVk1Ka3hPR3l6VmNqdzJWYWciLCJtYWMiOiI3M2MyOGM2Y2JmY2NhYTcxOWUzNmUzMzViNzUwOGU0M2RkODFmMWE2NjVmMTg3MmE0NzZiNGIxY2E0MjM3OTIzIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 23:41:29 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjQ5YnBhOWJkQ2QxR2RzSGcvWURQc1E9PSIsInZhbHVlIjoiS3Jsb2lObHZPTU9DUDJMbmtFTENPYUxjZFdKNFB2cE1KaTQyR0M0MDJTNGsyUzAzbGkzaGVhU2d6V0dwNjJiSWdR ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "aBKqUKpZTX6Qpb8AXbIRV33npWXqENdYf9f4DU2h"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000002755"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-14 21:41:29GET/Job0000002755311140