Software Support Specialist (L3 Support)

PrismHR; Dadri; On-site; INR 900,000 - 1,300,000; Full time

Job summary

PrismHR is seeking a Software Support Specialist (L3) to provide technical support for the HRMS web application, focusing on SQL Server issues for the Operations team. The role excludes pure development work and requires direct communication with US-based clients to resolve queries.

Candidates should have 4-8 years of SQL experience, including writing queries and knowledge of stored procedures, triggers, and functions. US shift timing is required with relocation to Noida/Greater Noida preferred.

Qualifications

• 4-8 years of experience.
• Strong knowledge in SQL and ability to write SQL queries.
• Strong knowledge of Stored Procedures, Triggers and Functions.
• Willingness to work on aggressive timelines.
• Good communication skills to talk directly with US based clients to understand and resolve queries/issues.

Responsibilities

• Act as frontline support to resolve issues (Bug Fixing).
• Escalate issues to Software Development with case details when needed.
• Collaborate with the Development team as part of Operations.
• Work US shift timings: 5 PM to 5 AM for 9 hours.

Skills

SQL

Stored Procedures

Triggers

Functions

Communication

Tools

SQL Server

Job description

Software Support Specialist (L3 Support)

We are seeking a candidate to provide technical support (SQL Server) to the Operations team i.e. Customer Service, with regards to any issues being faced by the Users/Clients related to our web application(HRMS)

Candidates with experience only on MySQL, PL SQL , Postgres SQL shall not apply.

Responsibilities:

• Act as Frontline support team to resolve issues (Bug Fixing) in first instance.
• If the issue requires intervention of the S/W Development team, they will assign the issue to them along with case details.
• The candidate will be part of Operations team and will collaborate with S/W Development team on need basis.
• The candidates will be required to work permanently in US Shift timings along with the Ops team in 5 PM to 5 AM window for 9 hours.
• Candidates who are looking for purely Software development profile shall not apply.
• Candidates will be required to sign a Service Agreement for 2 years.

Qualification:

• 4-8years of experience is required.
• Strong knowledge in SQLand ability to write SQL Queries.
• Strong knowledge of Stored Procedures, Triggers and Functions.
• Willingness to work on aggressive timelines.
• Good communication skills to talk directly with US based clients to understand and resolve their queries / issues.
• The candidate is expected to be a proactive and self motivated individual.
• Candidates residing in Noida/Greater Noida or willing to relocate there will be given preference.
• Candidates having notice period of one month or less would be preferred.

Desired Qualifications:

• Ability to optimize the SQL Queries and Bug Fixing.
• Basic understanding of Dot Net web applications is required.

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:

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 aren't 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 you’re excited about our roles but your past experience doesn’t 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 Affluent Action Employer, PrismHR encourages talent from all backgrounds to join our team. Employment decisions are based on an individual’s qualifications as they relate to the job under consideration. The Company’s 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 https://www.prismhr.com/about/privacy-policy.

PrismHR 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: [e-mail]. 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.

Invitation for Job Applicants to Self-Identify as a U.S. Veteran

• A “disabled veteran” is one of the following:
  • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
  • a person who was discharged or released from active duty because of a service-connected disability.
• A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
• An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
• An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE

I AM NOT A PROTECTED VETERAN

I DON’T WISH TO ANSWER

Voluntary Self-Identification of Disability

Voluntary Self-Identification of Disability Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualifiedpeople with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law sayswemust measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disabilityor have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one whomakes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If youwant to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract CompliancePrograms (OFCCP) website at www.dol.gov/ofccp .

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever hadsuch a condition, you are a person with a disability. Disabilities include, but are not limited to:

• Alcohol or other substance usedisorder (not currently usingdrugs illegally)
• Blind or low vision
• Cancer (past or present)
• Cardiovascular or heartdisease
• Celiac disease
• Cerebral palsy
• Deaf or serious difficultyhearing
• Diabetes
• Disfigurement, for example,disfigurement caused by burns,wounds, accidents, or congenitaldisorders
• Epilepsy or other seizure disorder
• Gastrointestinal disorders, for example,Crohn's Disease, irritable bowelsyndrome
• Mental health conditions, for example,depression, bipolar disorder, anxietydisorder, schizophrenia, PTSD
• Missing limbs or partially missing limbs
• Mobility impairment, benefiting from theuse of a wheelchair, scooter, walker,leg brace(s) and/or other supports
• Nervous system condition, for example,migraine headaches, Parkinson’sdisease, multiple sclerosis (MS)
• Neurodivergence, for example,attention-deficit/hyperactivity disorder(ADHD), autism spectrum disorder,dyslexia, dyspraxia, other learningdisabilities
• Partial or complete paralysis (anycause)
• Pulmonary or respiratory conditions, forexample, tuberculosis, asthma,emphysema

Please check one of the boxes below:

YES, I HAVE A DISABILITY, OR HAVE HAD ONE IN THE PAST NO, I DO NOT HAVE A DISABILITY AND HAVE NOT HAD ONE IN THE PAST I DO NOT WANT TO ANSWER

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.