PL/SQL with Oracle

Tech Mahindra; Pune District; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Tech Mahindra in Pune is seeking a Software Engineer / Senior Software Engineer with Oracle PL/SQL and SQL Server expertise. 7-10 years of experience in database development, performance tuning, and production support is required.

The role involves handling complex SQL, data migrations, and RCA for production issues in a large enterprise environment. The position offers hybrid work arrangements in Pune with opportunities to contribute to enterprise-grade database solutions and data integrity

Qualifications

• Experience in Oracle Database and PL/SQL programming.
• Strong SQL Server proficiency and data manipulation skills.
• Hands-on in performance tuning and query optimization.
• Exposure to production support and incident management.

Responsibilities

• Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Write complex SQL queries, stored procedures, and scripts in SQL Server.
• Perform database performance tuning and query optimization.
• Analyze production issues and provide root cause analysis (RCA).
• Support data migration, data validation, and ETL-related activities.
• Monitor database health and troubleshoot performance bottlenecks.
• Work closely with application development and support teams.
• Develop and maintain database documentation.
• Handle incident, problem, and change management activities.
• Ensure data integrity, security, and compliance with organizational standards.
• Participate in deployments, releases, and production support activities.

Skills

Oracle PL/SQL

SQL Server

Database development

Performance tuning

Data analysis

Production support

Query optimization

ETL

Job description

Job Title: Software Engineer / Senior Software Engineer Oracle PL/SQL & SQL Server

Location: Pune / Hybrid

Experience: 7 to 10 Years

Employment Type: Full-Time

Job Summary-

We are seeking a highly skilled Oracle PL/SQL and SQL Server Developer with strong experience in database development, performance tuning, data analysis, and production support. The ideal candidate should possess hands-on expertise in Oracle Database, PL/SQL programming, SQL Server, query optimization, troubleshooting, and database design. Experience in application support, incident management, and enterprise environments is highly desirable. Relevant skills appear frequently in internal candidate profiles and database support experience. [Naukri_Bal...nge[5y_6m] | PDF], [Naukri_Arc...hid[5y_0m] | Word]

Key Responsibilities

• Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Write complex SQL queries, stored procedures, and scripts in SQL Server.
• Perform database performance tuning and query optimization.
• Analyze production issues and provide root cause analysis (RCA).
• Support data migration, data validation, and ETL-related activities.
• Monitor database health and troubleshoot performance bottlenecks.
• Work closely with application development and support teams.
• Develop and maintain database documentation.
• Handle incident, problem, and change management activities.
• Ensure data integrity, security, and compliance with organizational standards.
• Participate in deployments, releases, and production support activities.