Oracle Sql Performance Tuning Projects
Looking for freelance Oracle Sql Performance Tuning jobs and project work? PeoplePerHour has you covered.
opportunity
MySQL Query Optimization for Charity Website
We are seeking an experienced MySQL developer to analyse and optimise slow SQL queries for our website hosted on a shared server environment. Our monitoring has identified a significant number of slow queries that are adversely affecting server performance and website loading speeds. Background: During routine server monitoring, we discovered that our website is generating slow MySQL queries that are consuming extensive CPU and memory resources, leading to a degradation in performance. Scope of Work: Analysis of Slow Queries: Review the log file located at (****) containing 1,181 slow queries. Identify key factors contributing to the slow performance. Optimise the top 10 slowest queries, which have execution times ranging from 29.1 to 44.1 seconds. Implement query restructuring and indexing strategies to reduce execution time. Testing and Validation: Test the optimised queries to ensure they meet performance improvements. Validate that changes do not negatively impact the functionality of the website. Reporting: Provide a comprehensive report detailing changes made, before and after execution times, and any recommendations for further improvements. Deliverables: A detailed report of analysis and optimisations performed. Implementation of query optimisations in the live environment. Final validation report showing performance improvements. Timeframe: The project needs to be completed within three days of commencement. Selection Criteria: Proven experience in MySQL and database performance tuning. Ability to work efficiently under tight deadlines. Previous experience with high-traffic websites on shared servers is preferable.
an hour ago7 proposalsRemoteFull-Stack Developer with React.js and Node.js Expertise
Job Description: We are seeking a highly skilled and experienced Full-Stack Developer to join our team on a large-scale project. The ideal candidate will have a strong background in both front-end and back-end development, with specific expertise in React.js for front-end and Node.js for back-end services. This project involves building a robust, scalable, and high-performance web application that will be used by a wide range of users. Responsibilities: ● Develop and maintain the front-end of the application using React.js, ensuring high performance and responsiveness. ● Build and maintain back-end services and APIs using Node.js that will support the functionality of the web application. ● Collaborate with designers and other team members to convert designs and wireframes into high-quality code. ● Design and implementation of data storage solutions, including databases and server-side logic. ● Ensure the entire stack is designed and built for speed and scalability. ● Integrate various third-party services and APIs such as payment gateways, social media, geolocation, etc. ● Write clean, maintainable, and efficient code. ● Perform code reviews and enhance the performance of existing applications. ● Stay plugged into emerging technologies/industry trends and apply them into operations and activities. ● Provide detailed updates to project managers and stakeholders regarding development progress. Skills and Qualifications: ● Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model. ● Thorough understanding of React.js and its core principles, along with popular React.js workflows (such as Flux or Redux). ● Proficiency in Node.js and frameworks available for it (such as Express, StrongLoop, etc). ● Familiarity with RESTful APIs and experience in API design and development. ● Understanding of front-end technologies, such as HTML5 and CSS3. ● Experience with user authentication and authorization between multiple systems, servers, and environments. ● Integration of multiple data sources and databases into one system. ● Understanding of database systems such as MySQL, MongoDB, Oracle, and/or PostgreSQL. ● Knowledge of code versioning tools such as Git. ● Excellent problem-solving skills and ability to perform well in a team-oriented environment. Additional Requirements: ● Bachelor’s or master’s degree in Computer Science, Engineering, or a related subject. ● Proven track record of delivering large-scale projects successfully. ● Excellent communication skills and fluency in English. Project Details: ● Duration: 6+ months ● Hourly Rate: Negotiable based on experience ● Commitment: Full-time preferred, minimum 40 hours per week How to Apply: Interested candidates should submit a proposal detailing their qualifications, a portfolio of relevant projects, and at least two references. Please include your expected hourly rate and availability. This is a fantastic opportunity to work on a project that will be utilized globally and to expand your skills in a dynamic and supportive environment. We look forward to your applications!
6 days ago25 proposalsRemoteMarketing Specialist: Fueling Engagement & Driving Growth
Are you enthusiastic about devising impactful marketing strategies that propel business expansion? We're on the lookout for an adept freelance Marketing Specialist to integrate into our team, contributing significantly to bolstering our brand visibility and fostering audience engagement. Responsibilities: - Innovate and execute dynamic marketing campaigns across diverse platforms to captivate and retain our target demographic. - Conduct in-depth analysis of market dynamics and consumer behavior to pinpoint strategic avenues for marketing initiatives and product positioning. - Collaborate seamlessly with internal stakeholders to ensure uniformity in messaging and brand identity across all marketing channels. - Continuously monitor and evaluate the performance metrics of marketing endeavors, fine-tuning strategies for optimal results and ROI. - Remain at the forefront of industry trends and best practices, consistently refining and elevating our marketing approaches. This freelance position offers a competitive compensation of $20 per hour. If you possess a creative flair, an unwavering dedication to marketing, and a relentless pursuit of excellence in driving outcomes, we eagerly await your application! Join us in steering the trajectory of our brand and propelling business success through strategic marketing endeavors.
10 days ago15 proposalsRemoteWebsite Testing
Comprehensive Website Testing Services 1. Introduction: We are seeking proposals from qualified vendors to conduct comprehensive testing of our website. The purpose of this testing is to ensure the functionality, usability, compatibility, security, performance, and content accuracy of the website. The selected vendor will be responsible for executing various testing types and providing detailed reports with findings and recommendations. 2. Scope of Work: The scope of this project includes conducting comprehensive testing of the Medha Immigration Consultants website to assess its functionality, usability, compatibility, security, and performance. The testing should cover all aspects of the website, including but not limited to: Functionality testing to verify links, forms, navigation menus, search functionality, interactive elements, and dynamic content. Usability testing to evaluate ease of navigation, layout, design consistency, readability, accessibility, and responsiveness across different devices and screen sizes. Compatibility testing to ensure compatibility with various browsers, operating systems, screen resolutions, and assistive technologies. Security testing to identify and address potential vulnerabilities such as SQL injection, XSS, authentication, authorization, SSL certificate installation, secure transmission of data, error handling, and logging mechanisms. Performance testing to determine website capacity, response times under heavy load conditions, server and database performance, image and media optimization, caching mechanisms, and monitoring of performance metrics. 3. Deliverables: The testing service provider is expected to deliver the following: Detailed test plan outlining the testing approach, methodologies, tools, and schedule. Test cases and scenarios covering all aspects of the website. Test reports with findings, recommendations, and prioritized action items. Documentation of identified issues, including severity levels and sugge
23 days ago30 proposalsRemoteopportunitypre-fundedurgent
Webhook to sync Dropbox 'Team folder' changes to OneDrive
Prefer C# as the language. Summary - Using an Azure Web App as the platform; Two (2) Web Apps. One for the Webhook receiver, the second for the 'worker process pool'. They will NOT run on the same Web App service in production and will be isolated from each other. 1 - Dropbox file change Webhook receiver that will queue file sync to the corresponding OneDrive (match 'Team folder') requests for the worker process pool. If there is an existing outstanding sync request for the same file skip additional sync request. Process will refresh Dropbox user watch list, refresh Dropbox Team folder -> OneDrive mapping hourly. 2 - A worker process pool that will perform the queued file download from Dropbox & upload the file to the corresponding OneDrive location. The worker process pool must be configurable of how many simultaneous downloads. Requirement of a 5-worker process pool for the deliverable. Worker process pool will operate on file sync queue in a FIFO manner. Will provide Azure Web App service, access to MS Dataverse & SQL Server. Dropbox Webhooks reference URL below https://www.dropbox.com/developers/reference/webhooks OneDrive API reference URL below - please use REST API beta not 1.0 version https://learn.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-beta Azure Web App reference URL below https://azure.microsoft.com/en-us/pricing/details/app-service/windows/
4 days ago22 proposalsRemoteExpires in 25Power BI Developer
Key Responsibilities: Develop functional & operational reports & dashboards. Build automated reports and dashboards with the help of Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX Be able to quickly shape data into meaningful reports and analytics solutions. Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more. Analyse data sources and ensure data quality and integrity. Design and develop efficient data models in Power BI, ensuring optimal performance and scalability. Transform raw data into meaningful insights by implementing appropriate data transformations. Develop visually appealing and user-friendly dashboards, reports, and interactive visualizations in Power BI. Implement complex calculations and custom measures to meet business requirements. Leverage DAX (Data Analysis Expressions) to create advanced calculations. Integrate data from various sources into Power BI, ensuring seamless connectivity and data refresh. Utilize Power Query to clean, transform, and shape data for reporting purposes. Collaborate with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment with overall business goals. Conduct regular stakeholder meetings to gather feedback and make necessary adjustments to BI solutions. Provide training and documentation for end-users to ensure effective use of Power BI reports and dashboards. Monitor and optimize the performance of Power BI reports and dashboards. Ability of learning new tools to enhance the data quality and visualizations. Qualifications and Skills: Bachelor’s degree in computer science, Information Systems, or a related field. Proven experience as a Power BI Developer or similar role. Strong knowledge on Azure Data Lake, Data Factory and other data services Strong proficiency in Power BI, including data modelling, DAX, and Power Query. Solid understanding of relational databases and SQL. Experience in ETL processes and data integration. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Ability to work independently and as part of a team. Preferred Qualifications: Microsoft Power BI certification. Experience with other BI tools (Tableau, QlikView, etc.). Knowledge of data warehousing concepts. Familiarity with cloud platforms (Azure, AWS) for BI solutions.
13 days ago22 proposalsRemoteMachine Learning Engineer
We are seeking a highly skilled and motivated Machine Learning Engineer to join our team and contribute to the development of cutting-edge solutions for child safety applications. As a Machine Learning Engineer, you will be responsible for: ● Training and enhancing machine learning models using image-based data on TensorFlow. ● Evaluating and enhancing the performance of existing ML models, identifying opportunities for targeted advancements. ● Advising and guiding on the full ML development lifecycle, from conception to deployment, ensuring robust, efficient, and scalable solutions. ● Developing strategies for continual model training and retraining to adapt to evolving data patterns and threats, including training models in remote and sensitive environments. ● Innovating and exploring new ML development pathways, including the integration of open-source multi-modal models for advanced image and video classification tasks. ● Customising and fine-tuning state-of-the-art ML models to align with company-specific use cases and client needs. ● Architecting and implementing solutions for on-device model deployment, emphasising user privacy and data security. ● Creating and maintaining model deployment packages, such as SDKs and Docker containers, for seamless client integration. ● Collaborating cross-functionally with product managers, software engineers, and other stakeholders to integrate ML solutions into our product suite. ● Staying abreast of the latest ML technologies and methodologies, advocating for the adoption of industry-best practices. Qualifications: ● Bachelor's or Master's degree in Computer Science, Engineering, or related field. ● Proven experience in machine learning model development and deployment, particularly with TensorFlow. ● Strong programming skills in Python and proficiency in ML libraries such as TensorFlow, PyTorch, or Keras. ● Experience with image-based data and advanced image processing techniques. ● Knowledge of model evaluation metrics, optimization algorithms, and deep learning architectures. ● Familiarity with cloud platforms for model deployment (e.g., AWS, Google Cloud). ● Ability to work independently and collaboratively in a fast-paced environment. ● Excellent communication skills and the ability to explain complex concepts to non-technical stakeholders. Bonus Skills: ● Experience with on-device model deployment and edge computing. ● Familiarity with privacy-preserving ML techniques and data security protocols. ● Knowledge of open-source ML models and their integration into custom applications. If you are passionate about leveraging machine learning for child safety applications and are excited to work on impactful projects, we encourage you to apply and be part of our innovative team!
12 days ago17 proposalsRemoteBook Product Manager for Bestseller Launch
We are seeking a highly experienced and dynamic Book Product Manager to spearhead the creation and launch of a management book poised to become a bestseller in 2024. This role is for a driven individual accustomed to high-pressure, demanding environments, with a proven track record of delivering exceptional results. The ideal candidate will build and manage a dedicated team to fulfill a comprehensive list of deliverables, ensuring the seamless execution of each stage of the book’s development, from inception to post-launch marketing. You will play a pivotal role in transforming a book idea into a widely recognized and commercially successful product. We expect you to have an entrepreneurial mindset with the ability to take charge and navigate complex project landscapes. You should be comfortable engaging with high-profile industry experts and possess a network that includes contacts at esteemed media outlets, such as MIT, TechCrunch, Harvard Business Review, Forbes, and other reputable platforms in the management sphere. Key Deliverables : Create and lead a team in charge of the following: Writting Services Manage collaboration with a top-tier ghostwriter to: 1. Organize text revisions 2. Develop a cohesive book idea into a polished professional positioning and roadmap 3. Conduct and transcribe content interviews with testimonials that will be added into the book, transforming them into a compelling manuscript 4. Manage a series of revisions to fine-tune the manuscript Publishing Services Build a publishing team to: 1. Oversee a thorough proofreading process. 2. Direct the creation of the book cover design, offering multiple options and accommodating revisions. 3. Manage the interior layout design 4. Manage the eBook conversion process. 5. Handle copyright and ISBN registration, with the choice to publish under our company’s imprint or the author’s. 6. Arrange formatting, publishing, and distribution through major booksellers, including Amazon. 7. Secure up to 1000 author copies of the book. 8. Coordinate the production and distribution of the audiobook version. 9. Communicate distribution limitations, with a focus on solutions for international dissemination. 10. Manage international distribution. Translation Rights with foreign publishers 1. Offer exclusive representation for translation deals for two years. 2. Partner with foreign rights agents to negotiate with foreign publishers. 3. Ensure the author receives 60% of any advance and royalties from foreign sales. Marketing Services 1. Craft a customized marketing plan aimed at making the book a bestseller. 2. Generate social media graphics and articles for promotional campaigns. 3. Construct a media-ready press kit for high-caliber coverage. 4. Orchestrate book launch week activities, maximizing visibility and impact. 5. Execute network outreach and provide email templates to boost the launch. 6. Obtain Amazon reviews of high quality 7. Organize a Goodreads giveaway. 8. Secure interviews and coverage through media and podcast outreach, targeting high-standard management outlets such as MIT, TechCrunch, Harvard Business Review, Forbes, and other reputable platforms in the management sphere. 9. Manage submissions for professional book reviews. 10. Regularly publish content on platforms like LinkedIn to maintain engagement. 11. Administer Amazon Advertising campaigns, utilizing allocated budgets effectively. 12. Deliver weekly progress reports and compile a comprehensive final coverage report. 13. Develop a book landing page with an enticing lead magnet and a strategic email sequence. Candidate Profile The individual we seek will have the following attributes: - A high-performing, meticulous project manager with experience in book launches. - Exceptional organizational skills and the ability to manage complex projects with multiple components. - A strong communicator with the ability to lead and inspire a team. - Established connections with high-standard media outlets in the management domain. - A strategic thinker with a keen eye for market trends and promotional opportunities. - Experience in budget management and resource allocation to maximize project ROI. How to Apply: If you are ready to take on the challenge of delivering a management book that will dominate the bestseller lists in 2024, please send your CV, a cover letter detailing your relevant experience, and a portfolio showcasing previous book launches or similar projects you have managed to pm.book24@gmail.com We are excited to welcome a Book Product Manager who can elevate our vision and drive this project to unprecedented success.
16 days ago7 proposalsRemote
Past "Oracle-sql-performance-tuning" Projects
opportunity
Database Module for .NET application
I have a running application currently working and the data exchange part is by using APIs for Oracle and saving some data locally. Now will by moving to SAP S/4HANA with its own set of APIs, as well as the local data would be organized and saved into Postgresql databases. I need to create a database module that would seamlessly integrate with the application and perform the data exchange related tasks with the multiple databases. The application is .NET desktop windows application. POSTGRESQL Databases are with network access on linux. SAP S/4HANA database is cloud based, with its API provided and has minimal data exchange.
Looking for SEO & Google Ads Management Specialist
Hello There, We are looking for an SEO & Google Ad management specialist. Below are the specific services we are looking for: Keyword Research and Strategy Development: We require assistance in identifying relevant keywords and phrases that align with our target audience's search intent and our business objectives. On-Page and Off-Page Optimization: We need support in optimizing our website's content, meta tags, headers, and other on-page elements. Additionally, assistance with off-page strategies such as backlink building and local SEO optimization would be beneficial. Content Creation and Optimization: We are looking for expertise in creating high-quality, engaging content that resonates with our audience and is optimized for search engines. Technical SEO Audit and Implementation: We require a comprehensive audit of our website's technical aspects to identify and address any issues that may affect our search engine rankings and user experience. This includes but is not limited to site speed optimization, mobile responsiveness, and resolving crawl errors. Google Ads Campaign Management: We seek assistance in creating and managing Google Ads campaigns to drive targeted traffic to our website. This includes keyword research, ad copywriting, bid management, and ongoing optimization to maximize ROI. Analytics and Reporting: We need assistance in setting up and analyzing data from tools such as Google Analytics and Google Ads to track the performance of our website and advertising campaigns. Regular reporting on key metrics and insights is essential for us to make informed decisions. Conversion Rate Optimization (CRO): We are interested in optimizing our website's conversion paths to increase the likelihood of visitors taking desired actions, such as making a purchase or filling out a contact form. Local SEO Optimization: We require support in optimizing our website for local searches, including managing Google My Business listings, obtaining online reviews, and ensuring consistency of NAP information across online directories. SEO deliverables required ON PAGE – DELIVERABLES • Complete analysis of the existing website and a detailed analysis report • Competitor analysis of up to 3 competitor websites and a detailed analysis report • Configure Google Tag Manager • Configure and monitor Google Analytics, Google Search Console and Bing Webmaster Tool • Tune and optimize Meta tags for all pages on the website • Add ALT tags for all images used on the website Ensure proper structure for the entire site maintaining HTML heading tags • Ensure the terms of use, about us, contact us pages meet the legal requirements as well as general webmaster guidelines • Check the entire content of the website of copyright violations • Improve the content of the homepage for the best results • Implement Live chat support, if necessary • Implement schema on the website to improve the performance of the website • Maintain the blog section with properly tuned content • Add a new blog post per month on the site OFF PAGE - DELIVERABLES • Publish articles on third party websites • Publish marketing content in Quora discussions, subject to Quora's current policies • Participate in the third-party forum and discussion groups and refer your services when there are relevant questions • List your business on various business directories to improve web presence • Build backlinks to the site through booking websites • Submit your profile in various socially relevant sites including SlideShare, Flickr, Pinterest and more • Tune and optimise your press release if there are any. CONTENT MARKETING DELIVERABLES • Content marketing through various websites and blogs • Quora presence in the form of questions and answers • Increase the visibility of our brand image on the web BLOGGING DELIVERABLES • 2 blog posts per month are included in our package • Submit all blog posts to social media and bookmarking sites • Build internal links to and from the blog posts • Add blog posts to the sitemap We are looking for a reliable partner who can provide these services efficiently and effectively, helping us achieve our digital marketing goals. If you believe your expertise aligns with our requirements, we would appreciate the opportunity to discuss further details, including pricing and timelines.
opportunity
Mobile App Developer needed for Designer Clothing Marketplace
We are in search of a seasoned app developer to construct an innovative platform tailored for the buying, selling, and trading of designer clothing. The app's core objective is to offer users a seamless and secure environment to explore, list, and purchase high-end fashion items. The ideal candidate will possess extensive expertise in app development alongside a deep understanding of e-commerce functionalities. Responsibilities: Craft a user-friendly and visually captivating app compatible with both iOS and Android platforms Implement robust payment gateways and user verification mechanisms to ensure security Incorporate advanced features such as product search, filtering, and personalized recommendations Establish communication channels facilitating interaction between buyers and sellers Fine-tune app performance and ensure smooth functionality across various devices Skills: Proficient in mobile app development for both iOS and Android platforms Demonstrated experience with e-commerce and marketplace operations Knowledgeable about secure payment gateways and user authentication systems Familiarity with product search algorithms and recommendation mechanisms Strong problem-solving abilities and adeptness in debugging issues
SQL Developer
We have a platform online running with a few hundred active users which is performing poorly. We've investigated using New Relic and have determined the cause to be poorly performing SQL queries. We are seeking an expert to help diagnose and rewrite the queries with our development team. Requirements: - Excellent knowledge of SQL - Ability to diagnose issues from New Relic - Strong ability in rewriting bad SQL - Able to work during the UK timezone Nice to haves - Knowledge of PHP and codeigniter
Looking for SEO & Google Ads Management Specialist
Hello There, We are looking for an SEO & Google Ad management specialist. Below are the specific services we are looking for: Keyword Research and Strategy Development: We require assistance in identifying relevant keywords and phrases that align with our target audience's search intent and our business objectives. On-Page and Off-Page Optimization: We need support in optimizing our website's content, meta tags, headers, and other on-page elements. Additionally, assistance with off-page strategies such as backlink building and local SEO optimization would be beneficial. Content Creation and Optimization: We are looking for expertise in creating high-quality, engaging content that resonates with our audience and is optimized for search engines. Technical SEO Audit and Implementation: We require a comprehensive audit of our website's technical aspects to identify and address any issues that may affect our search engine rankings and user experience. This includes but is not limited to site speed optimization, mobile responsiveness, and resolving crawl errors. Google Ads Campaign Management: We seek assistance in creating and managing Google Ads campaigns to drive targeted traffic to our website. This includes keyword research, ad copywriting, bid management, and ongoing optimization to maximize ROI. Analytics and Reporting: We need assistance in setting up and analyzing data from tools such as Google Analytics and Google Ads to track the performance of our website and advertising campaigns. Regular reporting on key metrics and insights is essential for us to make informed decisions. Conversion Rate Optimization (CRO): We are interested in optimizing our website's conversion paths to increase the likelihood of visitors taking desired actions, such as making a purchase or filling out a contact form. Local SEO Optimization: We require support in optimizing our website for local searches, including managing Google My Business listings, obtaining online reviews, and ensuring consistency of NAP information across online directories. SEO deliverables required ON PAGE – DELIVERABLES • Complete analysis of the existing website and a detailed analysis report • Competitor analysis of up to 3 competitor websites and a detailed analysis report • Configure Google Tag Manager • Configure and monitor Google Analytics, Google Search Console and Bing Webmaster Tool • Tune and optimize Meta tags for all pages on the website • Add ALT tags for all images used on the website Ensure proper structure for the entire site maintaining HTML heading tags • Ensure the terms of use, about us, contact us pages meet the legal requirements as well as general webmaster guidelines • Check the entire content of the website of copyright violations • Improve the content of the homepage for the best results • Implement Live chat support, if necessary • Implement schema on the website to improve the performance of the website • Maintain the blog section with properly tuned content • Add a new blog post per month on the site OFF PAGE - DELIVERABLES • Publish articles on third party websites • Publish marketing content in Quora discussions, subject to Quora's current policies • Participate in the third-party forum and discussion groups and refer your services when there are relevant questions • List your business on various business directories to improve web presence • Build backlinks to the site through booking websites • Submit your profile in various socially relevant sites including SlideShare, Flickr, Pinterest and more • Tune and optimise your press release if there are any. CONTENT MARKETING DELIVERABLES • Content marketing through various websites and blogs • Quora presence in the form of questions and answers • Increase the visibility of our brand image on the web BLOGGING DELIVERABLES • 2 blog posts per month are included in our package • Submit all blog posts to social media and bookmarking sites • Build internal links to and from the blog posts • Add blog posts to the sitemap We are looking for a reliable partner who can provide these services efficiently and effectively, helping us achieve our digital marketing goals. If you believe your expertise aligns with our requirements, we would appreciate the opportunity to discuss further details, including pricing and timelines.
Senior PHP/WordPress Developer
The PHP/WordPress Developer we are seeking will be the cornerstone of our development team, responsible for creating and implementing a range of database-driven web applications with a focus on delivering innovative and user-centric solutions. Your technical expertise will drive the design, development, and deployment of projects that stand out for their quality and functionality. Your Main Responsibilities Will Include: Execute the full website design and development life cycle, from the initial concept to deployment and beyond. Seamlessly integrate third-party APIs to extend the capabilities of our web applications. Develop and manage efficient, secure databases that support the functionality of our applications. Customize WordPress installations, crafting bespoke themes and plugins tailored to project requirements. Vigilantly address, diagnose, and rectify any issues in the application, prioritizing a bug-free user experience. Conduct thorough unit testing of code to ensure robustness, usability, and general reliability under various conditions. Manage and maintain domain registrations and configurations, ensuring optimal performance and reliability. Qualifications: Degree in Computer Science, IT, or a related field, with a minimum of 5 years of relevant work experience. Proficiency in PHP and SQL, with extensive experience in WordPress, HTML, CSS, JavaScript, and Bootstrap. Familiarity with C# will be considered a valuable asset. Solid understanding of MySQL databases and UI/UX design principles. High proficiency in English, both written and spoken; knowledge of additional languages is a bonus. Exceptional attention to detail, ensuring precision in coding and design. Strong organizational skills, including effective time management, prioritization of tasks, and the ability to multitask in a dynamic work environment. If you believe that your skills and expertise align with the requirements of this position, please send us your CV for review. Additionally, if you have a portfolio or examples of previous work, we would be interested in seeing them. We are eager to assess your qualifications and establish a cooperative relationship as soon as possible. We look forward to hearing from you.
Need to create a report using SQL
I require assistance in generating a complex report from multiple data sources within a custom application. The report necessitates retrieving and aggregating information from various tables using SQL queries. It must pull and consolidate pertinent records from a range of interconnected database assets while preserving data integrity. Specifically, the report will need to extract salient fields like identifiers, values, and timestamps from several intricately related operational stores. It should then compile and organize the extracted segments to provide a holistic view of core business operations over a specified timeframe. The constituent pieces must be intelligently linked and cross-referenced to offer meaningful insights. The underlying database schema may be intricate with numerous joins and intricate relationships between entities. As such, the SQL development will require strong expertise in querying disparate sources and nesting clauses to obtain all needed attributes. Optimization will also be critical as improper queries could impact system performance. Overall, the finished report must deliver a cohesive narrative and present compiled information in a clear format that facilitates easy analysis. Requirements gathering, iterative testing, and validation against source data will be pivotal to ensure accuracy and reliability. Mobility with formatting for both onscreen and printable distribution is preferable. Key skills needed are advanced SQL, relational data modeling, report generations, and analytical problem-solving abilities. Experience extracting consolidated views from sophisticated production databases through SQL is a must.
SQL Optimization
I am presently encountering performance issues with a certain SQL query, relying heavily on joins. The complexity of understanding the query also adds to it, taking away precious time and productivity. My performance measurement indicator is query execution time. The quicker the execution, the better the performance. Therefore, my project involves reconstructing this query to use Common Table Expressions (CTE) instead of joins. I would also need you to create views based on this newly optimized query. The database management system in use is PostgreSQL. Corresponding experience and knowledge in this system, along with skill in CTE implementation and optimizing SQL queries are pertinent. Skills and Experience: - PostgreSQL expertise - Proficient in SQL and CTE - Familiar with performance metrics like execution time - Experience in building SQL views The goal of this project is to have a more streamlined and efficient SQL query that uses less execution time. Your prime responsibility would be to restructure and simplify the query without disturbing its functionality.
C# Developer
We are developing a LIMS platform using ABP.io in C#. We are seeking software developers to join our team and help develop new features. Requirements: - Excellent C# knowledge - Able to create high performing and clean code - Can take part in code reviews - Produce a full suite of tests for each new function - Microsoft SQL server - Working knowledge of Jira - Work within a remote team - Able to join regularly scheduled standups - Excellent knoweldge of working with Angular and writing front-end tests - UK Based. Nice to haves: - Experience working with abp.io framework Please apply with your experience, availability and location.
Music listening
I am looking to hire a freelance designer to develop a simple but elegant web application focused on music listening and discovery. The goal is to create an online portal where users can browse songs by genre, era, and artist. They should be able to stream full tracks directly within the site or save songs to personal playlists for later enjoyment. The core functionality needed includes an intuitive interface for navigating a catalogue of songs drawn from various streaming services' open databases. Users must be able to search for songs by partial titles, artists, or other attributes. Playback controls are essential to allow starting, pausing, rewinding or fast-forwarding through tracks. Beyond just playing individual songs, the ability to create public or private playlists would add value by letting users customize musical collections. A clean, visually appealing design is important to enhance the user experience. The color scheme, layout, typography and other aesthetic elements should seamlessly support interactivity with the music. Responsiveness across devices is also a priority, as the site needs to perform and appear nicely on both desktops and mobile phones. Account registration, personalized profile pages, social sharing options and purchase/subscription features could potentially be added in future if the initial rollout is successful. The goal is to create a tasteful yet technologically sophisticated platform for music lovers to discover new favorites, revisit old ones and connect over shared tunes. Strong skills with
AI/Prompt expert
Hello everyone, Job Description: We are seeking a talented AI/Prompt Expert to join our team. The ideal candidate will have a strong background in natural language processing (NLP), machine learning, and deep learning, with a focus on generative models. The AI/Prompt Expert will be responsible for developing and fine-tuning AI models, such as GPT-3 and DALL·E, to generate creative and contextually relevant content in response to user prompts. The role involves working closely with cross-functional teams to understand user requirements and develop innovative solutions using cutting-edge AI technologies. Responsibilities: Research, develop, and implement state-of-the-art AI models for natural language generation. Train and fine-tune generative models to produce high-quality and diverse outputs. Collaborate with product managers, engineers, and designers to integrate AI models into user-facing applications. Analyze user interaction data to improve model performance and user experience. Stay updated with the latest advancements in NLP, machine learning, and generative models. Requirements: Master's or Ph.D. in computer science, artificial intelligence, or a related field. Solid understanding of NLP, deep learning, and generative modeling techniques. Proficiency in Python and experience with deep learning frameworks such as TensorFlow or PyTorch. Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment. Excellent communication skills and the ability to explain complex AI concepts to non-technical stakeholders. Preferred Qualifications: Experience with large-scale language models such as GPT-3 and DALL·E. Research publications or contributions to the field of NLP and generative modeling. Familiarity with cloud-based AI services and deployment. If you are passionate about AI and have a strong background in NLP and generative modeling, we encourage you to apply for this exciting opportunity. Thank you.
PL/SQL extract of Oracle 19c unified auditing data
I need a PL/SQL programmer to help me write a routine to extract the data from Oracle 19c unified auditing tables and produce Key Value pair output to a log file. The routine will have to track where in the audit table it got up to and next iteration continue from that point to the last data written. There can be no gaps in the audit trail output. This needs to be scheduled to run every 5 minutes. The data will be forwarded to a SIEM for monitoring purposes. Is this something you can help with?