
Concluído
Publicado
Pago na entrega
I’m looking for someone who can dive into an existing MySQL 8.4 Community Server database, scrutinise its current structure for hidden bottlenecks and design flaws, and then re-engineer it so we can pull clean, reliable information on demand. You’ll have access to our full SRS and we’ll work together remotely—screen sharing is fine—so you can see exactly how the standalone desktop app runs today. Once the schema review is complete, I’ll need a robust stored program (procedure or function) that joins data across several tables and builds a new view designed for aggregated statistical reports. A companion Python 3 script should automatically call that view, fetch the results, and push them straight into an Excel sheet that mirrors the layout in the diagram I’ll supply. No web front-end is involved; everything stays local on the workstation. Deliverables • Written assessment of current database issues and your optimisation steps • Optimised schema changes (DDL) and the final stored program/view • Python 3 script for automated retrieval and Excel export (xlsx) • Sample Excel file that demonstrates the aggregated report matches the required format • Brief hand-off notes so I can maintain or extend your work independently in the future I’ll be available throughout for quick testing rounds, so if you love measuring execution plans, fine-tuning indexes, and wiring MySQL to Python’s mysql-connector or SQLAlchemy for seamless data pulls, let’s get started.
ID do Projeto: 39753403
112 propostas
Projeto remoto
Ativo há 1 mês
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos

Hello Marion T., I have read the project details and understood the overall requirement. With 5 years of experience in PHP, Python, SQL, MySQL, Database Administration, Database Programming, Data Analysis, and Database Design, I am well-equipped to optimize your MySQL 8.4 database for efficient data retrieval and reporting. I will begin by conducting a thorough review of your current database structure to identify and address any hidden bottlenecks and design flaws. Following this, I will re-engineer the database to ensure clean and reliable information can be accessed on demand. I will create a robust stored program that joins data across multiple tables and builds a new view for aggregated statistical reports. Additionally, I will develop a Python 3 script to automate data retrieval and export it to Excel as per your specifications. You can view my portfolio here: https://www.freelancer.com/u/mannanmaan1425 Please ping me back so we can discuss the project further. Best regards, Abdul
$100 USD em 7 dias
7,3
7,3
112 freelancers estão ofertando em média $199 USD for esse trabalho

Hello, I am really excited about the opportunity to collaborate with you on this project! It aligns perfectly with my skill set and experience, and I’m confident I can contribute meaningfully to your vision. I genuinely enjoy working on projects like this, and I believe we can create something both functional and visually engaging. Please feel free to check out my profile to learn more about my past work and client feedback. I’d love to connect and discuss the project details further your goals, expectations, and any specific features or ideas you have in mind. The more I understand your vision, the better I can bring it to life. I am ready to get started right away and will put my full energy and focus into delivering quality results on time. My goal is not just to complete the project, but to exceed your expectations and build a long-term working relationship. Looking forward to hearing from you soon! With regards! Divya
$300 USD em 7 dias
8,1
8,1

Hello, I can help you to optimize and make sure it use correct mysql indexes and join query to achieve high performant database data fetching. Please kindly contact me for more further discussion. Thank you, Yuda
$300 USD em 2 dias
7,9
7,9

With over a decade of experience under our belt, our team at STR Softwares LLP is ideally suited to undertake your MySQL 8.4 Data Optimization & Reporting project. As a collective of senior Python developers, we have extensive experience with handling and optimizing large-scale databases like the one you have described. This means we can pinpoint hidden bottlenecks, identify design flaws, and craft effective solutions to make your data extraction process more streamlined and reliable. Our proficiency in Python 3 makes us particularly well-versed in creating scripts for automating data retrieval - a skillset that will prove indispensable for your project's need to call organized data views and export the results straight into an Excel sheet. We also possess a deep understanding of MySQL database architecture, providing added assurance of being able to create DDL optimized schema changes as required. Lastly, I want to emphasize our commitment to client satisfaction. We believe in maintaining clear lines of communication with our clients throughout the project duration.
$200 USD em 7 dias
7,4
7,4

Hi Marion, I’ve optimized MySQL databases for multiple products, including a large-scale web app with 1 million+ users. I’ve worked extensively with MySQL 5.7 and 8.0, focusing on performance tuning, schema optimization, and query refinement. I’m also proficient in Python and have integrated it with MySQL using libraries like SQLAlchemy and mysql-connector. In your project, I see two key areas: optimizing the existing database and creating a new reporting mechanism. I can handle both efficiently, ensuring you get a fully optimized solution. Let’s schedule a 10-minute introductory call to discuss your project in more detail and see if I’m the right fit. I usually respond within 10 minutes. I’m eager to learn more about your exciting project. Best regards, Adil
$300 USD em 7 dias
7,1
7,1

