8+ Oracle SQL Developer Jobs in Bangalore (Bengaluru) | Oracle SQL Developer Job openings in Bangalore (Bengaluru)

·      Problem-Solving Skills, should be able to convert Idea on Paper to Code

·      Bachelor’s degree in computer science or related field, or equivalent professional experience.

·      0 - 4 years of database experience (Oracle SQL, PL/SQL)

·      Proficiency in Oracle, with Hands-on experience in database design

·      Creation & implementation of data models.

·      Strong experience with Oracle functions, procedures, triggers, packages.

·      Willing to learn, grasp & quickly adapt needed cutting-edge tools & technologies in shorter timeframe.

·      Should be able to write basic Procedures & Functions.

• Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
• Develop Reports, Charts and Forms using built-in UI components
• Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
• Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
• Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
• Inspect / Debug the code logic using the browser developer tools
• Deploy Authentication and Authorization for the modules as per requirement
• Build features and applications with a mobile responsive design (Not mandatory)
• Migrate application and DB objects from DEV to TEST/PROD environments.
• Mandatory to work from Bosch Bangalore office from the start

Mandatory and Optional Skills

Sr. No.

Technical Skills

Mandatory /Good to have

Min Years of hands on Exp in this skill

1

Oracle Apex

Mandatory

3 Yrs

2

Oracle SQL, PL/SQL, Oracle DB Models/Objects

Mandatory

3-5 Yrs

3

Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)

Mandatory

3

4

JavaScript, JQuery, AJAX, CSS and HTML5

Knowledge

1-2 Yrs

5

Data and UI integration with external (Oracle & Non-Oracle) systems 

Knowledge

3 Yrs

• Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
• Develop Reports, Charts and Forms using built-in UI components
• Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
• Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
• Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
• Inspect / Debug the code logic using the browser developer tools
• Deploy Authentication and Authorization for the modules as per requirement
• Build features and applications with a mobile responsive design (Not mandatory)
• Migrate application and DB objects from DEV to TEST/PROD environments.
• Mandatory to work from Bosch Bangalore office from the start

Mandatory and Optional Skills

Sr. No.

Technical Skills

Mandatory /Good to have

Min Years of hands on Exp in this skill

1

Oracle Apex

Mandatory

3 Yrs

2

Oracle SQL, PL/SQL, Oracle DB Models/Objects

Mandatory

3-5 Yrs

3

Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)

Mandatory

3

4

JavaScript, JQuery, AJAX, CSS and HTML5

Knowledge

1-2 Yrs

5

Data and UI integration with external (Oracle & Non-Oracle) systems 

Knowledge

3 Yrs

Technical-Requirements: 

• Bachelor's Degree in Computer Science or a related technical field, and solid years of relevant experience. 
• A strong grasp of SQL/Presto and at least one scripting (Python, preferable) or programming language. 
• Experience with an enterprise class BI tools and it's auditing along with automations using REST API's. 
• Experience with reporting tools – QuickSight (preferred, at least 2 years hands on). 
• Tableau/Looker (both or anyone would suffice with at least 5+ years of hands on). 
• 5+ years of experience with and detailed knowledge of data warehouse technical architectures, data modelling, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures and hands-on SQL coding. 
• 5+ years of demonstrated quantitative and qualitative business intelligence. 
• Experience with significant product analysis based business impact. 
• 4+ years of large IT project delivery for BI oriented projects using agile framework. 
• 2+ years of working with very large data warehousing environment. 
• Experience in designing and delivering cross functional custom reporting solutions. 
• Excellent oral and written communication skills including the ability to communicate effectively with both technical and non-technical stakeholders. 
• Proven ability to meet tight deadlines, multi-task, and prioritize workload. 
• A work ethic based on a strong desire to exceed expectations. 
• Strong analytical and challenge process skills.

Key Job Responsibilities:

• He/She is a responsive team player who can proactively contribute for building technical

strategies for applications and systems by promoting an understanding of the technology and business roadmap.

• He /she is someone who thrives in a fun, fast-paced, dynamic, startup-like environment.
• Work very closely with various business stakeholders to drive the execution of multiple

