Oracle PL/SQL

2 weeks ago

Chicago, United States Vantage Point Consulting Inc. Full time
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

  • PL/SQL lead

    2 weeks ago

    Chicago, United States E-Solutions Full time

    Position: PL/SQL leadLocation: Chicago Metropolitan Area (onsite)JD:Skills: PLSQL, SQL with ETL background, preferably IICS; Exp working in Data Migration projects at lead level; Salesforce knowledge and Salesforce Data Load experience; Good to have - Snowflake, AWS • 8+ years of total experience in ETL as a PLSQL Lead Data Developer with Very good...

  • PL/SQL lead

    2 weeks ago

    Chicago, United States E-Solutions Full time

    Position: PL/SQL leadLocation: Chicago Metropolitan Area (onsite)JD:Skills: PLSQL, SQL with ETL background, preferably IICS; Exp working in Data Migration projects at lead level; Salesforce knowledge and Salesforce Data Load experience; Good to have - Snowflake, AWS • 8+ years of total experience in ETL as a PLSQL Lead Data Developer with Very good...

  • Oracle Application Developer

    1 week ago

    Chicago, United States Norgate Technology Full time

    Long Term W2 Contract. Hybrid Position at Chicago, IL. No Corp-Corp for this role. Title: Oracle Apps Developer with PL/SQL experience. Business Objective: The resources will support data engineering efforts, focusing on developing Oracle applications and providing solutions across various projects and initiatives.Responsibilities (Day to Day)• Develop and...

  • Database Administrator, Oracle and SQL

    6 days ago

    Chicago, Illinois, United States Argo Group Full time

    Argo Group is a leader in specialty insurance with a vibrant culture built on respect, equality, wellness and opportunity. We're an innovative organization that's small enough to be agile and big enough to make a difference in our industry. Our flexible workplace is continuously evolving to ensure all employees feel: Comfortable bringing their whole selves...

  • Oracle developer

    2 weeks ago

    Chicago, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle developer Contract: Chicago, Illinois, US Salary: $68.00 Per Hour Job Code: 348598 End Date: 2024-05-23 Days Left: 5 days, 3 hours left Apply Day To Day Responsbilities: 80% of this role will be hands-on development on existing data systems. 20% of the role will be dealing with production issues,...

  • Oracle developer

    2 weeks ago

    Chicago, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle developer Contract: Chicago, Illinois, US Salary: $68.00 Per Hour Job Code: 348598 End Date: 2024-05-23 Days Left: 4 days, 3 hours left Apply Day To Day Responsbilities: 80% of this role will be hands-on development on existing data systems. 20% of the role will be dealing with production issues,...

  • Oracle developer

    2 weeks ago

    Chicago, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle developer Contract: Chicago, Illinois, US Salary: $68.00 Per Hour Job Code: 348598 End Date: 2024-05-23 Days Left: 3 days, 3 hours left Apply Day To Day Responsbilities: 80% of this role will be hands-on development on existing data systems. 20% of the role will be dealing with production issues,...

  • Oracle developer

    1 week ago

    Chicago, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle developer Contract: Chicago, Illinois, US Salary: $68.00 Per Hour Job Code: 348598 End Date: 2024-05-23 Days Left: 1 days, 3 hours left Apply Day To Day Responsbilities: 80% of this role will be hands-on development on existing data systems. 20% of the role will be dealing with production issues,...

  • SQL Database Administrator

    5 days ago

    Chicago, United States TechCoreGlobal Full time

    **Title: SQL DBA** **Location: Chicago, IL (Onsite - Open for relocation )** **Good SQL DBA skills, having some experience of doing TDE data base encryption & automations in the DBA space.** **Responsibilities**: - Manage and maintain SQL databases including PostgreSQL, Oracle, DB2, MySQL, and Microsoft SQL Server. - Implement encryption protocols to...

  • Senior Oracle EBS DBA

    3 weeks ago

    Chicago, United States CyberTec Full time

    Only USC/GC USG Corporation Senior Oracle EBS DBA Chicago, IL- Hybrid 6+ Month Contract Phone then Video $57-60/hr on C2C Job Description: The Senior Oracle Applications DBA's role is responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems. The position is responsible for researching and troubleshooting...

  • Oracle EBS Techno-Functional Consultant

    2 weeks ago

    Chicago, United States Sysmind, LLC Full time

    Job Title - Oracle EBS Techno-Functional Consultant - Purchasing, Sourcing and iSupplier portal Location Chicago, IL Job Description: Provide Techno-functional expertise on projects and initiatives involving Oracle ERP Experience in requirement discussion, design, development, testing, and implementation of applications using Oracle Applications...

  • Snowflake/Oracle Data Architect

    3 days ago

    Chicago, United States Delta System & Software, Inc. Full time

    Position: Snowflake/Oracle Data Architect Duration: 12+ monthsLocation: Chicago, IL (3 Days/week – Hybrid) - Local candidate onlyUSC/GC/H4EAD/L2EAD/TN Permit who are willing to work on W2 can apply for this jobJob Responsibilitiesyears of experience in data engineering designing, implementing and maintaining efficient data platformshave strong experience...

  • Snowflake/Oracle Data Architect

    2 days ago

    Chicago, United States Delta System & Software, Inc. Full time

    Position: Snowflake/Oracle Data Architect Duration: 12+ monthsLocation: Chicago, IL (3 Days/week – Hybrid) - Local candidate onlyUSC/GC/H4EAD/L2EAD/TN Permit who are willing to work on W2 can apply for this jobJob Responsibilitiesyears of experience in data engineering designing, implementing and maintaining efficient data platformshave strong experience...

  • Senior SQL Reports Developer

    1 month ago

    Chicago, United States Alert IT Solutions Full time

    Job DescriptionJob DescriptionSenior SQL Report Developer Description:A Senior SQL Report Developer is responsible to participate in the analysis, build, and test of software components for data migration solutions. Responsible for developing SQL databases and writing applications to interface with SQL databases. Development often consists of designing...

  • Ab Initio/Teradata Sql/Oracle Developer

    5 days ago

    Chicago, United States The Dignify Solutions LLC Full time

    Technical/Functional Skills •Linux & Basic ksh/shell scripting; understanding of SFTP •Oracle & Ansii SQL is a must, Teradata SQL knowledge is a plus •Experience in database software solutions and Restful services is highly desired; •Excellent analytical skills, passion for pinning down technical issues and solving problems. Roles & Responsibilities...

  • Junior Database Developer

    2 months ago

    Chicago, United States Cogent Data Solutions LLC Full time

    Job Description We are seeking a talented Oracle Database Developer who has experience in performing the following activities. Strong hands-on experience in in Oracle SQL and PL/SQL development in 11g or 12c environment using SQL Developer TOAD and other tools. Analyze user requirements and translate into database requirements and implement in database...

  • Oracle Developer

    2 weeks ago

    Chicago, United States Experis Full time

    Role : Oracle Database Developer Location : Chicago IL (Hybrid Remote) Term : W2 Contractor - CANNOT work Corp to Corp (C2C) Compensation : Negotiable Summary : We invite you to join the GIS team as an Oracle DB Developer. We are a tight-knit, supportive community passionate about delivering the best experience for our customers while remaining sensitive...

  • Oracle Developer

    5 days ago

    Chicago, United States Experis Full time

    Role : Oracle Database Developer Location : Chicago IL (Hybrid Remote) Term : W2 Contractor - CANNOT work Corp to Corp (C2C) Compensation : Negotiable Summary : We invite you to join the GIS team as an Oracle DB Developer. We are a tight-knit, supportive community passionate about delivering the best experience for our customers while remaining sensitive...

  • Oracle Developer

    5 days ago

    Chicago, United States Manpower Group Inc. Full time

    Role: Oracle Database Developer Location: Chicago IL (Hybrid Remote) Term: W2 Contractor - CANNOT work Corp to Corp (C2C) Compensation: Negotiable Summary: We invite you to join the GIS team as an Oracle DB Developer. We are a tight-knit, supportive community passionate about delivering the best experience for our customers while remaining sensitive to...

  • Junior Database Developer

    1 month ago

    Chicago, Illinois, United States Cogent Data Solutions LLC Full time

    Job Description We are seeking a talented Oracle Database Developer who has experience in performing the following activities. Strong hands-on experience in in Oracle SQL and PL/SQL development in 11g or 12c environment using SQL Developer TOAD and other tools. Analyze user requirements and translate into database requirements and implement in database code....