Schemapekerjaan

I'm in need of a schema markup expert with a high level of proficiency to implement necessary markup for my water treatment business - uswater. The project involves targeting approximately 60-70 cities for 5 different water treatment services. The website I'm working on is built on WordPress. Key Details: - I require schema markup for 5 different water treatment services, namely water filtration, water softening, water purification, legionella testing & management. - The focus is on 60-70 cities, although the range may widen based on the most cost-effective approach. Ideal Skills & Experience: - Proficiency in implementing schema markup, particularly for local SEO purposes. - Extensive experience with WordPress, as the website is built on this platf...

...performance, visibility, and user experience through effective web development and SEO strategies. Our newly migrated site is ready to switch to the live domain. Before or after site Domain is switched to Live Domain. We need to have the following changes/updates done Responsibilities: 1. SEO Optimization: • Implement advanced SEO techniques using Rank Math SEO (Paid) to optimize product descriptions, schema markup, and on-page content for improved search engine visibility. • Utilize Linkwhisper (Paid) to strategically optimize internal linking structure and enhance topical authority for blog posts, ensuring content is displayed in a topical authority format on the blog page. • Monitor and analyze SEO performance metrics, making data-driven decisions to improve or...

**Job Type**: Full-time **About Us**: We are a startup in stealth mode located in the Bay Area. Our mission is to revolutionize Event management through innovative solutions and cutting-edge technology. **Role Overview**: We are seeking an experienced Backend Developer with strong expertise in FastAPI to join ...Bitbucket. 5. Good understanding of CI/CD pipelines, specifically Jenkins. 6. Strong problem-solving skills. 7. Ability to write clean, readable, and maintainable code. 8. Excellent communication skills. 9. Advanced knowledge of FastAPI framework 10. Strong understanding of database integration and management 11. Proficiency in handling API requests and responses 12. Experience with data modeling and schema design 13. Ability to optimize database performance for efficient ...

- XML Experience with Layout Creation in Schema St4 by Quanos

This project is research. It does not require technical implementation, but requires technical analysis and solution design with complete documentation. We wish to study and analyze the API of teachablemac...page (a page that can have the role of a player ). The reports/logs page is essential here as well. Deliverables: • Mockups of the process (indicatively the teacher's settings page (with or without the upload), the student's View (Player page), the reports/logs that the teacher sees for all students, the reports/Logs that the student sees for myself) • API matching for settings pages. • Database schema • Detailed documentation of the process The result of the above deliverables should be such that it allows a developer to know exactly what to imp...

Hello All, Need below resource on monthly basis. Its totally remote work. Tableau Admin JD - ( 4+ years of exp )( Payment is between 60k to 80K Per Month ) Should have good experience about configuration, migration, upgrade, and maintenance of Tableau Server/Online Tableau Architect JD - ( 6+ years of exp) ( Payment is between 80k to 1 Lac Per Month ) good experience on complex schema building. PLEASE REPLY ONLY YOU MATCHED WITH BUDGET AND READY TO WORK ON MONTHLY BASIS FULL TIME. More info will be share later. Thank You

I'm looking for a developer who can build the frontend of an art supplies multi-vendor e-commerce site, specifically focused on paints, brushes, canvas, pencils, etc. The project needs to be ...Understanding of art supplies and e-commerce in this niche Your role will be crucial in enhancing the online shopping experience for art enthusiasts and professionals who visit the site. If you're ready for a project that needs immediate attention, and you have the right skills for it, I'd love to hear from you. There are some related files attached down below. The screenshots for sample interface @ ER schema and requirements file is for ideas about the sections would developed in frontend. There not much informations about multi-vendor functionalities in documents but site w...

I'm in need of an experienced MySQL and Neo4J expert who can help me with designing a database schema and an ERD Diagram from a CSV file. Make a report of the database with proper screenshots and run some queries. more details in chat... Requirements: - Proven expertise in MySQL and Neo4J - Solid understanding of database schema designing - Producing an ERD Diagram

