MYSQL DBA Architect

Convoso

Contract Woodland Hills, California, United States Posted 3 months ago

 Write a Review Add Vendor   Add Contact  

About Position

MYSQL DBA Architect (Contract)

$0.00 / Hourly

Woodland Hills, California, United States

MYSQL DBA Architect

Contract Woodland Hills, California, United States Posted 3 months ago

Description

Minimum 3 years experience configuring and supporting MySQL/MariaDB database management and data modeling. Databases running in Linux environments first, with strong domain knowledge.

Solid database concepts and database design knowledge (ACID, abstraction levels, schemas and constraints, stored procedures, replication, etc.)

Strong troubleshooting skill in database performance analysis and improvements.

Good knowledge of storage, networking, and other systems directly impacting database performance.

Solid experience in the administration and performance tuning of database-related tools and environments.

Experience with monitoring systems like Grafana, Prometheus, Zabbix, etc.

Experience with planning, executing, and managing large - scale system deployments, ensuring high availability and performance.

Skilled in system scripting and automation to streamline deployment processes and operational tasks, utilizing tools such as Ansible, Chef, Terraform, etc.

Solid scripting skills (e.g., Python, Ruby, Bash, Perl, etc)

Proven working experience in configuring and troubleshooting UNIX/Linux-based environments.

Strong work ethic and communication skills both spoken & written

Flexibility to work a variety of shifts with availability to work overtime

BS/MS degree in Computer Science, Engineering or a related subject.

Responsibilities
  • Maintain and support the current MYSQL/InnoDB & Redis /KeyDB database, including the creation of new DB's, migrations, backups, and replications.
  • Design, plan and deploy database schemas.
  • Review the existing databases and provide recommendations and drive the implementation to fine-tune and growth-proof the performance and scalability of our databases, including multi-sites replication.
  • Ensure that data is properly backed up and consistent.
  • Defines customers’ needs and functionality in a service development cycle.
  • Provide and communicate the best practices and specific detailed information for database management, including present and future capacity requirements.
  • Provide documentation as required to ensure accurate and current information is available for each database schema, relationships, performance bottleneck, and data flows.
  • Assists in the coordination of various teams testing and evaluating for the development of design and its implementation including database tools and software selection, including present and future capacity requirements.
  • Ensures the highest level of database and systems availability, stability and scalability.
  • Implements warranty and support activities.
  • Plans and implements system automation as required for better efficiency.
  • Oversees the development of customized software and hardware requirements.
  • Willing to stay up-to-date with security best practices and drive implementation accordingly
  • Collaborates with other professionals to ensure high-quality deliverables within organization guidelines, policies, and procedures.
  • Run diagnostics to resolve customer-reported issues
  • Deals with work process, optimization methods, and risk management tools in the given projects for successful accomplishments according to the requirements of the stakeholders.

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

Job Summary

Contract

Woodland Hills, California, United States

Experience Level : Medium

Only Any

Posted : 3 months ago

Deadline : December 31, 2024 3 months ago

Job ID : 832908SHBZ2ZO

Convoso

22837 Ventura Blvd. Suite 300

1

www.Convoso.com

