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

www.Convoso.com

Messages Timeline Exceptions Views3 Route Queries10 Models140 Mails Gate Session Request

Request history8.1.323.48s695MBGET {slug}

Booting (2.94s)time
Application (543ms)time
1 x Booting (84.4%)
2.94s
1 x Application (15.6%)
543ms

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 executed217ms

JobController.php#484clientfyi_final22.76msselect * 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_final94.26msselect `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_final630μ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_final460μs

select 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_final410μs

select (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_final8.32msselect 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_final450μs

select * 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_final730μ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_final42.8ms

SELECT 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_final45.81ms

SELECT 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: sTjogqXS4XQeAulX0anYIEijxiCvWyLRaRPfZqn4
_previous: array:1 [ "url" => "https://pingjob.com/mysql-dba-architect" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/mysql-dba-architect

status_code

status_text

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.19.188.198"
  ]
  "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 => "92caa4a6fef8870a-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.19.188.198"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.131.118"
  ]
  "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 => "Mon, 07 Apr 2025 15:43:56 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkR1OHlvUCtvWHZWcHJ0U0RyYlhwUEE9PSIsInZhbHVlIjoidkZtVXZNT0Y3eGZ5ejM3d3ptcXlKYnRRditJMGRTNTdiQ0lTaHEvVTFsWjBweTFOY0JVSitMTmRXazF3T1dXc1JQaVpRekhHU2wvL01NQkxxZmQ0UmdNUG56bzczaEdFYUpqR1A2dkZRWjhuNU9qby9mV09qNlFrd1JjWCtxUmgiLCJtYWMiOiI4YmY5NmZhMTAwYjZmOTQ1YzZkZjQ4ZGFjYzRmYjY3YjM4MTg2OWMwYzY4N2E2ZmUyM2U5ZDdiNThhZGE2ZWQ4IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 17:43:56 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkR1OHlvUCtvWHZWcHJ0U0RyYlhwUEE9PSIsInZhbHVlIjoidkZtVXZNT0Y3eGZ5ejM3d3ptcXlKYnRRditJMGRTNTdiQ0lTaHEvVTFsWjBweTFOY0JVSitMTmRXazF3T1dXc1JQaVpRe ▶"
    1 => "laravel_session=eyJpdiI6ImZXZFpmUTYwYU9rNzl6UWUxa2lMZ1E9PSIsInZhbHVlIjoiWXVVRU9CUW5wTXZZRTgrbXVGazc0M0ZPaDBSM3IySW5FU3V4bkNwci9zcTJkWjhWczhFREdvVzZWdDl2cHBpdk12c0xIV0lybHk4RDZGVFlPbmd0Vzh1YmdkUlJjeGw1VGRSYVJMS2syM2dHMGNQMHNIeGt3OFZkVi9LdVN5U3oiLCJtYWMiOiJjZWE1MDAyYjI2ZWNkZjljZDQzODFmZDY5NDBkMDc1N2Q3Mzk1MjZiNTU4NjA2ZjdlYmMzZWNiMjc3NWFiNzM1IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 17:43:56 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImZXZFpmUTYwYU9rNzl6UWUxa2lMZ1E9PSIsInZhbHVlIjoiWXVVRU9CUW5wTXZZRTgrbXVGazc0M0ZPaDBSM3IySW5FU3V4bkNwci9zcTJkWjhWczhFREdvVzZWdDl2cHBpdk12 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkR1OHlvUCtvWHZWcHJ0U0RyYlhwUEE9PSIsInZhbHVlIjoidkZtVXZNT0Y3eGZ5ejM3d3ptcXlKYnRRditJMGRTNTdiQ0lTaHEvVTFsWjBweTFOY0JVSitMTmRXazF3T1dXc1JQaVpRekhHU2wvL01NQkxxZmQ0UmdNUG56bzczaEdFYUpqR1A2dkZRWjhuNU9qby9mV09qNlFrd1JjWCtxUmgiLCJtYWMiOiI4YmY5NmZhMTAwYjZmOTQ1YzZkZjQ4ZGFjYzRmYjY3YjM4MTg2OWMwYzY4N2E2ZmUyM2U5ZDdiNThhZGE2ZWQ4IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 17:43:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkR1OHlvUCtvWHZWcHJ0U0RyYlhwUEE9PSIsInZhbHVlIjoidkZtVXZNT0Y3eGZ5ejM3d3ptcXlKYnRRditJMGRTNTdiQ0lTaHEvVTFsWjBweTFOY0JVSitMTmRXazF3T1dXc1JQaVpRe ▶"
    1 => "laravel_session=eyJpdiI6ImZXZFpmUTYwYU9rNzl6UWUxa2lMZ1E9PSIsInZhbHVlIjoiWXVVRU9CUW5wTXZZRTgrbXVGazc0M0ZPaDBSM3IySW5FU3V4bkNwci9zcTJkWjhWczhFREdvVzZWdDl2cHBpdk12c0xIV0lybHk4RDZGVFlPbmd0Vzh1YmdkUlJjeGw1VGRSYVJMS2syM2dHMGNQMHNIeGt3OFZkVi9LdVN5U3oiLCJtYWMiOiJjZWE1MDAyYjI2ZWNkZjljZDQzODFmZDY5NDBkMDc1N2Q3Mzk1MjZiNTU4NjA2ZjdlYmMzZWNiMjc3NWFiNzM1IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 17:43:56 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImZXZFpmUTYwYU9rNzl6UWUxa2lMZ1E9PSIsInZhbHVlIjoiWXVVRU9CUW5wTXZZRTgrbXVGazc0M0ZPaDBSM3IySW5FU3V4bkNwci9zcTJkWjhWczhFREdvVzZWdDl2cHBpdk12 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "sTjogqXS4XQeAulX0anYIEijxiCvWyLRaRPfZqn4"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/mysql-dba-architect"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 15:43:56	GET	/mysql-dba-architect	3 10 140

MYSQL DBA Architect

Convoso

MYSQL DBA Architect (Contract)

MYSQL DBA Architect

Description

Responsibilities

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Job Summary

Convoso

Jobs by States

Jobs by City

1 x Booting (84.4%)	2.94s
1 x Application (15.6%)	543ms