Bank Of America

Oracle PL/SQL Developer

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Plano
  • Experience: NA
  • No. of Positions: 1
  • Primary Skills: Software Engineers Database Testing Performance Oracle SQL
  • Secondary Skills: PL/SQL Linux Unix Data Warehouse Python
  • Job Location: Plano, Texas
  • Posted Date: Posted today
Job Description

Job Description:

Responsible for designing and developing complex requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Ensures solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Possess strong proficiency in development and testing practices common to the industry, and have extensive experience of using design and architectural patterns. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements. Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Designs/develops/modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained. Designs/develops/maintains automated test suites (integration, regression, performance). Sets up and develops a continuous integration/continuous delivery pipeline. Automates manual release activities. Mentors other Software Engineers and coaches team on CI-CD practices and automating tool stack.

As part of an internal shared technology services group providing consulting services to internal clients.
- Serves as a fully seasoned/proficient technical resource. Will not have direct reports, however may provide technical leadership on projects and direct activities of a team related to projects. May collaborate with external programmers to coordinate delivery of software application. Routine accountability is for technical knowledge and capabilities.
- Works under minimal supervision, with general guidance from more seasoned team members.
- Drives process improvements and innovation
- Interprets business requirements into design solutions
- Understands design and development of project lifecycle
- Designs the conceptual and physical data model
- Adapts best Database design and coding standards
- Database coding
- Code Unit Testing and Component Integration Testing.
- Creation and maintenance of system, functional and reference documentation.
- Provide support during testing phases as required.
- Conduct analysis and recommend bug fixes for production incidents
- Performance tuning
- Provide On-call support
- Carry out daily health-check activities involving application checks, system checks, and database checks and related on production systems / servers
- Report root cause of the incidents and present ideas on how to prevent the incidents from occurring in future
- Ensure adherence to incident and change management processes
Required Skills:
• Provent hands-on experience (5-7 years)
- Oracle SQL
- Oracle PL/SQL
- Database Objects
- Performance Tuning
- Linux/Unix shell scripting
- Debugging and modifying existing application
- Database design and development
- Installing configuration of applications and maintaining environments

• Planning skills -- ability to think ahead and be proactive
• Must be able to clearly and succinctly articulate progress, issues, solutions, plans, results, and success
• Strong presentation skills - ability to tell the story to leaders and stakeholders
• Ability to build strong relationships with people of all levels of the organization and influence to bring about positive change
• Positive "can do" attitude
• Continuous improvement mindset
• Ability to encourage and accept feedback from all stakeholders with an open mind and take appropriate actions to follow up
• Ability to provide technical leadership to initiatives and teams
• Voracious learner
• Intellectually curious
Desired Skills:
• Autosys
• ETL
• Agile experience
• Jira
• Data Warehouse
• Python
• Exadata
• SQL*Loader
• External Tables
• Common Packages
• OEM

General Job Description:
Responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust and well-tested interfaces. Familiar with development and testing practices of the bank. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Contributes to existing test suites (integration, regression, performance); Analyzes test reports, identifies any test issues/errors; Triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Participates, contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes. Individual contributor.

Shift:
1st shift (United States of America)

Hours Per Week:
40

Learn more about this role

Relevant Job Openings
Tableau developer
Java Developer
Azure Data Architect with Talend
Java Full stack Developer
.Net Architects
Sr.Data Engineer