Pl sql in oracle jobber

I'm currently using Oracle and MySQL database management systems and I'm in urgent need of a dedicated database administrator who can expertly handle performance tuning, backup and recovery, and security management. The ideal candidate should have an extensive background in both Oracle and MySQL, as well as a solid understanding of the nuances of these database management systems. Here's what the project covers: - Performance Tuning: I'm experiencing sub-par performance with my existing workloads, and I need someone with a knack for diagnosing and resolving complex performance issues. - Backup and Recovery: An integral part of the project is to safeguard the digital assets by implementing robust backup and recovery strategies, thus to ensu...

I'm looking for an experienced Oracle specialist with a sharp eye for detail to help me resolve syntax errors in my Oracle 11g code. Key responsibilities include: - Identifying and rectifying syntax errors in my existing Oracle codebase I'd prefer regular video calls for updates and progress reports. Your insights into improving my code's efficiency are also highly appreciated.

I'm experiencing performance issues with 5 stored procedures in my SQL Server. These procedures are significantly slower than expected due to complex JOIN queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity...

I am seeking an ASP .NET and Angular developer to create a comprehensive web application for an electricity billing system that will enable seamless customer and administrative experiences. Key Features: - Enable customers to create accounts, sign in and out of their account and recover forgotten passwords. - Create the ability for customers to check their billing history and track their usage. - Implements functionality for customers to pay their bills online. - Develop static pages like 'Home', 'About Us', and 'Contact Us'. These pages should be attractive with modern UI design and animations. - Add an administrative interface for administrators to manage customer profiles, including adding new customers, editing existing profiles, and viewing custo...

...Key requirements include: - A modern, minimalist and professional design to keep the interface clean and simple. - Built-in functionalities for equipment tracking, calibration scheduling, and reporting Ideal candidate should possess strong experience in web-based app development, UX design, and database management. Capability to create an intuitive user interface is critical, and understanding of equipment calibration fields is a huge plus. Preferred technologies include but not limited to JavaScript, HTML/CSS, Python, SQL, or Ruby/Rails. However, I am open to your expertise on the tech stack that will best serve this project's requirements. Please include in your proposal an estimate of timelines and previous examples of similar work. Let�...

I'm looking for an experienced web developer to build a functional social networking website. Key Functionalities: - User Profile Creation: Users should be able to create a...an experienced web developer to build a functional social networking website. Key Functionalities: - User Profile Creation: Users should be able to create a profile solely with their email and appropriate user input parameters. - Blog Postings: Users should be able to post blogs and comments on these blogs. Ideal Skills: The ideal freelancer for this project should be proficient in HTML, CSS, JavaScript, and SQL. Experience with creating social networking sites or similar projects would be a plus. They should be able to cleanly write code, create an intuitive user interface, and ensure a secure...

...Assisting in larger team projects through more focused backend development * Utilizing test procedures, test environments, and consistency conventions * Ensuring all forward-facing projects are cross-browser compatible and mobile friendly * Maintaining system security and integrity through best practices * Providing information support for the administration team as needed * Participating in team efforts toward efficient and successful project planning including weekly virtual team meetings Job Requirements * 5+ Years Experience in backend or full stack development * Knowledge in ColdFusion (2018 or newer), Python, PHP, CFC, Javascript, SQL, MySSQL, Database Design, Server Management * Experience in front end user interface devel...

...data visualizations should be incorporated for users' easy and comfortable navigation The ideal candidate for this project should have strong experience and skills in developing with Wix and Wix Apps, SQL and integrating them cohesively. Understanding the importance of data management and the ability to integrate real-time updates into a simple yet functional interface will be critical for this role. Here's the full Scope of 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 Info...

...developer to build the backend for my web application. The application should have: - User authentication: The ability for users to create accounts, log in securely and manage their profile. - Data storage and retrieval: I need a system to store and retrieve various types of data within the application. - API integration: The backend should be able to communicate with external APIs, enhancing the functionality and enriching the user experience. Ideal skills and experiences for this project include: - Proficiency in back-end programming languages such as Node.js, Python, or Ruby on Rails. - Strong understanding of database management and experience with SQL or NoSQL databases. - Previous experience with building secure user authentication systems. - Familiarity with...

I need a competent professional to smoothly facilitate the migration of my MSSQL 2019 database to a new server. Additionally, the ownership of SQL Management Studio must be changed effectively. Key job responsibilities: - Safe and efficient migration of the MSSQL 2019 database to a new server - Successfully transfer ownership of SQL Management Studio Ideal Skills and Experience: - Proven expertise in MSSQL 2019 and prior versions - Proficient in handling SQL Management Studio - Experience in successful database migration projects - Detail-oriented in project proposals Please note that only freelancers providing detailed project proposals will be considered. Your proposal should demonstrate your understanding of the project requirements a...

