SQL DBA Production Support

CIGNA Corporation

Contract Nashville, Tennessee, United States Posted 5 years ago

 Write a Review Add Vendor   Add Contact  

About Position

SQL DBA Production Support (Contract)

$75.00 / Hourly

Nashville, Tennessee, United States

SQL DBA Production Support

Contract Nashville, Tennessee, United States Posted 5 years ago

Description

MS SQL Server 2014/2012/2018R2/2005/2000 in Production, Test, Development and Cluster Server Environments.SQL Server backup and recoveryCreation of database maintenance plans, rebuild/defrag indexes, database consistency checks.Develops database systems that are more complex with full competency. Coordinates with users to determine requirements. Analyzes, designs, creates and implements more complex databases including access methods, device allocations, validation checks, organization and security. Designs more complex data models, logical and physical databases, data dictionaries and schemas. Liaisons with database software vendors and external technical support on issues such as software upgrades, problems and potential solutions. Reviews systems under development and related documentation. May coordinate activities of the project team and assist in monitoring project schedules and costs. Highly skilled.

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

CIGNA Corporation Vendors

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

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

Accenture Ltd
Write a Review

1345 Avenue of the Americas
New York
New York
www.accenture.com ( 51 vendors)

Cognizant Technology Solutions Corporation
Write a Review

500 Frank W. Burr Boulevard
Teaneck
New Jersey
www.Cognizant.com ( 50 vendors)

Job Summary

$75.00 / Hourly

Contract

Nashville, Tennessee, United States

Experience Required : 8 Year/s

Posted : 5 years ago

Deadline : September 30, 2019 5 years ago

Job ID : Job0000017453

CIGNA Corporation

1 Liberty Place

