Oracle PL/SQL Developer

Bank of America Corporation

Contract Kennesaw , Georgia, United States Posted 2 months ago

Write a Review Add Vendor Add Contact

About Position

Oracle PL/SQL Developer (Contract)

$85.00 / Hourly

Kennesaw , Georgia, United States

Oracle PL/SQL Developer

Contract Kennesaw , Georgia, United States Posted 2 months ago

Skills

Computer Science/Software Engineering (or related technical) degree or equivalent experience in field HR Data Domain experience. Finance Data Domain experience (RDR Finance space). 6+ year Data Warehousing experience including manipulation/ transformation of millions of rows with optimal methods 6+ year experience with traditional relational database management systems (Oracle) and SQL skills including developing stored procedures functions and triggers in a Big Data environment 6+ year SQL PL/SQL development experience with Oracle DBMS and VPD Security. 6+ year using TOAD Unix Shell Scripting Autosys Jira and Microsoft Office Suite (Outlook Excel Word Access) Experience in Master Data Management (MDM) concept tools and best practices Demonstrable risk identification skills Working knowledge of Java/ Mulesoft/ APIs Enterprise HR (or other highly sensitive) Data Domain experience Technology Development experience in Financial Services/Banking Industry Experience in Agile Scrum DevOps SAFe or Disciplined Agile ways of working CI/CD Release Processes Expert in data regulation and exercises best practices in data management and governance Advanced experience in Unix Shell Scripts Autosys and TOAD for Oracle Advanced-level analytical debugging and critical thinking skills.

Description

Strong Oracle PL/SQL Development experience
Unix (Operating systems & scripting)
Data Methodology & Analysis: Understanding data structure, data design, and improving the Oracle DB with a focus on an API type environment rather than pushing files
Performance tuning
ETL (Extract, Transform, Load) work
Datawarehouse experience: NEED to have – primarily what they do
Informatica
Prior Bank experience would give candidates a better advantage

Responsibilities

Participate in status meetings to track progress, resolve issues, articulate mitigate risks and escalate concerns in a timely manner.
Exemplifies and evangelizes great solution delivery management by minimizing technical debt, surpasses design, engineering, organizational practices (unit testing, release procedures, coding design and documentation protocols), coding and quality, and exceeds security standards and Bank's change management requirements
Demonstrates the development and implementation of enterprise data quality standards and data protection standards within the space
sets the bar for team communications and interactions - is an excellent teammate to peers, influencing them in a positive direction
Acts as a liaison for production activities/issues. Mentors the team on work breakdown and execution
Oversees continuous improvement of database scalability performance
uses versioning tools such as GIT/Bit bucket
sets up jobs using autosys for automation
Advocates and advances modern application development deployment – Agile solution delivery, Automated Testing, Continuous Integration, Continuous Delivery
identifies data anomalies/data patterns in huge data sets

Educational Requirements

• Takes pride and ownership in their working
• Be passionate about quality, programming, and software development in general.
• Hands-on experience in database development with efficient sOL, performance tuning and debugging skills.
• Good understanding of performance tuning and debugging/Problem-solving skills.
• Working knowledge on Agile Scrum/ Kanban process as a Team developer.
• Knowledge of Finance and Global Markets products - Derivatives, Securities, SET is a plus.
• Bachelor's degree in computer science, Computer Engineering, or a closely related field.
• Track record of being detalled oriented, self-starter and deliverables with minimal defects.
• Must be able to quickly grasp complex concepts and learn new technologies.
• Ability to work well independently with minimal direction and together as a member of cross-functional teams.
• Must be solutions-oriented and a critical thinker.
* Strong analytical and problem-solving skills.
• Ability to effectively manage multiple, competing, high-priority projects with varying deadlines

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

Bank of America Corporation Vendors

( Login to see all the 53 vendors)

TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Ajilon Consulting
Write a Review

210 West Pennsylvania Avenue
Towson
Maryland
www.ajilonconsulting.com ( 47 vendors)