I require an expert in SAP Integration Suite for a project focused on integrating Salesforce, Slack, and SQL. With proficient experience in Cloud Integration, Open Connectors, and API, you'll be able to skillfully execute my requirements. Your main tasks will be: - Implementing SAP Integration Suite with Salesforce, Slack and SQL. - Ensuring real-time data synchronization between the systems. - Establishing automated data transfer protocols. - Enhancing the overall efficiency of business processes through these integrations. Your expertise in SAP Integration Suite, Cloud Integration, Open Connectors, and API, along with the ability to ensure real-time data sync, automate data transfers, and streamline business processes, will be crucial for this ...

I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each column.

I need to convert a small 25mb .bak file to csv/xml. This is a backup of MSSQLSERVER2016 (MS SQL Server)

...hospital appointment booking website. This site should include essential features such as online appointment scheduling, patient registration, and detailed information on the hospital and doctors available. The primary users will be patients and hospital staff, so the user interface must be intuitive and user-friendly. Ideal skills: * Proficient in WordPress development * Experience in healthcare sector websites beneficial * Knowledgeable in SQL or other database management systems * Familiarity with responsive and mobile-friendly designs Key Customization Features: * Patient profile creation: Users should be able to create and manage their profiles effortlessly. * Personalized appointment reminders: The platform should send customized reminders to patien...

I'm in need of a highly skilled .NET developer for my project. It involves .NET framework (specifically web forms) and a complex SQL database. Ideal Skills and Experience: - Strong expertise in .NET framework, particularly with web forms. - Comprehensive knowledge of SQL, able to navigate and manipulate complex databases. - Previous experience with large-scale projects requiring intricate database structures. Your application should focus on your experience in these areas and similar projects you've completed. Please, make sure to emphasize your accomplishments and results in your past work.

Hi, Please apply only individual. Agency can apply but budget should not be more than mentioned. Role : GCP Engineer (OTP) Exp : 7 + yrs SHIFT: IST Cloud Storage Buckets, BigQuery (SQL, Data Transformations and movement) Airflow (python, DAGs), DBT IAM Policies PyCharm Databricks (pySpark), Azure DevOps Clear and confident communication

In this project, I'm seeking a Power BI expert's assistance to accomplish the following: - Development of data visualization using Power BI - Creation of intuitive dashboards and comprehensive reports I will provide data from classified sources, particularly Excel spreadsheets and SQL databases. Your task will be to integrate these platforms and generate compelling, easy to understand visualizations. The primary KPIs needed in the dashboard and reports will focus on: - Sales revenue: I'm interested in monthly, quarterly, and annual trends - Customer satisfaction: We'll track this through a set of predefined parameters. Your ability to illustrate complex data in a user-friendly manner will be paramount. Prior experience with inter...

I'm keen to find a well-versed ASP.NET MVC core developer to work on building a project from scratch. This task includes: - 4 Web Forms using Razor View and 4 Listing page with Filtering and Search feature. - Code first approach - Wir...developer to work on building a project from scratch. This task includes: - 4 Web Forms using Razor View and 4 Listing page with Filtering and Search feature. - Code first approach - Wire frames will be shared with shortlisted developer. - Entire code project need to share. - SQL Server DB. Key skills required: - Mastery in ASP.NET MVC core - Proficiency in Entity Framework and Identity Framework - Profound understanding of user authentication protocols - Demonstrable experience with responsive design - Ability in creat...

As a beginner in Power BI, I need a proficient tutor to help me master all aspects of the tool including Data modeling, Creating visualizations and DAX formulas. I have various data sources such as Excel files, SQL databases and Web APIs which I'd like to connect with Power BI seamlessly. For this job, a deep understanding of Power BI and experience in teaching or tutoring are desired. Patience and ability to explain technical concepts to a newbie could be a good fit for the role. - Power BI mastery - Tutoring experience - Familiarity with Excel files, SQL databases and Web APIs - Patient and clear communication skills

I'm in need of an MS SQL expert who can write complex stored procedures for my project. Key Responsibilities: - Develop and write complex stored procedures tailored to my specific needs Ideal Skills and Experience: - Proficient in MS SQL - Experience in writing complex stored procedures - Strong understanding of database design - Ability to understand and adapt to project requirements This project is vital to my current development, and I'm looking for someone who can deliver quality results. Please share your experience and approach to this task in your bid.

