19+ Oracle SQL Developer Jobs in India

·      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.

Snowflake SRE JD

Your Role Accountabilities

• Primarily responsible for administrating Snowflake environments on AWS
• Identify, tune, and fix the performance issues on priority.
• Diagnose and troubleshoot Snowflake related errors and work with team to raise support tickets, follow ups and help to resolve them.
• Implement security, roles, users and privileges using the best practices.
• Provide database/objects recovery as need on basis.
• Design, identify and implement high performing and highly available data warehouse solutions.
• Create database, schema, tables, views, data sharing
• Create Snowflake utilization and capacity/cost plans, identifies, and provide solution for abnormalities.
• Proactively identify, design, and implement process improvements like automating manual processes
• Stay up-to-date with the latest features and best practices in Snowflake administration
• Follow existing database runbooks, create and maintain new runbooks for new and improved processes
• Provide 24X7 On-call support by participating in rotation schedule.

Qualifications & Experiences

• Bachelor's degree in computer science, information systems, or information technology.
• 10+ years of experience as a database administrator.
• Minimum 5+ years of hands-on administration experience, from setting up the Snowflake environments to successfully administering it (AWS preferred)
• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting, Python etc.
• Some experience with AWS with knowledge of S3, EC2, VPC, IAM, Security, Networking etc.
• Ability and experience with the development of processes and procedures to standardize Database configuration
• Extensive experience with implementation and maintenance of Disaster Recovery and High availability.
• Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious.
• Ability to provide technical documentation and project plans for technical staff members.
• Excellent communication, presentation, and customer relationship skills.
• Excellent organizational and time management skills to handle multiple tasks simultaneously
• Ability to provide 24/7 support.

• 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

Senior Database (PL/SQL)

Work Experience: 8+ Years

Number of Vacancies: 2

Location:

CTC: As per industry standards

Job Position: Oracle PLSQL Developer.

Required: Oracle Certified Database Developer

Key Skills:

