32 Oracle SQL Developer Jobs in India

Job Title : Oracle EBS Functional & Automation Testing Engineer

Experience : 8+ Years

Location : Remote

Employment Type : Full-Time

Position Overview :

We are looking for an experienced Oracle EBS Finance Functional & Automation Testing Engineer with strong expertise in Oracle EBS R12 / R12.2, financial business processes, and test automation.

The candidate should be skilled in building reusable automation frameworks and validating end-to-end finance workflows across UI, API, and database layers.

Strong experience with Playwright, TypeScript / JavaScript, Oracle SQL, and Oracle Forms automation is highly preferred.

Mandatory Skills :

Oracle EBS R12 / R12.2 Finance (GL, AP, AR, Fixed Assets, Cash Management), Playwright, TypeScript / JavaScript, Oracle Forms Automation, Oracle SQL, REST / SOAP API Testing, Automation Framework Development, Procure-to-Pay (P2P), Order-to-Cash (O2C), and Record-to-Report (R2R).

Key Responsibilities :

• Design and maintain automated tests for Oracle EBS Finance modules : GL, AP, AR, Fixed Assets, and Cash Management.
• Develop automation frameworks using Playwright with TypeScript / JavaScript.
• Automate Oracle Forms-based workflows using SikuliX, OpenCV, PyAutoGUI, or equivalent tools.
• Perform REST / SOAP API testing and validate financial transactions using Oracle SQL.
• Automate end-to-end finance processes, including Procure-to-Pay (P2P), Order-to-Cash (O2C), and Record-to-Report (R2R).
• Integrate automation suites with Git and CI/CD pipelines; implement test reporting and failure analysis.
• Collaborate with functional and technical teams to improve test coverage, framework stability, and automation quality.
• Explore AI-assisted testing, test-case generation, and intelligent / self-healing automation.

Required Skills :

• 8+ years of experience in software quality engineering and automation testing.
• Strong hands-on experience with Oracle EBS R12 / R12.2 Finance modules and financial business processes.
• Expertise in Playwright with TypeScript / JavaScript and reusable automation framework development.
• Experience with Oracle Forms and EBS web / HTML applications.
• Strong knowledge of Oracle SQL, database validation, REST / SOAP APIs, and EBS integrations.
• Experience with Git and CI/CD tools such as Jenkins, GitHub Actions, or GitLab CI/CD.
• Strong analytical, troubleshooting, communication, and problem-solving skills.

Good to Have :

• SikuliX, OpenCV, or PyAutoGUI for Oracle Forms automation.
• Python / Node.js database connectivity, Selenium / Cypress, and automated test reporting tools such as Allure.
• Financial reconciliation, SFTP / XML / CSV integrations, concurrent programs, and batch processing.
• Docker, performance testing, Agile / Scrum, and AI-powered quality engineering tools.

Priority : Candidates with strong hands-on experience in Oracle EBS Finance + Playwright / TypeScript automation + Oracle Forms automation.

Job Title : Senior AWS DevSecOps & AI Platform Engineer

Experience Required : 5+ Years in AWS / Cloud Engineering

Terraform Experience : 4+ Years

Location : Gurugram

Work Mode : Onsite

Employment Type : Full-time

About the Role :

We are looking for an experienced Senior AWS DevSecOps & AI Platform Engineer with strong expertise in AWS cloud infrastructure, Kubernetes, Infrastructure as Code (IaC), CI/CD automation, cloud security, and database administration.

The ideal candidate will be responsible for designing and maintaining secure, scalable, reliable, and cost-efficient cloud environments while supporting microservices-based applications and implementing DevSecOps best practices. The role also involves building and deploying AI agents using Amazon Bedrock and Bedrock AgentCore, along with managing enterprise development and collaboration tools.

Mandatory Skills :

AWS (EC2, EKS, ECS, Lambda, S3, CloudWatch), Kubernetes, Terraform, Jenkins, Bitbucket Pipelines, CI/CD, DevSecOps, AWS Security Services (IAM, WAF, GuardDuty, Security Hub, KMS, Secrets Manager), Microservices, Helm, PostgreSQL, Oracle SQL, RDS, Jira, Confluence, Amazon Bedrock, Bedrock AgentCore, AWS Networking, and Cloud Cost Optimization.