I am seeking a freelancer with deep experience in .NET MVC project code and Azure databases who can assist me in deploying my project on Azure. The task specifically involves: • Investigating issues with my database connectivity on Azure. • Identifying and resolving authentication-related errors I am currently encountering while using SQL Server authentication. The freelancer ideally could view these issues on my laptop setup and advise solutions accordingly. Knowledge of error diagnosis is critical. Understanding of Azure databases, .NET MVC projects and SQL Server authentication is a must.

...(India) 3+ years of .NET or JAVA development experience  Exposure to Outsystems and/or Appian for Low-Code preferable  3+ years with relational databases  3+ years of MS SQL or MYSQL  1+ years designing and developing REST APIs  Proficiency in C#, .NET, HTML, and/or Javascript  Exposure to JIRA and BitBucket/Git for source control a plus  Practical understanding of data structures, algorithms, and design patterns in a web environment  Cloud first architectures (AWS, Azure, Cloudera, etc.) a plus  Log aggregators (SumoLogic, Splunk) a plus  Experience with SAP, HANA, and/or Vistex a plus  Bachelor's degree in Computer Science, Information Technology or similar  Strong analytical skills to debug complex problems and curiosity/passion...

Seeking an experienced Business Intelligence (BI) developer to create a comprehensive and responsive BI dashboard using Oracle 19C. Your base will be my existing design sketch, bringing a clear and user-friendly layout to life. With an emphasis on real-time data refresh capacity, your focus will be to ensure users have up-to-the-minute information at their fingertips. Skills and Experience required: - Proficient in Oracle 19C - Proven record in BI dashboard development and design - Excellent understanding of real-time data updating - Detail-oriented with a knack for creating intuitive, user-friendly dashboard layouts. Tasks: - Connect Oracle 19C as the primary data source - Develop a BI dashboard based on provided design - Implement a Real-time data r...

I own tons of digital documents composed of text data that need to be carefully and accurately entered into a SQL database. Seeking an experienced Data Entry Specialist who: - Has proficient knowledge in working with digital documents for data entry. - Demonstrates excellent typing skills for handling text data. - Has a strong understanding of SQL databases and is comfortable entering data into this platform. - Has meticulous attention to detail to ensure the integrity and accuracy of my data. - Possesses a track record of data entry efficiency and speed, without compromising quality.

...that uses Classic ASP to query an SQL database with over 4000 entries. This is now causing loading issue due to the number of entries loaded into the web page. I require this page to be converted to JSON and save as a text file. The saved text file should then be loaded using AJAX and using JavaScript formatted for using Data Tables. I am also open to other ways that this can be achieved BUT DataTables is a MUST as all entries need to be loaded on the page and it MUST be written in VBScript. The current web page formatting and design details MUST remain the same. A copy of the page will be sent to the ideal candidate. No other data will be supplied. I'm looking for someone that has very good understanding of VBScript, Classic ASP, JSON and JavaScript in orde...

As a rapidly growing business, we are now experiencing some difficulties with our large MS SQL database system. The system comprises of multiple databases, which includes complex relationships and transactions. The primary task we need to carry out is Query Optimization and Performance Tuning. Our large infrastructure could use the expertise of a professional who can recognize inefficiencies and have them fixed. The ideal candidate will have: - Extensive experience with MS SQL , especially Stored Procedure - Proven expertise in query optimization and performance tuning - Experience with large databases, managing complex relationships and transactions. Your aim will be to help us optimize our system and ensure smoother operation of our database infrastructure. ...

As the primary user of a Windows 11 Pro PC acting as a server for a SQL based car dealership software, EasyDeal, I require technical support to resolve my ongoing issue. The main problem I encounter is that various devices are struggling to maintain a connection to the software, indicating a "Connection Timeout" TCP errors, "could not locate server" error message. Key Tasks: * Troubleshoot and repair the connection issues on the server and other devices * Ensure stable, reliable connection between the devices and server Ideal Skills & Experience: * Proven experience with EasyDeal software * Excellent knowledge and skills in SQL and network troubleshooting * Familiarity with Windows 11 Pro and server management.

I'm looking for someone proficient in SQL Server to help with my complex stored procedure. This task incorporates both performance optimization throughout and enhancements in specific areas. Required Skills and Experience: • Expertise in SQL Server. • Experience in performance optimization of stored procedures. • Tackling both overall and specific improvements. I have complete documentation of the current structure and logic of the procedure. This will aid in understanding what needs to be fixed and consequently expedite the completion of the project. Your role will include finalizing it and working according to the requirements. Do not bid for this unless you are free to work on this for the next 5 days, as this is ur...

