SingleStore DBA

Apple Computer Inc

Contract Austin , Texas, United States Posted 3 months ago

 Write a Review Add Vendor   Add Contact  

About Position

SingleStore DBA (Contract)

$75.00 / Hourly

Austin , Texas, United States

SingleStore DBA

Contract Austin , Texas, United States Posted 3 months ago

Skills
Bachelor’s degree in Computer Science Information Technology or a related field. Proven experience as a Database Administrator specifically with SingleStore. Strong proficiency in Python programming with experience in writing scripts for database management and automation. In-depth knowledge of database performance tuning query optimization and troubleshooting. Experience with database backup and recovery procedures. Familiarity with database security best practices. Excellent problem solving skills and attention to detail. Strong communication and collaboration skills. Ability to work independently and manage multiple tasks effectively. Experience with other RDBMS database systems (e.g. Vertica MySQL Oracle). Familiarity with cloud-based database solutions and infrastructure (e.g. AWS). Experience with managing Distributed databases. Experience with DevOps tools and practices. Knowledge of data warehousing and ETL processes.
Description

We are looking for SingleStore DBA with Python Programming. You will be responsible for managing and maintaining our SingleStore database environment. This includes database performance tuning, monitoring, backup and recovery, and ensuring data integrity and security. The ideal candidate will have a solid background in database administration, particularly with SingleStore, and will use their Python programming skills to develop scripts and tools to automate routine tasks and improve database efficiency.

Responsibilities
  • Install, configure, and maintain SingleStore database systems.
  • Monitor database performance, implement performance tuning, and optimize queries.
  • Ensure high availability and disaster recovery of database systems.
  • Develop, test, and deploy backup and recovery plans.
  • Implement and maintain database security policies and procedures.
  • Create and maintain database documentation, including data models, schemas, and procedures.
  • Develop Python scripts to automate database management
  • tasks and enhance operational efficiency.
  • Troubleshoot and resolve database-related issues and provide support to development teams.
  • Collaborate with other IT professionals and stakeholders to ensure seamless integration of database systems with other applications.
  • Stay updated with the latest industry trends and best practices in database management and Python programming.

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

Apple Computer Inc Vendors

( Login to see all the 12 vendors)
Cognizant Technology Solutions Corporation
Write a Review

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

Tech Mahindra (Americas) Inc
Write a Review

2140 Lake Park Boulevard Suite 920
Richardson
Texas
www.techmahindra.com ( 45 vendors)

Tata Consultancy Services
Write a Review

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

Job Summary

$75.00 / Hourly

Contract

Austin , Texas, United States

Experience Level : Medium

Experience Required : 9 Year/s

Only Any

Posted : 3 months ago

Deadline : January 3, 2025 3 months ago

Job ID : Job0000012434

Apple Computer Inc

1 Infinite Loop

408-996-1010

