Database administration with MarkLogic

CVS Corporation

Contract Woonsocket, Rhode Island, United States Posted 6 months ago

 Write a Review Add Vendor   Add Contact  

About Position

Database administration with MarkLogic (Contract)

$75.00 / Hourly

Woonsocket, Rhode Island, United States

Database administration with MarkLogic

Contract Woonsocket, Rhode Island, United States Posted 6 months ago

Skills
Experience with automation via Ansible Terraform Experience with deployments (CI/CD) with GHA GitHub Jenkins
Description

This senior role requires expertise in database administration and the ability to work in a fast-paced collaborative environment. We provide support for on-premises and cloud databases (IaaS and DBaaS) including critical Tier 1 and Tier 2 systems that utilize high availability solutions with replication.

This resource will support the design, implementation, and maintenance of database environments.

You will ensure integrity and high availability of the database environments in your charge. Responsibilities include but are not limited to build/management of on-prem VM and as-a-service cloud implementations, monitoring/alerting setup and admin, application consulting, performance tuning, version upgrades, automations, architecture, access methods and reviews, backup/recovery, vendor coordination/ticketing, and team mentoring and knowledge sharing.

As part of the DBA team you will collaborate with peer DBAs, project teams, application contacts to support and maintain current implementations as well as new builds/requirements. The role will assist in assuring that the Database implementations are secure, compliant, and adhere to minimum security requirements as set by CVS Health.

You will use your knowledge and experience in the Database space to support application requirements and make recommendations for improving existing and future processes. You will aid in reviewing new enhancements, features, products for future use and planning.

Responsibilities
  • · 8 years of combined experience in Database Administration / Engineering
  • · Advanced knowledge of performance tuning, monitoring/alerting, observability, dashboarding
  • · Advanced knowledge of process/query analysis, buffer tuning, client/server connectivity and database consistency checks
  • · Advanced knowledge of maintenance routines, upgrades, patching
  • · Experience in handling physical/logical backups & restores and data refreshes.
  • · Experience in Linux/Unix shell commands or Windows PowerShell or Python
  • · Experience in OS fine tuning with regards to Network I/O, Disk
  • · Should be able to collaborate with DBA peers and mentor, work well in a team and independently
  • · Should be able to multi-task i.e. parallelize multiple environment build / data migration
  • · Should be able to work off-hours for application release support, Linux patching support, maintenance windows
  • · Experienced with security and data compliance aspects of database
  • · Well versed with latest version of database

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

CVS Corporation Vendors

( Login to see all the 13 vendors)
Kforce Professional Staffing Firm
Write a Review

1001 E Palm Avenue
Tampa
Florida
www.kforce.com ( 82 vendors)

Tata Consultancy Services
Write a Review

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

Ciber Global, LLC
Write a Review

3270 West Big Beaver Road
Troy
Michigan
www.ciber.com ( 34 vendors)

Job Summary

$75.00 / Hourly

Contract

Woonsocket, Rhode Island, United States

Experience Level : Medium

Experience Required : 7 Year/s

Only Any

Posted : 6 months ago

Deadline : October 9, 2024 6 months ago

Job ID : Job0000014666

CVS Corporation

Corporate Headquarters , One CVS Drive

www.cvs.com