I have a document that needs to be translated into the following languages: Japanese Polish Portuguese I need all of the text translated EXCEPT for any text that is italicised and in brackets (essentially any text telling where images should go, as this should not be translated).

Looking for a SQL Expert who is good with Transact SQL, stored procedure and expert with MS SQL server. Task is related to trigger and XML and should hardly take one day to complete

I have a webform developed in HTML5, PHP, SQL, and JavaScript. I'm looking for a developer to make a few key improvements. PRE-BUILT I have currently built a where the user selects a customer from a dropdown and selects the number of products to add to this order. Each customer from an SQL table called 'customers' has its own price class 'customerPriceClass' When the user selects the number of products, the page updates and adds rows for each product with a dropdown menu where the choices are fetched from another table called 'products'. The user selects the product and enters the number of units. NEEDED: STEP1 For each row of products the corresponding price from the table 'prices' should be fetched that is associated...

...established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions. 1. What type of Software you have done in Laravel+Vue? 2. How many years of Industry experience do you have in Laravel software development? 3. How many years of Industry experience do you have in Vue software development? 4. How many years of Industry experience do you have in Laravel + Vue software d...

I need an experienced C# developer to create an advanced contact form for my existing website and execute its storage function by integrating it with MS SQL Server. Key Requirements: - Development of a contact form with fields for Name, Email, Phone number, and Address. - Form validation should be included to ensure data input integrity. Specifically: * Email format should adhere to standard email format * Phone number input should match a predefined format. Preferred Skills: - Proficiency in C# and MS SQL Server - Experience in form creation and data validation - Attention to detail for error-free functionality.

I am looking for an expert who can aid with the design and development of an SQL database and a coherent PHP framework. The ideal candidate should have extensive experience with: - Designing efficient SQL database structures for small-scale databases (less than 1000 records). - Writing comprehensive SQL queries. - Effectively integrating PHP with SQL databases. The purpose of this project is to utilize SQL and PHP to innovatively design and construct a web application. The applicant should have a strong track record of building successful, high-performing web applications. Emphasis will be placed on the ability to manage and manipulate small-sized databases. Given the nature of this project, a meticulous approach to data management and a keen eye for de...

I'm in need of an experienced ASP.NET full-stack developer to provide job proxy from 7:30 pm IST to 2:30 am IST. (must have to work on client laptop wia screen sharing) Resource must have Knowledgeable of the ASP.NET framework, Microsoft SQL Server and design/architectural patterns (e.g., Model View-Controller (MVC)). Knowledge of web development languages, such as HTML, XML, CSS, JavaScript and AJAX. Experience with database servers, particularly Microsoft SQL Server 2016 or newer/ In-depth knowledge of the .NET infrastructure Experience with architecture styles/APIs (REST, RPC). Understanding of the Agile methodology. Knowledge of REST and RPC APIs. Strong communication and interpersonal skills with an ability to work well in a team...

...as the primary focus of the software. Ideal freelancers should have a strong background in this area. Key Details: - Essential components of the system will include flight booking capabilities along with additional elements addressing hotel bookings. - Must include a search function to locate hotels and book or cancel reservations. - Ability to review and rate hotels is a mandatory feature to incorporate. Payment Details: - The software system should integrate a secure payment gateway for the booking procedure. - I prefer to accept payments using Credit/Debit cards and Bank Transfers. Previous experience in developing booking systems and payment gateways will be a plus. Skills: - Python, C#, SQL or other relevant languages - Payment gateway integration - UX/...

I'm in need of a skilled trainer who can guide potential data analysts with intermediate level knowledge. Mastery in software such as Excel, Python, SQL, Pandas is expected along with competence in working with data frames and Basic Data Structures. Clear understanding of basic syntax is a must along with experience in Tableau/Power BI. The chosen professional would be conducting group training sessions, hence prior experience in the same would be a plus. Ability to simplify complex concepts for easier understanding is a valuable trait we are looking for in our trainer.

Necesito terminar un proyecto que ya empezamos, el profesional debe tener pricipalmente conocimientos en Framework Laravel y Bases de Datos SQL

...detailed 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

I'm looking for a detail-oriented professional to help enter a mixture of text, numbers, and images into a Microsoft SQL Server database. This should be completed in an organized and efficient manner. Key skills and Experience: - Proficient in Data Entry - Familiar with Microsoft SQL Server - Ability to accurately enter a mix of text, numbers, and images - Good organizational skills and attention to detail - Understanding of database organization and management This project requires someone with data entry experience and a solid understanding of how to utilize Microsoft SQL Server. Efficient and meticulous data organization is crucial to this project's success.