Project Overview: We are looking for a skilled developer or development team to create a custom form and page bui...Facilitate the viewing of generated form code and its modification. - Utilize MongoDB for storing form templates and data. 3. Page and Form Viewing: Ensure created pages and forms are viewable with TailwindCSS library components, maintaining responsiveness and design integrity. Project Deliverables: Well-structured, reusable frontend ReactJS codebase. Efficient and maintainable Flask backend. Database schema design for MongoDB and PostgreSQL. Thorough documentation outlining project architecture and usage. Additional Considerations: Prioritize user-friendly, visually appealing interfaces. Ensure seamless cross-browser compatibility. Performance optimization should b...

...Work for integrating your system with Azure SQL and developing the necessary functionalities on your Wix Application: **Azure SQL Integration and Database Setup:** - Integrate the system with Azure SQL. - Create databases for **Customer Information**, **Customer Sizing**, **Certification Information**, **Purchase Information**, **Courses**, and **Certification Dates**. - Define data structure and schema based on the provided Excel sheets. - Develop data import and validation processes. - Implement security measures and conduct regular audits. **Wix Application Development:** - Develop forms and interfaces for adding and modifying student information. - Implement automatic linking of website members to the Customer Information database based on email and birthdate. - Create cour...

I'm looking for an experienced professional to correct several issues identified by a Semrush audit on my WordPress website. This work involves, but is not limited to: • Fixing redirect loops • Addressing a missing business field in the schema • Numerous additional tasks identified from the audit report Please note, there haven't been any notable recent changes made to the site. As such, I require someone with strong WordPress experience and a deep understanding of SEO. Proven success fixing Semrush audit issues is a must for this project. Quick turnaround time is highly appreciated as these corrections need to be made urgently.

...Handle OAuth authentication and data synchronization for discounts and transactions. Unit Testing and Quality Assurance: Implement comprehensive unit tests for all backend components to ensure reliability and maintainability. Adopt a test-driven development approach and use continuous integration tools to automate testing processes. Database Management with PostgreSQL: Design a PostgreSQL database schema to store user and business data, discount information, and transaction records. Ensure data integrity and implement efficient querying for app functionalities. Security and Compliance: Implement security best practices for API endpoints, data encryption, and user authentication. Ensure compliance with data protection regulations and Clover's API usage policies. Required ...

Hello All, Need below resource on monthly basis. Its totally remote work. Tableau Admin JD - ( 4+ years of exp )( Payment is between 60k to 80K Per Month ) Should have good experience about configuration, migration, upgrade, and maintenance of Tableau Server/Online Tableau Architect JD - ( 6+ years of exp) ( Payment is between 80k to 1 Lac Per Month ) good experience on complex schema building. PLEASE REPLY ONLY YOU MATCHED WITH BUDGET AND READY TO WORK ON MONTHLY BASIS FULL TIME. More info will be share later. Thank You

Hello All, Need below resource on monthly basis. Its totally remote work. Tableau Admin JD - ( 4+ years of exp )( Payment is between 60k to 80K Per Month ) Should have good experience about configuration, migration, upgrade, and maintenance of Tableau Server/Online Tableau Architect JD - ( 6+ years of exp) ( Payment is between 80k to 1 Lac Per Month ) good experience on complex schema building. PLEASE REPLY ONLY YOU MATCHED WITH BUDGET AND READY TO WORK ON MONTHLY BASIS FULL TIME. More info will be share later. Thank You

Looking for highly experienced data entry specialist who is detail-oriented, conscientious, and efficient. Experience updating meta tag and schema markup is preferred but not required. Will need to copy and paste data into a dashboard with multiple documents open simultaneously.

