1.0 Primary Duties & Responsibilities Specific duties and responsibilities include:
• Create complex queries on large data sets
• Reverse engineer existing SQL code, data flow and logic
• Create stored procedures, triggers, functions and views
• Generate code to extract, transform and load data
• Perform performance tuning of queries
• Develop and design database objects, such as tables, indexes, constraints, etc.
• Analyze query performance and identify improvement areas
• Work with development, QA, business teams and at times directly with customers
2.1 Education and Training
• Bachelor’s degree in Computer Science or related field from an accredited university and/or equivalent work experience
2.2 Knowledge and Skills
• 6+ years’ experience in SQL Server Fundamentals
• 6+ years’ experience in using T-SQL programming language, including writing queries, stored procedures, and functions
• Knowledge of web development (ASP.NET web forms, MVC, C# or .Net Core a plus)
• Thorough understanding of database modeling
• Understanding of cloud development with Azure services a plus
Benefits