CrawlJobs Logo

Production Support - PL/SQL

India, Bangalore · Job Posted May 06, 2026
Apply Position
Job Link Share

Job Description

Design solutions, build, test and maintain efficient, reusable, and reliable WMS, Oracle EBS &Pro*C code. Using standard methodologies, analyze functional and requirement documents to develop technical design specifications. Perform root cause analysis on production issues to Identify bottlenecks and bugs. Identify prevention and resolution actions and drive till implementation. Ability to develop good technical designs with all the required considerations – scalability, performance, architecture. Maintain high level of code quality, SDLC processes and documentation. Strong knowledge of the standard library as specified by ISO and ANSI. Good Knowledge of code versioning tools. Strong analytical and problem solving skills. Willingness to learn and deliver on new technologies as and when the situation arises. Experience in working with global team. Participate actively in conference calls and drive the discussions and meetings. Also work closely with the cross-functional teams on various production issues and projects. Proven ability to estimate work efforts for complex technology implementations, deliver results, and meet deadlines by using good time management skills. Candidate should possess good communication skills. Self-driven, Bottom line oriented and take ownership of tasks.

Job Responsibility

  • Design solutions, build, test and maintain efficient, reusable, and reliable WMS, Oracle EBS & Pro*C code
  • Using standard methodologies, analyze functional and requirement documents to develop technical design specifications
  • Perform root cause analysis on production issues to Identify bottlenecks and bugs
  • Identify prevention and resolution actions and drive till implementation
  • Ability to develop good technical designs with all the required considerations – scalability, performance, architecture
  • Maintain high level of code quality, SDLC processes and documentation
  • Strong knowledge of the standard library as specified by ISO and ANSI
  • Good Knowledge of code versioning tools
  • Strong analytical and problem solving skills
  • Willingness to learn and deliver on new technologies as and when the situation arises
  • Experience in working with global team
  • Participate actively in conference calls and drive the discussions and meetings
  • Also work closely with the cross-functional teams on various production issues and projects
  • Proven ability to estimate work efforts for complex technology implementations, deliver results, and meet deadlines by using good time management skills
  • Candidate should possess good communication skills
  • Self-driven, Bottom line oriented and take ownership of tasks

Requirements

  • 5 to 10 years of experience in WMS, EBS and Pro*C
  • Strong proficiency in WMS, EBS and Pro*C along with programming experience using UNIX/C and Shell scripting
  • Proficient PLSQL experience
  • Integration of ERP Applications with 3rd party systems would be an added advantage

Nice to have

Integration of ERP Applications with 3rd party systems

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Production Support - PL/SQL

8 matching positions

Unix & Sql Production Support Analyst

We are seeking a Unix & SQL Production Support Analyst with strong technical exp...
Location
Location
India , Pune
Salary
Salary:
Not provided
vodafone.com Logo
Vodafone
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2–3 years of experience in Unix and SQL production support projects
  • Strong conceptual and practical knowledge of Unix, Shell scripting, and Oracle PL/SQL syntax
  • Familiarity with data warehouse concepts and ETL features such as high performance and parallelism
  • Knowledge of ticketing tools (e.g., Remedy) and ITIL processes for incident and change management
  • Excellent communication and interpersonal skills to work in a diverse and sometimes ambiguous environment
  • Ability to multi-task, prioritise effectively, and deliver results under pressure
  • Strong problem-solving, analytical, and troubleshooting skills
  • Flexible to work in 24/7 rotational shifts, including weekends and public holidays
Job Responsibility
Job Responsibility
  • Participate in design and architecture for development projects in Unix and SQL
  • Deliver responsibilities from requirements capture to high-level and low-level design, including performance tuning
  • Write, debug, and fine-tune queries and Unix shell scripts
  • Execute scripts and SQL queries, manage sandboxes, and perform version and access management
  • Triage and participate in root cause analysis of data migration issues and implement code fixes
  • Identify bottlenecks and optimise migration processes
  • Monitor production environments, perform health checks, and ensure defect-free deliverables
  • Escalate or interact with relevant teams for resolution of service requests
  • Support SLA fulfilment and compliance with standard processes and practices
What we offer
What we offer
  • Opportunity to work on critical production support projects in a global telecom environment
  • Exposure to ETL, data warehousing, and advanced troubleshooting techniques
  • Collaborative work culture with continuous learning and development opportunities
  • Experience in ITIL-based processes and global customer support
Read More
Arrow Right

L2 Production Support

