Senior Production Software Engineer

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
  
  
  

Career Level - IC3

Responsibilities

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:

• Availability for on-call duty during off-hours, as required. Willingness to learn new tools and technologies.
  
  
  

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

We know that true innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing an inclusive workforce that promotes opportunities for all.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.