Description:
Responsibilities of the SQL Server Developer:
- Develop and maintain high-quality, secure, and efficient database objects.
- Create and execute comprehensive unit tests for T-SQL code.
- Conduct thorough reviews of T-SQL code for adherence to standards and performance.
- Analyze existing T-SQL applications for optimization opportunities.
- Collaborate with various teams, including Application Support, QA, and DBA.
Requirements of the SQL Server Developer:
- 4+ years of experience with Microsoft SQL Server 2012 or above.
- Strong background in T-SQL development and stored procedures (OLTP) for at least three years.
- Proficiency in SSIS 2012 or above, with 4+ years of experience.
- Experience with SQL Agent jobs maintenance for at least one year.
- Proficient in database design for enterprise-scale systems, Dynamic Management Views, query performance tuning, database performance tuning, and procedure analysis.
- Version control (e.g., GIT)
- -Scripting (Batch files, PowerShell)