• Must have basic knowledge in SQL Queries, Joins, DDL, DML, TCL, Types, Object, Collection Developer. Basic Oracle PLSQL programming experience (Procedures, packages, functions, exceptions.
• Develop, implement, and optimize stored procedures and functions using PLSQL
• Writing basic Queries, Package, Procedures, Functions, Triggers, Ref Cursors, Using Oracle 11g to 19c features, including triggers, stored procedures, queries, SQL Code, and design (stored procedures, functions, packages, tables, views, triggers, indexes, constraints, collections, bulk collects, etc..).
• Must have basic knowledge in PL/SQL Developer tool.
• Basic knowledge of MySql & Mongo DBA
• Strong communication skills
• Good interpersonal and teamwork skills
• PL/SQL, stored, procedure, functions, trigger
• Bulk Collection
• Utl_file
• Materilized View
• Performance handling
• Usage of Hint in Queries
• JSON (json object, json table, json queries)
• BLOB CLOB concept
• External table
• Dynamic SQL

Please get to know about us by visiting http://www.peoplefirst.co.in/" target="_blank">www.peoplefirst.co.in 

We have a job opportunity for the role of "Outsystems Developer" in one of the fast-growing Japanese-based Start-Up Companies.

Job Location: Chennai / Coimbatore / Bhubaneswar

Job Description:

Experience – 8 – 10 years

Location - NCR

Roles and Responsibilities:

System Analyst

The individual in this role will gather, document, and analyze client functional, transactional, and insurance business requirements across all insurance functions and third-party integrations. System Analyst will also work within a cross-functional project team to provide business analytical support and leadership from the business side.  The individual will play a highly visible, client-facing, and the consultative role and have the ability to offer system solutions to enhance client implementations and transform client workflow and business processes. Individual should be very good in mapping business functions / attributes with the Insurance rules and data.

Skills Required:

• A successful candidate in this role must:
• Good hands-on skills in Oracle, PL/SQL, TSQL
• Object oriented knowledge should be good
• Have Functional knowledge on P & C
• Overall Tech - 60% and Functional - 40%

Primary Skills:

• Good Data Mapping knowledge, RDBMS / SQL Knowledge

Secondary Skills:

• Oracle Big+

Job Title: Oracle PL/SQL Developer

Qualification: (B.E./B.Tech/ Masters in Computer or IT)

Years of Experience: 3 – 7 Years

No. of Open Positions – 3

Job Location: Jaipur

1. Proven hands-on Database Development experience
2. Develop, design, test and implement complex database programs
3. Strong experience with oracle functions, procedures, triggers, packages & performance tuning,
4. Ensure that database programs are in compliance with V3 standards. 
5. Hands-on development using Oracle PL/SQL.
6. Performance tune SQL's, application programs and instances. 
7. Evaluation of new and upcoming technologies.
8. Providing technical assistance, problem resolution and troubleshooting support.

Job Description & Responsibilities:

Selected engineer's day-to-day responsibilities include:

• Performs Database Administration tasks in Oracle & MS/MY SQL. Also performs basic DBA tasks in

SQL Server and DB2 environments as necessary.

• Designs and builds simple to complex database structures from data models.

• Installs, configures and patches Oracle.

• Implements HA and DR systems using Data guard and RAC.

• Builds and manages Data Guard Physical/Logical Standby Databases using Data Guard Broker

• Provides rotating 24x7 on-call support for company's Oracle, SQL Server, and DB2 environments as

necessary.

• Participates in design reviews as required to ensure database design meets application

requirements.

• Designs, maintains, documents and executes database utilities to provide information regarding

database activity.

• Proactively performs database monitoring and performance tuning tasks.

• Identify and provide solutions to performance issues in multiple database environments.

• Provides automation to standard DBA tasks. Able to develop scripts on UNIX and Windows

platforms as necessary.

• Reviews and enforces adherence to the company's Architecture, as well as database design and

usage standards.

• Understands database high availability technologies and guides the company in implementing

appropriate solutions.

• Performs other duties as assigned.

Location : Chennai, Tamil Nadu

Joining : Immediate – 15 days

Education, Experience & other requirements

• B.S. degree from an accredited university.

• Must have solid Oracle RAC , Golden Gate & Data Guard experience.

• 3+ years of extensive experience with Oracle database installation / configuration best practices

and Database upgrade/migration approaches.

• Experience installing, building, upgrading and supporting Oracle RAC environment, ASM,

Grid/Cluster.

• In-depth knowledge and hands-on experience in the installation, configuration and

troubleshooting of Oracle products and patches, including Oracle 12c, RAC, ASM, Clusterware,

GoldenGate, Dataguard, Oracle Database Appliance (ODA), Oracle Enterprise Manager 12c.

• Experience in Oracle 12c RAC based environment - architecture, installation, building, upgrading

and maintenance of Oracle RAC based environment in production.

• Extensive experience in Oracle DataGuard replication and physical standby for Disaster recovery

• Working experience of Oracle Database Appliance.

• Strong knowledge of OEM 12C grid monitoring configuration.

• Strong working experience with RMAN configuration, Job maintenance and backup & recovery

• Experience in database problem identification, problem diagnosis and resolution.

• Experience in building data architecture models and enforcing enterprise architecture standards

and guidelines.

• Excellent communication – ability to explain a technical problem to management.

• Ability to work on high performing teams and deliver under pressure situations.

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.

Who we are looking for

A candidate who can design, build and configure applications to meet business process and application requirements.

Key Role Requirements:

• Experience in Java-J2EE Development
• Hands-on experience in Struts (Core Java, JSP, Servlets, EJB) framework.
• Hands-on experience in Oracle SQL, Procedures
• Hands-on experience in Spring boot, Spring batch
• Should have worked on application servers like IBM WAS / Jboss / Web logic.
• Knowledge of basic Linux commands and BIRT reporting tool is an added advantage.
• Knowledge in SVN or any other version control is an added advantage.
• Knowledge in Build tool like ANT, Maven is an added advantage
• Strong problem solving and analytical capabilities.

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

Looking for Part time candidate job support having good skills in python, hadoop, oracle and perl .

Working hours - 2-3 hrs daily work for 1year payment from 200-700 whatsapp +1 mad C00  Vwxe your details