Key Responsibilities :

• AWS Cloud Infrastructure : Design, implement, and maintain AWS infrastructure with a focus on scalability, availability, security, reliability, and cost optimization.
• Microservices & Containerization : Manage and support distributed microservices architectures, including deployment, monitoring, troubleshooting, performance optimization, service meshes, and API gateways.
• Kubernetes Administration : Administer and optimize Kubernetes clusters, including Amazon EKS and self-managed environments, covering upgrades, networking, workload management, scaling, and resource optimization.
• Cloud Security & Compliance : Implement and manage AWS security services, including IAM, GuardDuty, Security Hub, WAF, KMS, Secrets Manager, AWS Config, and CloudTrail.
• DevSecOps Implementation : Integrate security testing, vulnerability scanning, container security, and compliance-as-code tools into CI/CD pipelines.
• CI/CD & Source Control : Manage Bitbucket repositories, branching strategies, permissions, and Bitbucket Pipelines. Build and optimize Jenkins pipelines using declarative and scripted approaches.
• Infrastructure as Code : Develop and maintain Terraform modules, manage remote state and workspaces, detect infrastructure drift, and implement reusable infrastructure provisioning practices.
• Database Administration : Provision, manage, secure, and optimize AWS RDS databases, particularly PostgreSQL and Oracle, including backups, replication, patching, performance tuning, and migrations.
• Jira & Confluence Administration : Manage projects, workflows, automation rules, permissions, user access, spaces, schemes, and plugins.
• Monitoring & Reliability : Define and monitor SLIs, SLOs, and SLAs; implement observability best practices; and participate in incident management, root cause analysis, and post-incident reviews.
• AI Agent Development : Design, build, and deploy AI agents using Amazon Bedrock and Bedrock AgentCore, including agent runtime, memory, tools, gateway integration, identity and access management, guardrails, and lifecycle management across environments.
• Cloud Connectivity : Support hybrid cloud connectivity using AWS Direct Connect, VPN, and Transit Gateway.
• Cost Optimization : Apply FinOps practices to monitor cloud expenditure, optimize resource utilization, and improve infrastructure efficiency.
• API Integrations : Integrate third-party APIs while implementing authentication, rate limiting, error handling, and webhook management.

Required Skills & Qualifications :

• 5+ years of hands-on experience with AWS cloud services, including EC2, ECS, EKS, Lambda, ALB, CDN, S3, CloudWatch, Amazon Bedrock, and Bedrock AgentCore.
• Strong understanding of AWS networking, multi-account strategies, landing zone architecture, and hybrid connectivity.
• 4+ years of practical experience with Terraform, including module development, remote state management, workspaces, drift detection, and state operations.
• Extensive experience administering Kubernetes, preferably Amazon EKS, including Helm, Kustomize, operators, RBAC, network policies, autoscaling, and multi-tenancy.
• Proven experience managing distributed microservices, service meshes, API gateways, and inter-service communication.
• Strong knowledge of AWS security services, including IAM, Service Control Policies (SCPs), WAF, KMS, Secrets Manager, AWS Config, and CloudTrail.
• Experience implementing least-privilege access, zero-trust principles, and cloud security compliance controls.
• Hands-on experience integrating DevSecOps tools such as Snyk, Trivy, Checkov, and SonarQube into CI/CD pipelines.
• Understanding of OWASP security principles, CIS benchmarks, vulnerability management, and container security.
• Proficiency in Bitbucket repository administration, branch permissions, and YAML-based Bitbucket Pipelines.
• Strong experience developing and maintaining Jenkins CI/CD pipelines, shared libraries, plugins, and build agents.
• Experience administering AWS RDS databases, particularly PostgreSQL and Oracle SQL, including backup, replication, performance tuning, and migration activities.
• Experience administering Jira and Confluence, including workflows, permissions, automation, and plugin management.
• Working knowledge of Azure services, particularly Web Apps and Logic Apps/Workflows.
• Practical experience with Amazon Bedrock, including model invocation, guardrails, and AI agent development and deployment using Bedrock AgentCore.
• Understanding of third-party API integration, authentication mechanisms, rate limiting, error handling, and webhook management.
• Familiarity with FinOps practices and cloud cost optimization.