seeking an experienced Java Developer with L3 Production Support experience to s...
Location
Location
Malaysia , Putrajaya
Salary
Salary:
Not provided
airswift.com Logo
Airswift Sweden
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's or Master's degree in Computer Science, Engineering, or related field
  • 8+ years of extensive knowledge of Java and Spring Boot with a strong understanding of microservices architecture
  • Experience with basic PL/SQL, writing queries, stored procedures, and performance tuning in Oracle
  • Hands-on experience with Shell Scripting and automation in a Linux environment
  • Exposure to Linux environments
  • Experience in the Banking or Financial Services sector
  • Prior exposure to incident management and post-mortem reporting
  • Familiarity with tools like JIRA, ServiceNow, or ELK
  • Strong analytical and debugging skills
  • Ability to work under pressure and with multiple stakeholders
Job Responsibility
Job Responsibility
  • Design, develop, and maintain high-performance applications using Java and Spring Boot for enterprise-level solutions
  • Write efficient, scalable, and maintainable code, ensuring that applications run optimally, leveraging Spring Boot and Java 8+ features
  • Provide Level 3 support for Java-based applications in the banking production environment
  • Develop optimized PL/SQL queries, procedures, and functions to interface with Oracle databases
  • Write Shell Scripts for automating system tasks and deployments in a Linux environment
  • Analyze and resolve production issues with minimal downtime
  • Perform code-level debugging and apply minor fixes or enhancements
  • Work on incident tickets, participate in root cause analysis, and track resolution
  • Develop automation scripts using Shell scripting for logs, restarts, or health checks
  • Perform log monitoring, system checks, and collaborate with infrastructure teams
  • Fulltime
Read More
Arrow Right
New

Senior Software Developer

Our client is looking for a Senior Software Developer for a 12 month contract in...
Location
Location
Canada , North York
Salary
Salary:
554.83 - 590.41 CAD / Day
https://www.randstad.com Logo
Randstad
Expiration Date
June 10, 2026
Flip Icon
Requirements
Requirements
  • 10+ years of experience in SAP BusinessObject (BOBJ) and Crystal Report
  • Other Reporting tools, particularly Cognos and PowerBI would be an asset
  • Database management such as data normalization, relational database structures, table joins, database constraints
  • BO scripting, Unix/Linux shell scripting and tuning
  • BO administration and package creation
  • Informatica or other ETL experience
  • Oracle (19c), SQL, PL/SQL, JSON, XML, optimized database queries, data architecture, data design, modeling and mapping Business intelligence and data analytics, data warehouse design, development and support
  • Database and BO Performance tuning, automation
  • Enhanced CI/CD experience and DevOps methodologies and technologies an asset
  • BO/Crystal report AODA
Job Responsibility
Job Responsibility
  • Develop, test, support and maintain Panorama Business Object (BO) reports
  • Supporting Panorama Immunization, Inventory and Audit reports
  • Provide subject matter expertise to develop and maintain BO tools for development and unit testing
  • Provide Business Objects and Crystal Reports
  • SQL query creation and tuning
  • Provide Business intelligence and data analytics, data warehouse design, development and support
  • Conducting technical analysis, troubleshooting, and issuing resolutions for production operational support of Panorama reports and other components and utilities
  • Develop reports using relational and hierarchical database technologies
  • Provide information retrieval packages using query languages
  • Support BO administration and package creation
What we offer
What we offer
  • Earn a competitive rate within the industry
  • Location: Onsite role
  • Potential for extension
  • Fulltime
!
Read More
Arrow Right
New

Senior Software Developer

Do you have knowledge of OPS Enterprise Architecture artifacts (or similar), pro...
Location
Location
Canada , North York
Salary
Salary:
554.83 - 590.41 CAD / Day
https://www.randstad.com Logo
Randstad
Expiration Date
June 21, 2026
Flip Icon
Requirements
Requirements
  • Public Sector Experience
  • Experience working with federal/provincial/broader public-sector healthcare providers
  • Knowledge of the provincial immunization system and OPS large complex IT Health related projects or equivalent
  • Experience with integration of Clinical IT Systems such as Client and Provider Registries
  • Knowledge of OPS Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices
  • Knowledge of industry standard such as Project Management Institute (PMI)
  • Experience adopting and adhering to OPS Unified I&IT Project Methodology, OPS Enterprise Architecture and OPS Gating process, and OPS Standard Systems Development Methodologies
  • 10+ years of experience with Cognos 11.x report design, development and testing, Framework manager, Query Studio, Reports Studio, creation of dashboards, map/location etc.
  • Cognos AODA compliant
  • Cognos administration and package creation
