SQL DBA

Emory Healthcare

Contract Atlanta, Georgia, United States Posted 5 years ago

 Write a Review Add Vendor   Add Contact  

About Position

SQL DBA (Contract)

$65.00 / Hourly

Atlanta, Georgia, United States

SQL DBA

Contract Atlanta, Georgia, United States Posted 5 years ago

Description


Emory Healthcare is in need of a Lead level Sr SQL consultant. The team has undergone a re-org so they need to review/develop SOPs and best practices. The consultant they bring in needs to have enough experience with interfacing with other elements of the organization (network, storage, vmware, etc) to make this a successful project.



Consultant needs to be highly experienced with this type of situation so that they are ready to hit the ground running. This person needs to be more than just a SQL DBA, they have to have someone that has experiencing augmenting new or at risk DBA groups and getting them on the right track.

Responsibilities
  • 1. Extensive experience setting up SQL Always on cluster. Must be able to identify all requirements necessary (DNS, Network, vmware, etc)-must be able to set up the servers, consolidate, management of SQL server, building
  • 2. Extensive experience developing best practices and standard operating procedures for vmware virtualized SQL
  • •Will need to be able to come in and help getting their SQL environment organized, help with documentation, writing best practices, communication, etc
  • 3. Experience augmenting new or at risk DBA groups
  • 4. SQL risk assessment- someone that has experiencing augmenting new or at risk DBA groups and getting them on the right track.
  • 5. High Availability experience- must have strong knowledge in this

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

Emory Healthcare Vendors

TEK Systems
Write a Review

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

Job Summary

$65.00 / Hourly

Contract

Atlanta, Georgia, United States

Experience Required : 6 Year/s

Posted : 5 years ago

Deadline : December 19, 2019 5 years ago

Job ID : Job0000024132

Emory Healthcare

1364 Clifton Road NE, Room FG06

www.emoryhealthcare.org

