SQL Developer - On Contract for 9 Months
MSCI
India-Pune
2d ago

Position overview

SQL Developer in the HR Technology Team

Responsibilities :

  • 7+ years’ experience developing SQL based applications in a large development environment.
  • Deep expertise in SQL, Stored Procedures, Triggers, functions and SQL troubleshooting.
  • Developing complex SQL queries, views, procedures and triggers with a deep understanding of indexing for optimization.
  • Experience in SSIS, SSAS, SSRS and ability to develop, build and troubleshoot SSIS packages.
  • Experience in designing efficient database solutions for loading and transforming large volume of data.
  • Proficiency in optimization techniques & performance tuning, understanding benefits & disadvantages of normalization & denormalization.
  • Performance Tune database applications & schemas for performance & scalability ensuring security, and availability of databases.
  • Familiar with common database procedures such as upgrade, backup, recovery, migration, etc.
  • Maintain high standards of data quality and integrity.
  • Recommend and lead implementation for improvements to SQL Server configuration.
  • Build relationships with the enterprise DBA team and collaborate and partner with them to propose & implement changes for database optimization.
  • Partner with software development teams to provide technical insights into schema, queries & stored procedure design.
  • Understanding the Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology.
  • Desired experience and qualifications :

  • Collaborating with other team members and stakeholders to develop strong relationships and partnerships.
  • Strong analytical and problem-solving abilities.
  • Ability to work with minimal supervision or assistance to complete tasks.
  • Deep expertise in T-SQL, Stored Procedures, Triggers, functions & knowledge of SQL Developer tools is must.
  • Strong proficiency with SQL Server SSIS, SSAS and SSRS.Power BI, DAX and M-Query knowledge is a definite plus.
  • Excellent knowledge of Business intelligence tools like Import / Export, SSAS, SSRS and Power BI.
  • Proficiency in optimization techniques & performance tuning, understanding benefits & disadvantages of normalization & denormalization.
  • Skilled in working with poorly documented source databases and understanding the source schema through examining the data itself.
  • Experience in designing database solutions and capable of troubleshooting common database issues.
  • Preparing documentations and specifications.
  • Due to the great number of applications we receive for each of our open vacancies, we are unable to respond on an individual basis.

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form