D-TechWorks - Senior MS SQL Andamp; Oracle Developer - Fuel Retail Andamp; Convenience Systems Domain

Description

We are Hiring for Senior MS SQL & Oracle Developer - Mumbai

Job Title : Senior MS SQL & Oracle Developer

Experience : 5 to 7 Yr

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
  
  

• 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.
  
  

• 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.
  
  

• 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.