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 plus years of experience in a Microsoft SQL Server environment (with recent experience using SQL Server 2012 and above).
2 plus 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 T-SQL.
Solid understanding of principles of database design and modeling as well as data quality best practices.
Expert knowledge of stored procedure writing and best practices.
Solid experience with SQL tuning to improve query performance.
Ability to learn new technical skills easily and troubleshoot data-related issues and errors.
Proven experience writing stored procedures for maintaining data.
26 freelancers are bidding on average $14/hour for this job
Hello, I have been working on T-SQL from past 7 years and best fit for you for various organizations. I can write queries for complex business rules quickly.