Hello Marion, I am excited about the opportunity to optimize your MySQL 8.4 database for data reporting. I will meticulously analyze your database structure, identify bottlenecks, and redesign it for efficient data retrieval. With full access to your SRS, I'll collaborate with you remotely, leveraging screen sharing to understand your desktop app's current performance. I will deliver a detailed assessment of existing database issues, optimized schema changes, a robust stored program/view for statistical reports, an automated Python 3 script for data retrieval and Excel export, and a sample Excel file showcasing the report's format. Additionally, I'll provide comprehensive hand-off notes for future maintenance. If you appreciate tuning indexes, optimizing execution plans, and integrating MySQL with Python seamlessly, I am well-equipped to meet your requirements. I assure you of my expertise in Data Analysis, Python, PHP, MySQL, Database Design, Administration, Programming, and SQL. Once you're ready, I'm eager to commence this project. How soon would you like to kickstart this database optimization project? Thanks, KANIKA
$230 USD em 12 dias
6,9
6,9

As an experienced and dedicated data professional, I have spent a solid decade honing my skills in Database Administration and Python, both of which are integral to the successful completion of your job. My problem-solving attitude makes me a keen analyzer who isn't afraid to scrutinize existing structures for potential issues. This, combined with my meticulous nature has always ensured that I can identify hidden bottlenecks and design flaws others may miss. My 10+ years of experience includes building robust stored programs for precisely this type of project. As such, I'm already well-versed in the art of creating efficient joins across multiple tables, and using these to construct new views that can deliver the aggregated statistical reports you desire. I guarantee not only a functioning solution but also one that is highly optimised. Moreover, my skillset is wholly suited for developing your Python 3 script to automate data calls and export into Excel. I'm proficient in using the mysql-connector or SQLAlchemy for seamless data pulls, which means I can implement exactly what you need without any hiccups. Working remotely is not an issue as I will ensure full transparency throughout our collaboration, including screen sharing for real-time progress updates if desired. Given my track record of achieving 100% client satisfaction, hiring me would mean you're bringing on someone trustworthy and determined to get the job done efficiently and in line with your expectations.
$100 USD em 3 dias
6,5
6,5

Hello, I am a PHP Developer with 15+ years of experience, specializing in building dynamic, secure, and high-performance websites and applications. I have worked on simple to complex websites, e-commerce stores, membership portals, and custom PHP-based solutions, always ensuring top-quality results for my clients. My expertise includes custom PHP development, Laravel/CodeIgniter frameworks, API integration, database management (MySQL), and performance optimization. Recently, I also worked on OpenAI API integration for auto-generated content, images, and social sharing, showing my ability to adopt the latest technologies. If you are looking for a dedicated PHP expert who guarantees quality, innovation, and timely delivery, I’d be happy to bring your project to life.
$100 USD em 7 dias
6,5
6,5

With my wealth of experience and expertise in database management, I am the ideal candidate for optimizing your MySQL 8.4 Community Server and creating efficient reports. I have a proven track record of 10+ years in this field and have excelled in fine-tuning indexes, executing plans, and resolving any hidden bottlenecks or design flaws.
$200 USD em 3 dias
6,3
6,3

Hello Marion T. Hope you are doing well! This is Efan , I checked your project detail carefully. I am pretty much experienced with Database Administration, Python, Database Programming, Data Analysis, Database Design, MySQL, SQL and PHP for over 8 years, I can update you shortly. Cheers Efan
$225 USD em 1 dia
6,5
6,5

Hello, Hope you're doing great. I have extensive experience optimizing MySQL databases and can dive into your MySQL 8.4 Community Server setup to identify design flaws, indexing issues, and bottlenecks. After a thorough schema review, I will provide a clear written assessment along with optimized DDL changes. Next, I will design a robust stored program and view to aggregate your data for accurate statistical reporting. To complete the workflow, I will develop a Python 3 script that automatically queries the view, retrieves results, and exports them into an Excel file formatted exactly as per your supplied diagram. Let’s connect to discuss your vision—I’d love to bring this recruitment piece to life and help attract the next generation of firefighter/paramedics. Feel free to message me to get started! Regards, Adnan H.
$200 USD em 7 dias
6,0
6,0

