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

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries10Models140MailsGateSessionRequest
Request history8.1.32PHP Version4.76sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (4.02s)time
    • Application (737ms)time
    • 1 x Booting (84.51%)
      4.02s
      1 x Application (15.49%)
      737ms
      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 executed384ms
      • JobController.php#484clientfyi_final69.41msselect * 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_final114msselect `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_final770μ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_final15.98msselect 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_final25.07msselect 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_final1.24msselect * 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_final930μ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_final59.78msSELECT 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_final96.58msSELECT 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
          Dru3Lx55xypTderfnhsRffrJkn5VybDIox3KMtZn
          _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.143.254.10"
  ]
  "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 => "92bb4e6de8970bf0-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.143.254.10"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.127.51"
  ]
  "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 => "Sat, 05 Apr 2025 19:03:39 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjNPTDlPY2N5a3ZWZC9YL2ZRUElMNEE9PSIsInZhbHVlIjoiWVR6cnNiZGcxQVFid3JoVWNNUTVjWFZSSWFDaW5qWWVtSFQ5TWxrOWxYN0hReE1sWGkxRUlPcFhINk5PL2Y2ZWx5c2c1azJ4aHhZOXU3dXptZUk2Vk5VVjRkai9zZUEvY3I1T2Z0eXFLbENwMmtGS0MzbEQ5ZytNdUVQSkdBRy8iLCJtYWMiOiI5ZjEyNGZiOWE4NGJmZDE5Mzc2MWYzYTk2ZjAzMTY2MTQ4ZjI4ZjQ4ZWVkYmRmOTZmYTFiMzUzZDU4YzRiMzM4IiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 21:03:40 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjNPTDlPY2N5a3ZWZC9YL2ZRUElMNEE9PSIsInZhbHVlIjoiWVR6cnNiZGcxQVFid3JoVWNNUTVjWFZSSWFDaW5qWWVtSFQ5TWxrOWxYN0hReE1sWGkxRUlPcFhINk5PL2Y2ZWx5c2c1a ▶"
    1 => "laravel_session=eyJpdiI6ImJiWFZRemF2T1VsT0F3bE0yMjBYN3c9PSIsInZhbHVlIjoiamF2c1ZyRzhWai9GbFFydG9PbHBscS9DWGNNVUFqUitEczZSb0tpWWtXQUNma1JJdzRsNjlSRnV3c2ovVmxNMEI0UU5rSmhmUW95T0JKUzZrTXhZbGhNU1djc2gyUWNSTVhhMkFlc0xIa3hnQnBYSWhvRHlsTENRRWxxamE4dlEiLCJtYWMiOiI1ZmMwZjUyN2NmNjhiMmMyYzI3NTE5ZTlhZmE4NmM5ZmZiOTMwYWUwYzcyNGJhMzczOTAzOTk1NGZhMzJmMjJhIiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 21:03:40 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImJiWFZRemF2T1VsT0F3bE0yMjBYN3c9PSIsInZhbHVlIjoiamF2c1ZyRzhWai9GbFFydG9PbHBscS9DWGNNVUFqUitEczZSb0tpWWtXQUNma1JJdzRsNjlSRnV3c2ovVmxNMEI0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjNPTDlPY2N5a3ZWZC9YL2ZRUElMNEE9PSIsInZhbHVlIjoiWVR6cnNiZGcxQVFid3JoVWNNUTVjWFZSSWFDaW5qWWVtSFQ5TWxrOWxYN0hReE1sWGkxRUlPcFhINk5PL2Y2ZWx5c2c1azJ4aHhZOXU3dXptZUk2Vk5VVjRkai9zZUEvY3I1T2Z0eXFLbENwMmtGS0MzbEQ5ZytNdUVQSkdBRy8iLCJtYWMiOiI5ZjEyNGZiOWE4NGJmZDE5Mzc2MWYzYTk2ZjAzMTY2MTQ4ZjI4ZjQ4ZWVkYmRmOTZmYTFiMzUzZDU4YzRiMzM4IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 21:03:40 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjNPTDlPY2N5a3ZWZC9YL2ZRUElMNEE9PSIsInZhbHVlIjoiWVR6cnNiZGcxQVFid3JoVWNNUTVjWFZSSWFDaW5qWWVtSFQ5TWxrOWxYN0hReE1sWGkxRUlPcFhINk5PL2Y2ZWx5c2c1a ▶"
    1 => "laravel_session=eyJpdiI6ImJiWFZRemF2T1VsT0F3bE0yMjBYN3c9PSIsInZhbHVlIjoiamF2c1ZyRzhWai9GbFFydG9PbHBscS9DWGNNVUFqUitEczZSb0tpWWtXQUNma1JJdzRsNjlSRnV3c2ovVmxNMEI0UU5rSmhmUW95T0JKUzZrTXhZbGhNU1djc2gyUWNSTVhhMkFlc0xIa3hnQnBYSWhvRHlsTENRRWxxamE4dlEiLCJtYWMiOiI1ZmMwZjUyN2NmNjhiMmMyYzI3NTE5ZTlhZmE4NmM5ZmZiOTMwYWUwYzcyNGJhMzczOTAzOTk1NGZhMzJmMjJhIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 21:03:40 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImJiWFZRemF2T1VsT0F3bE0yMjBYN3c9PSIsInZhbHVlIjoiamF2c1ZyRzhWai9GbFFydG9PbHBscS9DWGNNVUFqUitEczZSb0tpWWtXQUNma1JJdzRsNjlSRnV3c2ovVmxNMEI0 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "Dru3Lx55xypTderfnhsRffrJkn5VybDIox3KMtZn"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/mysql-dba-architect"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-05 19:03:40GET/mysql-dba-architect310140