SQL Server DBA

WS Badcock Corporation

Contract Mulberry , Florida, United States Posted 7 years ago

 Write a Review Add Vendor   Add Contact  

About Position

SQL Server DBA (Contract)

$75.00 / Hourly

Mulberry , Florida, United States

SQL Server DBA

Contract Mulberry , Florida, United States Posted 7 years ago

Description

Minimum Qualifications 1. Bachelor Degree in Computer Science or Management Information Systems 2. Four years DBA experience with U2 / Universe, SQL Server. 3. Two + years experience in systems development lifecycle. 4. Experience in Linux and Windows Operating Systems. 5. Strong problem solving technique, analytical skills and the ability to multitask several projects at one time. 6. Strong understanding of business administration to include accounting, audits, controls and procedures. 7. Knowledge and experience with database design, data modeling, normalization, integration, implementation, security and architecture. 8. Ability to develop and manage multiple activities and components related to IT integration projects. 9. Ability to communicate effectively with management, and personnel by telephone, or through written communication; assimilate information and make decisions; work under pressure in a detailed and organized manner. 10. Effective time management and organizational skills, the ability to exercise independent judgment and decision making skills.

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

WS Badcock Corporation Vendors

Touchmark Consulting
Write a Review

4249 Easton Way Suite 220
Columbus
Ohio
www.touchmarkconsulting.com ( No vendors )

Job Summary

$75.00 / Hourly

Contract

Mulberry , Florida, United States

Experience Required : 8 Year/s

Posted : 7 years ago

Deadline : April 21, 2017 7 years ago

Job ID : Job0000009208

WS Badcock Corporation

200 N Phosphate Blvd

800-223-2625

www.Badcock.com

