Vantage Point Consulting Inc.
Oracle PL/SQL
Vantage Point Consulting Inc., Chicago, Illinois, United States, 60290
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:
- 10 years' experience in software development, focusing on data load & processing of Data
- 7+ years of database design and modeling, coding, and management
- 5 years of SQL and PL/SQL in Oracle 12+
- Strong in Database Architecture, Data Warehousing Concepts and storage
- Strong database design knowledge and optimization experienced skills are a must
- Experience in SQL and performance tuning and handles huge volume of data
- Knowledge of Oracle Exadata concepts and features
- Working knowledge of SDLC
- Oracle concepts with hands on experience in Stored Procedures, Functions, Views, Indexing, Query performance tuning etc.
- Problem solving skills and ability to think algorithmically
- Strong analytical and organizational skills
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:
- 10 years' experience in software development, focusing on data load & processing of Data
- 7+ years of database design and modeling, coding, and management
- 5 years of SQL and PL/SQL in Oracle 12+
- Strong in Database Architecture, Data Warehousing Concepts and storage
- Strong database design knowledge and optimization experienced skills are a must
- Experience in SQL and performance tuning and handles huge volume of data
- Knowledge of Oracle Exadata concepts and features
- Working knowledge of SDLC
- Oracle concepts with hands on experience in Stored Procedures, Functions, Views, Indexing, Query performance tuning etc.
- Problem solving skills and ability to think algorithmically
- Strong analytical and organizational skills