Request history8.1.32PHP Version2.36sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.01s)time
    • Application (345ms)time
    • 1 x Booting (85.35%)
      2.01s
      1 x Application (14.65%)
      345ms
      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 executed263ms
      • JobController.php#484clientfyi_final11.87msselect * from `jobs` where `job_slug` = 'database-administration-with-marklogic' limit 1
        Bindings
        • 0: database-administration-with-marklogic
        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_final134msselect `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_final720μsselect * from `users` where `users`.`id` = 1490 limit 1
        Bindings
        • 0: 1490
        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_final680μ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` = 1490
        Bindings
        • 0: 1
        • 1: 1490
        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.45msselect `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` = 1490 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 1490
        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` = 1490
        Bindings
        • 0: 1
        • 1: 1490
        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.95msselect DISTINCT email from `job_applications` where `category_id` = 40 and `status` = 1
        Bindings
        • 0: 40
        • 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_final360μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 14666 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 14666
        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_final1.4msselect * 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_final50.56msSELECT 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_final52.82msSELECT 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
          9IeQhw3ePk3fvwDhnRJukhwuOGLAkXTnVqpWu3qJ
          _previous
          array:1 [ "url" => "https://pingjob.com/database-administration-with-marklogic" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /database-administration-with-marklogic
          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:18 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "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" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [ 0 => "3.19.60.207" ] "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 => "Sun, 20 Apr 2025 04:45:25 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InEySjJ3eXNKaTFYM3B4S1N6aVd3ZWc9PSIsInZhbHVlIjoialA2ckFNMnQrSFNaTGlxbHNON1dCTjdiRFBzbzFyZmpGRFFNTUxNNGgrdEdZM2cwbDlCdk0vVU1VMWhBeFVVeENXcU45VnZrK01hbGllZlcyU1JPMmk4bSt3YnZkUXZoanNCL0M1ZENVWEF2TTBtTkhMRGRuVmlZR3I1RlB4UUoiLCJtYWMiOiIwMTY5ZjcxNTBlMDA2MTI5ODJkYjU3Mzg5YTg2MmQ2OTU2MzE5ZDVkMDVjMmRmM2E2YjRhM2RkNTc0NGRhNmM2IiwidGFnIjoiIn0%3D; expires=Sun, 20 Apr 2025 06:45:26 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InEySjJ3eXNKaTFYM3B4S1N6aVd3ZWc9PSIsInZhbHVlIjoialA2ckFNMnQrSFNaTGlxbHNON1dCTjdiRFBzbzFyZmpGRFFNTUxNNGgrdEdZM2cwbDlCdk0vVU1VMWhBeFVVeENXcU45V" 1 => "laravel_session=eyJpdiI6IlhReFRWNGNVU2ZIeUpCM3pTMFdHZUE9PSIsInZhbHVlIjoiYnRYWUJuUmdDZXM3WUZHNHdHT0dmQWtxV1JhKzJmN3FjOXBRTjBveXV1MnFyMzNvOWUvTkhkcyttMm5wUStUYWFnc1JNaEZPcWJXUlJ4aDNpV2JFLzBvbVlTVnJVZ1k5anpmc2JzaEJ1Ym9MM0E0S0xIaS96cjJZYTZvMG45Y0UiLCJtYWMiOiIwYzQwZjRkOWI0MzcxZDkzODA2N2E4OTUyNTUzMzQ3NDkxYWVhYWRjYTVkZTFmYzFkYjU2ODAzMDAyN2E4ZTI1IiwidGFnIjoiIn0%3D; expires=Sun, 20 Apr 2025 06:45:26 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlhReFRWNGNVU2ZIeUpCM3pTMFdHZUE9PSIsInZhbHVlIjoiYnRYWUJuUmdDZXM3WUZHNHdHT0dmQWtxV1JhKzJmN3FjOXBRTjBveXV1MnFyMzNvOWUvTkhkcyttMm5wUStUYWFn" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InEySjJ3eXNKaTFYM3B4S1N6aVd3ZWc9PSIsInZhbHVlIjoialA2ckFNMnQrSFNaTGlxbHNON1dCTjdiRFBzbzFyZmpGRFFNTUxNNGgrdEdZM2cwbDlCdk0vVU1VMWhBeFVVeENXcU45VnZrK01hbGllZlcyU1JPMmk4bSt3YnZkUXZoanNCL0M1ZENVWEF2TTBtTkhMRGRuVmlZR3I1RlB4UUoiLCJtYWMiOiIwMTY5ZjcxNTBlMDA2MTI5ODJkYjU3Mzg5YTg2MmQ2OTU2MzE5ZDVkMDVjMmRmM2E2YjRhM2RkNTc0NGRhNmM2IiwidGFnIjoiIn0%3D; expires=Sun, 20-Apr-2025 06:45:26 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InEySjJ3eXNKaTFYM3B4S1N6aVd3ZWc9PSIsInZhbHVlIjoialA2ckFNMnQrSFNaTGlxbHNON1dCTjdiRFBzbzFyZmpGRFFNTUxNNGgrdEdZM2cwbDlCdk0vVU1VMWhBeFVVeENXcU45V" 1 => "laravel_session=eyJpdiI6IlhReFRWNGNVU2ZIeUpCM3pTMFdHZUE9PSIsInZhbHVlIjoiYnRYWUJuUmdDZXM3WUZHNHdHT0dmQWtxV1JhKzJmN3FjOXBRTjBveXV1MnFyMzNvOWUvTkhkcyttMm5wUStUYWFnc1JNaEZPcWJXUlJ4aDNpV2JFLzBvbVlTVnJVZ1k5anpmc2JzaEJ1Ym9MM0E0S0xIaS96cjJZYTZvMG45Y0UiLCJtYWMiOiIwYzQwZjRkOWI0MzcxZDkzODA2N2E4OTUyNTUzMzQ3NDkxYWVhYWRjYTVkZTFmYzFkYjU2ODAzMDAyN2E4ZTI1IiwidGFnIjoiIn0%3D; expires=Sun, 20-Apr-2025 06:45:26 GMT; path=/; httponlylaravel_session=eyJpdiI6IlhReFRWNGNVU2ZIeUpCM3pTMFdHZUE9PSIsInZhbHVlIjoiYnRYWUJuUmdDZXM3WUZHNHdHT0dmQWtxV1JhKzJmN3FjOXBRTjBveXV1MnFyMzNvOWUvTkhkcyttMm5wUStUYWFn" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "9IeQhw3ePk3fvwDhnRJukhwuOGLAkXTnVqpWu3qJ" "_previous" => array:1 [ "url" => "https://pingjob.com/database-administration-with-marklogic" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-20 04:45:26GET/database-administration-with-marklogic311140