SQL Developer

Allianz Life Insurance Company of North America

Contract Minneapolis , Minnesota, United States Posted 3 months ago

 Write a Review Add Vendor   Add Contact  

About Position

SQL Developer (Contract)

$80.00 / Hourly

Minneapolis , Minnesota, United States

SQL Developer

Contract Minneapolis , Minnesota, United States Posted 3 months ago

Description

Expert level of experience in SQL server
Good understanding of SQL, Stored procedure, and all functions
Very strong in Troubleshooting and debugging SQL code
Should be expert in SQL query Performance optimization(Indexing, Collecting stats, Partitioning, etc.,) for long running queries and DB administration
Should be able to analyze requirements and write large & complex queries creation based on requirements
Support and suggest the developers on query implementation whenever required
Connect with developers to understand the issues and guide them on resolution
Should be able to troubleshoot and identify the translation issues when data transferred from source to target.
Support developers to produce code which meets clients coding standards and best practices.
Should work with the client’s technical personnel to clarify and validate business requirement
Should be able to identify potential problems and proactively suggest changes and solutions.
Should be able to act as a reference for the data integration and reporting solution
Interact with and communicate detailed technical requirements to project development team

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

Allianz Life Insurance Company of North America Vendors

( Login to see all the 8 vendors)
BearingPoint Inc
Write a Review

1676 International Drive
McLean
Virginia
www.bearingpoint.com ( 47 vendors)

Tata Consultancy Services
Write a Review

101 Park Avenue 26th Floor
New York
New York
www.usa-tcs.com ( 41 vendors)

HCL Technologies America Inc
Write a Review

330 Potrero Avenue
Sunnyvale
California
www.hcltech.com ( 34 vendors)

Job Summary

$80.00 / Hourly

Contract

Minneapolis , Minnesota, United States

Experience Level : Medium

Experience Required : 9 Year/s

Only Any

Posted : 3 months ago

Deadline : December 31, 2024 3 months ago

Job ID : Job000002483

Allianz Life Insurance Company of North America

P.O. Box 1344