...Gmail Account Create Google Developer Account (we supply credit card) Create Google API with OAuth and proper credentials for: - Embedding Google Maps - Google Gmail API - Google Reviews and Rating plugin Install WP Mail SMTP (or comparable) Create ReCAPTCHA key Integration Install Recaptcha via Kadence / Astra Plugin Install GTM on website Install and Set up Rankmath Pro (General setup, No schema) Install Reviews and Rating - Google Reviews Our goal is to partner with someone who understands the importance of these details and has the capability to execute them with precision. We recognize that finding a subcontractor proficient in all these areas within a reasonable budget may be challenging. Therefore, we are open to discussions about what parts of this list you are m...

Looking for highly experienced data entry specialist who is detail-oriented, conscientious, and efficient. Experience updating meta tag and schema markup is preferred but not required. Will need to copy and paste data into a dashboard with multiple documents open simultaneously. Must complete entries for one city every 15 minutes for a total of 4 cities per hour. Total of 40 hours over a one-week period. Before responding to this job post

I need a helping hand with SEO to carry out an audit in my website, and do the necessary implementations. My website is in Software Industry. I have a RankMath SEO plugin installed, but I want to enhance it properly to get use of all the available features. I want the SEO guy to carry out the following things: 1) Adding structured data to my Website - Schema markup 2) Breadcrumbs implementation 3) Make sure file is added to my Google Search Console account 4) Setting up sitelinks to show in Google Search Results. 5) Checking if properly internal links are used between pages 6) Adding "noindex" tags to the pages that I do want to remove from search. 7) Proper use of Canonical tags 8) Checking if there is any need on renaming any of the page titles 9) Check if ...

...descriptions of their business visions. Go-To-Market Plan Analysis: Logic and infrastructure to analyze submitted visions and generate tailored strategic plans. Utilization of Full Stack FastAPI Template () Leverage the existing user authentication (login and registration) provided by the template. Use the template's built-in database and schema designs as a foundation, extending them to support additional features like vision storage and analysis results. Development Focus Customization and Enhancement: Adapt the user interface to incorporate vision submission functionalities. Enhance the backend to process and analyze business visions, integrating with external APIs for market data where necessary. UI/UX Design: Develop intuitive and

We are seeking a proficient Sanity Developer who specializes in mobile design and is adept at resolving website errors. As a Sanity Developer in this rol...errors on our website using Sanity CMS to ensure a seamless user experience across all devices. Tech Stack: Sanity CMS HTML5, CSS3, JavaScript React.js (or similar front-end framework) Responsive design frameworks (e.g., Bootstrap) Version control systems (e.g., Git) Web debugging tools Task Required: Website: - Mobile Design - W3C Errors (Clean Code) - Form Validation - Old Links - sitemap - Schema Markup Please review the attached documents for a list of issues that need to be addressed for sanity. :w:/g/personal/roevic_austria_kmc_solutions/EZHaBSbu5UFPgMYpQarhVxkB9qt76ahGyf-3s9vrOiRACg?e=nmJdEO

I'm looking for an expert in database schema and development, ideally with experience in price comparison websites, especially in electronics sector. The scope includes: - Creating a comprehensive, efficient database to store data on electronics products primarily, including product prices, specifications, and details of the vendors. - This data will need to be structured in a way that allows for easy and consistent updates, as new products and prices will be integrated into the database on a daily basis. We are looking for experienced professionals to undertake the creation of a comprehensive database for the development of a price comparison website. The website will work similarly to well-known platforms such as greek website , providing users with information on product

I'm in need of an expert with Debezium for a change data capture (CDC) project. The source database for this task is Oracle, more specifically, Oracle 19c. Your expertise should involve: - Deep understanding and experience managing CDC with Debeziu...seamless data integration and real-time data synchronization. Experience with similar projects is highly desirable. Request detail Trying to Setup Oracle (OnPrem) to GCP (Pub Sub) migration using Debezium. Basic connection (end to end) is setup, including setup of logminer on Oracle side However, unable to see actual data (historical & incremental) flowing from Source to Sink I see the table schema messages being sent to PubSub successfully, but actual data is not flowing. When i configure more than 1 table in config file, i...

