Oracle DBA

Verizon Business

Contract Ashburn, Virginia, United States Posted 1 year ago

 Write a Review Add Vendor   Add Contact  

About Position

Oracle DBA (Contract)

$70.00 / Hourly

Ashburn, Virginia, United States

Oracle DBA

Contract Ashburn, Virginia, United States Posted 1 year ago

Description

Senior Oracle DBA with a minimum of 6 or more years of excellent hands-on experience to support on-premise and Cloud (OCI and AWS) with strong emphasis on Database performance tuning ,which includes: using hints, execution plans, write/re-write SQL, PL/SQL, identifying SQL regression, Resource Manager, reading various Oracle provided tools like OEM, SPA, AWR, ADDM, ASH. AWR-Diff, tracing and unix utilities like top, vmstat, sar etc.

Responsibilities
  • Ability to support Production (24X7) systems and non-prod systems
  • Ability to work efficiently in production support environment
  • Ability to attend calls during off -hours
  • Ability to provide weekly on-call support
  • Well versed in Oracle Performance Tuning (P&T) with hands-on tuning experience in production environment
  • Ability to write and review PL/SQL codes
  • Thorough understanding of RMAN Backup and Recovery process
  • Well versed in HA and DR solutions – RAC (GI, ASM), Oracle Goldengate, Physical Standby Database, ActiveDataguard
  • Well versed in Oracle Goldengate (OGG) – Active/passive (one-way), Active/Active Install, setup, config, troubleshooting, admin
  • Expert in various Database migration scenarios
  • Experience in Cloud support and migrations
  • Expert in Database installs, upgrades, and patching
  • Ability to efficiently carry out BAU (day to day) DBA responsibilities
  • Experience in Capacity Planning
  • Ability to provide technical support to application development teams, Application DB release changes, Backout process
  • Experience with Physical Database design
  • Ability to understand Application architecture
  • Pro-active and Reactive monitoring, Oracle Enterprise Manager (OEM) (Synthetic Monitoring)
  • Troubleshooting Skills (process, scripts, commands) to quickly identify and resolve issues
  • Oracle Security, Audit and security compliance
  • Understanding of Storage technologies and Networking
  • Well versed in Scripting (Shell, PL/SQL, Python)
  • Good understanding of ITIL (Release Management, Change Management, Crisis Management, etc)
  • Strong Linux/Unix skills
  • Good understanding of DevOps, DB release automation for DevOps
  • Understanding of Oracle Support process
  • Exposure to Terraform, Jenkins, Sourcetree, YAML
  • Experience with cloud automation
  • Good documentation skills
  • AWS certification is a plus
  • Cassandra DB experience is a plus

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

Verizon Business Vendors

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

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

Cognizant Technology Solutions Corporation
Write a Review

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

Brillio
Write a Review

5201 Great America Parkway
Santa Clara
California
www.brillio.com ( 24 vendors)

Job Summary

$70.00 / Hourly

Contract

Ashburn, Virginia, United States

Experience Level : Medium

Experience Required : 6 Year/s

Only Any

Posted : 1 year ago

Deadline : February 9, 2024 1 year ago

Job ID : Job0000003066

Verizon Business

140 West Street