Job Responsibility
Job Responsibility
  • Provide subject matter expertise to develop, test, support and maintain 40+ Standard Panorama Enhanced Analytic Reports and transform and present data to support analytics
  • Provide and support PEAR business model to enable self-service reports which is a critical functionality for PHUs, OCMOHPH, PHO and OGP
  • Develop and support PEAR to be AODA compliant
  • Develop and support Cognos upgrades
  • Develop and enhance PEAR by adding more new data scopes, new reports or other new features
  • Provide Business intelligence and data analytics, data warehouse design, dimensional data modeling, relational data modeling development and support
  • Provide impact analysis, effort estimate and solution design/development for PEAR due to DHIR solution upgrades, software upgrades or any new requirements (e.g. Panorama 4.4.x upgrades, PHU merge and more)
  • Support Cognos administration and package creation
  • Conduct research and assessment of options for technical design issues
  • Contributing to design/development project plans, including work breakdown and resources estimates
What we offer
What we offer
  • Earn a competitive rate within the industry
  • Potential for extension
  • Fulltime
Read More
Arrow Right
New

Python with AI Engineering - Vice President

We are seeking a highly experienced and motivated Lead Data Engineer to join our...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related field
  • 10-15 years of progressive experience in Data Engineering roles within the finance industry
  • Proven expertise in Oracle SQL and PL/SQL for complex data manipulation, stored procedures, functions, and database performance optimization
  • Strong proficiency in Python for data processing, scripting, and application development, with a focus on writing high-performance, efficient code
  • Extensive experience with job scheduling tools, specifically Autosys, including job definition, dependency management, and monitoring
  • Solid understanding and hands-on experience with Unix/Linux operating systems, including shell scripting and command-line tools
  • Demonstrated experience in implementing and maintaining CI/CD pipelines for data engineering projects
  • Deep understanding of data warehousing concepts, ETL/ELT principles, and data modeling techniques
  • Methodology of AI includes Chunking, Embedding, AI Engineering, Prompt Engineering
  • Extensive Design Experience handling Large Data Volume
Job Responsibility
Job Responsibility
  • Design, develop, and optimize scalable and high-performance data pipelines using various technologies to support business intelligence and analytical needs
  • Work closely with business users, analysts, and other engineering teams to understand data requirements and translate them into technical solutions
  • Develop and maintain complex SQL and PL/SQL scripts for data extraction, transformation, and loading (ETL) processes, primarily on Oracle databases, focusing on performance tuning and optimization
  • Implement and manage automation workflows using Autosys to schedule and monitor batch jobs, ensuring data availability and integrity
  • Develop and maintain data processing scripts and applications using Python, focusing on efficiency, reliability, writing performant code, and best practices
  • Manage and operate data processes within a Unix/Linux environment, including scripting for process automation, monitoring, and troubleshooting
  • Contribute to the continuous integration and continuous deployment (CI/CD) pipeline for data solutions, promoting automation and efficiency in software delivery
  • Ensure data quality, accuracy, and consistency across all data platforms
  • Explore, evaluate, and integrate Agentic AI frameworks and AI-driven tools to enhance productivity, automate routine tasks, and optimize data engineering workflows
  • Design, build, and deploy AI-driven solutions to solve complex business problems and enhance data analytics capabilities
  • Fulltime
Read More
Arrow Right

Semi Sr Platform Engineer Analyst IT Support

The position has the responsibility for researching, troubleshooting and support...
Location
Location
Costa Rica , Heredia
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years experience as Oracle DBA with Oracle RDBMS 11g/12c
  • Direct support of application end-users in a corporate environment
  • Experience on Dataguard, Datapump, RMAN, database migration
  • Advisors and Performance Tuning
  • Solid technical understanding and experience for analysis and support (e.g. SQL, PL/SQL)
  • Knowledge of Oracle maintenance/patching mechanics
  • 5+ as MS SQLServer DBA (version 2014 minimum required)
  • 3+ years of experience on multiple platforms, web servers and application servers (IIS, APACHE, J2EE, WEBLOGIC, WEBSPHERE WASND)
  • 3+ years Experience administering SSO products (AD, SiteMinder, etc.)
  • Installing, configuring, troubleshooting WebSphere
