1. Design, develop, and maintain SQL Server databases to support web applications and business processes.
2. Collaborate with application developers, designers, and stakeholders to understand database requirements and ensure alignment with application functionality.
3. Write efficient T-SQL queries, stored procedures, functions, and triggers to implement business logic and data manipulation requirements.
4. Optimize database performance by tuning queries, indexing strategies, and database configurations.
5. Implement database security measures to protect sensitive data and ensure compliance with regulatory requirements.
6. Write Crystal, Kendo, and/or SSRS reports.
7. Troubleshoot and resolve database-related issues in a timely manner.
8. Document database design, architecture, and processes for knowledge sharing and future reference.
9. Stay current with SQL Server technologies, trends, and best practices through continuous learning and professional development.
Requirements:
1. Bachelors degree in Computer Science, Information Technology, or a related field (or equivalent experience).
2. Proven experience as a SQL Server Developer with at least 5 years of experience in SQL Server development.
3. Proficiency in T-SQL programming and SQL Server database administration.
4. Strong understanding of relational database concepts, normalization, and data modeling principles.
5. Experience with performance tuning, query optimization, and database indexing.
6. Familiarity with Crystal or Kendo reporting system.
7. Excellent problem-solving skills and attention to detail.
8. Strong communication and collaboration abilities.
9. Ability to work effectively in a fast-paced, team-oriented environment.
Preferred Qualifications:
1. Experience with SSRS reporting.
2. Knowledge of ETL processes and tools.
3. Familiarity with data warehousing concepts and methodologies.
4. Lab background.