Request history8.1.32PHP Version2.45sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.1s)time
    • Application (352ms)time
    • 1 x Booting (85.64%)
      2.10s
      1 x Application (14.36%)
      352ms
      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 executed281ms
      • JobController.php#484clientfyi_final10.28msselect * from `jobs` where `job_slug` = 'Job0000009208' limit 1
        Bindings
        • 0: Job0000009208
        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_final116msselect `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_final680μsselect * from `users` where `users`.`id` = 49719 limit 1
        Bindings
        • 0: 49719
        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_final590μ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` = 49719
        Bindings
        • 0: 1
        • 1: 49719
        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` = 49719 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 49719
        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` = 49719
        Bindings
        • 0: 1
        • 1: 49719
        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_final14.48msselect DISTINCT email from `job_applications` where `category_id` = 63 and `status` = 1
        Bindings
        • 0: 63
        • 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_final510μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 9208 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 9208
        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_final1msselect * 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_final70.8msSELECT 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_final65.69msSELECT 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
          zn80LMBsWV0ie9XKUnm6GbIbzHP9gycSHiio5PkP
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000009208" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000009208
          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.222.240.84" ] "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 => "92b1264f6b0ae258-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "18.222.240.84" ] "x-real-ip" => array:1 [ 0 => "172.70.100.8" ] "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, 04 Apr 2025 13:28:36 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik9MaEZ2TVNyTVl0dG1IS2kzVDVCL3c9PSIsInZhbHVlIjoiMGpnbUFRaDNSNnlDWDZWSFVYV1UzbWxnR0QrMTVPRloyTGJEVTg3SXA0M0FFSHp5Nkpha0sxOTlJMmxNQWZ4TDJpTjFFUFJKalg3SldGUDVHaU45T0hYNkFYMFdPNy9oTitRZ1laOTNEeUFwRVluVklpN1c0ZXN5dVlCYVRhV0giLCJtYWMiOiJkMjE2NzJkOGQ1ZjkxMjY0MTBjNTFhMWI2OGFkYjcwMGMzZGQ4YTNjOTc2YTQ3YTY4ZWEwMjE4MDdmNTUxOGZiIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 15:28:36 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ik9MaEZ2TVNyTVl0dG1IS2kzVDVCL3c9PSIsInZhbHVlIjoiMGpnbUFRaDNSNnlDWDZWSFVYV1UzbWxnR0QrMTVPRloyTGJEVTg3SXA0M0FFSHp5Nkpha0sxOTlJMmxNQWZ4TDJpTjFFU" 1 => "laravel_session=eyJpdiI6IlRnSmhudEl2TndKYStvQmc2YjM5Wnc9PSIsInZhbHVlIjoiRVNlTE45SzNMQllWMnhSTWlwNE90UDZRcWt2VFFBU2tBTDVQYlJUT00xUTV3YzRZUzRML2t4K2NvdGRkRWowdXdSQTF3dU5DRENHTGJhK2cxT2tKOSs4cU9ZMUlMaXNubzZPWGlrUG1TY2JEYVZsTlM2R2s3WE8vdURCa3A3cUUiLCJtYWMiOiIyOWVhY2UxODY5YWNiZWExMGEyNWQ3M2VhYTAzZjBjMzRkOTMyNzdlMDk1OTI0ZTBhZWUxYTM5ZmYxMTI4N2Q5IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 15:28:36 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlRnSmhudEl2TndKYStvQmc2YjM5Wnc9PSIsInZhbHVlIjoiRVNlTE45SzNMQllWMnhSTWlwNE90UDZRcWt2VFFBU2tBTDVQYlJUT00xUTV3YzRZUzRML2t4K2NvdGRkRWowdXdS" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik9MaEZ2TVNyTVl0dG1IS2kzVDVCL3c9PSIsInZhbHVlIjoiMGpnbUFRaDNSNnlDWDZWSFVYV1UzbWxnR0QrMTVPRloyTGJEVTg3SXA0M0FFSHp5Nkpha0sxOTlJMmxNQWZ4TDJpTjFFUFJKalg3SldGUDVHaU45T0hYNkFYMFdPNy9oTitRZ1laOTNEeUFwRVluVklpN1c0ZXN5dVlCYVRhV0giLCJtYWMiOiJkMjE2NzJkOGQ1ZjkxMjY0MTBjNTFhMWI2OGFkYjcwMGMzZGQ4YTNjOTc2YTQ3YTY4ZWEwMjE4MDdmNTUxOGZiIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 15:28:36 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ik9MaEZ2TVNyTVl0dG1IS2kzVDVCL3c9PSIsInZhbHVlIjoiMGpnbUFRaDNSNnlDWDZWSFVYV1UzbWxnR0QrMTVPRloyTGJEVTg3SXA0M0FFSHp5Nkpha0sxOTlJMmxNQWZ4TDJpTjFFU" 1 => "laravel_session=eyJpdiI6IlRnSmhudEl2TndKYStvQmc2YjM5Wnc9PSIsInZhbHVlIjoiRVNlTE45SzNMQllWMnhSTWlwNE90UDZRcWt2VFFBU2tBTDVQYlJUT00xUTV3YzRZUzRML2t4K2NvdGRkRWowdXdSQTF3dU5DRENHTGJhK2cxT2tKOSs4cU9ZMUlMaXNubzZPWGlrUG1TY2JEYVZsTlM2R2s3WE8vdURCa3A3cUUiLCJtYWMiOiIyOWVhY2UxODY5YWNiZWExMGEyNWQ3M2VhYTAzZjBjMzRkOTMyNzdlMDk1OTI0ZTBhZWUxYTM5ZmYxMTI4N2Q5IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 15:28:36 GMT; path=/; httponlylaravel_session=eyJpdiI6IlRnSmhudEl2TndKYStvQmc2YjM5Wnc9PSIsInZhbHVlIjoiRVNlTE45SzNMQllWMnhSTWlwNE90UDZRcWt2VFFBU2tBTDVQYlJUT00xUTV3YzRZUzRML2t4K2NvdGRkRWowdXdS" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "zn80LMBsWV0ie9XKUnm6GbIbzHP9gycSHiio5PkP" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000009208" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-04 13:28:36GET/Job0000009208311140