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 tojoin 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 akey 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, andproduction 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 SQLDeveloper.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.
Must have Skills :
Mssql - 5 YearsOracle - 5 YearsT-SQL - 3 YearsIntermediate :
PL / SQL - 3 YearsIntermediate :
database security - 2 YearsIntermediate :
SSIS / SSRS - 1 Years(ref : hirist.tech)