3 to 6 months –
Less than 10 hrs/week –
Looking to hire Senior MS SQL Database Developer. My team needs someone to write and cleanup complex SQL queries & scripts. I will provide detailed explanation for each job, source data, and how the data needs to look after script.
Essential Functions (e.g., in order to be considered to perform this position, the person must be able to perform essential duties and responsibilities listed below):
Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.
Develop ad-hoc scripts, including cleanup scripts as needed.
Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.
Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts.
Monitor and troubleshoot SQL jobs using available tools such as SQL Profiler; review logs and triage issues.
Education and Experience:
5+ years of experience in a Microsoft SQL Server environment (with recent experience using SQL Server 2008 R2).
2+ years of experience with MS SQL Server Integration Services (SSIS).
Highly proficient with SQL Server and strong programming skills with SQL including complex SQL programming, stored procedures and performance tuning. Extensive knowledge of ...