Description
Responsibilities:
• Demonstrates advanced knowledge and skills in developing data components using SQL Server T/SQL, SQL stored procedures, triggers, and views, SSIS, and SQL agent jobs
• Designing, developing, and testing data transformations for reporting and interfaces between systems using SSIS for SQL Server 2016
• Advanced knowledge and experience developing in SQL Server 2016, understanding of database architecture, security, deployment strategies
• Secondary responsibilities include knowledge of SQL Server 2016 maintenance and troubleshooting
Required Skills:
• Hands on experience with SQL Server 2016
• Expertise in writing T-SQL stored procedures, triggers, cursors
• Expertise in SQL Server Integration Services (SSIS)
• Experience in creation and deployment of reports using SQL Server Reporting Services (SSRS)
• Experience debugging stored procedures
• Experience in database design and implementation
• Experience working with Microsoft Excel and Microsoft Access as data sources
Secondary Skills:
Working knowledge in Azure environments
Required Experience:
• 4-7 Years SQL Server development experience
• Ability to read, analyse, and interpret general business documentation, technical specifications, and project management documentation.
• Good experience in writing complex queries and performance optimization
• Good experience in developing ETL packages, understanding different ETL strategies and troubleshooting ETL jobs
• Ability to deconstruct and understand reports and stored procedures with little to no documentation
• Knowledge of reporting and query tools and practices
• Good interpersonal, written, and oral communication skills
• Technical documentation skills
• Ability to present ideas in user-friendly language
• Self-motivated and directed, with keen attention to detail
• Able to prioritize and execute tasks in a high-pressure environment
• Experience working in a team-oriented, collaborative environment
• Good written and oral communication skills
Are you a returning applicant?
Previous Applicants: Email: Password: