Teradata DBA

MGM Resorts International

Full Time Las Vegas, Nevada, United States Posted 2 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Teradata DBA (Full Time)

$0.00 / Hourly

Las Vegas, Nevada, United States

Teradata DBA

Full Time Las Vegas, Nevada, United States Posted 2 years ago

Description

Required Skills : Teradata DBA, BTEQ, TPT, Tpump, Fastload, Multiload and other utilities
Ability and knowledge with relational database and data storage concepts.
Knowledge of Teradata Tools and Utilities like BTEQ, TPT, Tpump, FastLoad, MultiLoad and exposure to Teradata Utilities.
Good working knowledge on UNIX shell scripting.
Knowledge of Teradata, Microsoft SQL Server or Oracle.
Knowledge of Microsoft Transact?SQL, PL/SQL, or Teradata SQL.
Knowledge of Microsoft SQL Server Management Studio 2012/2014/2016 and above, Oracle 11g/12c, or Teradata Studio.
Knowledge of Microsoft Windows Server 2012 and above, UNIX, Oracle Exadata, or AIX.

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

MGM Resorts International Vendors

( Login to see all the 3 vendors)
Wipro Technologies
Write a Review

1300 Crittenden Lane
Mountain View
California
www.wipro.com ( 61 vendors)

Cognizant Technology Solutions Corporation
Write a Review

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

Apex Systems Inc
Write a Review

4400 Cox Road
Glen Allen
Virginia
www.ApexSystemsInc.com ( 9 vendors)

Job Summary

Full Time

Las Vegas, Nevada, United States

Experience Level : Medium

Only Any

Posted : 2 years ago

Deadline : November 1, 2022 2 years ago

Job ID : 814322SJQUACK

MGM Resorts International

3600 Las Vegas Blvd. South

www.mgmresorts.com