Good-to-Have Skills :

• Additional Azure experience, including networking, Azure SQL Managed Instance, and Azure Kubernetes Service (AKS).
• Hands-on experience with AI-driven Development Lifecycle (AI-DLC) methodologies and tools such as Kiro.

Relevant certifications, such as :

• AWS Certified Solutions Architect
• AWS Certified DevOps Engineer – Professional
• AWS Machine Learning or Generative AI certifications
• Certified Kubernetes Administrator (CKA)
• HashiCorp Terraform certifications

Ideal Candidate Profile :

The ideal candidate is a hands-on cloud and DevSecOps professional who can manage enterprise-scale AWS infrastructure, automate deployments, strengthen security controls, troubleshoot complex distributed systems, and support AI agent development. Strong problem-solving skills, an automation-first mindset, and the ability to collaborate across development, security, and infrastructure teams are essential.

We are looking for a skilled Oracle Developer with strong expertise in PL/SQL development and database management. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining robust Oracle database solutions to support business applications and operations.

Key Responsibilities

Design, develop, test, and maintain robust PL/SQL code including stored procedures, functions, packages, triggers, and views.

Participate in database design and development activities ensuring efficient database structure and performance.

Optimize SQL queries and PL/SQL code for maximum efficiency and performance.

Identify, troubleshoot, and resolve database performance issues.

Develop and implement data migration, transformation, and ETL processes using Oracle tools and PL/SQL scripts.

Provide support for existing database applications and resolve issues within defined SLAs.

Collaborate with application developers, business analysts, and stakeholders to understand business requirements and translate them into technical solutions.

Maintain proper documentation for database designs, code, and technical processes.

Follow best practices in database development including code reviews, version control, and coding standards.

Required Skills & Qualifications

Bachelor’s degree in Computer Science, Information Technology, or a related field.

3–5 years of hands-on experience as an Oracle Developer.

Strong expertise in Oracle PL/SQL development.

Experience in writing complex stored procedures, functions, packages, and triggers.

Strong understanding of database schema design, tables, views, indexes, and constraints.

Experience with data migration, ETL processes, and data transformation.

Knowledge of Oracle backup and recovery techniques including RMAN.

Strong analytical and problem-solving skills.

Good communication and collaboration abilities.

Ability to work independently and manage multiple tasks effectively.

Preferred Skills

Experience working in performance tuning and query optimization.

Familiarity with version control and development best practices.

Exposure to Oracle tools and enterprise database environments.

Why Join Us?

Opportunity to work on enterprise-grade Oracle database solutions.

Collaborative and growth-oriented work environment.

Exposure to challenging projects and modern database practices.

Key Responsibilities

Develop, customize, and maintain technical components in Oracle E-Business Suite

Design and develop:

• Reports
• Interfaces
• Conversions
• Extensions

Develop and maintain:

• PL/SQL packages, procedures, functions, triggers
• Oracle Forms
• Oracle Reports
• XML/BI Publisher Reports
• Build and support integrations between Oracle E-Business Suite and third-party applications/APIs

Work on inbound/outbound interfaces using:

• APIs
• Open Interface Tables
• Web Services
• SQL Loader
• Customize and support Oracle Workflow processes and approval mechanisms

Troubleshoot production issues and resolve technical defects

Perform performance tuning of SQL queries, reports, and database objects

Required Skills

Strong experience in Oracle E-Business Suite

Advanced knowledge of:

• PL/SQL
• Oracle Forms
• Oracle Reports
• XML Publisher / BI Publisher
• Oracle Workflow
• SQL Loader
• Shell Scripting
• REST/SOAP APIs

Strong understanding of Oracle EBS modules such as:

• Oracle Financials
• Oracle Procurement
• Oracle HRMS
• Oracle Inventory Management

Experience working with US clients/offshore teams

