Desired Skills and Experience
- Develop and optimize SQL queries and stored procedures
- Work with stakeholders, peers, and product management to identify potential solutions, technical requirements and development options
- Debug and optimize the performance of a high traffic, multi-tier web application
- Analyze, design, implement, and maintain SQL Server objects
- Provide support for existing reporting needs including analyzing data or system errors, answering user questions and modification requests.
- Tune and optimize queries, stored procedure and indexes to improve performance.
- Have considerable knowledge in the different levels of locking, blocking and deadlocks and be able to write T-SQL code that avoid these situations
- Troubleshoot issues with database objects and provide solutions/insight
- Design, develop and deploy SSIS Packages.
- Learn and document the data-model and the business rules to be able to understand the data
- Have an ownership-mindset with respect to the code - be prepared to do extensive testing and simulations on your code to ensure it performs as optimally as possible
- Minimum 5 years experience in enterprise level database design, implementations and development in MS-SQL Server with large databases and live sensitive data
- Demonstrated ability to write complex optimized SQL queries and stored procedures in Microsoft SQL Server 2012/2014/2016 with a deep understanding of performance factors such as indexes, T-SQL techniques, execution plan and statistics
- Expert level knowledge of SQL administration, engineering, and monitoring tools
- Expert level experience with databases in excess of 1 TB
- Knowledge of SQL Server’s dynamic management views are a recommended
- Excellent communication and interpersonal skills to be adaptable in a fast-paced team
- Quick learning, curious, and self-starter personality
- Advanced critical thinking and problem solving skills.
- ASP.net, C#
- Google BigQuery
- SQL Server Reporting Services (SSRS)