Design and Develop Complex SQL queries

$2-8 USD / hour

Closed

Posted

about 9 years ago

$2-8 USD / hour

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.

Microsoft SQL Server

Project ID: 7434045

About the project

24 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

24 freelancers are bidding on average $14 USD/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 designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

$15 USD in 10 days

4.9

(64 reviews)

6.0

@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 number of users is tremendous, and thus the performance of the Database and Queries is very crucial. We have experienced Database Developers, as well as Database Administrators, who have experience in Query / Script writing, Query Optimization, Database Administration, Database support/management, System Management, Electronic Data Processing, Data Mining, Data Analysis, Integration Services (SSIS) and Reporting, Proficiency in database optimization, tuning, backup and recovery. They also have good working experience of database security implementation and auditing and expertise on providing high availability features like Clustering, Replication and Mirroring functionality. Kindly initiate a chat with us, so that i can send the CV of our 14 years experienced Database Developer/Administrator, who will work with you directly. We assure you that Quality of work, timely delivery and commitment for a long term relationship is what you will always get from Us. We would like to discuss your project in more detail so that we get a more detailed and accurate understanding of the work that needs to be done. Kindly give us a chance to show our professionalism. Have a great day sir! Thank You

$16 USD in 20 days

5.0

(8 reviews)

4.3

@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 Moving the database Import and Export in SQL Server SQL Server indexes SQL Server jobs SQL Server Maintenance Plan SQL Server backup and Restore SQL Server Profiler for performance bottlenecks Working with SQL Server Transaction Log SSIS Developer, I have developed complex ssis package for performing ETL operations based on my clients requirement using synchronous and asynchronous transactions, transformations, execute sql task, data flow task ..etc Please reach back to me for further clarifications. Lets discuss the project and come for a fixed bid, since I do not prefer to charge my clients extra

$16 USD in 160 days

5.0

(5 reviews)

3.9

@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 confidently. I am very much Interested to do your work,Please revert me if you have any concern.

$15 USD in 40 days

5.0

(3 reviews)

3.8

@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 in 10 days

5.0

(1 review)

0.6

@cgc3iii

A proposal has not yet been provided

$30 USD in 27 days

0.0

(0 reviews)

0.0

@nesiasoft

Hello, How are you? I found your freelancer.com job post and I’m very interested in your project. As a skilled PHP/Classic ASP/ASP.NET Database Programmer professional with experience developing web, I think you’ll find I have the skills you’re looking for. Please take a look at my portfolio in my profile and my site : nesiasoft[dot]org to get an idea of the kind of web I have developed. I am looking for a long time relation with you and I think I can handle your project. Thank you for your time, I am looking forward to hear again from you Regards Michael

$5 USD in 50 days

0.0

(0 reviews)

0.0

@aishwary9122

Hello, I am MSBI developer and have good skills in database programming specially. Also have good problem solving nature but I haven't as much experience as demanded but I can do this task very efficiently. You can check my reviews here related to SSIS projects. If your are interested or have any issue then contact me here... Thanks

$60 USD in 40 days

0.0

(0 reviews)

0.0

@akshat116

Hi I have worked on Sql 2012 and I am currently working on sql 2014 I have vast experience in writing complex queries using t-sql

$16 USD in 10 days

0.0

(0 reviews)

0.0

@sergiogustavo

I'm a 7 years experienced .NET & SQL SERVER developer. My time zone is US Mountain. I am willing to establish a long term relationship with my customers.

$8 USD in 40 days

0.0

(0 reviews)

0.0

@jaygoti

Hello, I have 5 year experience in Microsoft Sql Server Development and Designing and .Net technologies. i am expert in Store Procedure, Functions, Triggers, Views, Indexes and many more. A waiting for your favorable reply. Thanks

$11 USD in 28 days

0.0

(0 reviews)

0.0

@eongodo

A proposal has not yet been provided

$5 USD in 160 days

0.0

(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. • Ability to handle multiple tasks and capable of handling responsibilities independently, managed a team of 8 members in tasks allocation, code reviews, status updating. • Direct interaction with the client for gathering requirements and creating functional documents. • Performance tuning of stored procedures. • Excellent analytical, Interpersonal and communication skills. • Self-disciplined, team player and highly adaptable to ever changing priorities.

$17 USD in 50 days

0.0

(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 triggers) , DBA , SSRS and SSIS.

$7 USD in 160 days

0.0

(0 reviews)

0.0

@somohamedibrahim

A proposal has not yet been provided

$5 USD in 15 days

0.0

(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 in 30 days

0.0

(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 in 160 days

0.0

(0 reviews)

0.0

@sktech85

A proposal has not yet been provided

$5 USD in 160 days

0.0

(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 tuning slow running queries,

$11 USD in 60 days

0.0

(0 reviews)

0.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 in 40 days