Closed

Design and Develop Complex SQL queries

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).

Qualifications:

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.

Skills: Microsoft SQL Server

See more: t sql programming, t sql jobs, t sql developer jobs, tools needed for programming, the principles of design, technical support duties, ssis jobs, sql server developer jobs, sql developer to hire, Sql developer jobs, sql database developer jobs, sql database business, solid modeling jobs, solid design principles, senior developer looking for a job, senior developer jobs, senior design, senior database developer jobs, review writing jobs, programming best practices, proficient with microsoft, principles of programming, principles of design, optimal design, new hire procedures

About the Employer:
( 0 reviews ) Ambala Cantt., India

Project ID: #7434045

26 freelancers are bidding on average $14/hour for this job

mpalgeo

Hi I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have More

$15 USD / hour
(21 Reviews)
4.3
acronymsolutions

Hi, I am 8+ years experienced VisualBasic,ASP.NET, VB.NET,MVC, C#,Bootsrap,Telerik control,Crystal report,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confide More

$15 USD / hour
(2 Reviews)
3.8
thegrchet

SQL Server DBA/MSBI Developer with 5+ years of experience. I have expertise in creating ssis packages, ssrs reports and writing sql queries. My Day-to-Day activities as sql server DBA Adding users in SQL Server More

$16 USD / hour
(5 Reviews)
3.9
marasinghe82

Dear Sir, I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experienc More

$13 USD / hour
(3 Reviews)
3.8
fanninson45

INTRODUCTION I have done a similar project like this recently for a HRM organisation within a small budget in UK here [url removed, login to view] SHOWCASE I am an ex More

$10 USD / hour
(5 Reviews)
3.3
prashantbjadhav

Hi there. I have a strong experience in MS SQL SERVER. I will be able to complete your your job to your satisfaction with minimal time required. Please go through my profile on freelancer. I would be the best fit for More

$11 USD / hour
(1 Review)
2.4
harune

Dear Sir, We have loads of experience and expertise in writing and optimizing Queries and Scripts using MySQL, MS SQL and Oracle. We have experience of developing and working on huge financial systems, where the num More

$16 USD / hour
(1 Review)
1.0
ashwanixtra

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.

$11 USD / hour
(0 Reviews)
0.0
pcjawan

I use MS SQL for all my business applications. I am using SQL Server since version 6.5 and have experience managing stored procedure from simple to complex. Handled database having more than 7 million rows. Performance More

$11 USD / hour
(0 Reviews)
0.0
sktech85

A proposal has not yet been provided

$5 USD / hour
(0 Reviews)
0.0
MVeraChipoco

Experiencia en el desarrollo del software, desde la toma y mejora de los requerimientos hasta la puesta en producción y mantenimiento.

$12 USD / hour
(0 Reviews)
0.0
bansai

I am a business intelligence developer and work with complex SQL queries and structures on a daily basis. I also design complex ETL processes in SSIS and T-SQL.

$11 USD / hour
(0 Reviews)
0.0
infysuresh

I have rich exposure to SQL Server. I can get the work done based on the nature - Tactical to strategic. To prove my ability, give me a sample work, I can turn around in few hours. My public profile works: http More

$5 USD / hour
(0 Reviews)
0.0
somohamedibrahim

A proposal has not yet been provided

$5 USD / hour
(0 Reviews)
0.0
lokeshwarreddy3

Hello, I am very much interested to apply for this Project as it matches my abilities and knowledge with your requirements. I have good experience on sql server Developer (T-sql-> views,Function,Procedures and tr More

$7 USD / hour
(0 Reviews)
0.0
yubor

hi, i am mssql expert (mcse) and have 15+ yaers of exp in developing of db applications. Can help you on flex graphic with about 10hrs in week. Regards, Yuri

$20 USD / hour
(0 Reviews)
0.0
kongjie86

Hello I have strong skill in database administrate and ETL programming. More than 13 years experiences in many of database systems (Oracle, MSSQL, MySQL, FileMaker, MS Access and PostgreSQL) I have ever took part More

$11 USD / hour
(0 Reviews)
0.0
Deepikap21

• Expertise in creating reports using MS SQL Server Reporting Services (SSRS) and T- SQL server. • Involved in analyzing the requirements from client, creating design documents, code development and unit testing. • A More

$17 USD / hour
(0 Reviews)
0.0
eongodo

A proposal has not yet been provided

$5 USD / hour
(0 Reviews)
0.0
cgc3iii

A proposal has not yet been provided

$30 USD / hour
(0 Reviews)
0.0