Ability to work independently in overlapping US shift hours (3 PM - 11 PM IST)

Role & Responsibilities:

Develop and deliver defect free, web-based applications using C#, ASP.Net and Oracle as per the specifications provided by the Business Analysts.

• Read and Understand the Functional and Technical Specification and have complete understanding of the work before commencing the work
• Design, develop, and unit test applications in accordance with established standards.
• Adhering to high-quality development principles while delivering solutions on-time.
• Adhere to the Quality Management Standards established in the organization.
• Understanding of the SDLC process defined in the organization and follow it without any deviation
• Providing third-level support to the support tickets raised by the business users
• Analyzing and resolving technical and application Logic related problems
• Ensure high performance in the application by developing efficient code

Ideal Candidate:

• Strong .NET Senior Software Engineer Profile
• Must have 5+ years of hands-on development experience with C#.NET, ASP.NET, ADO.NET.
• Must have 3+ years of experience in web application development using HTML, CSS, JavaScript/jQuery
• Must have strong experience in Writing Complex SQL Queries, Stored Procedures, Functions using Oracle / SQL Server.
• Must have experience in designing, developing, and unit testing applications with SDLC compliance
• Experience with AJAX, Crystal Reports, and front-end validations using JavaScript/jQuery.
• ME/MTech (CS) or BE/BTech (CS).

Company Name : Enlink Managed Services

Company Website : https://enlinkit.com/

Location : Turbhe , Navi Mumbai

Shift Time : 12 pm to 9:30 pm

Working Days : 5 Days Working(Sat-Sun Fixed Off)

SQL Developer 

Roles & Responsibilities :

Designing Database, writing stored procedures, complex and dynamic queries in SQL

Creating Indexes, Views, complex Triggers, effective Functions, and appropriate store procedures to facilitate efficient data manipulation and data consistency

Implementing database architecture, ETL and development activities

Troubleshooting data load, ETL and application support related issues

Demonstrates ability to communicate effectively in both technical and business environments

Troubleshooting failed batch jobs, correcting outstanding issues and resubmitting scheduled jobs to ensure completion

Troubleshoot, optimize, and tune SQL processes and complex SQL queries

Required Qualifications/Experience

4+ years of experience in the design and optimization of MySQL databases

General database development using MySQL

Advanced level of writing stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks

Troubleshoot, optimize, and tune SQL processes and complex SQL queries

Experienced and versed in creating sophisticated MySQL Server databases to quickly handle complex queries

Problem solving, analytical and fluent communication

Key Skills & Experience:

🔹 #SQL, #OraclePLSQL, #Unix / Perl / Python

🔹 #OracleRDBMS (latest) | #PostgreSQL plus

🔹 DB Objects | Performance Tuning | Analytics

🔹 #UnixLinux, Agile (Scrum, JIRA, Confluence, BitBucket)

🔹 DevOps (UC4, Maven, Jenkins, CI/CD)

🔹 ETL, Data Modeling, Informatica

🔹 Java, Angular/React, Spring Boot, XML, JSON, API Gateway

🔹 #OracleAPEX advantage

Job Description: Oracle BI Publisher Developer

Position Type

• Work Type: Full-time

• Employment Type: Contract

Experience Required

• Minimum 1 year of hands-on experience in:

o Oracle Database: SQL development, performance tuning, data modelling

o Oracle BI Publisher: Report design, template customization, data source integration

Technical Skills

• Mandatory:

o Oracle SQL & PL/SQL

o BI Publisher report development and deployment

o XML and XSLT for template customization

• Preferred:

o Experience with Oracle E-Business Suite or Fusion Applications

o Familiarity with data visualization principles

o Basic understanding of performance metrics and report optimization

Responsibilities

• Design, develop, and maintain BI Publisher reports based on business requirements

• Write and optimize SQL queries for data extraction and transformation

• Collaborate with stakeholders to ensure report accuracy and usability

• Troubleshoot and resolve issues related to data and report performance

• Document technical specifications and maintain version control

We are seeking a highly skilled Sr. Oracle EBS Finance Functional Consultant to join our team. The successful candidate will be responsible for providing functional support and expertise in Oracle E-Business Suite (EBS) Finance modules, including General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, and Purchasing.

