Procedure oracle pl sqlJobs

Looking for a skilled web developer to create a sleek and responsive standalone web app th...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's work together to create a tool to simplify equipmen...

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 profile solely...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 regist...

...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 development,
HTML, and CSS * Knowledgeable in APls, both SOAP and REST * Knowledgeable in Windows server management * Strong problem solving skills * Forward thinking in all development * Strong time management skills * Self-starter * Detail oriented Projects You will Own or Assist in...

...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 Information**, *...

I'm looking for a skilled full-stack developer to build the backend for my web application. The application should have: - User authentication: The ability for users...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 integrating various APIs. - Good communication skills and ability to work collaboratively with a front...

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 as well as how you intend to ...

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

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)

...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 patients about their upcoming appointments to reduce no-shows. Your port...

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 interpreting sales data and custo...

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 - 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 creating professional, corporate designs.

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. • I...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...

...looking for an Independent contributor, who can support us for 8 hours a day, 5 days a week, with the following requirements. Role- Low code Developer Exp Required - 5+ Yrs Timings : 10:00 am to 07:00 PM IST Location : Remote (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 ...

...quantiles in the regression analysis framework. WORK PLAN 1.) For the first objective, the effectiveness of these three sample selection adjustment methodologies in quantile regression modelling framework is to be tested, and the best one is to be further used in “decomposition” analysis. The three types of sample selection adjustment methodologies are: • Albrecht et al. (Research Paper): This procedure combines a semiparametric binary model for the participation equation with a linear quantile regression model for the wage equation and follows Buchinsky's (1998) approach. The research paper is based on this approach. • Arhomme (Stata Package): ssc install arhomme • Qregsel (Stata Package): ssc install qregsel To determine the impact of various c...

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 refresh feature

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.

I have a VBScript page 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 i...

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 urgent work!

The purpose of this project is for an experienced data analyst to make sense of provided educational assessment data, specifically test scores. Annually we run an assessment of surgical technical skill for several distinct cohorts, based upon surgical specialty. They perform several procedures, which are assessed using procedure-specific assessment tools by 2 assessors. Initial reliability has been conducted (inter-item, inter-rater). Here's what is expected: - Conduction of G theory studies.

...charging. 2. Overcurrent protection to safeguard against excessive current flow. 3. Low voltage charging protection to prevent the battery from reaching dangerously low levels. 4. Charging status indication for the microcontroller **Key Responsibilities:** 1. Design a LiPo charger circuit incorporating overvoltage, overcurrent, and low voltage charging protection. 2. Develop a robust testing procedure to verify the circuit's reliability, efficiency, and safety. 3. Provide comprehensive documentation detailing the circuit design, component selection, and testing procedures. **Requirements:** 1. Proven experience in circuit design, particularly with LiPo battery charging circuits. 2. Expertise in implementing overvoltage, overcurrent, and low voltage charging protection mech...

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 with t...

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you 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....

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

...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 setting. Advanced proficiency in C#, F#, or VB.NET; preferably all three. Highly experienced using Microsoft SQL. Outstanding analytical, problem-solving, and cri...

This project requires building a robust flight booking system that will function as the primary focus of the software. Ideal freelancers should have a strong background in this area. ...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/UI - Database Management - Pr...

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

...development and potential future scaling. End Goal To create a functional MVP that effectively demonstrates the capability of the platform to support businesses in developing and analyzing their visions, leveraging the robust foundation of the Full Stack FastAPI template. ⚡ FastAPI for the Python backend API. ? SQLModel for the Python SQL database interactions (ORM). ? Pydantic, used by FastAPI, for the data validation and settings management. ? PostgreSQL as the SQL database. ? React for the frontend. ? Using TypeScript, hooks, Vite, and other parts of a modern frontend stack. ? Chakra UI for the frontend components. ? An automatically generated frontend client. ? Dark mode support. ? Docker Compose for development and production. ? Secure password hashing by default. ? ...

I need a professional to increase the number of followers of our German Facebook page and the number of membe...also be positively increased and maybe used. This is a German website and the associated social media channels. Content of the website are bargain offers (coupons, price errors and the like) based on the Amazon affiliate program. It is important that only permitted and legal methods are implemented to increase the number of German-speaking participants! I expect a precise structure in the procedure with concrete suggestions for action for the planned implementation, already in your offers. What is important to me is 100% legal implementation without running the risk of Meta (Facebook & Whatsapp) blocking access! Please only bid if you really have expertise in exac...

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

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

I’m working on a mobile quiz game and require Unity scene designs. It is a mobile game. The game is a quiz game to test the knowlegde of firefighters. We want to add more interaction and this is the reason we created this project. Key tasks: - Design and develop a Unity scenes that requires the player to rescue someone from a car by performing a procedure. - Implement logic for drag and drop, toolbox, etc Ideal skills and experience: - Proficiency in Unity and 2D design - Experience in game development, preferably mobile games - Ability to translate game concepts into engaging visual designs. - Understanding of level design and difficulty balancing in games. Please see attached document for more details.

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

To change our allocation access / SQL system as per the discussed changes.