Hostess

Role Overview: As a Senior MS SQL and Oracle Developer, you will be a valuable asset to the technology team by utilizing your expertise in database design, performance tuning, stored procedures, and PL/SQL & T-SQL development. Your primary responsibility will involve designing and optimizing critical business systems and databases to ensure efficiency and scalability. 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. Qualifications: - B.Tech in any stream. - 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. Additional Details: - Job Location: Koparkhairane - Navi Mumbai - Work Schedule: Rounding Shift (Note: The qualifications section was included as part of the Key Responsibilities as it contained relevant information for the job role.),