Key Responsibilities:

1.     Collaborate with cross-functional teams and stakeholders to gather business requirements and translate them into technical specifications for implementation in Oracle EBS Finance modules.

2.     Provide expertise in the design, configuration, testing, and implementation of Oracle EBS Finance modules.

3.     Identify and troubleshoot issues in Oracle EBS Finance modules, providing timely and effective solutions to minimize business disruptions.

4.     Develop and maintain functional documentation, including business process flows, functional designs, test cases, and training materials.

5.     Deliver training sessions to end-users to ensure the effective adoption and utilization of Oracle EBS Finance modules.

6.     Stay up to date with the latest Oracle EBS Finance functionality and provide recommendations for process improvements and system enhancements.

Requirements:

1.     Bachelor’s degree in finance, Accounting, or a related field.

2.     Minimum of 3-8 years of experience in implementing and supporting Oracle EBS Finance modules.

3.     Strong understanding of accounting principles and financial processes.

4.     Extensive experience in Oracle EBS R12 or above, including functional setup, configuration, and implementation.

5.     Knowledge of Oracle EBS Finance integration points with other modules and third-party systems.

6.     Excellent problem-solving and analytical skills.

7.     Strong communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams and stakeholders.

8.     Ability to work independently and manage multiple projects simultaneously in a fast-paced environment.

9.     Experience with full cycle implementations, upgrades, and support

Preferred Qualifications:

1.     Oracle certifications in EBS Finance modules.

2.     Experience in data migration and conversion.

JD-

Job Title: Full Stack Developer (ASP.NET & MySQL)

Experience Required: 3 to 5 Years

Location: Kalina, Mumbai (Onsite)

Employment Type: Full-Time

About the Role:

We are looking for a skilled and proactive Full Stack Developer with 3 to 5 years of hands-on experience in ASP.NET and MySQL to join our dynamic team in Kalina, Mumbai. This is a fully onsite role, ideal for professionals who enjoy working in a collaborative office environment and are passionate about building scalable web applications.

Key Responsibilities:

• Design, develop, test, and maintain web applications using ASP.NET (MVC/Web API).
• Write clean, scalable, and efficient code for both front-end and back-end development.
• Develop and manage MySQL databases, including design, optimization, and complex queries.
• Collaborate with UI/UX designers, front-end developers, and other stakeholders to deliver seamless user experiences.

Required Skills & Qualifications:

• 3 to 5 years of experience in full stack development.
• Strong proficiency in ASP.NET (MVC, Web API) and C#.
• Solid experience with MySQL database design, queries, and optimization.
• Good understanding of front-end technologies such as HTML, CSS, JavaScript, and jQuery.
• Familiarity with version control tools like Git.

Good to Have (Preferred):

• Experience with front-end frameworks (e.g., Angular, React).
• Knowledge of RESTful API development and integration.
• Understanding of Agile methodologies.

Location & Work Mode:

• Location: Kalina, Mumbai
• Work Mode: Onsite (Work from Office)

Roles and Responsibilities:

• Independently analyze, solve, and correct issues in real time, providing problem resolution end-

to-end.

• Strong experience in development tools, CI/CD pipelines. Extensive experience with Agile.

• Good proficiency overlap with technologies like: Java8, Spring, SpringMVC, RESTful web services, Hibernate, Oracle PL/SQL, SpringSecurity, Ansible, Docker, JMeter, Angular.

• Strong fundamentals and clarity of REST web services. Person should have exposure to

developing REST services which handles large sets

• Fintech or lending domain experience is a plus but not necessary.

• Deep understanding of cloud technologies on at least one of the cloud platforms AWS, Azure or Google Cloud

• Wide knowledge of technology solutions and ability to learn and work with emerging technologies, methodologies, and solutions.

• Strong communicator with ability to collaborate cross-functionally, build relationships, and achieve broader organizational goals.

• Provide vision leadership for the technology roadmap of our products. Understand product capabilities and strategize technology for its alignment with business objectives and maximizing ROI.