Request history8.1.31PHP Version2.24sRequest Duration688MBMemory UsageGET {slug}Route
    • Booting (1.97s)time
    • Application (262ms)time
    • 1 x Booting (88.27%)
      1.97s
      1 x Application (11.73%)
      262ms
      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 executed194ms
      • JobController.php#484clientfyi_final25.33msselect * from `jobs` where `job_slug` = 'teradata-dba' limit 1
        Bindings
        • 0: teradata-dba
        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_final68.65msselect `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_final600μsselect * from `users` where `users`.`id` = 51848 limit 1
        Bindings
        • 0: 51848
        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_final550μ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` = 51848
        Bindings
        • 0: 1
        • 1: 51848
        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.01msselect `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` = 51848 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 51848
        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_final310μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 51848
        Bindings
        • 0: 1
        • 1: 51848
        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.56msselect DISTINCT email from `job_applications` where `category_id` = 142 and `status` = 1
        Bindings
        • 0: 142
        • 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_final390μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 81432 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 81432
        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_final850μ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_final46.17msSELECT 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.89msSELECT 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
          zwEQSwwMuyLGKfEgo2G8CZoSmHlOxUa3xWxIA8zA
          _previous
          array:1 [ "url" => "https://pingjob.com/teradata-dba" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /teradata-dba
          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.118.171.28" ] "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 => "91914eceffa98131-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "18.118.171.28" ] "x-real-ip" => array:1 [ 0 => "172.70.130.175" ] "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, 28 Feb 2025 15:04:36 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InM0UVJoWjlVQTNkSlh5Q0s5VzRGQmc9PSIsInZhbHVlIjoic1NrN0p1YWxEWCtVTVVtWll6NEhIU2VBVEQ5WXFsQmJtZG9GTklaOEZId0cvS3V4bmdLR3lhaUw4N2ZZUFp5N3NPNXNYMWdQbXRQZTVoNnQzcUZvMmc2RHBWZXhxblFBQTJqcUk4S2xBdFlxWDR1ajZkczZscEdxVFJxOUgzVXgiLCJtYWMiOiI3ODVhZGU2ZmRhNjJmZmYzMjBkYzA2YjYxNGMxNWMwYjI0MmY3MDgxOGZmZDUxM2U1MDM3ODc4ODFmYWI3N2IzIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 17:04:36 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InM0UVJoWjlVQTNkSlh5Q0s5VzRGQmc9PSIsInZhbHVlIjoic1NrN0p1YWxEWCtVTVVtWll6NEhIU2VBVEQ5WXFsQmJtZG9GTklaOEZId0cvS3V4bmdLR3lhaUw4N2ZZUFp5N3NPNXNYM" 1 => "laravel_session=eyJpdiI6IjI0SmVOOHhNNkw4V1ZIb0RUUFFEaWc9PSIsInZhbHVlIjoiRTJMNURWYWpSSWlrTndzc2VBL1lGSVBlMDJRSVY4ZGZrUXQ2eTNhMXFnWWp1SlphQXJCYVZXbDNSdkJMVlJ5OVlUd1FWbEFTWC9UWGhJZWhWR0V3NjYxTnNrbVZYbzJoeVlXRllhNEdmZUt0ZlZSTWFhaHNCc3NLZXFoMDdSR1MiLCJtYWMiOiIwZjZlY2FkNjJiZGM5Njc0Mjc1MWRkODBhNTdlNTVmNDllZmM5MjJiYjhkNGY3M2ZlZTMyYjczMTQwNWJiNzZhIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 17:04:36 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IjI0SmVOOHhNNkw4V1ZIb0RUUFFEaWc9PSIsInZhbHVlIjoiRTJMNURWYWpSSWlrTndzc2VBL1lGSVBlMDJRSVY4ZGZrUXQ2eTNhMXFnWWp1SlphQXJCYVZXbDNSdkJMVlJ5OVlU" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InM0UVJoWjlVQTNkSlh5Q0s5VzRGQmc9PSIsInZhbHVlIjoic1NrN0p1YWxEWCtVTVVtWll6NEhIU2VBVEQ5WXFsQmJtZG9GTklaOEZId0cvS3V4bmdLR3lhaUw4N2ZZUFp5N3NPNXNYMWdQbXRQZTVoNnQzcUZvMmc2RHBWZXhxblFBQTJqcUk4S2xBdFlxWDR1ajZkczZscEdxVFJxOUgzVXgiLCJtYWMiOiI3ODVhZGU2ZmRhNjJmZmYzMjBkYzA2YjYxNGMxNWMwYjI0MmY3MDgxOGZmZDUxM2U1MDM3ODc4ODFmYWI3N2IzIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 17:04:36 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InM0UVJoWjlVQTNkSlh5Q0s5VzRGQmc9PSIsInZhbHVlIjoic1NrN0p1YWxEWCtVTVVtWll6NEhIU2VBVEQ5WXFsQmJtZG9GTklaOEZId0cvS3V4bmdLR3lhaUw4N2ZZUFp5N3NPNXNYM" 1 => "laravel_session=eyJpdiI6IjI0SmVOOHhNNkw4V1ZIb0RUUFFEaWc9PSIsInZhbHVlIjoiRTJMNURWYWpSSWlrTndzc2VBL1lGSVBlMDJRSVY4ZGZrUXQ2eTNhMXFnWWp1SlphQXJCYVZXbDNSdkJMVlJ5OVlUd1FWbEFTWC9UWGhJZWhWR0V3NjYxTnNrbVZYbzJoeVlXRllhNEdmZUt0ZlZSTWFhaHNCc3NLZXFoMDdSR1MiLCJtYWMiOiIwZjZlY2FkNjJiZGM5Njc0Mjc1MWRkODBhNTdlNTVmNDllZmM5MjJiYjhkNGY3M2ZlZTMyYjczMTQwNWJiNzZhIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 17:04:36 GMT; path=/; httponlylaravel_session=eyJpdiI6IjI0SmVOOHhNNkw4V1ZIb0RUUFFEaWc9PSIsInZhbHVlIjoiRTJMNURWYWpSSWlrTndzc2VBL1lGSVBlMDJRSVY4ZGZrUXQ2eTNhMXFnWWp1SlphQXJCYVZXbDNSdkJMVlJ5OVlU" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "zwEQSwwMuyLGKfEgo2G8CZoSmHlOxUa3xWxIA8zA" "_previous" => array:1 [ "url" => "https://pingjob.com/teradata-dba" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-02-28 15:04:36GET/teradata-dba311140