We have a website where we have some complex queries which are taking very long. We used postgis to optimize the performance of location aware queries but are running in to bottlenecks due to the size of the database (currently sitting at over 10 million records). We want someone who understands postgres, sql, and postgis to help us optimize our queries. This may involve sql query engineering, optimization, indexing, restructuring of data (not something we are very inclined to do). We have are filtereing the database by 4 main parameters. We need this done within a week. Please send us a message with link to past projects. Thank you.

Web APP responsive to mobile -all devices - Safari Chrome Edge Firefox Current team needs assistance w time clock and updates synchronized to play clock w/ on issues as they coordinate events on pages. Seeking 1 expert in custom PHP no framework that has experience in Auction Development. Will consider retaining long term as support team member

Need a simple project Gantt chart which will provide five different colored sections (use only light blue, and light green to separate each section). Each section should have at least 20 line entries. The project start date should be for Monday, May 13, 2024 and end October 31, 2024. The project view and progress bars should show each day of the week. A sample of what we are looking for is attached.

Hiya - I have about 8-9 boxes and a guitar amplifier that I need carried out of my room and to my car. I had ankle surgery 6 weeks ago so not able to carry anything right now. There is one flight of stairs down and the car is probably at most 20 or so feet from the front door. Location is Swarthmore, PA

Job Title: Class Action Lawsuit Lawyer Location: Anywhere outside Minnesota (Remote work) Overview: We are seeking a skilled and experienced lawyer to represent approximately 100 residents in a class action lawsuit against an apartment management company located in Minnesota. The management company has consistently neglected maintenance requests, failed to address apartment issues, and allowed amenities to remain non-functional for years, despite residents' payments for these amenities. Additionally, residents unknowingly signed a lease agreement containing a no-class action lawsuit clause, and the management company attempts to silence residents by requiring them to sign NDAs after maintenance requests are completed. Residents are experiencing severe issues such as leaking ceilings, which have been neglected for years, leading to ceilings collapsing from the rafters. Responsibilities: 1. Provide legal counsel and representation to the residents in a class action lawsuit against the apartment management company. 2. Conduct thorough legal research and analysis to build a strong case against the management company, focusing on breaches of contract, negligence, and any other relevant legal grounds. 3. Collaborate with the residents to gather evidence, including documentation of maintenance requests, communication with the management company, and lease agreements containing no-class action lawsuit clauses and NDAs. 4. Investigate and document specific instances of negligence and disregard for resident safety and well-being, such as leaking ceilings and collapsing structures. 5. Develop and implement a legal strategy to effectively advocate for the residents' rights and interests in court. 6. Communicate regularly with the residents to provide updates on the progress of the lawsuit and address any questions or concerns they may have. 7. Represent the residents in negotiations with the management company and other parties involved in the case. 8. Prepare and file all necessary legal documents and pleadings with the appropriate courts. Qualifications: 1. Juris Doctor (JD) degree from an accredited law school. 2. Admission to the bar in the relevant jurisdiction(s). 3. Proven experience in handling complex civil litigation cases, preferably including class action lawsuits. 4. Strong knowledge of contract law, property law, and landlord-tenant law. 5. Excellent research, writing, and oral advocacy skills. 6. Ability to work effectively with a diverse group of clients and stakeholders. 7. Demonstrated commitment to advocating for justice and protecting the rights of individuals. If you are passionate about fighting for the rights of tenants and have the skills and experience to represent our residents in this important legal matter, we encourage you to apply.

Seeking a skilled paralegal to assist with filling out legal forms. The ideal candidate should have a solid understanding of legal terminology and documentation. This role will primarily involve reviewing and completing various forms, ensuring accuracy and compliance with legal requirements. The ability to work independently and meet deadlines is crucial. Strong communication and research skills are also essential. Skills required: - Proficiency in legal writing and research - Knowledge of legal terminology and documentation - Attention to detail - Excellent organizational skills - Strong communication skills This is a small-sized project with an estimated duration of under 1 month.

Multi Family construction Project Scheduler for New Buildings. 8 Story 77 Units Residential 1600 Square Feet Retail 15 Months total Duration of Job See attached sample. Please let me know if you would like the full set of Drawings.

I need our website designed & fully fleshed out. I have the colors I'd like to stick too. No Logo at this time ( would like that done too). We plan to sell digital and physical products and have a blog. I'll be linking some inspo below. I attached our pinterest banner to give an idea of what kind of style were going for. Color scheme also attached. Please provide examples of work you have created. AI GENERATED PROPOSALS WILL BE IGNORED. IT DOESNT NEED TO BE AN ESSAY. :) https://www.etsy.com/listing/1711102052/squarespace-website-template-pastel?ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=squarespace+template&ref=sc_gallery-1-16&pro=1&sts=1&dd=1&plkey=3edaed24a5622d1b49ca4ebd18001517feb34857%3A1711102052 https://www.etsy.com/listing/1696238009/squarespace-template-71-pink-website?ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=squarespace+website+template&ref=sr_gallery-2-16&pro=1&dd=1&content_source=7218f921ac78d7bb109123dcb279d73373ecfdb2%253A1696238009&organic_search_click=1 https://www.etsy.com/listing/1713684604/squarespace-store-squarespace-template?ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=squarespace+website+template&ref=sr_gallery-2-31&pro=1&dd=1&content_source=a08e5fa9b793123851d26d1d7b01b7d992e18bda%253A1713684604&organic_search_click=1

We are seeking a Shopify Store Optimization Specialist to help us boost sales for our existing Shopify store. The ideal candidate will have a solid understanding of the Shopify platform and proven experience in improving conversion rates. As a Shopify Store Optimization Specialist, you will be responsible for implementing strategies and tactics to increase customer engagement, optimize product listings, and enhance the overall user experience. Key Skills: - Proficient in Shopify platform - Strong knowledge of e-commerce best practices - Conversion rate optimization - A/B testing - User experience design Size: Medium Duration: 1 to 3 months Expertise: Intermediate

My company, Mecella Co., needs a total website makeover. We currently use the Colibri theme but want a more modern, sleek, responsive, and sophisticated look. I request that the site be made from the ground up using a designer like Elementor. The theme will be black and white. Please visit https://Mecella.co to get a feel for the website. All the pages you find on the current site will be used for the new site. **This project starts June 1st.