What are the responsibilities and job description for the Oracle PL/SQL position at Vantage Point Consulting Inc.?
Oracle PL / SQL for Chicago and Atlanta
The team will be subject to multiple critical regulations and also going through a Technology Transformation Journey to build and adopt General capabilities for Data Ingestion, Rules Authoring & Execution, and Analytics capabilities. This is a greenfield project that requires meticulous design to replace multiple legacy applications within Treasury Technology. These applications will also house some critical regulatory programs such as Basel IV, & FRTB.
Responsibilities :
- 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.
- Debug and identify the performance issues and provide solutions
- Support and help the application development team to develop & deliver optimized queries and database objects
- Work with Application development team, understand the requirement and provide better optimized solution
- Performs spike / proof of concept as necessary to mitigate risk or implement new ideas.
- Monitor the database performance and storage and work with DBA team if any DB issues
- Support Month-end release process and Month End production run
- Assists team with resolving technical complexities involved in realizing story work.
- 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.
Required Skills :
