SQL Developer

Job Description

Role Summary We are looking for a highly motivated and detail-oriented SQL Developer with 2-3 years of experience in Microsoft SQL Server to join our growing team. This role will focus on developing, maintaining, and optimizing SQL-based solutions to support mission-critical Payroll and HRIS applications. The ideal candidate will have a strong foundation in database development, data integrity, and query performance optimization. Key Responsibilities Design, develop, and maintain SQL Server databases, tables, views, stored procedures, triggers, and functions. Optimize SQL queries and stored procedures for improved performance and scalability. Collaborate closely with the HR, Payroll, and Product teams to gather requirements and translate them into scalable database solutions. Build and manage ETL processes for seamless data integration between internal and external systems. Maintain and enhance data integrity, security, and accuracy across all platforms. Create reports and data extracts for business use, analytics, and compliance using SQL or tools like SSRS/Power BI. Monitor database performance, identify issues, and implement timely resolutions. Implement database version control and participate in code reviews and QA processes. Stay updated with the latest SQL Server features, performance tuning strategies, and security best practices. Required Skills & Qualifications Bachelor's degree in Computer Science, IT, or a related field. 2-3 years of hands-on experience in Microsoft SQL Server (MSSQL) development. Strong expertise in T-SQL, complex joins, subqueries, window functions, views, triggers, and indexing strategies. Solid understanding of ETL concepts and tools for data integration. Experience in working with HRIS or Payroll systems is mandatory. Exposure to data security practices and compliance (GDPR, labor laws) related to employee data. Ability to analyze large datasets and optimize data processing. Strong problem-solving skills and attention to detail. Good communication skills and the ability to collaborate with cross-functional teams. Preferred Skills Knowledge of reporting tools like SSRS, Power BI, or other dashboarding tools. Familiarity with cloud-based databases (e.g, Azure SQL, AWS RDS). Experience in backup/recovery, disaster recovery, and database versioning strategies. Familiarity with Agile/Scrum methodologies and tools like JIRA or Azure DevOps. Version control using Git or similar (ref:hirist.tech) Show more Show less