Senior MS SQL and Oracle Developer

Job Description

-----------------------------------------------------

Job Title: Senior MS SQL & Oracle Developer

Department: IT/Technical Support

Reports To: IT Operations Manager

Job Summary:

We are seeking an experienced and highly skilled Senior MS SQL and Oracle Developer to

join our technology team. The ideal candidate will have deep expertise in database design,

performance tuning, stored procedures, and PL/SQL & T-SQL development. You will play a

key role in the design and optimization of critical business systems and databases.

Key Responsibilities:

 Design, develop, and maintain complex SQL queries, stored procedures, triggers,

and functions in both MS SQL Server and Oracle environments.

 Optimize and tune SQL and PL/SQL/T-SQL code for performance and scalability.

 Design and implement database schemas, tables, views, indexes, and partitions.

 Collaborate with application developers to ensure efficient database access and data

integrity.

 Perform data migration, transformation, and ETL operations between databases.

 Conduct regular database reviews and troubleshoot issues in development, test, and

production environments.

 Implement and maintain best practices in database management, version control,

and deployment.

 Document database processes, data models, and changes clearly and accurately.

 Mentor junior developers and participate in code reviews.

Required Skills:

 5+ years of experience with MS SQL Server and Oracle development.

 Expert-level knowledge of T-SQL and PL/SQL.

 Strong experience with query performance tuning and execution plans.

 Solid understanding of relational database design and normalization.

 Experience with database security, backup, and recovery.

 Familiarity with SSIS/SSRS and Oracle tools such as SQL*Plus, TOAD, or SQL

Developer.

 Proficient in writing and optimizing complex joins, subqueries, and window functions.

 Strong problem-solving and analytical skills.

Qualifications

 Education: BE/B.Tech/MCA/MCS in any stream.

 Experience: 5-6 years, with at least 4 years in Fuel Retail and Convenience Systems

or similar domains.

Job Location

Koparkhairane - Navi Mumbai

Work Schedule Rounding Shift

Job Types: Full-time, Permanent

Pay: ₹427,853.24 - ₹1,200,000.00 per year

Application Question(s):

• How many years of overall experience do you currently have?
• What is your notice period in days?
• What is your Expected CTC in LPA?

Experience:

• Mssql: 5 years (Required)
• Oracle: 5 years (Required)
• T SQL: 3 years (Required)
• PL/SQL: 3 years (Required)
• database security: 2 years (Preferred)
• SSIS/SSRS: 1 year (Preferred)

Work Location: In person