SQL Developer - Implementation & Design (4-5 yrs)

We're seeking a SQL Developer to augment its backend processing, reporting and analytics capabilities.

The ideal candidate needs to have practical exposure to backend design and optimization techniques, and able to use that knowledge to solve complex problems.

The role requires a proactive and self motivated individual, who is willing to take an idea, groom it into a well defined user story, and see through the implementation.

Responsibilities :

- Experience in analyzing and debugging execution plans.

- Experience in creating and managing indexs based on development cycles.

- Strong development experience, preferably on web based applications, however a mix of desktop and web based applications is also acceptable.

- Strong hands on skills on SQL Server 2012/2016/2019, including use of analyzing and debugging tools, query optimization, transaction handling, stored procedures, functions, triggers and views.

- Experience in designing and implementing highly optimized queries for consistent response time, under a highly variable and fluctuating processing load.

- Experience in converting raw data into usable formats, for reporting and business analytics.

- Exposure and practical experience on SQL Server Reporting Services will be an considered an advantage.

- Exposure to at least one NoSQL database such as Cosmos DB will be considered an advantage.

- Exposure to applications hosted on one of the leading cloud hosting platforms (Microsoft Azure, Amazon AWS, Google Cloud), and having practical ideas towards designing solutions to minimize resource usage.

Qualifications :

- Familiarity with at least one or more source control tools like Github, or Subversion (SVN).

- Exposure and practical working experience on Agile methodology.

- The job requires some overlapping with the US based teams, so the candidate should be flexible to work in afternoon shift 1PM to 10PM IST.

- PrismHR is a fast-paced SaaS company which provides customers with a cloud-based payroll process software application.

- PrismHR also provides professional services including system implementation consulting, custom configurations, and training.

- Lastly, via the Company's Marketplace platform customers and end users access other human resources and employee benefits applications from PrismHR's Marketplace Partners.

- Diversity, Equity And Inclusion Program/Affirmative Action Plan.