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:
- B.Tech./B.E./ M.Tech./BCA/MCA with first class (>60%) throughout in academics, from reputed institutions.
- 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.
Top Skills
What We Do
PrismHR creates exceptional software and services, empowering human resource outsourcing service providers such as Professional Employer Organizations (PEOs) and Administrative Service Organizations (ASOs) to deliver world-class payroll, benefits and HR to small and medium sized businesses. PrismHR software is used by more than 88,000 organizations and 2.2 million worksite employees, processing greater than $57 billion in payroll each year. Visit our website to learn more about how PrismHR can help your business be more profitable and productive. http://www.prismhr.com