Oracle/Sybase DBA

Northern Trust Corporation

Contract Chicago , Illinois, United States Posted 8 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Oracle/Sybase DBA (Contract)

$60.00 / Hourly

Chicago , Illinois, United States

Oracle/Sybase DBA

Contract Chicago , Illinois, United States Posted 8 years ago

Description

The candidate should have extensive Oracle and Sybase experience. Candidate would be expected to execute multiple application and infrastructure projects ensuring that all DBA and Project checkpoints have been addressed. For the duration of the project assignment, the candidate will function as the primary database contact for the Technical Services Project Management Office (PMO), Application Partners and Technical Services partners. There is a 46 week ramp up time, during which someone will shadow this person (ideal person will need to pick up things quickly). At times this person may be working on 57 projects at once.The candidate would provide database expertise as either the lead on databaseonly projects or serve as a virtual team member (VTM) for larger projects with representatives from multiple Technical Services teams. All database staff rotate through the firecall list and will be expected to provide after hours support for the pro

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

Northern Trust Corporation Vendors

( Login to see all the 20 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Wipro Technologies
Write a Review

1300 Crittenden Lane
Mountain View
California
www.wipro.com ( 61 vendors)

Tata Consultancy Services
Write a Review

101 Park Avenue 26th Floor
New York
New York
www.usa-tcs.com ( 41 vendors)

Job Summary

$60.00 / Hourly

Contract

Chicago , Illinois, United States

Experience Required : 8 Year/s

Posted : 8 years ago

Deadline : August 17, 2016 8 years ago

Job ID : Job0000005673

Northern Trust Corporation

50 South La Salle Street

312-630-6000

www.northerntrust.com

Request history8.1.31PHP Version2.24sRequest Duration688MBMemory UsageGET {slug}Route
    • Booting (1.99s)time
    • Application (251ms)time
    • 1 x Booting (88.81%)
      1.99s
      1 x Application (11.19%)
      251ms
      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 executed184ms
      • JobController.php#484clientfyi_final5.54msselect * from `jobs` where `job_slug` = 'Job0000005673' limit 1
        Bindings
        • 0: Job0000005673
        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_final81.24msselect `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_final590μsselect * from `users` where `users`.`id` = 3986 limit 1
        Bindings
        • 0: 3986
        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_final670μ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` = 3986
        Bindings
        • 0: 1
        • 1: 3986
        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_final1.6msselect `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` = 3986 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 3986
        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_final290μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 3986
        Bindings
        • 0: 1
        • 1: 3986
        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.43msselect 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` = 5673 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 5673
        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_final830μ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_final44.21msSELECT 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_final39.79msSELECT 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
          3tDnd9OQslf7P7XTHTdvIdU4dIQy7hZ9ZZyuv4d1
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000005673" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000005673
          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 => "52.14.88.125" ] "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 => "91aa90455ca710d1-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "52.14.88.125" ] "x-real-ip" => array:1 [ 0 => "172.69.58.101" ] "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 => "Mon, 03 Mar 2025 16:38:21 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkQ0K0h6enNlUjR1bjhvb2hoNzA4clE9PSIsInZhbHVlIjoiV3d5dkptbllJcUJuMXUzRmFLSzB3aGg2Y2prQi9vcGtyWHd5WW15WTBUWGcxUHpDSTZWZVJyVExQWUpxZmttL2ZhMkFEeDEyMzFMY1V4Z09sd0ZYR3I2L3VPYmVWYVBQaERQVnA1UUI5bitVQ2hiWVJZSFl0cjExOHkwYytYQkciLCJtYWMiOiI5ZGNkOWVjMTlkMjk1Y2ViZTJlZmMyNGRlMDQ4OGZlMGM3ZGJjNDIyNGYwOTg3OWUwYTVhMDNkNjI1MTI1MDMxIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 18:38:22 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkQ0K0h6enNlUjR1bjhvb2hoNzA4clE9PSIsInZhbHVlIjoiV3d5dkptbllJcUJuMXUzRmFLSzB3aGg2Y2prQi9vcGtyWHd5WW15WTBUWGcxUHpDSTZWZVJyVExQWUpxZmttL2ZhMkFEe" 1 => "laravel_session=eyJpdiI6InQwUnBvS2NxWVpTVVQraThiOXFFUnc9PSIsInZhbHVlIjoiWnJMdnhKUDloMXEwSkF4Q1E3L0E3TkxSRjgwWTJTVnJXRlpmRGhxVThsc0lrTjM5T0FiZUVFVlBqLzFRWXRBZmdoR2NocXpWcHVMbHpIVVFlREFnOE9tcVU0eXh4dlVFVWF1bkFGY3BhWGFjNG8rV01RM1NiZGNDNkRpV1IrUVQiLCJtYWMiOiJkZjBhMzcxMjk2MTkyZTBiMzk2YzJlYTkxMTQ5NmQxNjgzOTk1ZGZlYzdiNGMzY2JkZTgwODJjYzFhZjgyZjkwIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 18:38:22 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6InQwUnBvS2NxWVpTVVQraThiOXFFUnc9PSIsInZhbHVlIjoiWnJMdnhKUDloMXEwSkF4Q1E3L0E3TkxSRjgwWTJTVnJXRlpmRGhxVThsc0lrTjM5T0FiZUVFVlBqLzFRWXRBZmdo" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkQ0K0h6enNlUjR1bjhvb2hoNzA4clE9PSIsInZhbHVlIjoiV3d5dkptbllJcUJuMXUzRmFLSzB3aGg2Y2prQi9vcGtyWHd5WW15WTBUWGcxUHpDSTZWZVJyVExQWUpxZmttL2ZhMkFEeDEyMzFMY1V4Z09sd0ZYR3I2L3VPYmVWYVBQaERQVnA1UUI5bitVQ2hiWVJZSFl0cjExOHkwYytYQkciLCJtYWMiOiI5ZGNkOWVjMTlkMjk1Y2ViZTJlZmMyNGRlMDQ4OGZlMGM3ZGJjNDIyNGYwOTg3OWUwYTVhMDNkNjI1MTI1MDMxIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 18:38:22 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkQ0K0h6enNlUjR1bjhvb2hoNzA4clE9PSIsInZhbHVlIjoiV3d5dkptbllJcUJuMXUzRmFLSzB3aGg2Y2prQi9vcGtyWHd5WW15WTBUWGcxUHpDSTZWZVJyVExQWUpxZmttL2ZhMkFEe" 1 => "laravel_session=eyJpdiI6InQwUnBvS2NxWVpTVVQraThiOXFFUnc9PSIsInZhbHVlIjoiWnJMdnhKUDloMXEwSkF4Q1E3L0E3TkxSRjgwWTJTVnJXRlpmRGhxVThsc0lrTjM5T0FiZUVFVlBqLzFRWXRBZmdoR2NocXpWcHVMbHpIVVFlREFnOE9tcVU0eXh4dlVFVWF1bkFGY3BhWGFjNG8rV01RM1NiZGNDNkRpV1IrUVQiLCJtYWMiOiJkZjBhMzcxMjk2MTkyZTBiMzk2YzJlYTkxMTQ5NmQxNjgzOTk1ZGZlYzdiNGMzY2JkZTgwODJjYzFhZjgyZjkwIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 18:38:22 GMT; path=/; httponlylaravel_session=eyJpdiI6InQwUnBvS2NxWVpTVVQraThiOXFFUnc9PSIsInZhbHVlIjoiWnJMdnhKUDloMXEwSkF4Q1E3L0E3TkxSRjgwWTJTVnJXRlpmRGhxVThsc0lrTjM5T0FiZUVFVlBqLzFRWXRBZmdo" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "3tDnd9OQslf7P7XTHTdvIdU4dIQy7hZ9ZZyuv4d1" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000005673" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-03 16:38:22GET/Job0000005673311140