business plans and technologies.

• Work closely with Product, Design, and Marketing to conceive features, plan projects, and build roadmaps
• Prior experience with scalable Architecture managing team of minimum 5 engineers and

coaching, mentoring while maintaining a role with code development.

• Proven history of contributing to product strategy and shipping products with multi-functional teams.
• Highly involved in recruitment while building team also leading app development for both platforms.
• Promote and support company policies, procedures, mission, values, and standards of ethics and integrity.

Minimum Qualification:

• Total of 10+ years experience
• Hands-on working on Java ( {Language understanding - Java 8, Lambdas, Collections,

• Worked on REST frameworks/libraries like Spring MVC, Spring Boot, Dropwizard,  REST popular frameworks & libraries}, JVM, GC tuning, performance tuning) Express etc

• Experience in Microservices architecture is a must.
• Working on public clouds such as AWS, GCP, Azure etc is preferred
• Worked on Relational data stores viz. MySQL, Oracle, or Postgres.
• Worked on Non-relational data stores viz. Cassandra, HBase, Couchbase, MongoDB, etc
• Worked on caching infra viz. Redis, Memcached, Aerospike, Riak, etc
• Worked on Queueing infra viz. Kafka, RabbitMQ, ActiveMQ etc

Position Overview

Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex

and experience in Apex Upgrade. Should have a good working knowledge of Oracle

Applications(R12).

Skills

1-2 end to end implementation/development project

Strong detail, quality, and solution orientation

5+ years of experience designing and implementing technical solutions that are aligned with

business strategy

5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL

5+ years of Oracle APEX experience

5+ years experience in Oracle Databases

5+ years experience using PL/SQL

5+ years of JavaScript, HTML, CSS, and REST services

Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions

Ability to work on SQL performance issues

Ability to think critically and solve complex issues

Ability to work independently, while engaging the customer and providing information to the team

Strong ability to communicate both verbally and in writing with internal and external teams

Ability to prioritize across multiple projects and meet deadlines

Experience adapting in a dynamic work environment

Experience working in a customer-focused environment

Ability to troubleshooting issue

Proficiency in analysis, design, development, testing, implementation, and maintenance of

applications in Oracle Application Express (APEX).

Excellent conceptual knowledge of Oracle 11g.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,

packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,

Dynamic SQL.

Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

Essential duties and responsibilities include the following.

• Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
• Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
• Convert complex business requirements into technical specifcations to build scalable and reliable data solutions 
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
• Flexibility to work after office hours for any production issue or production deployment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications include:

• 4+ years of database and backend development experience
• Good understanding of database systems and architectures
• Expertise in writing complex SQL queries and stored procedures
• Hands on experience with RDBMS and NoSQL data stores like  MySQL and MongoDB
• Experience working with Python scripting and application development
• Experience working with Cloud applications and data stores like AWS RDS is a plus
• In-depth understanding of data management and ETL processes

Key Responsibilities & Job Duties

● To provide functional support for our ERP

Finance applications (Oracle eBusiness Suite)

○ Assist users in case of question

○ Manage functional requests

● Train users to keep the right level of skill

○ To organize audits of the use of systems

○ Detect and collect issues

○ Implement action plan and coordinate actions

● To manage enhancements in accordance with the procedures which apply in the department

○ Collect enhancements from users

○ Challenge the user requirements

● Define priorities

○ Write functional specifications and coordinate developments with the technical team

● Test and train the users

○ Regularly communicate to the users the status of the enhancement

○ Report activity to the management

○ Collaborate with functional support in other zones to share information

○ Optionally, may manage some projects

Key Technical & Functional Competencies
● Functional competencies

○ Strong Business processes: Finance

● Technical competencies

○ Good Knowledge of Oracle SQL

○ Strong Oracle eBusiness Suite

Modules: AP, AR, GL, FA (At least at a professional for two Modules)

○ Basic knowledge of Oracle eBusiness Suite Modules: INV, PO, OE, WSH is preferable