Oracle DBA

Amerisure Insurance

Contract Farmington Hills, Michigan, United States Posted 4 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Oracle DBA (Contract)

$35.00 / Hourly

Farmington Hills, Michigan, United States

Oracle DBA

Contract Farmington Hills, Michigan, United States Posted 4 years ago

Description

This is an excellent opportunity for an individual to work with a small team and have a significant impact in the design, implementation, and maintenance of the clients critical database systems. The ideal candidate will independently and proactively evaluate, recommend, install, test, modify and maintain complex relational database system hardware and software configurations meeting functional and technical requirements. The database administrator will work with the team and IT leadership in the identification and implementation of process and technical best practices and continuous improvement initiatives.
RESPONSIBILITIES

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

Amerisure Insurance Vendors

HCL Technologies America Inc
Write a Review

330 Potrero Avenue
Sunnyvale
California
www.hcltech.com ( 34 vendors)

Job Summary

$35.00 / Hourly

Contract

Farmington Hills, Michigan, United States

Experience Required : 3 Year/s

Posted : 4 years ago

Deadline : October 30, 2020 4 years ago

Job ID : Job0000022130

Amerisure Insurance

26777 Halsted Road

248-615-9000

www.amerisure.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.23sRequest Duration690MBMemory UsageGET {slug}Route
    • Booting (1.98s)time
    • Application (255ms)time
    • 1 x Booting (88.57%)
      1.98s
      1 x Application (11.43%)
      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 executed187ms
      • JobController.php#484clientfyi_final22.63msselect * from `jobs` where `job_slug` = 'Job0000022130' limit 1
        Bindings
        • 0: Job0000022130
        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_final68.21msselect `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` = 26669 limit 1
        Bindings
        • 0: 26669
        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_final470μ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` = 26669
        Bindings
        • 0: 1
        • 1: 26669
        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_final750μ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` = 26669 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 26669
        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_final300μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 26669
        Bindings
        • 0: 1
        • 1: 26669
        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.85msselect DISTINCT email from `job_applications` where `category_id` = 31 and `status` = 1
        Bindings
        • 0: 31
        • 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_final370μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 22130 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 22130
        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_final860μ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.69msSELECT 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.6msSELECT 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
          2VBzz9N6OlgkzcolNgnrUD5sLVrZaEaKy00wP3Sm
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000022130" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000022130
          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.191.148.200"
  ]
  "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 => "91cee4c2b92289ec-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.191.148.200"
  ]
  "x-real-ip" => array:1 [▶
    0 => "108.162.216.57"
  ]
  "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 => "Sat, 08 Mar 2025 02:27:29 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImsvUjFmNWpHQW1qZS90M1hxSGVtZ0E9PSIsInZhbHVlIjoiRkNiV2JtQ0NGaUR2cjJaTjQ3aEYwZEZmQXBZK0dYYk4rU29reE1TSjFqd2JQK0dmSDMxMmN0T0w5L3paZVkwM0wrTXdpQ29TYWpSamRqM3BiNElaWW5ud1c4MG9KRCtPTkNrMkExSVJMOTkrajNMcUFqR21oRGEzTUtMY0UrQ0EiLCJtYWMiOiJmMDgxZmYxYmI4NjZkMzM3MjhhYWE5NTA3NmY3MGIyYzgxZWVhMWZkOGI1MmM4MjVhMTdmMTNmMzg2OWY0NGRiIiwidGFnIjoiIn0%3D; expires=Sat, 08 Mar 2025 04:27:30 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImsvUjFmNWpHQW1qZS90M1hxSGVtZ0E9PSIsInZhbHVlIjoiRkNiV2JtQ0NGaUR2cjJaTjQ3aEYwZEZmQXBZK0dYYk4rU29reE1TSjFqd2JQK0dmSDMxMmN0T0w5L3paZVkwM0wrTXdpQ ▶"
    1 => "laravel_session=eyJpdiI6IlRreEhBQ25VY09QeXBHVkNwUnVHSnc9PSIsInZhbHVlIjoiN0hCd0pTSHVkNmZFYnNzaUJldVU2WElmZXorUEV4SE9TcmcxNmlWTnNOT004RkJnVmhjaHI0ayt6L0VIQVZ4TWJRaHhBVUtRMTFJa0YxaWZvMmpsYTF4bktldi9kZGpTWXM5cURtcEJBeHlWN0lNSHBTQ3BEajZLMitRSHlCMG0iLCJtYWMiOiJjNTM5M2JlNjA2MmRjNzk1MjAwZmVmYmFmMDZmM2I3OTgwNjgxMTY3MDZjNzY1NjVhZjI1ZjVmZDdhMzllMjlhIiwidGFnIjoiIn0%3D; expires=Sat, 08 Mar 2025 04:27:30 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlRreEhBQ25VY09QeXBHVkNwUnVHSnc9PSIsInZhbHVlIjoiN0hCd0pTSHVkNmZFYnNzaUJldVU2WElmZXorUEV4SE9TcmcxNmlWTnNOT004RkJnVmhjaHI0ayt6L0VIQVZ4TWJR ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImsvUjFmNWpHQW1qZS90M1hxSGVtZ0E9PSIsInZhbHVlIjoiRkNiV2JtQ0NGaUR2cjJaTjQ3aEYwZEZmQXBZK0dYYk4rU29reE1TSjFqd2JQK0dmSDMxMmN0T0w5L3paZVkwM0wrTXdpQ29TYWpSamRqM3BiNElaWW5ud1c4MG9KRCtPTkNrMkExSVJMOTkrajNMcUFqR21oRGEzTUtMY0UrQ0EiLCJtYWMiOiJmMDgxZmYxYmI4NjZkMzM3MjhhYWE5NTA3NmY3MGIyYzgxZWVhMWZkOGI1MmM4MjVhMTdmMTNmMzg2OWY0NGRiIiwidGFnIjoiIn0%3D; expires=Sat, 08-Mar-2025 04:27:30 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImsvUjFmNWpHQW1qZS90M1hxSGVtZ0E9PSIsInZhbHVlIjoiRkNiV2JtQ0NGaUR2cjJaTjQ3aEYwZEZmQXBZK0dYYk4rU29reE1TSjFqd2JQK0dmSDMxMmN0T0w5L3paZVkwM0wrTXdpQ ▶"
    1 => "laravel_session=eyJpdiI6IlRreEhBQ25VY09QeXBHVkNwUnVHSnc9PSIsInZhbHVlIjoiN0hCd0pTSHVkNmZFYnNzaUJldVU2WElmZXorUEV4SE9TcmcxNmlWTnNOT004RkJnVmhjaHI0ayt6L0VIQVZ4TWJRaHhBVUtRMTFJa0YxaWZvMmpsYTF4bktldi9kZGpTWXM5cURtcEJBeHlWN0lNSHBTQ3BEajZLMitRSHlCMG0iLCJtYWMiOiJjNTM5M2JlNjA2MmRjNzk1MjAwZmVmYmFmMDZmM2I3OTgwNjgxMTY3MDZjNzY1NjVhZjI1ZjVmZDdhMzllMjlhIiwidGFnIjoiIn0%3D; expires=Sat, 08-Mar-2025 04:27:30 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlRreEhBQ25VY09QeXBHVkNwUnVHSnc9PSIsInZhbHVlIjoiN0hCd0pTSHVkNmZFYnNzaUJldVU2WElmZXorUEV4SE9TcmcxNmlWTnNOT004RkJnVmhjaHI0ayt6L0VIQVZ4TWJR ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "2VBzz9N6OlgkzcolNgnrUD5sLVrZaEaKy00wP3Sm"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000022130"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-08 02:27:30GET/Job0000022130311140