Oracle Pl/Sql Developer

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

Job Type: Full-time

Salary: $98,607.30 - $118,752.88 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Schedule:

• 8 hour shift

Experience:

• Oracle: 10 years (Required)
• PL/SQL: 10 years (Required)
• Data warehouse: 10 years (Required)
• Exadata: 8 years (Required)

Work Location: On the road