**Greetings!** I’m an experienced database developer and Python programmer, and I can help optimise your MySQL 8.4 database and automate your reporting workflow. **Here's how I can help:** * Review your current schema for bottlenecks and design flaws, providing a written assessment with recommended optimisations. * Re-engineer the schema and create a robust stored procedure or function to produce an aggregated view for statistical reporting. * Develop a Python 3 script to fetch the view’s results automatically and export them into a pre-formatted Excel file. * Deliver a sample Excel report to confirm the output matches your specifications, along with concise hand-off notes for future maintenance. Could you share the SRS and the diagram for the Excel layout so I can estimate timelines and confirm the full scope?
$250 USD em 7 dias
5,6
5,6

As an experienced freelancer with over 10 years of hands-on experience, I believe I am the ideal candidate to transform your existing MySQL 8.4 Community Server database for optimized data retrieval and reporting. My skill set aligned perfectly with your needs: Data Analysis, Database Administration, Database Programming, MySQL, PHP, Python, SQL—I've got you covered. Taking on this project, my first order will be meticulously assessing your current database structure and identifying the hidden bottlenecks and design flaws that may affect its efficiency. From there, implementing robust schema changes and developing a stored program/view to enable smooth aggregated statistical reports generation becomes a seamless task under my watch.
$200 USD em 7 dias
6,4
6,4

Subject: Full-Stack Developer to Deliver Your Project [MySQL 8.4 Data Optimization & Reporting] — Fast, Secure & SEO-Optimized Results Hi there, Thank you for outlining your project! I’d love the opportunity to bring it to life with precision, performance, and results you can count on. As a Full-Stack Web Developer with 7+ years of hands-on experience, I specialize in building modern, scalable, and conversion-optimized ecommerce websites across WordPress, WooCommerce, Shopify, Wix, Webflow, Laravel, PHP, React.js, Vue.js, and more. Here's how I’ll add value to your project: ✦ Fast, secure, and SEO-friendly development ✦ Clean, maintainable code built for long-term success ✦ Fully responsive design with modern UI/UX ✦ Hosting & domain setup: DNS, SSL, performance tuning ✦ Seamless API integrations, bug fixing, and ongoing support ✦ Transparent communication, on-time delivery, and post-launch care With 90+ 5-star reviews and a proven track record of delivering client success, I’m confident I can exceed your expectations. Portfolio & Reviews: https://www.freelancer.com/u/atifuiux Ready to start immediately — let’s chat and get your project moving! Best regards, Atif IS Full Stack Web Developer | UI/UX Specialist | Webflow Expert
$100 USD em 1 dia
5,7
5,7

I can help optimise your MySQL 8.4 database by reviewing the current schema, identifying bottlenecks, and applying best-practice improvements for clean, reliable reporting. I will deliver a detailed assessment of structural issues, propose and implement schema adjustments (DDL), and build a robust stored program/view that aggregates data across multiple tables for accurate statistical reporting. To streamline analysis, I’ll develop a Python 3 script (using mysql-connector or SQLAlchemy) that automatically queries the new view and exports results to Excel (.xlsx) in the exact format you provide. The script will be lightweight, fully local, and reusable, ensuring smooth integration with your current desktop workflow. Deliverables include: Written database review + optimisation steps Updated schema (DDL) and stored program/view Automated Python-to-Excel export script Sample Excel output for validation Clear hand-off documentation for future maintenance With experience in database performance tuning, indexing, and Python automation, I can ensure both reliability and efficiency. I’ll work closely with you via remote sessions for quick iterations and validation.
$200 USD em 5 dias
5,4
5,4

Hello, Drawing from a decade-long career as a full-stack developer and my proficiency with the required technologies, I strongly believe I'm the best choice for optimizing your MySQL 8.4 data structure and reporting needs. I have comprehensive knowledge of MySQL, PHP, Python, and SQL that will be instrumental in diving into your existing database, identifying hidden issues, and ironing out any design flaws- I live for this kind of challenge! My strong attention to detail combined with an analytical mindset allows me to quickly assess execution plans, fine-tune indexes and provide optimized schema changes (DDL). Apart from my technical abilities, I have a breadth of experience in seamless integration which includes flexibly wiring MySQL to Python's mysql-connector or SQLAlchemy - perfect for automated retrieval and Excel export using a Python 3 script. And though I specialize in React development, my skills are not just limited to front-end work; I'm comfortable working on the backend as well. This adaptability is an asset for your desktop-app focused project. In addition, my thorough understanding of data pulling methods means we can tailor a program or function that not only joins data across several tables but also builds new views designed for aggregated statistical reports. Lastly, I understand the value of clear communication throughout the project—something I prioritize. With easy remote collaboration and screen-sharing capab Thanks!
$100 USD em 15 dias
5,1
5,1

