SQL DBA

K-Love

Contract Rocklin, California, United States Posted 4 years ago

Write a Review Add Vendor Add Contact

About Position

SQL DBA (Contract)

$45.00 / Hourly

Rocklin, California, United States

SQL DBA

Contract Rocklin, California, United States Posted 4 years ago

Description

Responsibilities
Establish targets and measures that adequately reflect ministry and project objectives. Develop, implement, and report on objectives, measures, and outcomes.
Assist in the implementation of data models and database designs, data access and table maintenance; resolve database performance issues, database capacity issues, replication and other distributed data issues.
Consult with systems analysts, programmers, and end users to gather information about database intent, functions, features, data requirements, input requirements, output requirements, internal and external checks and controls, hardware and operating system environment, and interfaces with other systems.
Design/write database specifications based on consultations with supervisor, systems analysts, programmers, and end users.
Apply database programming standards and techniques to assure efficient database operation and data integrity and security.
Provide DBA services to programming teams, writing queries, developing stored procedures, creating data reports. Works closely with Data Science team to provide these services.
Manage DB settings, configurations, replication needs across multiple DB platforms
Assist in the development of software databases to include designing, coding, testing, debugging, configuring, and documenting software. Maintain strong working relationships with team members.
Create test transactions and run tests to find errors and confirm programs meet specifications.
Analyze database code to find causes of errors and revise programs.
Proactively communicate and work with other staff to resolve technical problems.
Maintain professional competency, knowledge and skills necessary to effectively perform job duties by taking responsibility for professional development and training.
Support and contribute to a safe and healthy work environment.
Qualifications Minimum 3 years experience in SQL Server database management.
Expertise with relational database design, capacity planning, security, and other distributed data issues. Experience administering Microsoft SQL Server in a Windows clustered environment. MCDBA preferred. Experience across at least two or more of the following DB environments Microsoft .NET framework knowledge, SSIS, and Reporting Services a plus.
Demonstrated troubleshooting and analysis skills and experience. Must have proven problemsolving experience in high impact environment
Understanding of back up, disaster recovery services and the importance to an organization. Able to hold to high standards and quality.
Desire to continuously improve on services through automation, improved efficiency.
Proven ability to deal with multiple, simultaneous problems in a systematic, logical manner.

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

$45.00 / Hourly

Contract

Rocklin, California, United States

Experience Required : 8 Year/s

Posted : 4 years ago

Deadline : August 22, 2020 4 years ago

Job ID : Job0000021183

Messages Timeline Exceptions Views3 Route Queries10 Models140 Mails Gate Session Request

Request history8.1.322.39s695MBGET {slug}

Booting (2.08s)time
Application (309ms)time
1 x Booting (87.08%)
2.08s
1 x Application (12.92%)
309ms

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 executed237ms

JobController.php#484clientfyi_final19.18msselect * from `jobs` where `job_slug` = 'Job0000021183' limit 1

Bindings	0: Job0000021183
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_final101msselect `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_final700μsselect * from `users` where `users`.`id` = 74830 limit 1

Bindings	0: 74830
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` = 74830

Bindings	0: 1 1: 74830
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_final330μs