Request history8.1.32PHP Version2.03sRequest Duration694MBMemory UsageGET {slug}Route
    • Booting (1.76s)time
    • Application (269ms)time
    • 1 x Booting (86.77%)
      1.76s
      1 x Application (13.23%)
      269ms
      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
      10 statements were executed199ms
      • JobController.php#484clientfyi_final25.13msselect * from `jobs` where `job_slug` = 'mysql-dba-architect' limit 1
        Bindings
        • 0: mysql-dba-architect
        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_final69.86msselect `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_final760μsselect * from `users` where `users`.`id` = 88800 limit 1
        Bindings
        • 0: 88800
        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_final500μ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` = 88800
        Bindings
        • 0: 1
        • 1: 88800
        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_final370μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 88800
        Bindings
        • 0: 1
        • 1: 88800
        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.33msselect DISTINCT email from `job_applications` where `category_id` = 165 and `status` = 1
        Bindings
        • 0: 165
        • 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_final440μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 83290 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 83290
        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.87msSELECT 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_final43.61msSELECT 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
          Ml60GLFkfQLB7314M1UMslonNJ1E6oHhdGmwJG5U
          _previous
          array:1 [ "url" => "https://pingjob.com/mysql-dba-architect" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /mysql-dba-architect
          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.137.184.154" ] "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 => "92a98882581789f7-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.137.184.154" ] "x-real-ip" => array:1 [ 0 => "108.162.216.168" ] "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 => "Thu, 03 Apr 2025 15:17:32 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlNlRERJRUwwN0xvZzkvV3Z0V2ZzT0E9PSIsInZhbHVlIjoiZDN5d1VQQU9UUTBGejN1a3VNOUFXcVRKZDJ0clBMOGI5TUVaenJ4cmFzSmZsYXpqakFLUDhiRy9rRnJGcUJheDRtVXRzenI3TmlvbTVMbHp3a3Q0YTlObFJGalg5dm8vWmYxWmZXOGVzMkRmSWxWY2EzanNhUWRuSC9FWnlJZFYiLCJtYWMiOiI5NDQwZGRlMzFiNDY1NjRhNTg4MDA1ZjdlM2Q5YTlmNjIwYTcwMTRkZGFlMjc3NTk0YzIyMDMzNDNhOThkNTY4IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 17:17:32 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlNlRERJRUwwN0xvZzkvV3Z0V2ZzT0E9PSIsInZhbHVlIjoiZDN5d1VQQU9UUTBGejN1a3VNOUFXcVRKZDJ0clBMOGI5TUVaenJ4cmFzSmZsYXpqakFLUDhiRy9rRnJGcUJheDRtVXRze" 1 => "laravel_session=eyJpdiI6ImFta1hZQU1XM1k3UWRVazh5UHFmd0E9PSIsInZhbHVlIjoiNXlNMVhqcVk2bmVGcHRkTXF1SGwyenlwZU8wMWtBV2lKMVdIVkhTbEpOL0ltYXU5NmplcWNwcHVFalZkdkE1aG5GNi9jL1pmMUpzWThMTWJmYlRGVVFlR2h4RU5iWkFZZ09JeUJFL1l6SlhseStUSCs5cG1sY1lQRXFkenEzLzEiLCJtYWMiOiIzNzBmYmM0Nzk1ZDQxYzA3M2M4M2JhYzJjMjc3ZjdiZjA1ZTYxNTI5Mzc3MGUwMGE4NzM4ZTc0Njk0YzYyMjA3IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 17:17:32 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6ImFta1hZQU1XM1k3UWRVazh5UHFmd0E9PSIsInZhbHVlIjoiNXlNMVhqcVk2bmVGcHRkTXF1SGwyenlwZU8wMWtBV2lKMVdIVkhTbEpOL0ltYXU5NmplcWNwcHVFalZkdkE1aG5G" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlNlRERJRUwwN0xvZzkvV3Z0V2ZzT0E9PSIsInZhbHVlIjoiZDN5d1VQQU9UUTBGejN1a3VNOUFXcVRKZDJ0clBMOGI5TUVaenJ4cmFzSmZsYXpqakFLUDhiRy9rRnJGcUJheDRtVXRzenI3TmlvbTVMbHp3a3Q0YTlObFJGalg5dm8vWmYxWmZXOGVzMkRmSWxWY2EzanNhUWRuSC9FWnlJZFYiLCJtYWMiOiI5NDQwZGRlMzFiNDY1NjRhNTg4MDA1ZjdlM2Q5YTlmNjIwYTcwMTRkZGFlMjc3NTk0YzIyMDMzNDNhOThkNTY4IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 17:17:32 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlNlRERJRUwwN0xvZzkvV3Z0V2ZzT0E9PSIsInZhbHVlIjoiZDN5d1VQQU9UUTBGejN1a3VNOUFXcVRKZDJ0clBMOGI5TUVaenJ4cmFzSmZsYXpqakFLUDhiRy9rRnJGcUJheDRtVXRze" 1 => "laravel_session=eyJpdiI6ImFta1hZQU1XM1k3UWRVazh5UHFmd0E9PSIsInZhbHVlIjoiNXlNMVhqcVk2bmVGcHRkTXF1SGwyenlwZU8wMWtBV2lKMVdIVkhTbEpOL0ltYXU5NmplcWNwcHVFalZkdkE1aG5GNi9jL1pmMUpzWThMTWJmYlRGVVFlR2h4RU5iWkFZZ09JeUJFL1l6SlhseStUSCs5cG1sY1lQRXFkenEzLzEiLCJtYWMiOiIzNzBmYmM0Nzk1ZDQxYzA3M2M4M2JhYzJjMjc3ZjdiZjA1ZTYxNTI5Mzc3MGUwMGE4NzM4ZTc0Njk0YzYyMjA3IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 17:17:32 GMT; path=/; httponlylaravel_session=eyJpdiI6ImFta1hZQU1XM1k3UWRVazh5UHFmd0E9PSIsInZhbHVlIjoiNXlNMVhqcVk2bmVGcHRkTXF1SGwyenlwZU8wMWtBV2lKMVdIVkhTbEpOL0ltYXU5NmplcWNwcHVFalZkdkE1aG5G" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "Ml60GLFkfQLB7314M1UMslonNJ1E6oHhdGmwJG5U" "_previous" => array:1 [ "url" => "https://pingjob.com/mysql-dba-architect" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-03 15:17:32GET/mysql-dba-architect310140