Oracle Sql Performance Tuning Projects
Looking for freelance Oracle Sql Performance Tuning jobs and project work? PeoplePerHour has you covered.
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.
10 days ago16 proposalsRemoteLooking 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.
23 days ago41 proposalsRemoteSenior 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.
9 days ago52 proposalsRemote
Past "Oracle-sql-performance-tuning" Projects
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
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?
Experienced Blockchain Game Data Scientist
Go Back Experienced Blockchain Game Data Scientist Posted yesterday Worldwide Introduction: Join our dynamic and innovative team as an Experienced Blockchain Game Data Scientist! At Wion Crypto, we are at the forefront of revolutionizing the gaming industry by leveraging blockchain technology to create immersive and decentralized gaming experiences. As a data scientist with a flair for blockchain, you will play a pivotal role in shaping our data strategy and driving data-driven decision making that aligns with our vision for the future of gaming. Role Overview: As an Experienced Blockchain Game Data Scientist, your primary objective will be to analyze, interpret, and extract valuable insights from the vast amount of data generated by our blockchain gaming platform. You will collaborate with cross-functional teams, including game developers, engineers, product managers, and marketing teams, to identify key metrics, design experiments, and develop machine learning models to enhance our gaming experience, retention, and monetization strategies. Responsibilities: - Collaborate closely with game developers and engineers to design and implement data collection and analytics frameworks within our blockchain gaming ecosystem - Develop and apply advanced analytical approaches to interpret complex data sets and provide actionable insights to drive decision making - Create and implement machine learning models to optimize game mechanics, user experience, and monetization strategies - Conduct ad-hoc analysis to support marketing initiatives, user segmentation, and targeting efforts - Collaborate with product managers to define, track, and analyze key performance indicators (KPIs) to measure the success of our gaming products - Communicate your findings and recommendations to cross-functional teams and senior leadership through data visualization and compelling storytelling - Stay up-to-date with the latest developments in blockchain technology, data science, and gaming trends to bring innovative solutions to our platform Skills: - Bachelor's or Master's degree in Computer Science, Mathematics, Statistics, or a related field - Proven experience as a data scientist working on complex projects in the gaming industry - Strong programming skills in Python and experience with relevant libraries and tools (e.g., TensorFlow, PyTorch, scikit-learn) - Proficiency in SQL for data manipulation and extraction - Solid understanding of blockchain technology and its applications in the gaming industry - Experience with data visualization tools (e.g., Tableau, Power BI) to present insights to non-technical stakeholders - Strong problem-solving skills with the ability to think creatively and explore alternative solutions - Excellent communication and collaboration skills to effectively work in a cross-functional team environment Benefits: - Competitive salary and comprehensive benefits package
opportunity
Need an expert in Vision Transformer Model
I am looking for an expert in Vision Transformer Model for a project that involves image detection and classification to classify and display the result as the tumour in to glioma, meningioma and pituitary and no tumor type.. The specific task is to develop a model that can accurately classify images. Can use Kaggle dataset for the model to train on. The preferred programming language for this project is Python/MATLAB. Ideal skills and experience: Strong knowledge and experience in Vision Transformer Model Proficiency in Python programming language Familiarity with image classification techniques and algorithms Experience in training and fine-tuning models using large datasets Ability to optimize and improve model performance
opportunity
I need Linux Admin with Mysql, Apache & Dovecot Postfix
Hello, I am looking for Linux Administrators, System Administrators, Apache, Mysql, Dovecot, Postfix expers who can analyse and optimize my server's services for best performance. I have an Ubuntu based server using Webmin Control Panel with Mysql, Apache, Dovecot & Postfix I host only 15 wordpress sites with a i9 CPU 128 gb ram server. CPU load is around 20-30 right now and Mysql using the higher number of CPU at the moment. I am using performance and cache plugins in all wordpress sites with WP Firewall plugin for security. But l still get high load % on the server. I am looking for some1 who can tune my server for best performance and lower the Server Loads to %5-%10 My budget is 25 usd for this task. Thanks.
Business central Developer (AL Language)
**Job Title:** Business Central Developer (AL Language Specialist) **Location:** [Flexible/Remote/Specific Location] **Job Type:** [Full-Time/Part-Time/Contract] **Introduction:** We are seeking a highly skilled and motivated Business Central Developer with expertise in the AL language to join our dynamic team. This role is critical to our ongoing efforts to enhance, customize, and innovate within our Microsoft Dynamics 365 Business Central environment. The ideal candidate will bring a strong technical background in Business Central development, a passion for solving complex business problems, and a collaborative mindset. **Responsibilities:** - Develop, customize, and extend Dynamics 365 Business Central using the AL language. - Analyze business requirements and translate them into effective technical solutions within Business Central. - Collaborate with stakeholders to design and implement new features and enhancements that improve operational efficiency and user experience. - Ensure the reliability and performance of Business Central solutions through comprehensive testing and debugging. - Provide technical support and guidance to end-users, addressing and resolving issues in a timely manner. - Stay up-to-date with the latest updates and features in Business Central and the AL development environment, leveraging new technologies to meet business needs. - Document technical designs, specifications, and procedures for the solutions developed. - Collaborate with project managers and other team members to ensure timely delivery of project milestones. **Requirements:** - Proven experience developing solutions in Microsoft Dynamics 365 Business Central using the AL language. - Strong understanding of Business Central functional capabilities, architecture, and development framework. - Proficiency in designing and implementing customizations, extensions, and integrations for Business Central. - Solid understanding of business processes and the ability to translate business requirements into functional design. - Experience with version control and DevOps practices for Business Central development. - Excellent problem-solving skills, with the ability to debug and troubleshoot issues effectively. - Strong communication skills, with the capacity to convey technical concepts to non-technical stakeholders. - Familiarity with SQL and an understanding of relational database concepts. - A commitment to continuous learning and staying informed about the latest trends and technologies in Business Central development. **Preferred Qualifications:** - Certification in Microsoft Dynamics 365 Business Central Development. - Experience with upgrading Business Central solutions from earlier versions or migrating from Dynamics NAV. - Knowledge of Power Platform (Power Apps, Power Automate) and its integration with Business Central. - Previous experience working in an Agile/Scrum development environment. **What We Offer:** - Competitive salary and benefits package. - A collaborative and innovative work environment. - Opportunities for professional growth and development. - Flexible working hours and remote work options. - The chance to work on exciting projects that have a meaningful impact on our business operations.
opportunity
Need a full stack developer
The project at hand is an ambitious and critical initiative, requiring a seasoned developer with a comprehensive skill set in cloud integration, specifically with Oracle Cloud Infrastructure (OCI). We are in search of a professional who can seamlessly transition our current system from AWS to OCI, ensuring that the authentication and API services are robustly integrated with our already established front-end architecture. This project is segmented into three primary milestones: OCI Integration: The successful candidate will be responsible for integrating OCI authentication and API services with the existing front-end, maintaining system integrity and ensuring seamless functionality. Minimum Viable Product (MVP) Development: Following the successful integration, the developer will focus on creating a functional MVP, incorporating essential features and capabilities that align with our project objectives. Complete Product Development: The final stage involves the full-scale development of the product, enriching it with features, optimizing performance, and refining user experience to meet the high standards expected in healthcare-related applications. We have allocated a total budget of $10,000 for the completion of this project, which will be released in phases corresponding to the successful completion of the outlined milestones. This is a healthcare-centric project, necessitating impeccable attention to detail and robust communication skills to ensure that the end product not only meets but exceeds the stringent requirements of healthcare applications. We invite proposals to begin with the word "Avocado" to ensure attention to detail and compliance with project prerequisites. The core technologies for this project include: Front-End Framework: React coupled with TypeScript Styling and Component Libraries: SCSS, Tailwind, and Material-UI (MUI) Back-End Services: Firebase, inclusive of Cloud Functions, databases, and authentication services. However, we remain open to alternatives that synergize with OCI. Cloud Infrastructure: Oracle Cloud, with a mandatory requirement for experience in this domain. Potential candidates are encouraged to outline their proficiency with the mentioned tech stack and any additional technologies they are adept in and prefer to employ. It is essential for applicants to demonstrate their capability and experience with Oracle Cloud to be considered for this role.
opportunity
Enhancing and Rendering Realistic 3D Models
Overview: We are seeking a skilled 3D modeler to elevate and enhance our existing 3D models, bringing them to life through realistic rendering. This project involves refining the details, textures, and overall visual appeal of the models to create a compelling and immersive visual experience. Key Responsibilities: Model Enhancement: Assess and analyze the current 3D models to identify areas for improvement. Refine the geometry, ensuring accuracy and attention to detail. Optimize the models for better performance and realistic representation. Texture and Material Refinement: Enhance texture maps and materials to achieve a higher level of realism. Pay attention to surface details, such as reflections, specular highlights, and surface imperfections. Realistic Rendering: Utilize advanced rendering techniques to achieve realistic lighting and shadows. Fine-tune rendering settings for optimal visual impact. Ensure the final output aligns with industry standards for realistic 3D visualization. Collaboration: Work closely with our creative team to understand the project requirements and vision. Iterate on feedback and make necessary adjustments to meet project objectives. Timeline and Deliverables: Develop a project timeline outlining key milestones and deadlines. Provide regular updates on progress and collaborate with the team to address any challenges.
opportunity
Add New Features to an Existing Machine Learning Model
We are looking for a machine learning pro to improve our current model's performance. The task involves fine-tuning, debugging, and adding new features to boost prediction accuracy. If you're skilled in machine learning, Python, and want to work on real-world applications, reach out to collaborate on this exciting project! Major task: Include new features (function enclosed already) Improve the model (a better way of coding it) Fix possible over-fitting (if it exists)
opportunity
Software Developer
Hi Please what are your thoughts of below?: Job Title Software Developer JOB DESCRIPTION/PURPOSE Responsible to Senior Software Developer to ensure an excellent level of technical design and development is delivered across to our customer meeting their needs. The Developer is part of an agile development team, that builds and works on software systems on top of the Microsoft.NET development stack. The Developer is involved in assigned areas of development from design to development to testing as identified by Senior Developer. The Developer will perform Hardware and Software design work as required of the company on projects as identified by the Senior Developer and Group Technical Director. Back-end coder for: • A Functional Directory like interactive Yellow Pages • Electronic Health record – for patients and solicitors/ hospital use • E commerce like any large online retailer • Microsoft Teams, Microsoft Shift etc integration PRINCIPAL RESPONSIBILITIES 1. Working with an agile team to develop, test, and maintain desktop, web-based applications and server-based business applications for all development projects and client deliveries. 2. Responsible for own day-to-day technical design and development work and for Mentoring Junior Software Developer. 3. Preparing reports, manuals and other documentation on the status, operation and maintenance of software 4. Design, develop, and unit test applications in accordance with established standards 5. Participate in reviews of solutions designs and related code 6. Package and support deployment of developed solutions and releases 7. Developing, refining, and tuning integrations between applications 8. Analysing and resolving technical and application problems. 9. Adhering to high-quality development principles while delivering software solutions on-time and on-budget. 10. Providing support to customers 11. Deliver against department SLA’s and KPI’s. 12. Build close relationships with the key business stakeholders and clients 13. Identify and achieve improvements in Design performance. 14. Comply with culture of customer service and continual improvement. 15. Build close partnerships with our critical technology and service partners to enhance the relationship and quality of service. 16. Adhere and strive to achieve Design & Development strategies and objectives. COMPETENCY 1. Educated to a degree level or equivalent 2. Significant background of Design & Development with at least 4 years’ experience service delivery or systems projects delivery 3. Hands on expertise across a broad range of ICT technologies (clients, applications, networks, infrastructure) 4. Experienced in influencing across the business management team. 5. Structured approach to change control, design control and continual improvement. 6. Demonstrates creativity in identifying opportunities and finding design solutions 7. The ability to inspire, motivate. 8. Initiative, drive and enthusiasm and results driven 9. Supervisory skills required, including the ability to coordinate the work of others. 10. Possess a broad range of IT knowledge, and willing to take on design based technical issues. 11. Possess a background in a Design & Development position, with a proven track record of leading staff to consistently meet and exceed the required levels of customer design. 12. Expert understanding of object orientated programming concepts 13. Expert understanding of relational database design and querying concepts 14. Familiarity with version control concepts JNR 15. At Least 4 Years experience in using Microsoft .NET development using C# 16. At Least 4 Years experience in web development, UI/UX front end development using ASP.Net Core, Razor and Entity Framework. 17. At Least 4 Years experience of client/server application development 18. At Least 4 Years experience of agile development methodologies 19. Comprehensive Knowledge of unit testing theory
Experienced Node developer for 3 month contract
We are looking for an experienced Node js developer for a 3 month contract. They have to work on an application that is already running and work along a team as well. Timing should be fine as long we get 40 hours every week. They should be experienced in writing secure node APIs and performance tuning and mongoDB