Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Oracle

Compare

3.7

based on 5.3k Reviews

Video summary

1403 Oracle Jobs

Senior Production Software Engineer

Oracle India Pvt. Ltd.

3.7

based on 5.3k Reviews

3-5 years

Kolkata

1 vacancy

Senior Production Software Engineer

Oracle

posted 1mon ago

Job Role Insights

Flexible timing

Key skills for the job

Medical Coding Virtual Assistant SAP CO SQL SSRS Debugging

+ 3 more

Job Description

The Shift-Based Software Engineer will be responsible for maintaining, monitoring, and troubleshooting software systems during assigned shifts. This role is part of a team providing 24/7 operational support, ensuring that critical systems remain functional and perform efficiently. The engineer will respond to incidents, implement fixes, and collaborate with other teams to ensure the reliability and availability of software services, troubleshoot and analyze intermediate to complex technical coding issues submitted by internal/cross-team or external customers.

Basic skills:

Good knowledge on SQL Database programming that includes below competencies - preference is M/S SQL Server (TSQL)
Database Design Optimization : Designed and maintained complex database schemas, implemented indexing strategies, and optimized queries, resulting in increased system performance.
T-SQL Expertise : Developed and optimized stored procedures, functions, triggers, and views to handle large and complex datasets.
Performance Tuning : Utilized tools like SQL Server Profiler, Extended Events, and execution plans to troubleshoot performance bottlenecks, reducing query response times.
Good understanding of ETL process and Data Warehouse concepts.
Experience of working on MSBI tools - SSAS, SSRS, SSIS
Reporting tools like SAP Business Objects- crystal reports, WEBI reports, Universe, BO administration

Key Responsibilities:

Incident Management : Respond to system alerts, diagnose issues, and resolve or escalate them in a timely manner(as per SLA/TAT) to minimize downtime. Create and update documentation related to incidents, and procedures for knowledge sharing and future reference.

Monitoring Maintenance : Continuously and proactive monitor solution performance, logs, and alarms. Implement routine checks and maintenance tasks.

Troubleshooting Debugging : Investigate solution code or software for the reported problems. Provide timely solutions or workarounds for issues affecting system performance or issues causing system downtime.

System Optimization : Suggest improvements in processes, tools, and software configurations to enhance performance and reliability.

Collaboration : Work closely with cross-functional teams including development, DevOps, and infrastructure teams to ensure smooth handoffs and coordinated efforts during issue resolution.

Support Communication: Act as the point of contact for production issues during shifts, keeping stakeholders informed about system statuses and incident resolution.

Additional Requirements :