SQL Developer

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