MS SQL Developer MS SQL Developer …

in Melbourne, Victoria, Australia
Permanent, Full time
Last application, 23 Jul 21
in Melbourne, Victoria, Australia
Permanent, Full time
Last application, 23 Jul 21
MS SQL Developer
Required Technical Skills:
  • Minimum 7 years of IT Experience, in Data warehousing projects on MS SQL space.
  • Strong T-SQL Programming experience with ability to produce production-quality code complete with internal documentation.
  • Ability to quickly analyze existing T-SQL code and make improvements to enhance performance of queries, transactions, exception handling and take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.
  • Develop and maintain SSIS packages, and ability to do Data Migration from different sources to SQL Server.
  • Good understanding of SQL Server database design concepts and ability to understand the underlying data model, to develop optimized code.
  • Experience in SSRS reports development.
  • Experience in processing huge volumes of data
  • Understand the performance measures that impact the application; create solutions to remove bottlenecks across any layer (reports/environment/extraction layer/database) to ensure that the overall application SLAs can be met
  • Create performance oriented code
  • Understanding of the data warehousing concepts - including Snowflake and Star schema and normalization concepts
  • Preparing scripts / tools to help automate development and testing, as appropriate
Other Skills:
  • Perform exhaustive unit testing and deliver defect-free product
  • Good understanding of the full development life cycle, development methodologies, and version control.
  • Be responsive. Take accountability for deliverables.
  • Solid teamwork and interpersonal skills; ability to work well on cross-functional project teams and foster team commitment to tasks.
  • Strong written, verbal, and graphical communications skills with the ability to express complex technical concepts effectively
  • Ability to work well with people from different disciplines with varying degrees of technical experience
  • Ability to work both independently and with minimal guidance, as well as with a team.
  • Interest and ability to learn new technologies, a tireless appetite for learning new things.
  • C# and .NET MVC - although the project is mostly about data, there is also an in-house app called Plato built using C# and .NET MVC and if the dev knows these technologies, the more the resource can contribute
  • Angular JS and React JS - Front-end of the Plato app. At the moment, Plato is using Angular and the client may look to refactor the code and transition from Angular to React. This was mentioned to me last year that they may re-code the front-end to use React. With the familiarity of the resource on the different applications, this will be a good initiative and seize new SOWs.
  • Git and Bitbucket - code repository
  • Knowledge in Powershell

Cognizant logo
More Jobs Like This
See more jobs