With over 15+ years of experience and a strong team of resources with an average experience of 5+ years in Web Design and Development, we at Muthukumar ensure that the project is delivered both on time and to your satisfaction. Our expertise span across a variety of areas from AWS and Azure for cloud servers, Android and Kotlin for mobile, to Node.js, PHP, and MySQL for backend development. This holistic proficiency makes us uniquely equipped to tackle your MySQL 8.4 Community Server project. We understand that the heart of your project lies in optimizing your existing database structure to obtain accurate and accessible insights for better decision making. We not only promise to apply our excellent database administration skills but also go beyond that by providing a written assessment, schema changes, stored program/view, Python script for data retrieval, and even a sample Excel file demonstrating the aggregated report format you need. Not only will we deliver, but we will also provide comprehensive hand-off notes so you can work on it independently in the future.
$200 USD em 7 dias
5,3
5,3

Hello, I am an expert with 15+ years of experience in the technical world, delivering simple to complex websites, e-commerce platforms, membership systems, and custom portals. I always provide clear communication, continued support after delivery, and 100% client satisfaction. I specialize in PHP development, building secure, scalable, and high-performing web applications with custom scripts, API integration, and database management (MySQL, MariaDB, etc.). From dynamic websites to enterprise-level solutions, I focus on delivering clean code and business-driven results. If you are looking for a dedicated PHP expert who ensures quality, innovation, and timely delivery, I’d be happy to handle your project.
$100 USD em 7 dias
5,6
5,6

Hello Marion T. I hope you're doing well. I understand you're looking for MySQL 8.4 Data Optimization & Reporting I am the ideal candidate for your project. I have read the provided job description and I understand what you are looking for. I have over 10+ years of experience PHP, Python, SQL, MySQL, Database Administration, Database Programming, Data Analysis, Database Design .Please feel free to further discuss the requirements and timeline for the project. I'd be happy to assist you. I am ready to start right now. ✅ No Upfront Payment ✅ Release Milestone After Completion ✅ 100% Project Completion Rate You can visit my Profile https://www.freelancer.com/u/HiraMahmood4072 Thank you
$130 USD em 2 dias
5,0
5,0

Hi Marion T., I came across your post MySQL 8.4 Data Optimization & Reporting and wanted to reach out. Based on my experience and skills, I believe I could be a strong fit for your project. Please feel free to review my profile, and if it aligns with your requirements, I would be happy to discuss your project in more detail. I look forward to the possibility of working together. Best regards, Adrian
$225 USD em 54 dias
4,9
4,9

I specialize in MySQL performance tuning and Python automation, and can transform your current schema into a reliable reporting system with clean Excel outputs. My Method: • Schema Audit: Review tables, PK/FK relationships, datatypes, and indexing; measure execution plans with EXPLAIN ANALYZE to uncover bottlenecks. • Optimization: Propose DDL changes—normalize where needed, add composite/covering indexes, align datatypes, and prune redundancy. • Stored Program + View: Build a robust procedure that joins key tables into a single reporting view using CTEs/window functions for aggregated statistics. • Python Exporter: Use mysql-connector-python (or SQLAlchemy) + xlsxwriter to fetch data, format headers, freeze panes, and export a polished Excel file that mirrors your diagram. • Deliverables: Written audit with fixes, optimized schema DDL, final procedure/view, Python script, sample Excel report, and handoff notes for future maintenance. I’ll work with you via screenshare for quick test iterations, ensuring the report is both fast and accurate. Questions: • Approximate row counts/volume for largest joins? • SLA expectations for report run time? • Any strict Excel formatting (fonts, styles, branding)?
$200 USD em 7 dias
4,8
4,8

Chesapeake, United States
Método de pagamento verificado
Membro desde mar. 6, 2022
$30-250 USD
$50-75 USD
$30-250 USD
$15-25 AUD / hora
$10-40 CAD / hora
$10-30 CAD
$14-30 NZD
€1500-3000 EUR
$15-25 AUD / hora
₹12500-37500 INR
$50-70 USD
₹37500-75000 INR
€18-36 EUR / hora
€18-36 EUR / hora
₹600-1500 INR
$30-250 AUD
$115-200 HKD / hora
$10-100000 USD
$30-250 USD
$10-30 CAD
$25-50 USD / hora
$250-750 USD
$10-30 USD