...attitude are highly appreciated. Key responsibilities: - Writing and debugging SQL & PLSQL queries - Handling PL/SQL procedures and packages - Managing and rectifying production defects - Conducting unit testing experience with Jira tickets platform is preferable. The ideal freelancer for this job would be a proficient PL/SQL developer with exceptional debugging skills, experience in database schema design, and an understanding of the healthcare sector's nuances. Experience with Jira and other project management tools will be a plus. Disclaimer: My salary is around Rs.35,000/- per month so i can only pay around Rs.6,000/- per month but if you are able to complete said task we can negotiate please read through everything and ping me if you are intrestedMore detail...

I need someone to help me integrate Bank API, BBPS API, KYC API, as well as, Create/modify APIs in existing system:- 1. Create referral/cash-back programs module, 2. FD - Schema like 12% club (Create FD, FD calculator, FD history, Renew FD, Break FD, etc.) 3. Add a Drop down to Merchant App Registration API to select business type/category. 4. Modify Commission API. Refer to - QRPay - Money Transfer with QR Code Full Solution at codecanyon

...Finals rounds / Heats and update format on website - Add Series standings - Add filter to pilot and channel drop downs - Modify round/heat view and update status - Make Leader board sorting dynamic, add profile pictures - Add Team profiles, leader boards, and functionality - Add Race Event functionality, race type and leaderboard tracking - update contact us to email address - ENCRYPT database schema for storing user data, event information, and voting records. - Implement the admin panel for basic CRUD (Create, Read, Update, Delete) operations on events and heats. - Build the front-end views for user profile creation and event browsing. **Milestone 3: Dev Testing** **Milestone 4: Prod Testing and Refinement** - Perform thorough testing of all MVP features, including unit tests...