• Define technical software architectures and lead development of frameworks.

• Engage end to end in product development, starting from business requirements to realization of product and to its deployment in production.

• Research, design, and implement the complex features being added to existing products and/or create new applications / components from scratch.

Minimum Qualifications

• Bachelor s or higher engineering degree in Computer Science, or related technical field, or equivalent additional professional experience.

• 5 years of experience in delivering solutions from concept to production that are based on Java and open-source technologies as an enterprise architect in global organizations.

• 12-15 years of industry experience in design, development, deployments, operations and managing non-functional perspectives of technical solutions.

Sr Java Developer

Experience: 5+ Years

Location: Navi Mumbai, CBD Belapur

Domain: Banking (Payment Aggregators Project)

Work Schedule: 1st and 3rd Saturdays required, as per banking norms

Education: B.E. or Graduation in Computer Science or related field

Budget- 15 Lacs max fixed

Initial document check list before sharing the profiles.

Education

1. 10th Passing Certificate
2. 10th Mark Sheet
3. 12th Mark Sheet
4. 12th Passing Certificate
5. Convocation Certificate (Mandatory)
6. PG (if completed) Degree Certificate & Passing Certificate

Employment

1. Previous Organization’s Offer Letter
2. Previous Organization’s Appointment Letter
3. Previous Organization’s Experience Letter
4. Resignation Acceptance Mail from Previous Organization

JOB DESCRIPTION

Key Responsibilities:

Application Development: Design, develop, and maintain robust applications using Java, Spring, Spring Boot, Microservices, Hibernate, REST API, and Oracle SQL.

Spring Validation & Security: Implement input validation and manage secure access to resources using Spring Security.

Collaboration: Work hand-in-hand with cross-functional teams to define, design, and deliver innovative features.

Performance Optimization: Ensure peak performance, quality, and responsiveness of applications.

Problem Solving: Identify bottlenecks and bugs, and craft effective solutions.

Code Quality: Maintain high standards of code quality, organization, and automation.

Skills and Qualifications:

Experience: 5+ years in Java development.

Technical Proficiency: Expert in Java, Spring, Spring Boot, Microservices, Hibernate, REST API, Oracle SQL, and Spring Security.

Banking Domain Knowledge: Experience in payment gateway projects is a plus.

Design Patterns: Strong understanding of object-oriented programming and design patterns.

Problem Solver: Excellent analytical skills and ability to thrive in a fast-paced environment.

Key Responsibilities

• Analyze and understand business processes and requirements to develop effective technical solutions.

• Assist in the planning, designing, development, of new applications and enhancements to existing applications.

• Collaborate with IT team members, decision makers, systems owners, and end users to define business requirements and systems goals, and identify and resolve business systems issues.

• Prepare functional specification documents in accordance to new business requirements.

• Ensure compatibility and interoperability of business software applications.

• Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.

• Assist in the deployment of new applications and enhancements to existing applications.

• Identify, assess, and recommend software solutions and implementation partners to management.

• Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.

• Participate and sometimes drive IT projects to ensure that system requirements and data engineering needs are addressed throughout the project life cycle.

• Create systems models including integration points, specifications, diagrams, and charts to provide direction to internal stakeholders and third parties.

• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.

• Provide orientation and training to end users for all modified and new systems.

Qualifications & Experience

• Minimum Bachelor’s degree in Information Technology, Computer Science, or related field.

• Minimum of 5 years of experience in related fields with 3 to 4 years in systems and/or functional analysis.

• Proven experience in analysing, designing, and implementing information systems.

• Strong understanding of business processes and technical systems.

• Hands-on skills in SQL and databases (e.g. Oracle, SQL Server).

Other Prerequisites

• Excellent problem-solving skills and the ability to work under pressure. • Good project management skills.

• Excellent written and oral communication and interpersonal skills.

• Ability to conduct research into systems issues and products as required.

• Ability to communicate ideas in both technical and user-friendly language.

• Highly self motivated and directed.

• Keen attention to detail.

• Proven analytical and creative problem-solving abilities.

• Strong customer service orientation.

• Experience working in a team-oriented, collaborative environment

·      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