SQL Server Developer

Knowledge Universe Technologies

Contract Portland, Oregon, United States Posted 7 years ago

 Write a Review Add Vendor   Add Contact  

About Position

SQL Server Developer (Contract)

$55.00 / Hourly

Portland, Oregon, United States

SQL Server Developer

Contract Portland, Oregon, United States Posted 7 years ago

Description

SQL Developer should be solidly midlevel, 6+ yrs of experience. Candidate should be able to handle midlevel SQL development with a minimum of handholding. Communication needs to be 9/10 or better, both verbal and written. We are looking for SQL DEVELOPERS, not DBA's. If a person has done some development work while being a DBA they won't be a fit for this role. Experience within full SDLC is required. Our two finalists really fell flat on this facet. Having been involved in only bits and pieces of the development cycle, they would have needed a lot of instruction of where the SQL Developer's role is throughout the SDLC. ER diagramming tools for SQL Microsoft VISIO and Erwin. (previous candidates also feel short in this) SQL 2005, SSIS and TSQL are all extremely important. A successful candidate will also have some solid understanding of .NET programming and architecture to make their SQL Development more effective. Should have handson experience designing SQL databases for transactions and writing TSQL scripts. SSRS not required. Cognos not required, but a definite plus. NO ETL developers, please. Again, we need someone who can work in a fastpaced environment. If a developer wants their work to be viewed and used by 47,000+ people, then this is the place for them!

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

$55.00 / Hourly

Contract

Portland, Oregon, United States

Experience Required : 9 Year/s

Posted : 7 years ago

Deadline : August 30, 2017 7 years ago

Job ID : Job0000010258

Knowledge Universe Technologies

650 NE Holladay, Suite 1400

888-588-3241

www.kutech.com