www.verizonbusiness.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version4.33sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (3.82s)time
    • Application (514ms)time
    • 1 x Booting (88.14%)
      3.82s
      1 x Application (11.86%)
      514ms
      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 executed235ms
      • JobController.php#484clientfyi_final2.82msselect * from `jobs` where `job_slug` = 'oracle-dba-22' limit 1
        Bindings
        • 0: oracle-dba-22
        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_final108msselect `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` = 6219 limit 1
        Bindings
        • 0: 6219
        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_final720μ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` = 6219
        Bindings
        • 0: 1
        • 1: 6219
        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.41msselect `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` = 6219 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 6219
        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_final390μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 6219
        Bindings
        • 0: 1
        • 1: 6219
        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_final18.59msselect 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_final490μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 3066 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 3066
        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_final880μ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_final58.93msSELECT 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_final42.74msSELECT 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
          UfvWQ2GfIJKUoI6aPDz5JciaI8015H12babcyjtP
          _previous
          array:1 [ "url" => "https://pingjob.com/oracle-dba-22" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /oracle-dba-22
          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"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "52.14.75.150"
  ]
  "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"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "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 => "92dda92feadf630c-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "52.14.75.150"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.179.69"
  ]
  "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, 09 Apr 2025 23:07:35 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZPT2p0bG9EWFVvdFc2aldoV3daVUE9PSIsInZhbHVlIjoiZ3kva0I4Q1oyU2gzYmF5ZGxHekc2R2Y2Mm03ME9pbi9yODJDVUxDSjZxR1JWc1VpQWI0Q1lXUU5HL0ZXNVkzZ2U1bHR2RWdXY0RnMGRmejFvdDNaMXZwQjJrUjVDMDdmNUlGT09SWVpGcWpManBpcmViZTYySmM4ZW5rQTdhSUoiLCJtYWMiOiI1OTcwNmQzMmYyZTBiZGM1YTUxNmU1ZmY0NTFmYzU4MGU5Mjg3YjEwYjFlNDhlMmJhOGI4N2VjMDQzOWM5YjRmIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 01:07:35 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlZPT2p0bG9EWFVvdFc2aldoV3daVUE9PSIsInZhbHVlIjoiZ3kva0I4Q1oyU2gzYmF5ZGxHekc2R2Y2Mm03ME9pbi9yODJDVUxDSjZxR1JWc1VpQWI0Q1lXUU5HL0ZXNVkzZ2U1bHR2R ▶"
    1 => "laravel_session=eyJpdiI6IlBMR3N4WUg2a2pCR2tReEFXbXJZREE9PSIsInZhbHVlIjoiODRxY2JEeEYyRERBY0sxaDR4eG5hT2FnTE9iN2FCQ3BpYmNnN3VSU21FSldxNHZWSXV6QkFTN21SZE5hNFV6cCs5MXFCYTRzTkw2aklpMzJUSzE1a2lCOHJzQWZ6bXM4dmZwSE9BNkVYMjM5eTBDd2twK3BabDlEVjN0b2M2UUUiLCJtYWMiOiJkNjgyYjc4YmJmZTE0YmNkNDRiNTExNjk0ZGY5NWJlN2RhMTEyMmU3ZjNjZmY1NTEzN2JjYzQ4ZDAxYWY3Y2FiIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 01:07:35 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlBMR3N4WUg2a2pCR2tReEFXbXJZREE9PSIsInZhbHVlIjoiODRxY2JEeEYyRERBY0sxaDR4eG5hT2FnTE9iN2FCQ3BpYmNnN3VSU21FSldxNHZWSXV6QkFTN21SZE5hNFV6cCs5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZPT2p0bG9EWFVvdFc2aldoV3daVUE9PSIsInZhbHVlIjoiZ3kva0I4Q1oyU2gzYmF5ZGxHekc2R2Y2Mm03ME9pbi9yODJDVUxDSjZxR1JWc1VpQWI0Q1lXUU5HL0ZXNVkzZ2U1bHR2RWdXY0RnMGRmejFvdDNaMXZwQjJrUjVDMDdmNUlGT09SWVpGcWpManBpcmViZTYySmM4ZW5rQTdhSUoiLCJtYWMiOiI1OTcwNmQzMmYyZTBiZGM1YTUxNmU1ZmY0NTFmYzU4MGU5Mjg3YjEwYjFlNDhlMmJhOGI4N2VjMDQzOWM5YjRmIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 01:07:35 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlZPT2p0bG9EWFVvdFc2aldoV3daVUE9PSIsInZhbHVlIjoiZ3kva0I4Q1oyU2gzYmF5ZGxHekc2R2Y2Mm03ME9pbi9yODJDVUxDSjZxR1JWc1VpQWI0Q1lXUU5HL0ZXNVkzZ2U1bHR2R ▶"
    1 => "laravel_session=eyJpdiI6IlBMR3N4WUg2a2pCR2tReEFXbXJZREE9PSIsInZhbHVlIjoiODRxY2JEeEYyRERBY0sxaDR4eG5hT2FnTE9iN2FCQ3BpYmNnN3VSU21FSldxNHZWSXV6QkFTN21SZE5hNFV6cCs5MXFCYTRzTkw2aklpMzJUSzE1a2lCOHJzQWZ6bXM4dmZwSE9BNkVYMjM5eTBDd2twK3BabDlEVjN0b2M2UUUiLCJtYWMiOiJkNjgyYjc4YmJmZTE0YmNkNDRiNTExNjk0ZGY5NWJlN2RhMTEyMmU3ZjNjZmY1NTEzN2JjYzQ4ZDAxYWY3Y2FiIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 01:07:35 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlBMR3N4WUg2a2pCR2tReEFXbXJZREE9PSIsInZhbHVlIjoiODRxY2JEeEYyRERBY0sxaDR4eG5hT2FnTE9iN2FCQ3BpYmNnN3VSU21FSldxNHZWSXV6QkFTN21SZE5hNFV6cCs5 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "UfvWQ2GfIJKUoI6aPDz5JciaI8015H12babcyjtP"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/oracle-dba-22"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-09 23:07:35GET/oracle-dba-22311140