www.cigna.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.18sRequest Duration691MBMemory UsageGET {slug}Route
    • Booting (1.7s)time
    • Application (473ms)time
    • 1 x Booting (78.28%)
      1.70s
      1 x Application (21.72%)
      473ms
      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 executed201ms
      • JobController.php#484clientfyi_final17.44msselect * from `jobs` where `job_slug` = 'Job0000017453' limit 1
        Bindings
        • 0: Job0000017453
        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_final85.16msselect `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` = 16787 limit 1
        Bindings
        • 0: 16787
        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_final740μ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` = 16787
        Bindings
        • 0: 1
        • 1: 16787
        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.95msselect `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` = 16787 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 16787
        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_final330μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 16787
        Bindings
        • 0: 1
        • 1: 16787
        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_final9.09msselect 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_final380μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 17453 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 17453
        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_final810μ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.4msSELECT 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.85msSELECT 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
          cAhRRsUcOzFEpGaiJ4voUkRFcXwnAJ4F3h6Duv8z
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000017453" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000017453
          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.144.33.74"
  ]
  "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 => "91f5f818c81beb0b-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.144.33.74"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.71.254.35"
  ]
  "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 => "Wed, 12 Mar 2025 20:16:26 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZDTkZ6L2tmMUpTZHpYWWxUdlVUQ3c9PSIsInZhbHVlIjoiVzJnNG9Xa3ZaS09sdGdvcDhubEMrV0JUTUd2VGs4RXJKMzZhaFhvWG9oeWRtR1VrMkk0RVZEWWM4alYza2pnOGw2MTdxdXNxZDZOWU5FUVo3MFFGb1owbkdtc2tXSjk3K01icmROcEQ5aTUwbnZXNllqTHkxWEZMTS92cVVqM0siLCJtYWMiOiI2NjJhNGY4ZjAzYmI0OTg5ZTkwNDg0Mjk1ZmVkZTMzMGY1MTRkODA2YjYxMmFmZWYyZTQ0YWQzMDk3YzA5MGM2IiwidGFnIjoiIn0%3D; expires=Wed, 12 Mar 2025 22:16:26 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InZDTkZ6L2tmMUpTZHpYWWxUdlVUQ3c9PSIsInZhbHVlIjoiVzJnNG9Xa3ZaS09sdGdvcDhubEMrV0JUTUd2VGs4RXJKMzZhaFhvWG9oeWRtR1VrMkk0RVZEWWM4alYza2pnOGw2MTdxd ▶"
    1 => "laravel_session=eyJpdiI6IlFQb09vQzlQOW1sS1dtSGdsdE85WEE9PSIsInZhbHVlIjoiSDlzSjB5eE5TVjNkSGFhakMrTUFkOWZ3OHk3cXlLVzBuZ2NlVWdxakoxZkVvMklxZkRTTVB4QWkzTVY4c1U2SDZOUkVTYUlNQUpyQy9LSHJzcFZocHUxTjBxRTRmK2M1TDNkc0swVDJlSzliRFVxTklnKzBPd3ZtNnY5d3ZYcjkiLCJtYWMiOiIyNWUwNjY1Nzc3NGM3YTk4MTQ0MjdlMDUzMGEyYmIzZjlhNjZhOWE2NDBkMzlmZjQ3NmRiMDQyZTY3NzE2ZmY4IiwidGFnIjoiIn0%3D; expires=Wed, 12 Mar 2025 22:16:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlFQb09vQzlQOW1sS1dtSGdsdE85WEE9PSIsInZhbHVlIjoiSDlzSjB5eE5TVjNkSGFhakMrTUFkOWZ3OHk3cXlLVzBuZ2NlVWdxakoxZkVvMklxZkRTTVB4QWkzTVY4c1U2SDZO ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZDTkZ6L2tmMUpTZHpYWWxUdlVUQ3c9PSIsInZhbHVlIjoiVzJnNG9Xa3ZaS09sdGdvcDhubEMrV0JUTUd2VGs4RXJKMzZhaFhvWG9oeWRtR1VrMkk0RVZEWWM4alYza2pnOGw2MTdxdXNxZDZOWU5FUVo3MFFGb1owbkdtc2tXSjk3K01icmROcEQ5aTUwbnZXNllqTHkxWEZMTS92cVVqM0siLCJtYWMiOiI2NjJhNGY4ZjAzYmI0OTg5ZTkwNDg0Mjk1ZmVkZTMzMGY1MTRkODA2YjYxMmFmZWYyZTQ0YWQzMDk3YzA5MGM2IiwidGFnIjoiIn0%3D; expires=Wed, 12-Mar-2025 22:16:26 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InZDTkZ6L2tmMUpTZHpYWWxUdlVUQ3c9PSIsInZhbHVlIjoiVzJnNG9Xa3ZaS09sdGdvcDhubEMrV0JUTUd2VGs4RXJKMzZhaFhvWG9oeWRtR1VrMkk0RVZEWWM4alYza2pnOGw2MTdxd ▶"
    1 => "laravel_session=eyJpdiI6IlFQb09vQzlQOW1sS1dtSGdsdE85WEE9PSIsInZhbHVlIjoiSDlzSjB5eE5TVjNkSGFhakMrTUFkOWZ3OHk3cXlLVzBuZ2NlVWdxakoxZkVvMklxZkRTTVB4QWkzTVY4c1U2SDZOUkVTYUlNQUpyQy9LSHJzcFZocHUxTjBxRTRmK2M1TDNkc0swVDJlSzliRFVxTklnKzBPd3ZtNnY5d3ZYcjkiLCJtYWMiOiIyNWUwNjY1Nzc3NGM3YTk4MTQ0MjdlMDUzMGEyYmIzZjlhNjZhOWE2NDBkMzlmZjQ3NmRiMDQyZTY3NzE2ZmY4IiwidGFnIjoiIn0%3D; expires=Wed, 12-Mar-2025 22:16:26 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlFQb09vQzlQOW1sS1dtSGdsdE85WEE9PSIsInZhbHVlIjoiSDlzSjB5eE5TVjNkSGFhakMrTUFkOWZ3OHk3cXlLVzBuZ2NlVWdxakoxZkVvMklxZkRTTVB4QWkzTVY4c1U2SDZO ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "cAhRRsUcOzFEpGaiJ4voUkRFcXwnAJ4F3h6Duv8z"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000017453"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-12 20:16:26GET/Job0000017453311140