www.allianzlife.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.74sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.4s)time
    • Application (341ms)time
    • 1 x Booting (87.53%)
      2.40s
      1 x Application (12.46%)
      341ms
      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
      11 statements were executed249ms
      • JobController.php#484clientfyi_final31.55msselect * from `jobs` where `job_slug` = 'sql-developer-16' limit 1
        Bindings
        • 0: sql-developer-16
        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_final105msselect `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_final580μsselect * from `users` where `users`.`id` = 240 limit 1
        Bindings
        • 0: 240
        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_final670μ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` = 240
        Bindings
        • 0: 1
        • 1: 240
        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
      • Vendor.php#57clientfyi_final1.09msselect `vendors`.*, `users`.`website`, `users`.`company`, `users`.`address`, `users`.`city`, `states`.`state_name`, `countries`.`country_name`, (SELECT (SUM(ratings)/COUNT(id)) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_rating, (SELECT COUNT(id) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_count, (SELECT COUNT(id) FROM vendors as b WHERE b.employer_id = vendors.vendor_id) as vendor_count 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` = 240 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 240
        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_final340μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 240
        Bindings
        • 0: 1
        • 1: 240
        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.86msselect 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_final560μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 23192 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 23192
        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_final740μ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_final55.75msSELECT 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.63msSELECT 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
          4XLZS7h3yNk3mAooJw6g4iRaMC4YoVu4qsMhHFdO
          _previous
          array:1 [ "url" => "https://pingjob.com/sql-developer-16" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /sql-developer-16
          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:18 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "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"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.117.101.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, 21 Apr 2025 11:09:34 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjkzTDcxT0gyTlp4dlRVVyswQmpUaWc9PSIsInZhbHVlIjoiQldqQUI0TmhOQVpqeE54bUxOaVhsVHZLUVFwbVhEcmQxeXp6N05CUkgyRnZtWWpKTzg5NDUzTm1FZ3NYbWNsYmYrOXJQZkcyeWtqdFBZY3RHZFptZUNSSDVHNkQ1ZFg4TldjVS9lSEM0M25Gb3lLOVBabXBVdVVpSjR4NytzUGMiLCJtYWMiOiJkOGYyZWY4ZTBkMTQyMzkxZGQwOTAyZWNmNzE1OGE2NDQ4Yjk5OGFhNzFiMDA3ZDNmMzgwMjY3YmM1MGMyMjU3IiwidGFnIjoiIn0%3D; expires=Mon, 21 Apr 2025 13:09:34 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjkzTDcxT0gyTlp4dlRVVyswQmpUaWc9PSIsInZhbHVlIjoiQldqQUI0TmhOQVpqeE54bUxOaVhsVHZLUVFwbVhEcmQxeXp6N05CUkgyRnZtWWpKTzg5NDUzTm1FZ3NYbWNsYmYrOXJQZ ▶"
    1 => "laravel_session=eyJpdiI6ImZSV0RlYUtzR0VwckEzNUlXS0dBL0E9PSIsInZhbHVlIjoiR0FPRG5tTG1MaG9rUm4xWXZNb3RZVzVNY25mWEVoTlQ0dHNaU3NPZnNSbWlrYTFyVlNzODNZQzZUZW95QzNhaTZRQ1A3MTFTdUQ4Yk9qSG9McGpFU0pTWElGSE00bEhWRVl1Znd0T1Z3Q3VPS05jOHExSlZaV0VmeU9JVWh0SEsiLCJtYWMiOiJhOGIzNTllNWI2ZTQ5NDI0OTQ2Y2I5YjYyZTA5NTkxY2M0N2U1MTE3OTNjN2U0NWI0NGU0NmMxMzQ1ZWQ3OGQ1IiwidGFnIjoiIn0%3D; expires=Mon, 21 Apr 2025 13:09:34 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImZSV0RlYUtzR0VwckEzNUlXS0dBL0E9PSIsInZhbHVlIjoiR0FPRG5tTG1MaG9rUm4xWXZNb3RZVzVNY25mWEVoTlQ0dHNaU3NPZnNSbWlrYTFyVlNzODNZQzZUZW95QzNhaTZR ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjkzTDcxT0gyTlp4dlRVVyswQmpUaWc9PSIsInZhbHVlIjoiQldqQUI0TmhOQVpqeE54bUxOaVhsVHZLUVFwbVhEcmQxeXp6N05CUkgyRnZtWWpKTzg5NDUzTm1FZ3NYbWNsYmYrOXJQZkcyeWtqdFBZY3RHZFptZUNSSDVHNkQ1ZFg4TldjVS9lSEM0M25Gb3lLOVBabXBVdVVpSjR4NytzUGMiLCJtYWMiOiJkOGYyZWY4ZTBkMTQyMzkxZGQwOTAyZWNmNzE1OGE2NDQ4Yjk5OGFhNzFiMDA3ZDNmMzgwMjY3YmM1MGMyMjU3IiwidGFnIjoiIn0%3D; expires=Mon, 21-Apr-2025 13:09:34 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjkzTDcxT0gyTlp4dlRVVyswQmpUaWc9PSIsInZhbHVlIjoiQldqQUI0TmhOQVpqeE54bUxOaVhsVHZLUVFwbVhEcmQxeXp6N05CUkgyRnZtWWpKTzg5NDUzTm1FZ3NYbWNsYmYrOXJQZ ▶"
    1 => "laravel_session=eyJpdiI6ImZSV0RlYUtzR0VwckEzNUlXS0dBL0E9PSIsInZhbHVlIjoiR0FPRG5tTG1MaG9rUm4xWXZNb3RZVzVNY25mWEVoTlQ0dHNaU3NPZnNSbWlrYTFyVlNzODNZQzZUZW95QzNhaTZRQ1A3MTFTdUQ4Yk9qSG9McGpFU0pTWElGSE00bEhWRVl1Znd0T1Z3Q3VPS05jOHExSlZaV0VmeU9JVWh0SEsiLCJtYWMiOiJhOGIzNTllNWI2ZTQ5NDI0OTQ2Y2I5YjYyZTA5NTkxY2M0N2U1MTE3OTNjN2U0NWI0NGU0NmMxMzQ1ZWQ3OGQ1IiwidGFnIjoiIn0%3D; expires=Mon, 21-Apr-2025 13:09:34 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImZSV0RlYUtzR0VwckEzNUlXS0dBL0E9PSIsInZhbHVlIjoiR0FPRG5tTG1MaG9rUm4xWXZNb3RZVzVNY25mWEVoTlQ0dHNaU3NPZnNSbWlrYTFyVlNzODNZQzZUZW95QzNhaTZR ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "4XLZS7h3yNk3mAooJw6g4iRaMC4YoVu4qsMhHFdO"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/sql-developer-16"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-21 11:09:34GET/sql-developer-16311140