Analysts International
Write a Review

3601 West 76th Street
Minneapolis
Minnesota
www.analysts.com ( 35 vendors)

Job Summary

$85.00 / Hourly

Contract

Kennesaw , Georgia, United States

Experience Level : Medium

Experience Required : 8 Year/s

Only Any

Posted : 2 months ago

Deadline : February 24, 2025 2 months ago

Job ID : Job0000002784

Bank of America Corporation

100 N. Tryon Street

www.bankofamerica.com

Messages Timeline Exceptions Views3 Route Queries11 Models140 Mails Gate Session Request

Request history8.1.322s695MBGET {slug}

Booting (1.72s)time
Application (282ms)time
1 x Booting (85.93%)
1.72s
1 x Application (14.07%)
282ms

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 executed208ms

JobController.php#484clientfyi_final2.92msselect * from `jobs` where `job_slug` = 'oracle-plsql-developer-7' limit 1

Bindings	0: oracle-plsql-developer-7
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_final78.21msselect `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` = 634 limit 1

Bindings	0: 634
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_final950μ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` = 634

Bindings	0: 1 1: 634
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_final5ms

select `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` = 634 order by `vendor_count` desc limit 3 offset 0

Bindings	0: 1 1: 634
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_final290μs

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

Bindings	0: 1 1: 634
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_final9.03msselect 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_final330μs

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

Bindings	0: App\Models\Job 1: 2784
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_final800μ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.94ms

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_final54.13ms

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: Kj99kb3X4DV7CfAWi7qcLffBgUlzlfWZb0HLPuwb
_previous: array:1 [ "url" => "https://pingjob.com/oracle-plsql-developer-7" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/oracle-plsql-developer-7

status_code

status_text

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 => "3.141.40.160"
  ]
  "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, 25 Apr 2025 18:21:51 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImgwemJ0OFhaRlh4WlBobDk5NXJ4b2c9PSIsInZhbHVlIjoiZWFmNERSMmNOTC9BZ2xCbTlyS2ZnZnZqQW1FK09DcWx0aE1uaCtMVUNjd29qanpRYVNyNHV2bElvSEMzS2JJM3NMQVlZbGo1cjBzRUdLMnZpNmpXc29idEliT3RsS1BrZlljRmJJblhsTjhOZS9YTUw4K3ovQmlodm1HeEpjU1EiLCJtYWMiOiIwYjQ4ZGQ5MDRiYTlkZDRiZjA4Mzg3YjAwM2Q5Y2MwMmIyZjM4YjA4NzE4NDA0ODM5YjNiYTljOTdjN2RlYjcwIiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 20:21:51 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImgwemJ0OFhaRlh4WlBobDk5NXJ4b2c9PSIsInZhbHVlIjoiZWFmNERSMmNOTC9BZ2xCbTlyS2ZnZnZqQW1FK09DcWx0aE1uaCtMVUNjd29qanpRYVNyNHV2bElvSEMzS2JJM3NMQVlZb ▶"
    1 => "laravel_session=eyJpdiI6InFOT3BSTldpSExSSy9MZXNtb3VnSUE9PSIsInZhbHVlIjoiMXBaZ0RIbHBzUEVlckxSVVNFMFN5eDBRa2RTdE9yT1BZaEZIQnVERUdzTHVZeWIzblpqdVFQbEVpSzZpWjJjV3h5WUlaUC90dzg0dmNYL3Y5bHdtdWllT0lJN3R0L3pnOVFwdjZzbC8wTTMzSGlyZkUrbEVBeTVQazFGTDEwMHUiLCJtYWMiOiI1YWYyOWIzMTgwN2EzZTk3OGM3OTRmOTMyNDA2ZjQ3ZjgyZTI0MGYzYzVlOWZjNjUxZGU1Y2YyZWM2OWY5OWNkIiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 20:21:51 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6InFOT3BSTldpSExSSy9MZXNtb3VnSUE9PSIsInZhbHVlIjoiMXBaZ0RIbHBzUEVlckxSVVNFMFN5eDBRa2RTdE9yT1BZaEZIQnVERUdzTHVZeWIzblpqdVFQbEVpSzZpWjJjV3h5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImgwemJ0OFhaRlh4WlBobDk5NXJ4b2c9PSIsInZhbHVlIjoiZWFmNERSMmNOTC9BZ2xCbTlyS2ZnZnZqQW1FK09DcWx0aE1uaCtMVUNjd29qanpRYVNyNHV2bElvSEMzS2JJM3NMQVlZbGo1cjBzRUdLMnZpNmpXc29idEliT3RsS1BrZlljRmJJblhsTjhOZS9YTUw4K3ovQmlodm1HeEpjU1EiLCJtYWMiOiIwYjQ4ZGQ5MDRiYTlkZDRiZjA4Mzg3YjAwM2Q5Y2MwMmIyZjM4YjA4NzE4NDA0ODM5YjNiYTljOTdjN2RlYjcwIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 20:21:51 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImgwemJ0OFhaRlh4WlBobDk5NXJ4b2c9PSIsInZhbHVlIjoiZWFmNERSMmNOTC9BZ2xCbTlyS2ZnZnZqQW1FK09DcWx0aE1uaCtMVUNjd29qanpRYVNyNHV2bElvSEMzS2JJM3NMQVlZb ▶"
    1 => "laravel_session=eyJpdiI6InFOT3BSTldpSExSSy9MZXNtb3VnSUE9PSIsInZhbHVlIjoiMXBaZ0RIbHBzUEVlckxSVVNFMFN5eDBRa2RTdE9yT1BZaEZIQnVERUdzTHVZeWIzblpqdVFQbEVpSzZpWjJjV3h5WUlaUC90dzg0dmNYL3Y5bHdtdWllT0lJN3R0L3pnOVFwdjZzbC8wTTMzSGlyZkUrbEVBeTVQazFGTDEwMHUiLCJtYWMiOiI1YWYyOWIzMTgwN2EzZTk3OGM3OTRmOTMyNDA2ZjQ3ZjgyZTI0MGYzYzVlOWZjNjUxZGU1Y2YyZWM2OWY5OWNkIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 20:21:51 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InFOT3BSTldpSExSSy9MZXNtb3VnSUE9PSIsInZhbHVlIjoiMXBaZ0RIbHBzUEVlckxSVVNFMFN5eDBRa2RTdE9yT1BZaEZIQnVERUdzTHVZeWIzblpqdVFQbEVpSzZpWjJjV3h5 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Kj99kb3X4DV7CfAWi7qcLffBgUlzlfWZb0HLPuwb"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/oracle-plsql-developer-7"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-25 18:21:51	GET	/oracle-plsql-developer-7	3 11 140

Oracle PL/SQL Developer

Bank of America Corporation

Oracle PL/SQL Developer (Contract)

Oracle PL/SQL Developer

Skills

Description

Responsibilities

Educational Requirements

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Bank of America Corporation Vendors

( Login to see all the 53 vendors)

TEK Systems
Write a Review

Ajilon Consulting
Write a Review

Analysts International
Write a Review

Job Summary

Bank of America Corporation

Jobs by States

Jobs by City

1 x Booting (85.93%)	1.72s
1 x Application (14.07%)	282ms

Oracle PL/SQL Developer

Bank of America Corporation

Oracle PL/SQL Developer (Contract)

Oracle PL/SQL Developer

Skills

Description

Responsibilities

Educational Requirements

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Bank of America Corporation Vendors

( Login to see all the 53 vendors)

TEK Systems Write a Review

Ajilon Consulting Write a Review

Analysts International Write a Review

Job Summary

Bank of America Corporation

Jobs by States

Jobs by City

TEK Systems
Write a Review

Ajilon Consulting
Write a Review

Analysts International
Write a Review