www.apple.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.02sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (1.73s)time
    • Application (289ms)time
    • 1 x Booting (85.7%)
      1.73s
      1 x Application (14.3%)
      289ms
      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 executed216ms
      • JobController.php#484clientfyi_final9.98msselect * from `jobs` where `job_slug` = 'singlestore-dba' limit 1
        Bindings
        • 0: singlestore-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_final102msselect `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_final690μsselect * from `users` where `users`.`id` = 401 limit 1
        Bindings
        • 0: 401
        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_final610μ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` = 401
        Bindings
        • 0: 1
        • 1: 401
        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.78msselect `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` = 401 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 401
        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_final300μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 401
        Bindings
        • 0: 1
        • 1: 401
        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.66msselect DISTINCT email from `job_applications` where `category_id` = 128 and `status` = 1
        Bindings
        • 0: 128
        • 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_final450μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 12434 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 12434
        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_final840μ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_final47.52msSELECT 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.47msSELECT 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
          XxemgWXzE39kSKgcgA4mEPTeHT3IngQXhZlZCIuw
          _previous
          array:1 [ "url" => "https://pingjob.com/singlestore-dba" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /singlestore-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: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.133.141.166"
  ]
  "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 => "Tue, 22 Apr 2025 01:14:20 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlCWHU4YXUzN0VUVER5ZWdiWlNTblE9PSIsInZhbHVlIjoiUkYzOXlPNDRUbGVLVVBnN1ZvRHNjOTdVU2lQblg4bC9GdFZGUXIxZ3lqcExmN05xaGZBUjl6RHJvWXJ0RXlyQUYwZUpubUJnR1FtTFd6RisrMk9VbUFKaDJyQ3pnY1R4cUk5QWJHamp4WVlIbDVjZThRdElqeCttWmRYaVdabFIiLCJtYWMiOiI0MTE4NWY1NmJmOWFkNGFmOTBkNjcyM2Q0MThjNjAzYWZiZjIwYWU5Nzc3YTFjOGIyY2U1YTFlMDIxOTIxMzkxIiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 03:14:21 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjlCWHU4YXUzN0VUVER5ZWdiWlNTblE9PSIsInZhbHVlIjoiUkYzOXlPNDRUbGVLVVBnN1ZvRHNjOTdVU2lQblg4bC9GdFZGUXIxZ3lqcExmN05xaGZBUjl6RHJvWXJ0RXlyQUYwZUpub ▶"
    1 => "laravel_session=eyJpdiI6IkV2Rkt3KzAzWVJDaDNYUzRBRy9qWnc9PSIsInZhbHVlIjoiaTlYcUl6MWFXdFNxZjgvYWR4d3BNcU5JZ0VPYXBvK0VCY2ExVkRZeEthRy9taWl3T2ZibU1PSmRibVM2MXY3WHd3cEtjS2wrQ2FySTN0YUh3ZHFsYzdwOG5lbHFYNThhbDJIYVI4WC9NajhMT1lvQllSbmxMS1ROcGRTYnU5VlEiLCJtYWMiOiI5MmM1ZGU5MWQ5MTJhNDNkMmIyOGE0ODdmZGYyMzIwOTI2MzY4ZjA3NTcxOGMzMzIwZmMxOTZlMmRiZGJmMjRjIiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 03:14:21 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkV2Rkt3KzAzWVJDaDNYUzRBRy9qWnc9PSIsInZhbHVlIjoiaTlYcUl6MWFXdFNxZjgvYWR4d3BNcU5JZ0VPYXBvK0VCY2ExVkRZeEthRy9taWl3T2ZibU1PSmRibVM2MXY3WHd3 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlCWHU4YXUzN0VUVER5ZWdiWlNTblE9PSIsInZhbHVlIjoiUkYzOXlPNDRUbGVLVVBnN1ZvRHNjOTdVU2lQblg4bC9GdFZGUXIxZ3lqcExmN05xaGZBUjl6RHJvWXJ0RXlyQUYwZUpubUJnR1FtTFd6RisrMk9VbUFKaDJyQ3pnY1R4cUk5QWJHamp4WVlIbDVjZThRdElqeCttWmRYaVdabFIiLCJtYWMiOiI0MTE4NWY1NmJmOWFkNGFmOTBkNjcyM2Q0MThjNjAzYWZiZjIwYWU5Nzc3YTFjOGIyY2U1YTFlMDIxOTIxMzkxIiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 03:14:21 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjlCWHU4YXUzN0VUVER5ZWdiWlNTblE9PSIsInZhbHVlIjoiUkYzOXlPNDRUbGVLVVBnN1ZvRHNjOTdVU2lQblg4bC9GdFZGUXIxZ3lqcExmN05xaGZBUjl6RHJvWXJ0RXlyQUYwZUpub ▶"
    1 => "laravel_session=eyJpdiI6IkV2Rkt3KzAzWVJDaDNYUzRBRy9qWnc9PSIsInZhbHVlIjoiaTlYcUl6MWFXdFNxZjgvYWR4d3BNcU5JZ0VPYXBvK0VCY2ExVkRZeEthRy9taWl3T2ZibU1PSmRibVM2MXY3WHd3cEtjS2wrQ2FySTN0YUh3ZHFsYzdwOG5lbHFYNThhbDJIYVI4WC9NajhMT1lvQllSbmxMS1ROcGRTYnU5VlEiLCJtYWMiOiI5MmM1ZGU5MWQ5MTJhNDNkMmIyOGE0ODdmZGYyMzIwOTI2MzY4ZjA3NTcxOGMzMzIwZmMxOTZlMmRiZGJmMjRjIiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 03:14:21 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkV2Rkt3KzAzWVJDaDNYUzRBRy9qWnc9PSIsInZhbHVlIjoiaTlYcUl6MWFXdFNxZjgvYWR4d3BNcU5JZ0VPYXBvK0VCY2ExVkRZeEthRy9taWl3T2ZibU1PSmRibVM2MXY3WHd3 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "XxemgWXzE39kSKgcgA4mEPTeHT3IngQXhZlZCIuw"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/singlestore-dba"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-22 01:14:21GET/singlestore-dba311140