select (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 74830

Bindings	0: 1 1: 74830
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_final21.62msselect DISTINCT email from `job_applications` where `category_id` = 63 and `status` = 1

Bindings	0: 63 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_final520μs

select * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 21183 and `comments`.`commentable_id` is not null and `parent_id` is null

Bindings	0: App\Models\Job 1: 21183
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_final810μ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.58ms

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_final46.6ms

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: 5TZLRywnuWhVVSYZL2YSZqPjEk2eWngdp31QBwzm
_previous: array:1 [ "url" => "https://pingjob.com/Job0000021183" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/Job0000021183

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.145.200.81"
  ]
  "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 => "92b371efcb2ee82c-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.145.200.81"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.71.254.244"
  ]
  "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, 04 Apr 2025 20:09:45 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlR5MDNIWTRsOS9TSHMrS2xBeDB5L0E9PSIsInZhbHVlIjoiaHFHeHBkWW92WEFUSDVnWUNFRk4rWXA2TW9WK2pYRm5SUnBZWWcrejJRL0psYjdnTVNuRlM1T05DUnQ2SUlaT09uYlN0bXA5Yit4R2lZaE1jV3FMN3lSNTdKL2loK2c3YXZpRDhXbGU2L1lma2RkcGJ1VVZqZld2RElqTWdZbE0iLCJtYWMiOiIxZTJkZjQ2MWRiM2U0ZjNmY2JjODAwOTNlZDkxZGI2NTBmMTFhNWZmN2Y5MGMzOTU0YWFlY2VhYmYxZWY0NTYyIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 22:09:46 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlR5MDNIWTRsOS9TSHMrS2xBeDB5L0E9PSIsInZhbHVlIjoiaHFHeHBkWW92WEFUSDVnWUNFRk4rWXA2TW9WK2pYRm5SUnBZWWcrejJRL0psYjdnTVNuRlM1T05DUnQ2SUlaT09uYlN0b ▶"
    1 => "laravel_session=eyJpdiI6IlBXUllvejJyQk5aODQ3c1gvM0JvUmc9PSIsInZhbHVlIjoiRU5vUTZjbEVZKytlbzVqbllwa2tYNHZyTitMZU1pZDFuZjVYbG5oTmw0Z2J2amtMcEg3Smw2dkJqRmh4WithcWU4NjdZcHE4WmxSejdGUUlZTGFyTjNGYmtUZUIwcFRxak52cktubFRYQjl2dDZMMDdtdzF3YXV3LzZLbTVkQjYiLCJtYWMiOiIwOGQ3NmIxZDFjZDU1OGEwMzlmOWY2OGFjNDk4NThhMzQ5Yzk4NTY1YjliOTBmZjliZTc1OThjZmRhZGRmZTA3IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 22:09:46 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlBXUllvejJyQk5aODQ3c1gvM0JvUmc9PSIsInZhbHVlIjoiRU5vUTZjbEVZKytlbzVqbllwa2tYNHZyTitMZU1pZDFuZjVYbG5oTmw0Z2J2amtMcEg3Smw2dkJqRmh4WithcWU4 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlR5MDNIWTRsOS9TSHMrS2xBeDB5L0E9PSIsInZhbHVlIjoiaHFHeHBkWW92WEFUSDVnWUNFRk4rWXA2TW9WK2pYRm5SUnBZWWcrejJRL0psYjdnTVNuRlM1T05DUnQ2SUlaT09uYlN0bXA5Yit4R2lZaE1jV3FMN3lSNTdKL2loK2c3YXZpRDhXbGU2L1lma2RkcGJ1VVZqZld2RElqTWdZbE0iLCJtYWMiOiIxZTJkZjQ2MWRiM2U0ZjNmY2JjODAwOTNlZDkxZGI2NTBmMTFhNWZmN2Y5MGMzOTU0YWFlY2VhYmYxZWY0NTYyIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 22:09:46 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlR5MDNIWTRsOS9TSHMrS2xBeDB5L0E9PSIsInZhbHVlIjoiaHFHeHBkWW92WEFUSDVnWUNFRk4rWXA2TW9WK2pYRm5SUnBZWWcrejJRL0psYjdnTVNuRlM1T05DUnQ2SUlaT09uYlN0b ▶"
    1 => "laravel_session=eyJpdiI6IlBXUllvejJyQk5aODQ3c1gvM0JvUmc9PSIsInZhbHVlIjoiRU5vUTZjbEVZKytlbzVqbllwa2tYNHZyTitMZU1pZDFuZjVYbG5oTmw0Z2J2amtMcEg3Smw2dkJqRmh4WithcWU4NjdZcHE4WmxSejdGUUlZTGFyTjNGYmtUZUIwcFRxak52cktubFRYQjl2dDZMMDdtdzF3YXV3LzZLbTVkQjYiLCJtYWMiOiIwOGQ3NmIxZDFjZDU1OGEwMzlmOWY2OGFjNDk4NThhMzQ5Yzk4NTY1YjliOTBmZjliZTc1OThjZmRhZGRmZTA3IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 22:09:46 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlBXUllvejJyQk5aODQ3c1gvM0JvUmc9PSIsInZhbHVlIjoiRU5vUTZjbEVZKytlbzVqbllwa2tYNHZyTitMZU1pZDFuZjVYbG5oTmw0Z2J2amtMcEg3Smw2dkJqRmh4WithcWU4 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "5TZLRywnuWhVVSYZL2YSZqPjEk2eWngdp31QBwzm"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000021183"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-04 20:09:46	GET	/Job0000021183	3 10 140

SQL DBA

K-Love

SQL DBA (Contract)

SQL DBA

Description

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Job Summary

K-Love

Jobs by States

Jobs by City

1 x Booting (87.08%)	2.08s
1 x Application (12.92%)	309ms