Job Responsibility
Job Responsibility
  • Maintain essential IT operations, including Unix/Linux operating systems, Messaging middleware (MQ), Databases, Application and Web servers
  • Manage, facilitate and own product support requests through consistent, positive and proactive IT methodologies using ticketing system
  • Troubleshoot, research, analyze and work with appropriate resources to solve problems
  • Identify and escalate situations requiring urgent or additional attention
  • Judgment must be used in prioritizing client requests and managing escalation workflow
  • Complete work on assigned projects to supervisor's satisfaction on time
  • Be on the rotation schedule for after-hours emergency support
  • Assist in testing during the rollout of new features product upgrades
  • Create product how-to documents, tutorials using tools such Wiki and Collaborate
  • Document any feature enhancement requests or ideas that will increase the productivity of the product offering for the chapter
  • Fulltime
Read More
Arrow Right
New

Digital Software Engineer Senior Analyst - Assistant Vice President

Location
Location
United States , Tampa
Salary
Salary:
96960.00 - 145440.00 USD / Year
https://www.citi.com/ Logo
Citi
Expiration Date
August 31, 2026
Flip Icon
Requirements
Requirements
  • 5-8 years experience with PL/SQL, Oracle and integration with Java applications
  • Exposure to architecture experience in building horizontally scalable, highly available, highly resilient, and low latency applications
  • Experience with data engineering techniques like building data lakes and data warehouses, data mesh, data pipelines, ETL vs. ELT
  • Exposure to Cloud infrastructure both on-premise and public cloud (i.e., OpenShift, AWS, Snowflake, Databricks)
  • Exposure to Continuous Integration and Continuous Delivery (CI/CD) pipelines, either on-premise or public cloud (i.e., Tekton, Harness, CircleCI, Cloudbees Jenkins, etc.)
  • Exposure to API Management tools
  • Exposure to Infrastructure as Code tools (i.e., IntelliJ, Cloudformation, PiSpark, etc.)
  • Experience mentoring junior developers
Job Responsibility
Job Responsibility
  • Accountable for executing and driving mid-size feature application design and development efforts to completion, serving as a development lead on medium-scale projects and supporting the execution of larger efforts
  • Proficient at operating with considerable autonomy and discretion as you will significantly influence the way an application is designed and developed by providing subject specific expertise and an advanced level of understanding of application programming principles
  • Sought after due to ability to analyze and troubleshoot coding, application performance and design challenges
  • Capable of research in root cause of development and performance concerns as well as the resolution of defects
  • Have a deep understanding of the technical requirements for the solutions being built
  • Understand engineering needs including those required to build, maintain, and operate the system through all phases of its life
  • Proficient in information modeling, data structures and algorithms
  • Understand maintenance characteristics, runtime properties and dependencies that exist in support of your system’s software
  • Demonstrate an advanced understanding of supported main system flows and possess a comprehensive understanding of how the system and others collectively integrate to contribute towards achieving business objectives
  • Participate in design discussions as a Development Lead and as such will play the part of a key decision maker in driving design decisions
What we offer
What we offer
  • medical, dental & vision coverage
  • 401(k)
  • life, accident, and disability insurance
  • wellness programs
  • planned time off (vacation)
  • unplanned time off (sick leave)
  • paid holidays
  • Fulltime
Read More
Arrow Right
New

Senior Software Developer

Do you have senior application development experience in cloud technologies usin...
Location
Location
Canada , Toronto
Salary
Salary:
554.83 - 590.41 CAD / Day
https://www.randstad.com Logo
Randstad
Expiration Date
June 04, 2026
Flip Icon
Requirements
Requirements
  • Senior application development experience in cloud technologies using OutSystems and .NET on Microsoft Azure
  • Demonstrated experience in C#/ MVC, Entity Framework, ReactJS, HTMLS/CS/JavaScript
  • Demonstrated experience supporting Ministry of Finance business areas, knowledge of Advisory, Objections and Appeals, and Tax and Benefit programs
  • Experience in programming and analysis
  • specialized software package support at the specified experience level
  • Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
  • Experience in structured methodologies for the development, design, implementation and maintenance of applications
  • Experience in design, code, test, debug and document applications
  • Experience in the use of object and/or third generation language development tools
  • Experience in one or more programming languages
Job Responsibility
Job Responsibility
  • Required to translate technical systems specifications into working, tested applications
  • Includes: developing detailed programming specifications writing and/or generating code compiling data-driven programs, maintaining, and conducting unit tests
  • Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations
What we offer
What we offer
  • Earn a competitive rate within the industry
  • Fulltime
Read More
Arrow Right