I urgently need a professional database designer to create an efficient MySQL schema. The primary purpose of the database is to track sales data. Requirements: - Expertise in MySQL - Experience in schema design - Proficient knowledge of database normalization - Awareness of best practices relating to tracking sales data I need next database tables: Users: Shipping and Billing addresses Products: (with and without Products attributes (colors, sizes could have different prices)). One product could be added 2 times to she Shopping Cart but with different attributes that will result in the same product with different prices. Payment Methods (stripe tokens) Cart (for sign in users and for guest users (should we generate a token to keep products in the shopping cart for not reg...

...for lots - Open preferred map app for directions to lots Technology Stack: The web application will be developed using modern technologies, potentially including: We have no preference of technology stack, just ensure modern templates and standards. - Laravel PHP or Python Django for backend development - React.js for frontend development - Database discussions to determine the most suitable schema - Payment gateway integration for secure transactions Additional Requirements: - Implementation of robust security measures to protect personally identifiable information (PPI), including secure storage of driver license information. - Compliance with legal regulations and best practices regarding data privacy and security. Proposal Submission: Interested freelancers can submit ...

...Description: The Briggs Coffee Company is a new entry into the retail and commercial coffee industry in North America. There is a need to establish a long-term relationship with a creative marketing group or individual to develop a wide portfolio of creative output. - Branding and logo design: Based upon the brand story, develop brand identify concepts including a company logo, fonts, color schema, and style to present the brand in a consistent manner. - Website Design: complimenting the branding of BCC, develop a fully functional website including e-commerce. - Product Packaging: Foils and packaging for individual coffees and packaging for brewer hardware and accessories. - Social media management: A crucial aspect of our marketing strategy, I need someone who can effect...

My project requires implementing a conversion from specific sheets in an XLS file to XML. I would appreciate a freelancer who can: - Focus on converting only select sheets from the XLS file - Use the XML schema already provided - Handle complex data structures present in the XLS file The ideal freelancer should be comfortable with both XLS and XML file formats, and have previous experience with complex data structures. Adequate knowledge in pivot tables and nested tables within an Excel environment will be beneficial.

I want a web developer skilled in advanced schema implementation who's proficient in SEO to enhance my website's visibility on search engines. The task involves executing schema markup on three major sections of my site - the Homepage, Product pages, and About Us page. The following details need to be integrated into the schema: 1. Course schema 2. local business schema 3. organization schema 4. website sitelink schema 5. Product schema 6. sitenavigation schema 7. article schema 8. blogposting schema 9. webpage schema The primary aim of this project is to improve our search engine visibility and potentially drive more organic traffic to our site. Relevant experience in both schema...

...actionable insights. - Keyword Research and Optimization. - Optimizing Meta descriptions and Title tags. - Image optimization. - URL optimization. - Improving the website's loading speed. - Implementing Rich Snippets for better CTR. - Improving site's mobile-friendliness. - Add target keywords to your body content - Generate accurate breadcrumb schema and navigation - Improve navigation with internal links - Add engaging visual content - Apply schema markup Skills and Experience Required: - Proven SEO experience specifically with WordPress sites. - Knowledge of Search Console & Google Analytics. - Experience with SEO tools like SEMrush, Yoast, etc. - Understanding of the skincare or beauty industry would be a plus. I'm looking for a long-term partne...

...programs for users to ensure adherence to HIPAA regulations. - Regular review and updates of user access permissions based on job roles and responsibilities. Development Approach: 1. Requirement Analysis: Gather detailed requirements from stakeholders and conduct a risk assessment to identify potential security and compliance risks. 2. Design Phase: Design the system architecture, database schema, and user interfaces with a focus on HIPAA compliance and security. 3. Development: Implement security controls and HIPAA-compliant features using appropriate technologies and frameworks. 4. Testing: Conduct thorough testing, including security testing and compliance validation, to ensure adherence to HIPAA regulations. 5. Deployment: Deploy the system to HIPAA-compliant hosting envi...

Certainly, here's a detailed guide for addressing the on-page SEO tasks for our website : 1. Google Search Console / Bing Webmaster Tools Setup: Register our site with both Google Search Console and Bing Webmaster Tools. Verify ownership to access valuable insights & fully Set-up 2. Schema Markup: Implement structured data using appropriate schema markup to enhance search engine understanding of your content. This can include schemas for articles, videos, FAQs, etc. 3. Page Indexing: Ensure that all important pages are indexed by search engines. Use the "site:" operator in search engines to check which pages are already indexed. 4. Alt Tags for content: Enable dynamic Alt Tags in the admin panel. Implement automation based on trending titles on Goo...

...seeking a Laravel Developer who specializes in building innovative and efficient applications. For this project, your task is to create a custom content management system (CMS), particularly designed around the core function of investment management. The specific features your tasks will include: - Building a sophisticated login and registration system - Implementing a well-considered database schema - Integrating secure and reliable payment gateways. The core CMS functions will need to include: - Comprehensive user management facilities - Investment content publishing capabilities Ideal Skills and Experience: - Proficient in Laravel and familiar with its coding and architectural patterns - Strong experience in building CMS with a focus on investment platforms - Solid un...

...to ensure the optimized solution meets performance expectations. Benchmark the optimized code against the original implementation to quantify performance improvements. Deliverables: 1- Optimized PHP code for searching staff members and their duties, significantly reducing the execution time. 2- Documentation detailing the optimizations applied, including changes made to the codebase, database schema, and query strategies. 3- Test reports and benchmarks demonstrating the performance improvements achieved through optimization efforts. Features: - Data Filtering: The central task for this project is to help in filtering staff duties data in an efficient and user-friendly manner. You are expected to create an intuitive UI that allows easy data querying. Ideal qualifications: - Pr...

I'm looking for a skilled freelancer to create a Spark script that transfers data from a Hive metastore to an S3 bucket. The goal of this project is to enable backup and recovery. Skills and Experience: - Proficiency in Spark and Hive - Extensive experience with S3 buckets - Understanding of data backup strategies Project Details: - The script needs to read the schema and perform metadata transfer for selected schema to s3 bucket. - Only bid if you have work experience with spark, hive, s3 - 4 schemas needs to be migrated - I have already got access to s3 configured - I have local instance of netapp s3 available and bucket created. - Server is Ubuntu

I am in need of an expert in Flask and MongoDB who can effectively save and retrieve data. Although the version of Flask being used has not be...Flask being used has not been specified, the ideal candidate should be familiar with a range of versions. In your application, - Highlight your past works related to Flask and MongoDB - Share your experience with these technologies - Provide a detailed project proposal detailing how you would approach this project I haven't decided yet whether I need the freelancer to design the MongoDB database schema from scratch, so demonstrate your ability to perform this task if required. Your flexibility and adaptability are key for this project. This job requires a seasoned developer with a solid understanding of MongoDB and Flask, regardless ...

Just need to make a schema and er diagram based on the project specifications

I'm looking for a talented Node.js developer, particularly with experience using NodeBB. My project involves setting up a NodeBB forum on a Linux server and integrating it with my domain and MongoDB. Key features required include: - User profiles - Topic/thread moderation tools -Standard off the shelf configuratio...features required include: - User profiles - Topic/thread moderation tools -Standard off the shelf configuration and firewall security I don't currently have a theme in mind, so I'm open to suggestions from someone more experienced with design. Ideal candidates will be: - Familiar with Linux - Experienced in NodeBB setup and customization - Capable in integrating MongoDB with NodeBB FE/BE schema. Im looking for a candidate who can do this in 1 t...

...'small', with less than 10,000 lines of code, consisting primarily of CRUD operations. For context, the main entities/data models involved in these CRUD operations are Users, Products, and Orders. Skills and experience necessary: - Proficiency with PHP and Laravel framework - Experience migrating from CI to Laravel - Familiarity with CRUD operations and MVC architecture - Understanding of database schema related to Users, Products, and Orders You should ensure that the converted Laravel application works smoothly and retains all the existing functionalities of the CI dashboard. the max budget for this job is $250 Looking forward to your bids!...

...a set of “apps” available on the popular mobile operating systems. Apart from this, clients can ask for specific services or apps based on the insights that the analytics can generate. Backlog for the main portal Work items Enable registration for free and paid users Build integrations with public weather services around the world Detect locations based on GPS (if on a device) or IP Create a schema and a database for storing weather data based on location Build logic to reconcile and aggregate data from multiple service providers Access control for paid services Provide severe weather advisory to registered users on the portal Have provisions for advertisements on the portal and apps Show current weather at a location Show forecasts for five, ten, and fifteen days a...

...analysis and internal assessment. Key Project Deliverables: Data Collection: Methodically extract comprehensive information about classic cars from designated sections of an online marketplace. Data Structuring: Efficiently organize the amassed data into a structured format such as CSV, Excel, or a database. Documentation: Provide detailed documentation outlining the scraping methodology, data schema, and instructions for executing the scraper. Compliance and Ethics: Ensure the scraping initiative adheres to online marketplace terms of service and abides by legal stipulations. Ideal Candidate: Demonstrated prowess in web scraping and data extraction ventures. Proficiency in scraping utilities and frameworks (e.g., Beautiful Soup, Selenium, Scrapy). Fluent in programming language...

...4. **Multilingual Support:** - The website will support multiple languages, including Hindi, English, and Bangla, allowing users to access content in their preferred language. - Language selection will be accessible via WordPress multisite language settings, ensuring seamless navigation for users across different language preferences. 5. **Sports Schema and SEO Optimization:** - Integration of structured data markup (Sports Schema) will enhance the website's search engine visibility and improve its ranking in search results. - SEO-friendly URLs, meta tags, and content optimization will be implemented to attract organic traffic and maximize reach. 6. **Deep Linking with Mobile App:** - Deep linking functionality will enable seamless redirection from th...

...- Proven track record in API development, with a strong portfolio demonstrating expertise in required programming languages and frameworks. - Extensive experience with API testing and documentation tools. - Knowledge of modern authentication protocols and security best practices. - Familiarity with containerization and cloud deployment technologies. - Proficiency in database management and schema design. - Excellent problem-solving skills and attention to detail. - Strong communication skills, capable of creating detailed documentation for a developer audience. Desirable Skills: - Previous experience developing APIs for WordPress or integrating third-party tools into WordPress environments. - Knowledge of WordPress REST API and plugin development. ### Project Delive...

...5) Change to unix time in post message 6) Add redis data cache. • Lookup serial number in redis, if exist then process post-message • Add unix time from the first line as value to the serial key 7) Restructure user/database, something like this (a log_user shall only be allowed to INSERT/COPY into log_data in Postgres: REVOKE CREATE ON SCHEMA public FROM PUBLIC; REVOKE ALL ON DATABASE log_database FROM PUBLIC; CREATE USER log_user; GRANT USAGE ON SCHEMA log_schema TO log_user; GRANT COPY ON TABLE log_data TO log_user; 8) Change JSON to: {"serial": "AB10", "sequence": 23} and add a sequence field in the table. Sequence shall be a “small integer” – two bytes. 9) Change log_data to a hyper_table, may affect table s...