I'm in need of a skilful database expert to restore a MySQL database. The database size is less than 1GB, hence would not pose a heavy workload. Our backup file is conveniently located on the server at hand. Key Skills Required: - MySQL Database Management. - Proficiency in SQL commands. - Experience in restoring databases, preferably MySQL. Your expertise should assure a minor downtime and safe recovery without data loss. Looking forward to connect with the right professional.

I am seeking an adept Java developer with experience in JUnit testing and microservice architecture, particularly focusing on services revolving around user authorization. Here are the specific requirements: - Knowledge and familiarity with Java language. - Hands-on experience with JUnit testing, ensuring seamless functionality. - Understanding of user authorization for microservices. - Ability to effectively conduct and troubleshoot testing in a local environment. Your primary task will be addressing and rectifying issues encountered during JUnit testing on a specifically user authorization-related microservice in a local environment. Qualified candidates should be comfortable with debugging and have a proven record of handling similar projects.

Seeking an experienced IT professional adept at executing tasks within a Windows framework. The primary project goals are: 1. Assisting in crafting a Virtual Machine (VM) on a Windows platform, and configuring it so that I can access it virtually. 2. Assisting with the creation of API processes in Python, particularly focusing on data extraction and insertion. Required skills include a robust understanding of Windows platforms, VM creation and management, Python programming, API integration and SQL database manipulation. Your comprehensive knowledge and practical experience in these fields will be key in successfully completing this project. More information on the API integration will be provided.

I am seeking an advanced-level SQL Query and Reports developer with a strong background in Microsoft SQL. Your expertise will be leveraged to create detailed operational reports. Key Responsibilities: - Design, develop, and maintain SQL queries for data analysis and extraction. - Create and maintain complex reports in Microsoft SQL. - Interpret data and analyze results using statistical techniques. Ideal Skills and Experience: - Proven experience as an advanced-level SQL Developer. - Ability to write complex SQL queries is a requirement. - High proficiency in Microsoft SQL. - Experience in creating operational reports. - Strong statistical analysis skills.

I am seeking an advanced-level SQL Query and Reports developer with a strong background in Microsoft SQL. Your expertise will be leveraged to create detailed operational reports. Key Responsibilities: - Design, develop, and maintain SQL queries for data analysis and extraction. - Create and maintain complex reports in Microsoft SQL. - Interpret data and analyze results using statistical techniques. Ideal Skills and Experience: - Proven experience as an advanced-level SQL Developer. - Ability to write complex SQL queries is a requirement. - High proficiency in Microsoft SQL. - Experience in creating operational reports. - Strong statistical analysis skills.

I'm in search of a Azure Data Factory expert who is well-versed in Delta tables, Parquet, and Dedicated SQL pool. As per the requirement, I have all the data and specifications ready. The successful freelancer will need to be familiar with advanced transformations as the ETL complexity level is high. It's a plus if you have prior and proven experience in handling such projects. Key Skills Required: - Expertise in Azure Data Factory - Deep knowledge of Delta tables, Parquet and Dedicated SQL pool - Familiarity with advanced ETL procedures

Looking for a skilled professional experienced in SQL and Power BI project. Please read word file for more information

...list of databases: - SQL (Oracle, PostgreSQL, SAP HANA) - Using Airbyte (with LlamaIndex or LogChain): - SAP CRM - Pipedrive (using Airbyte) - HubSpot - Salesforce - JIRA ( ) Additionally, the assistant should be able to process documents (PDF, DOC, TXT) and summarize a document upon request, answering questions based on the information found in the documents. For database queries, the user must start their request with a keyword to differentiate it from standard questions, for example, "SAP:", "Oracle:", "HubSpot:", etc.

I'm currently seeking a keen React developer with intermediate experience in Virtual DOM manipulation. This project will primarily focus on: - Building a user registration system - Implementing robust Virtual DOM manipulation using React - SQL Expertise required The potential candidate is expected to have a decent understanding and hands-on experience in working with component-based architecture and also state management. Solid experience with MySql backend will be considered a plus for this task. It is expected that you deliver a clean coded, well-structured and performance optimized registration system while adhering to best development practices. Looking forward to choosing a capable React developer for this challenging opportunity.

Please find database which need to recover, I want it into SQL file I am in immediate need of a skilled MySQL specialist to recover a database from a database folder. This is an urgent task and requires successful completion as soon as possible. The operating system used is Linux. - The chosen freelancer should have proven experience with database recovery tasks and a sound knowledge of Linux operating systems. - Due to missing information, flexibility with handling different versions of MySQL is also necessary. The project will be deemed successful once the database is fully recovered and available for use. Preference will be given to freelancers that offer swift project execution and those who have extensive experience in MySQL recovery tasks.