Request history8.1.32PHP Version3.26sRequest Duration694MBMemory UsageGET {slug}Route
    • Booting (2.8s)time
    • Application (467ms)time
    • 1 x Booting (85.69%)
      2.80s
      1 x Application (14.31%)
      467ms
      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 executed212ms
      • JobController.php#484clientfyi_final8.46msselect * from `jobs` where `job_slug` = 'Job0000010258' limit 1
        Bindings
        • 0: Job0000010258
        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_final99.93msselect `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_final620μsselect * from `users` where `users`.`id` = 50223 limit 1
        Bindings
        • 0: 50223
        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_final510μ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` = 50223
        Bindings
        • 0: 1
        • 1: 50223
        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_final420μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 50223
        Bindings
        • 0: 1
        • 1: 50223
        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.36msselect 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_final410μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 10258 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 10258
        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_final46.79msSELECT 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.21msSELECT 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
          cXqzrsCxmH1o0YW2Mc0BFMfe0wTZKrAXYlmTuqqQ
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000010258" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000010258
          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.18.103.165" ] "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 => "92a3ec0ebbd445f5-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.18.103.165" ] "x-real-ip" => array:1 [ 0 => "172.69.17.70" ] "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 => "Wed, 02 Apr 2025 22:56:56 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImJ3eEZvSGsvb1B4aURjYmd5NDBGVVE9PSIsInZhbHVlIjoiQ2RNcTJVaDZOWXVKRkhIbElvOG8weXFLUW13V3RkUGlwR2drLzhiNS96MExBWEhTaHFEbGFvMWYrZkRPeFRRY3NUeTNObG1PWkJIVUZhVXJTVEpKMW9jajRoT1p4ZHFXTFdma2krUzM4dDN4TnJ1eDF6NjFKT0hQSFRURVdnRGciLCJtYWMiOiIwMmMyMWZiMGQ5ZDc0ZmZiNzcxNmM4ZTEwZTJhZDZmZGZkOTYxOWMwYjJhMDczMzM5MDYzNjYwZDgxYmFiOGQ2IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 00:56:56 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImJ3eEZvSGsvb1B4aURjYmd5NDBGVVE9PSIsInZhbHVlIjoiQ2RNcTJVaDZOWXVKRkhIbElvOG8weXFLUW13V3RkUGlwR2drLzhiNS96MExBWEhTaHFEbGFvMWYrZkRPeFRRY3NUeTNOb" 1 => "laravel_session=eyJpdiI6IkZndUdMVlh1UGRKTGV4M3NiYVJJRUE9PSIsInZhbHVlIjoiNjVoc2Z3Q2tYczdtdzVQN2xwSG8zakQzUFUzMU5oQVU1dkdwazN4ajI2WDVybWh5a1dGUzFjR3Zsbm9IdWlzN1dLcFZwc1ZIWHJabWdtNFpwTVcyeWxCZE0vK2hrT2VENVpqTlNIK3hrNWFMMStlamhJdWFKMVBHalhsU0JRSmoiLCJtYWMiOiJmOGRhYzFmZDA2NmU0NzlhNGEzNjZlMDhiZTgwYTgwOWU1ZWVlODc5ZTNmMzc5MGYwOTg1ZDFlNzdiZmY3NzY3IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 00:56:56 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IkZndUdMVlh1UGRKTGV4M3NiYVJJRUE9PSIsInZhbHVlIjoiNjVoc2Z3Q2tYczdtdzVQN2xwSG8zakQzUFUzMU5oQVU1dkdwazN4ajI2WDVybWh5a1dGUzFjR3Zsbm9IdWlzN1dL" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImJ3eEZvSGsvb1B4aURjYmd5NDBGVVE9PSIsInZhbHVlIjoiQ2RNcTJVaDZOWXVKRkhIbElvOG8weXFLUW13V3RkUGlwR2drLzhiNS96MExBWEhTaHFEbGFvMWYrZkRPeFRRY3NUeTNObG1PWkJIVUZhVXJTVEpKMW9jajRoT1p4ZHFXTFdma2krUzM4dDN4TnJ1eDF6NjFKT0hQSFRURVdnRGciLCJtYWMiOiIwMmMyMWZiMGQ5ZDc0ZmZiNzcxNmM4ZTEwZTJhZDZmZGZkOTYxOWMwYjJhMDczMzM5MDYzNjYwZDgxYmFiOGQ2IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 00:56:56 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImJ3eEZvSGsvb1B4aURjYmd5NDBGVVE9PSIsInZhbHVlIjoiQ2RNcTJVaDZOWXVKRkhIbElvOG8weXFLUW13V3RkUGlwR2drLzhiNS96MExBWEhTaHFEbGFvMWYrZkRPeFRRY3NUeTNOb" 1 => "laravel_session=eyJpdiI6IkZndUdMVlh1UGRKTGV4M3NiYVJJRUE9PSIsInZhbHVlIjoiNjVoc2Z3Q2tYczdtdzVQN2xwSG8zakQzUFUzMU5oQVU1dkdwazN4ajI2WDVybWh5a1dGUzFjR3Zsbm9IdWlzN1dLcFZwc1ZIWHJabWdtNFpwTVcyeWxCZE0vK2hrT2VENVpqTlNIK3hrNWFMMStlamhJdWFKMVBHalhsU0JRSmoiLCJtYWMiOiJmOGRhYzFmZDA2NmU0NzlhNGEzNjZlMDhiZTgwYTgwOWU1ZWVlODc5ZTNmMzc5MGYwOTg1ZDFlNzdiZmY3NzY3IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 00:56:56 GMT; path=/; httponlylaravel_session=eyJpdiI6IkZndUdMVlh1UGRKTGV4M3NiYVJJRUE9PSIsInZhbHVlIjoiNjVoc2Z3Q2tYczdtdzVQN2xwSG8zakQzUFUzMU5oQVU1dkdwazN4ajI2WDVybWh5a1dGUzFjR3Zsbm9IdWlzN1dL" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "cXqzrsCxmH1o0YW2Mc0BFMfe0wTZKrAXYlmTuqqQ" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000010258" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-02 22:56:56GET/Job0000010258310140