Broken links fix Canonical URL fix Robots tag fix on each page Catchy SEO titles that'll have high CTR SEO descriptions with low competitive keywords. Schema implementation Robots fix sitemap fix Alt tags fix internal links creation keywords cannibalization fix and many more issues... Google search console verification Google Analytics verification

**Job Type**: Full-time **About Us**: We are a startup in stealth mode located in the Bay Area. Our mission is to revolutionize Event management through innovative solutions and cutting-edge technology. **Role Overview**: We are seeking an experienced Backend Developer with strong expertise in FastAPI to join ...Bitbucket. 5. Good understanding of CI/CD pipelines, specifically Jenkins. 6. Strong problem-solving skills. 7. Ability to write clean, readable, and maintainable code. 8. Excellent communication skills. 9. Advanced knowledge of FastAPI framework 10. Strong understanding of database integration and management 11. Proficiency in handling API requests and responses 12. Experience with data modeling and schema design 13. Ability to optimize database performance for efficient ...

I am in need of an SQL wizard, specifically well-versed in MySQL, who can dive into my database schema to rectify some complex queries. My time is deeply invested in other areas of my project, hence the need for a reliable, efficient expert who can complete the tasks below: - Write complex SQL queries: The tasks will require you to navigate through my database schema, and based on the relationships and business rules, write complex queries. This will require a profound understanding of JOINs, subqueries, stored procedures, and other advanced SQL concepts. - Performance tuning of SQL queries: Your task is not just to make them work, but optimize these queries. This will include ensuring they run efficiently, making suitable indices, tuning any other aspects of query execut...

Need someone to Optimize 4 below sites to solve vast majority of issues mainly the Speed/Meta etc. Not the social bit Out of free reports but other 2 sites are Must be able to solve local schema, robots txt etc to optimize these sites. Under no circstamances have you to install any premium plugins with trails or any black hat optimizations techniques' to try make it look like you done work that won't last when free trial run out etc. Must be able to do all the work legitamately. Price is to cover 4 sites which be divided into 4 milestones to make sure we can review each site as done before next is started.

I am seeking a skilled Local SEO expert with extensive knowledge and experience in optimization for Google, Bing, and Yahoo. My aim is to increase the visibility of our clients business within the city, co...for this project will be someone who can: - Utilize LOCAL SEO strategies to maximize traffic to my website - Implement tactics that generate leads for our clients business - Apply relevant methods to increase their online presence across all major search engines Must be able to provide examples of previous Local SEO work , must have excellent English and excellent knowledge of building local schema on websites, optimizing/auditing GMBs. Must have knowledge of creating citations, map packs, directions, naps. Must ideally have access to GMB tracking tools to show updates/ranking...