Senior SQL Developer

Were seeking a Senior Data Engineer 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.
• A minimum industry experience of 3 years with significant time spent in the relevant projects.
• 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 :

60%) throughout in academics from reputed institutions.

Desired Qualifications :

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 Companys Marketplace platform customers and end users access other human resources and employee benefits applications from PrismHRs Marketplace Partners.

Diversity Equity and Inclusion Program / Affirmative Action Plan :

We have transformed our company into an inclusive environment where individuals are valued for their talents and empowered to reach their fullest potential. At PrismHR we strive to continually lead with our values and beliefs that enable our employees to develop their potential bring their full self to work and engage in a world of inclusion.

Ensuring an inclusive environment for our employees is an integral part of the PrismHR culture. We arent just checking a box we are truly committed to creating a workplace that celebrates the diversity of our employees and fosters a sense of belonging for everyone. This is essential to our success. We are dedicated to building a diverse inclusive and authentic workplace so if youre excited about our roles but your past experience doesnt align perfectly with every qualification in the job description we encourage you to apply anyway. You may be just the right candidate for these open roles or other open roles. We particularly encourage applicants from traditionally under-represented groups as we seek to increase the diversity of our workforce and provide fair opportunities for all.

As a proud Equal Opportunity and Affirmative Action Employer PrismHR encourages talent from all backgrounds to join our team. Employment decisions are based on an individuals qualifications as they relate to the job under consideration. The Companys policy prohibits unlawful discrimination based on sex (which includes pregnancy childbirth breastfeeding or related medical conditions the actual sex of the individual or the gender identity or gender expression) race color religion including religious dress practices and religious grooming practices sexual orientation national origin ancestry citizenship marital status familial status age physical disability mental disability medical condition genetic information protected veteran or military status or any other consideration made unlawful by federal state or local laws ordinances or regulations.

The Company is committed to complying with all applicable laws providing equal employment opportunities. This commitment applies to all persons involved in the operations of the Company and prohibits unlawful discrimination by any employee of the Company including supervisors and co-workers.

Privacy Policy : For information about how we collect and use your personal information please see our privacy statement available at provides reasonable accommodation for qualified individuals with disabilities and disabled veterans in job application procedures. If you have any difficulty using our online system and you need a reasonable accommodation due to a disability you may use the following alternative email address to contact us about your interest in employment at PrismHR : Please indicate in the subject line of your email that you are requesting accommodation. Only candidates being considered for a position who require an accommodation will receive a follow-up response.

#LI-ML1

Required Experience :

Senior IC

Key Skills

Databases,SQL Server Management Studio,SQL,.NET,Microsoft SQL Server,ssrs,TFS,Database Design,Performance Tuning,SSIS,T Sql,Data Warehouse

Employment Type : Full-Time

Experience : years

Vacancy : 1