PL/SQL, Oracle, SAS, Programming Expert

Pace University

Contract New York, New York, United States Posted 8 years ago

 Write a Review Add Vendor   Add Contact  

About Position

PL/SQL, Oracle, SAS, Programming Expert (Contract)

$55.00 / Hourly

New York, New York, United States

PL/SQL, Oracle, SAS, Programming Expert

Contract New York, New York, United States Posted 8 years ago

Description

Analyze, design, implement, maintain, and document complex programs used by Pace's enterprise applications, Banner, and Third Party software applications. Review and translate user system needs (systems analysis and development) into technical solutions by writing appropriate programs and integrating systems. Review, understand, and help plan for all Banner and Third Party application software upgrades. The ability to work well with project team members and a varied user community is mandatory. Serve as project leader for all new or changes to existing application procedures and processing. Analyze application software problems, institute corrective action, and, document same. Review and evaluate proposals for changes to existing system and programming applications submitted by users and/or management and, when necessary, recommend improvements. Help develop, implement, and support the University's short and long term application information technology plans.

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

New York, New York, United States

Experience Required : 7 Year/s

Posted : 8 years ago

Deadline : November 27, 2016 8 years ago

Job ID : Job0000007137

Pace University

1 Pace Plaza

www.pace.edu

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries10Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.19sRequest Duration690MBMemory UsageGET {slug}Route
    • Booting (1.93s)time
    • Application (260ms)time
    • 1 x Booting (88.15%)
      1.93s
      1 x Application (11.85%)
      260ms
      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 executed189ms
      • JobController.php#484clientfyi_final7.25msselect * from `jobs` where `job_slug` = 'Job0000007137' limit 1
        Bindings
        • 0: Job0000007137
        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_final86.52msselect `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_final570μsselect * from `users` where `users`.`id` = 49243 limit 1
        Bindings
        • 0: 49243
        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_final390μ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` = 49243
        Bindings
        • 0: 1
        • 1: 49243
        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_final300μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 49243
        Bindings
        • 0: 1
        • 1: 49243
        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.85msselect DISTINCT email from `job_applications` where `category_id` = 56 and `status` = 1
        Bindings
        • 0: 56
        • 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_final380μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 7137 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 7137
        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_final720μ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_final45.42msSELECT 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_final38.81msSELECT 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
          R2yC3ww4DneFyJqFe3ww26s8mAjPt9xZYlHtN4ZR
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000007137" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000007137
          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.134.111.219"
  ]
  "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 => "91cd5e008dc789fd-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.134.111.219"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.100.165"
  ]
  "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, 07 Mar 2025 22:00:44 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkNRR0NXUU9nVzY0bGd3cHRzdlh1SGc9PSIsInZhbHVlIjoiMmpkZVFOTjQ3SURKS1NyeWtzV3h6WGpCbDR3YzU5MTNWcXJOSkRKU0M0QzVXUXljTG9obG1wQ1RFSjlkVm9TamxpR1Y4alRQMU5DMHhRdW8yMDJTeEpaMFNkYWFOdEx4Q2dybjlVeE9QWDFHY3dPRDdNWE5LYW02MGRaUFQ5TXciLCJtYWMiOiI0NTk4MDIxOGIwNDllZWFhMmFjZWYwYTI4ZDY1ZTg5N2ZjNGE1NGJkMGIzNmM2MjM1MGIwN2ZhYTk0OTQzZDc4IiwidGFnIjoiIn0%3D; expires=Sat, 08 Mar 2025 00:00:44 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkNRR0NXUU9nVzY0bGd3cHRzdlh1SGc9PSIsInZhbHVlIjoiMmpkZVFOTjQ3SURKS1NyeWtzV3h6WGpCbDR3YzU5MTNWcXJOSkRKU0M0QzVXUXljTG9obG1wQ1RFSjlkVm9TamxpR1Y4a ▶"
    1 => "laravel_session=eyJpdiI6ImtNQWYvZTF6ckFwaDhVMndoZlBKNXc9PSIsInZhbHVlIjoicHJ5QkxVdE5USlhWZ3dORWUvQ2c2U1NyRzdweklyYlJSSkRKTXFpL29WWGNqcDVBUEF1dzByd1NCM1RiUVdlVk4vRzZ4TUFHRlN2Y3RSU2xUK3c3dnM3QklrMzF6bkdVSUNqYzIzS0xORUlUQ2xJUXkreXM2RlVWaTU0NUFCeHQiLCJtYWMiOiI4NDMzZGYxM2RkZTdiNTdmMWJiOTBiM2IyNzdjYmI4ZTk3M2ZiOTgxMmZkNWMxMzliMDFhMDJhZmQ4Y2MwNjIwIiwidGFnIjoiIn0%3D; expires=Sat, 08 Mar 2025 00:00:44 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImtNQWYvZTF6ckFwaDhVMndoZlBKNXc9PSIsInZhbHVlIjoicHJ5QkxVdE5USlhWZ3dORWUvQ2c2U1NyRzdweklyYlJSSkRKTXFpL29WWGNqcDVBUEF1dzByd1NCM1RiUVdlVk4v ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkNRR0NXUU9nVzY0bGd3cHRzdlh1SGc9PSIsInZhbHVlIjoiMmpkZVFOTjQ3SURKS1NyeWtzV3h6WGpCbDR3YzU5MTNWcXJOSkRKU0M0QzVXUXljTG9obG1wQ1RFSjlkVm9TamxpR1Y4alRQMU5DMHhRdW8yMDJTeEpaMFNkYWFOdEx4Q2dybjlVeE9QWDFHY3dPRDdNWE5LYW02MGRaUFQ5TXciLCJtYWMiOiI0NTk4MDIxOGIwNDllZWFhMmFjZWYwYTI4ZDY1ZTg5N2ZjNGE1NGJkMGIzNmM2MjM1MGIwN2ZhYTk0OTQzZDc4IiwidGFnIjoiIn0%3D; expires=Sat, 08-Mar-2025 00:00:44 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkNRR0NXUU9nVzY0bGd3cHRzdlh1SGc9PSIsInZhbHVlIjoiMmpkZVFOTjQ3SURKS1NyeWtzV3h6WGpCbDR3YzU5MTNWcXJOSkRKU0M0QzVXUXljTG9obG1wQ1RFSjlkVm9TamxpR1Y4a ▶"
    1 => "laravel_session=eyJpdiI6ImtNQWYvZTF6ckFwaDhVMndoZlBKNXc9PSIsInZhbHVlIjoicHJ5QkxVdE5USlhWZ3dORWUvQ2c2U1NyRzdweklyYlJSSkRKTXFpL29WWGNqcDVBUEF1dzByd1NCM1RiUVdlVk4vRzZ4TUFHRlN2Y3RSU2xUK3c3dnM3QklrMzF6bkdVSUNqYzIzS0xORUlUQ2xJUXkreXM2RlVWaTU0NUFCeHQiLCJtYWMiOiI4NDMzZGYxM2RkZTdiNTdmMWJiOTBiM2IyNzdjYmI4ZTk3M2ZiOTgxMmZkNWMxMzliMDFhMDJhZmQ4Y2MwNjIwIiwidGFnIjoiIn0%3D; expires=Sat, 08-Mar-2025 00:00:44 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImtNQWYvZTF6ckFwaDhVMndoZlBKNXc9PSIsInZhbHVlIjoicHJ5QkxVdE5USlhWZ3dORWUvQ2c2U1NyRzdweklyYlJSSkRKTXFpL29WWGNqcDVBUEF1dzByd1NCM1RiUVdlVk4v ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "R2yC3ww4DneFyJqFe3ww26s8mAjPt9xZYlHtN4ZR"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000007137"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-07 22:00:44GET/Job0000007137310140