Find Jobs
Hire Freelancers

SQL Database Design and Optimization

$25-30 USD / hour

Closed
Posted 12 days ago

$25-30 USD / hour

I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in SQL coding - E,perince in Data warehouse like Data profiling, Data Validation, Data Quality etc.. This project is a great opportunity for a SQL developer looking to showcase their skills in building and optimizing database systems.
Project ID: 38074257

About the project

41 proposals
Remote project
Active 6 days ago

Looking to make some money?

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
41 freelancers are bidding on average $29 USD/hour for this job
User Avatar
Hi There, With my 15 years of professional experience, I offer in-depth expertise in using Microsoft SQL Server Analysis Services with hands-on Azure SQL experience- two core requirements for this task. Throughout my career, I have mastered complex SQL scripting for data processing, transformations, and migration- further emphasizing my ability to design and optimize high-performing databases. With my meticulous nature and a strong focus on accuracy, I am confident that I could exceed your expectations and help in the most efficient manner possible. Looking forward to discuss details. Warm regards, Saima
$25 USD in 40 days
5.0 (27 reviews)
5.0
5.0
User Avatar
Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Bursary, Pos System and Sacco system. I have used tools such as SQL Developer, SQL Plus, SQLYog, MySQL Workbench, SSMS etc. Am confident I can handle your project. Kindly open a discussion with me so that we talk the best way to work. If you award me the project I will work closely with you throughout the whole project life span, communicating continuously at every stage with updates until the project comes to fruition, in perfect condition, and ready for submission. Hope to work with you soon! Thanks Nyaronyari
$28 USD in 40 days
5.0 (32 reviews)
4.9
4.9
User Avatar
Hi i have 17 years of experience in c#, asp, sql server development,performance tuning, python, machine learning and power bi. I would be able to help you with the project. Please ping offline to discuss further
$60 USD in 20 days
4.9 (13 reviews)
4.6
4.6
User Avatar
I have more than 15 years of experience in SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business in an efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages. I am also good and working with big clients for BI parts like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I am also involved in Data warehouse design for OLTP systems. I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management. I assure you that you will get complete satisfaction regarding my work and output. Looking forward to working with you. Thanks Anil
$28 USD in 40 days
5.0 (6 reviews)
3.3
3.3
User Avatar
Drawing from my deep well of experience in SQL and database management, I assert that I am the perfect candidate for your SQL Database Design and Optimization project. Over the years, I’ve established expertise in Microsoft SQL Server Analysis Services within an Azure SQL environment, aligning perfectly with your needs. My skill set also encompasses data warehousing, which is essential for creating efficient and scalable database systems. Being a GCP-certified Database Engineer, I have a profound understanding of the optimization process. I can tune your queries precisely and strategically to deliver peak performance from your database system. Furthermore, proficiency in data validation, profiling, and quality assessments ensures the robustness and reliability of your data infrastructure. Together with my keenness for data visualization tools like Power BI and Looker, I guarantee that not only will your database become fast, efficient, and economical but also produce clear and actionable insights. Is there anything better than that? Let's quickly discuss how we can leverage my breadth of knowledge and skills to get the most out of your data storage today.
$28 USD in 40 days
5.0 (2 reviews)
2.8
2.8
User Avatar
SQL EXPERTS! We are working on sql since last 11 years. We could do it. Could we discuss in details over chat now? Best Regards Techwelfare
$30 USD in 40 days
5.0 (1 review)
1.5
1.5
User Avatar
Hi , I am software developer with 15 yrs experience in db design and sql query optimization. I have built 300+ small , medium and enterprise level applications. Send me a message so I can show you my previous work and we can discuss more. Best regards, Ravi
$28 USD in 40 days
5.0 (2 reviews)
0.8
0.8
User Avatar
Apart from my specialization in the areas of Machine Learning, Deep Learning, Statistical Analysis and Web Scraping, I also have a strong grasp on SQL. Being a graduate from IIT Roorkee, I have gained valuable knowledge and experience in Database Management which is an essential part of Data Analysis. My aim has always been to leverage data to make accurate decisions for clients and by choosing me, you can expect this same level of dedication and commitment to your project. Not only am I familiar with SQL, but my technical proficiency also extends to other databases like Microsoft SQL Server as well as tools such as Azure SQL. These skills are absolutely necessary for the task at hand - designing and optimizing a new database system. To add more weightage to my candidacy, let me mention my familiarity with data warehousing concepts and the fact that I've worked on similar projects before. In conclusion, hiring me means getting a versatile professional who understands not just the technical aspects of your job description but also its larger purpose - enabling better decision making through data analytics. I believe my interdisciplinary background sets me apart from other candidates and primes me to bring innovative ideas to your organization. It would be an honor to be given the opportunity to contribute my skills towards your project's success!
$28 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am expert in writing transact SQL quereies or coding. i have decades of expereience in Microsoft SQL Server data warehousing concepts,Microsoft SQL Server Analysis Services, Azure SQL environment
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Hope you are doing well. I am a Data Engineer and working on azure from past 4 years now. Being a data engineer, i have worked on azure sql server , ADF, ssis, Databricks, synapse etc. And have gained extensive knowledge on database designing and data warehousing. I am new to freelancing hance dont have much to showcase over here but given a chance i can share you my resume and we can discuss the work of your project. Looking forward to work with you. Best Regards Krishna Y.
$25 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have 20 years of full time experience in database design, development and query optimizations in Oracle, SQL Server and MySQL. I can work in designing databases, writing efficient queries, stored procedures, triggers and optimize queries when required (when database/dataset becomes very large size or queries are improperly written). I have also worked several times on performance monitoring and identifying bottlenecks of databases in oracle and SQL server, using database monitoring scripts and tools. I can provide you reports on CPU utilization, IO, memory usage and storage mismatch information in database, along with slow running queries and suggest ways to improve it. I am Individual freelancer and can work full time or part time as required, provided I get the requirements though meetings or documents. Looking forward to hear from you soon and work together.
$28 USD in 40 days
5.0 (1 review)
0.2
0.2
User Avatar
Hello, With a profound expertise in Microsoft Azure, I am confident that I possess the skills your project requires. Throughout my career, I have worked on numerous data warehousing projects including designing, optimizing and managing SQL databases. For the specific Microsoft SQL Server Analysis Services in an Azure SQL environment component of your project, I have demonstrated experience in ensuring exceptional performance and maximizing efficiency. My proficiency in SQL coding coupled with data profiling, validation, and quality assurance skills makes me equipped to handle every aspect of this project. I recently have completed a project here " Azure AD Review/Security Analysis ". You can my project feedback from this following link : https://www.freelancer.com/projects/active-directory/Azure-Review-Security-Analysis/reviews By choosing Solutionzhere, you are partnering with a seasoned expert who promises transformative excellence for your database system. Let’s elevate your organizational performance together! Regards Solutionzhere
$30 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I have rich experiences in Database management. I'll develop your programming using C#. I'm confident I can help you with this project. I'm exited about the opportunity to work with you. Please contact me to discuss in details. Thanks for considering my bid.
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am sure that, with my more than 7 years of SQL programming and optimization knowledge, I am the ideal candidate for your database design project. I have a track record of successfully applying my Microsoft SQL Server knowledge to develop reliable, effective, and scalable solutions. I am skilled at using Microsoft SQL Server Analysis Services and Azure SQL environments for your unique requirements because of my familiarity with these platforms. Throughout my career, I have demonstrated a deep understanding of data warehousing concepts and the ability to optimize queries to improve performance. This, combined with my strong coding skills in SQL, will ensure that your database system is not only designed effectively but also optimized for optimal performance. Skills:- Database Design and Optimization SQL Proficiency Data Warehousing Microsoft SQL Server Analysis Services Azure SQL Environment Moreover, my proficiency in Azure technologies including Azure DevOps and Kubernetes would enable me to efficiently manage and deploy the solutions we develop. I look forward to the opportunity to put my skills to use on your project and contribute towards its success. Let's make your innovative vision a reality together! Thank you for considering my proposal. I am looking forward to the prospect of growing with your business. Best regards, Vipul
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Stand out from the competition with a video bid Get ahead of the competition by recording a quick video describing why you are the best freelancer for this job. Your video will be shown on your bid with a new, eye-catching animation. Freelancers who send a video bid are 34% more likely to be contacted by a client.*
$28 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Nice to meet you yateeshbalaji1, It is a pleasure to communicate with you. My name is Anthony Muñoz, I am the lead engineer for DSPro IT agency and I would like to offer you my professional services. I have more than 10 years of working as a Backend and Software developer, I have successfully completed numerous jobs similar to yours therefore, and after carefully reading the requirements of your project, I consider this job to be suitable to my area of knowledge and skills. I would love to work together to make this project a reality. I greatly appreciate the time provided and I remain pending for any questions or comments. Feel free to contact me. Greetings
$56 USD in 40 days
0.0 (0 reviews)
3.9
3.9
User Avatar
I am writing to express my keen interest in your project seeking an experienced SQL developer for designing and optimizing a new data warehouse system on Microsoft SQL Server Analysis Services (SSAS) within Azure SQL. My [Number] years of experience working with MS SQL Server and data warehousing principles make me a strong candidate to deliver a high-performing solution.
$28 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Leveraging on my strong foundations as a Java Back-End Developer, I have immersed myself in the SQL terrain, honing my skills in database design and optimization to meet the unique needs of any project. Your project - rooted on revolving around Microsoft SQL and Azure SQL - aligns perfectly with my expertise. My knowledgeability in not just working with SQL, but also designing relational databases plus optimizing these for enhanced performance is an invaluable asset. In addition to Microsoft SQL Server Analysis Services, a tool you need uniquely for your system; I am also highly competent in other significant tech areas like spring Boot and Hibernate. This means that I’ll be able to navigate beyond strictly the design responsibilities in this task and deliver a more comprehensive package if required. But it's not just about what I can do; it's also about how I do it. With a results-oriented approach, emphasis on quality, and meticulous care for efficiency, I assure you the best outcome from every dollar spent. Plus, my knack for smooth inter-team rapport through excellent communication skills promises cordial collaboration that remains professional throughout. Together with these qualities and more - like being able to meet tight deadlines while still delivering impressive outputs –
$28 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, We can design and optimize a new database system with Microsoft SQL Server Analysis Services in an Azure SQL environment. We have 10+ years of experience in all these mentioned tech stacks and we are a team of well-established 150+ professionals. NOTE - I can share my recently built URLs with you in the chat box for your reference. Let's connect on chat and discuss this further in the meeting. Regards!
$25 USD in 50 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am excited to submit my proposal for the SQL Developer position focused on database design and optimisation. With a robust background in SQL development, particularly with Microsoft SQL Server and data warehousing in Azure environments, I am confident in my ability to contribute effectively to your project. Key Skills and Experience: Database Design and Optimization: I have significant experience in designing and optimizing database systems, particularly in Microsoft SQL Server environments. I am skilled in schema design, indexing strategies, and query optimization techniques to enhance performance. Microsoft SQL Server Expertise: I possess advanced proficiency in SQL programming with a focus on Microsoft SQL Server. I am adept at writing complex SQL queries, stored procedures, and functions to manipulate and retrieve data efficiently. Microsoft Azure Skills: I am familiar with working in Azure SQL environments and leveraging Azure services for data management and analysis. I have experience deploying and managing databases on the Azure platform. Experience with Analysis Services: I have hands-on experience with Microsoft SQL Server Analysis Services (SSAS) for multidimensional data analysis and reporting. Data Quality and Validation: I am experienced in data profiling, data validation, and ensuring data quality standards within a data warehouse environment.
$28 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Hyderabad, India
0.0
0
Member since Oct 10, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.