Request history8.1.32PHP Version2.22sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (1.96s)time
    • Application (258ms)time
    • 1 x Booting (88.38%)
      1.96s
      1 x Application (11.61%)
      258ms
      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 executed190ms
      • JobController.php#484clientfyi_final21.01msselect * from `jobs` where `job_slug` = 'Job0000024132' limit 1
        Bindings
        • 0: Job0000024132
        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_final69.49msselect `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_final610μsselect * from `users` where `users`.`id` = 55209 limit 1
        Bindings
        • 0: 55209
        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` = 55209
        Bindings
        • 0: 1
        • 1: 55209
        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_final860μ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` = 55209 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 55209
        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_final320μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 55209
        Bindings
        • 0: 1
        • 1: 55209
        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.99msselect 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_final350μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 22827 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 22827
        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_final790μ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_final45.18msSELECT 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_final41.56msSELECT 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
          aFPgOq5tD1hUWSpCzo7kQYZHFjPyLv1FfA11nkcq
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000024132" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000024132
          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.133.79.80" ] "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 => "92b13c310e6fe7fa-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.133.79.80" ] "x-real-ip" => array:1 [ 0 => "108.162.216.132" ] "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:43:32 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Impvai9UQnNXa3hIUWxZNGg4VHR1WlE9PSIsInZhbHVlIjoiYjZoczMzT1orNTZLcWx6OHZVL0ZueDcyMjNpbTRVSWNvTDdQbWVZTC9xS0hKbGlIVDRzaFJ4dWIycUI3N2lsZk5oOFhsMERsSVpWelFNWkxwbkZucUF4L3FsWkdiRkJ3cDJnbmpaOVg4UG5uVVpyYzhjSVpXUWRsQno0bGlMbEYiLCJtYWMiOiJlNWEyNmEzMmU1NDRlOTRmMTEzNjBlY2YzNDQwMzRkNjczNTgyYjQ0NmJkYmQzYTQzOTUxM2NlZjBlNDM2M2NiIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 15:43:33 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Impvai9UQnNXa3hIUWxZNGg4VHR1WlE9PSIsInZhbHVlIjoiYjZoczMzT1orNTZLcWx6OHZVL0ZueDcyMjNpbTRVSWNvTDdQbWVZTC9xS0hKbGlIVDRzaFJ4dWIycUI3N2lsZk5oOFhsM" 1 => "laravel_session=eyJpdiI6Im1MNFFneVJHanFkNHJPaHRHWUNXNnc9PSIsInZhbHVlIjoieUFiZkh1MW9tb1M3R0JwWGZtaVVBaDZMSWsxcWpHWldCbG1UTmVjandQTVp6TnF4REJDRHpWREVjT0t3NURmSGhSR0huOWxBWmVUU3VWTHNVK01JdUh1cG0zNW9hZXdrdkQxR0ROZFFQcXdHOUpOOXJLM3QxYS9FalBaUWVHUkEiLCJtYWMiOiI2ZDI0NDUwMTQyYWQ1MTFhYmQzY2UyMTJjYTc0ZWYwNTZiZTM0ZmZkMjA1ZDQ2NTI2MWQzOTMzYmE3ZjgxOTE5IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 15:43:33 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6Im1MNFFneVJHanFkNHJPaHRHWUNXNnc9PSIsInZhbHVlIjoieUFiZkh1MW9tb1M3R0JwWGZtaVVBaDZMSWsxcWpHWldCbG1UTmVjandQTVp6TnF4REJDRHpWREVjT0t3NURmSGhS" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Impvai9UQnNXa3hIUWxZNGg4VHR1WlE9PSIsInZhbHVlIjoiYjZoczMzT1orNTZLcWx6OHZVL0ZueDcyMjNpbTRVSWNvTDdQbWVZTC9xS0hKbGlIVDRzaFJ4dWIycUI3N2lsZk5oOFhsMERsSVpWelFNWkxwbkZucUF4L3FsWkdiRkJ3cDJnbmpaOVg4UG5uVVpyYzhjSVpXUWRsQno0bGlMbEYiLCJtYWMiOiJlNWEyNmEzMmU1NDRlOTRmMTEzNjBlY2YzNDQwMzRkNjczNTgyYjQ0NmJkYmQzYTQzOTUxM2NlZjBlNDM2M2NiIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 15:43:33 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Impvai9UQnNXa3hIUWxZNGg4VHR1WlE9PSIsInZhbHVlIjoiYjZoczMzT1orNTZLcWx6OHZVL0ZueDcyMjNpbTRVSWNvTDdQbWVZTC9xS0hKbGlIVDRzaFJ4dWIycUI3N2lsZk5oOFhsM" 1 => "laravel_session=eyJpdiI6Im1MNFFneVJHanFkNHJPaHRHWUNXNnc9PSIsInZhbHVlIjoieUFiZkh1MW9tb1M3R0JwWGZtaVVBaDZMSWsxcWpHWldCbG1UTmVjandQTVp6TnF4REJDRHpWREVjT0t3NURmSGhSR0huOWxBWmVUU3VWTHNVK01JdUh1cG0zNW9hZXdrdkQxR0ROZFFQcXdHOUpOOXJLM3QxYS9FalBaUWVHUkEiLCJtYWMiOiI2ZDI0NDUwMTQyYWQ1MTFhYmQzY2UyMTJjYTc0ZWYwNTZiZTM0ZmZkMjA1ZDQ2NTI2MWQzOTMzYmE3ZjgxOTE5IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 15:43:33 GMT; path=/; httponlylaravel_session=eyJpdiI6Im1MNFFneVJHanFkNHJPaHRHWUNXNnc9PSIsInZhbHVlIjoieUFiZkh1MW9tb1M3R0JwWGZtaVVBaDZMSWsxcWpHWldCbG1UTmVjandQTVp6TnF4REJDRHpWREVjT0t3NURmSGhS" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "aFPgOq5tD1hUWSpCzo7kQYZHFjPyLv1FfA11nkcq" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000024132" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-04 13:43:33GET/Job0000024132311140