SQL Jobs

Queries implementadas na linguagem SQL aplicadas no SGBDR Oracle, apoiadas no SqlDeveloper. Utilizar o MER Físico e BD Pedido disponibilizado para treinamento da disciplina de Banco de Dados.

Looking for an experienced EPICOR specialist to help with customization for our business. The project timeline is more than 4 weeks, and the ideal candidate should have the following skills and experience: Understanding employees requirement and making a report Building SQL query Building reports using SSRS reporting Understand Sales and Purchase process and develop salesforce as per process Train employees for Epicor/salesforce Resolve the issue by coordinating with Epicor/salesforce support This would be a part-time position as a starter and we will see how it goes to transition to fulltime. Please send a cover letter and your updated CV/resume.

I am looking for a freelancer to assist me in automating my travel agency. The specific tasks I need to automate include booking flights and hotels, scheduling tours and activities, and managing customer data. Currently, my system for managing travel bookings and customer data is a basic Springboot based Miniproject. I am looking for someone who can make basic changes in code and UI only for the user part. The timeline for completing the project is urgent - within 1 month, and I would prefer to have it completed today or tomorrow. The ideal freelancer for this project should have experience in coding, UI design, and automation.

I am looking for a skilled database developer who can optimize my MySQL query or index the database to improve performance. The database is currently 1.3GB in size and is used for transactional processing. There are specific tables and queries causing performance issues that need to be addressed. The specific table is approx 200k rows. The query is fairly simple but taking 10 seconds to complete, and it needs to be closer to 1 second. I can provide the exact table structure and the query, but not actual data. The database is hosted on a normal windows machine. Ideal skills and experience for this project include: - Advanced knowledge of MySQL database optimization and indexing - Experience working with large databases - Ability to identify and troubleshoot specific tables and queri...

We need to remotely re Setup existing device with old data in sql server we have software with serial and we have db in microsoft sql server

I am looking for someone to help me install phpMyAdmin and restore my SQL dump. I currently do not have a web hosting service set up and would appreciate recommendations. The project requires proficiency in PHP and only basic setup customization is needed for phpMyAdmin. Ideal skills and experience: - Proficiency in PHP - Experience with installing and configuring phpMyAdmin - Knowledge of SQL dump restoration - Familiarity with web hosting services and recommendations. and mysql and restor mysql dump as well 4-5 files

Looking for a skilled Golang developer to help with both new and existing projects. Specifically, we need assistance with backend development tasks. The ideal candidate will have experience with API development and web development. We have an existing codebase that needs to be maintained and optimized, as well as a new project that requires development from scratch. The expected timeline for the project is more than 4 weeks.

I need help with writing and solving some problems connected to SQL and ER model relations.

I am looking for a freelancer who can feed the product similar to older website in my newer new website will be built using Active Ecommerce CMS. Older Website: New Website: Check the product sheet here: Weight Attribute is created already in New Website. Shade Attribute has to be fed in new website. And Product Description to be copied from older website, images wherever required will be provided in zip or drive folder.

Hi I need support oracle database for my consultant like Indian time 8:30 pm to 10 pm 11$/hourly. Payment every Friday. This support will be on zoom meeting which we will provide you and you will connect with my consultant and support him.

I am looking for someone who can develop a forex / crypto signals platform where users would sign up for subscription which admin can set up in back end and users subscribe and received X amount of signals per day via WhatsApp, Email, Telegram, or SMS. The platform will be web based and users should be able to view charts on the platform too. Payment gateways: Stripe / PayPal Any experience in similar projects would be advantageous.

Job Description: Database Engineer (Informatica/ETL) We are seeking a highly skilled and motivated Database Engineer with expertise in Informatica and ETL (Extract, Transform, Load) processes to join our dynamic team. As a Database Engineer, you will play a crucial role in designing, implementing, and managing our complex database systems, ensuring optimal data integrity, performance, and security. You will collaborate closely with cross-functional teams to deliver scalable solutions and contribute to the success of our organization. Responsibilities: • Design, develop, and implement efficient and scalable database solutions using Informatica PowerCenter and other ETL tools. • Perform data extraction, transformation, and loading (ETL) processes, ensuring the accuracy and integrit...

I am looking for a freelancer who can help me with my SQL dump to Excel project. The SQL dump file size is medium, ranging from 50MB to 500MB. I would prefer the Excel output to be available in both CSV and XLSX formats. Additionally, I require specific data filtering and sorting in the Excel file. The ideal candidate for the job has experience working with SQL dumps and Excel, and is proficient in data filtering and sorting. If you have the necessary skills and experience to complete this project, please submit your proposal.

I have a custom wordpress plugin that has a database of test questions. There are several tests and several questions in each. Some tests are randomly dropping questions. I am looking for someone to fix this issue. Please bid accurately. Inaccurate bids will be ignored.

I am looking for a skilled developer to work on a legacy Visual Basic 6 (VB6) desktop GUI VB Form project with database access. The primary purpose of the VB6 desktop GUI form is data entry. The project requires working with an existing database structure, which is already set up. The database system being used is Oracle. The feature of the desktop application GUI is to modify a few fields in a DB table (less than 10 fields), keeping the access logs. There is already an existing VB desktop application with source code, the task is to add additional GUI access VB Form for the above mentioned data access. Ideal skills and experience: - Proficiency in VB6 desktop GUI form development - Familiarity with Oracle database system - Ability to work with an existing database structure - Experienc...

I am looking for a skilled developer to create a web portal that will analyze sales data in real-time. The portal will need to have the following features: - Real-time data updates - Data visualization - Customizable reports The portal will only need to be accessed by less than 10 users. The ideal candidate should have experience in web development and data analysis. They should also have knowledge of data visualization techniques and the ability to create custom reports. There are around 100k rows of data all stored in a SQL server.

I am in need of an experienced Oracle DBA with expertise in Golden Gate configuration. I have an existing Oracle database that requires Golden Gate configuration. The task is of medium priority and needs to be completed within a reasonable timeframe. The ideal candidate should have experience in Oracle Enterprise Manager (OEM) setup and be proficient in Oracle database administration. Key requirements for this project include: - Oracle DBA with experience in Golden Gate configuration - Familiarity with Oracle Enterprise Manager (OEM) setup - Strong knowledge of Oracle database administration - Ability to work within a medium priority timeframe

We have a database of 1.4 millions names and we process 14 millions search every year. Our results are very basic and we have a lot of false positive. We need to implement the new features of Solr 9.x. Our front is in Java. Sugester Re-ranking Highlighting Faceting

I am looking for a skilled freelancer to build a new system for our company database. Currently, we are using another software system to store our data. However, we need an upgrade that will provide us with more advanced features, including user access control. Our ideal freelancer should have experience in building database systems with user access control functionalities. In addition to that, we also need advanced search capabilities and custom reporting options. Furthermore, we require integration with new software. Therefore, an ideal freelancer should have experience in integrating systems.

I am looking for a database developer who can create a database that will primarily be used for analyzing data. The database should have basic security measures in place to protect the data. Skills and experience required for this project include: - Experience with database development - Knowledge of data analysis techniques - Understanding of basic security measures for databases

Hey all, so i have been building a database, all i need is someone to Finnish the last 3-4pages. One page needs to search by a query the database and show the results. One page loads the record and allows you to edit it One page shows the record there might be a few more but i can provide current work and this is the design i have done https://miro.com/app/board/uXjVMKvGVPs=/?share_link_id=322236887126

Hey all, so i have been building a database, all i need is someone to Finnish the last 3-4pages. One page needs to search by a query the database and show the results. One page loads the record and allows you to edit it One page shows the record there might be a few more but i can provide current work and this is the design i have done https://miro.com/app/board/uXjVMKvGVPs=/?share_link_id=322236887126

Hey all, so i have been building a database, all i need is someone to Finnish the last 3-4pages. One page needs to search by a query the database and show the results. One page loads the record and allows you to edit it One page shows the record there might be a few more but i can provide current work and this is the design i have done https://miro.com/app/board/uXjVMKvGVPs=/?share_link_id=322236887126

I am looking for a freelancer to assist with YouTube data harvesting and warehousing using SQL, MongoDB, and Streamlit. The primary focus of this project is to collect and store channel information such as channel id ,name, video count,likes, comments,description, and subscriber count. This data will be used to improve my video content strategy and monitor my competitor channels. The frequency of data updates is yet to be determined. Ideal skills and experience for this job include: - Proficiency in SQL and MongoDB - Experience with data warehousing and streamlit data pipelines - Familiarity with YouTube's API and data collection methods - Knowledge of data analysis and visualization techniques If you have the necessary skills and experience, please submit your proposal.

I am looking for a developer to help me extract stock market data from Lightstreamer and store it in a MYSQL database. The ideal candidate should have experience working with real-time data and be able to update the database as frequently as possible. Skills required: - Experience with Lightstreamer or real-time data - Proficiency in SQL and database management - Strong attention to detail and ability to troubleshoot issues quickly - Knowledge of financial markets and stock data Responsibilities: - Extract stock market data from Lightstreamer - Store the data in a SQL database - Update the database in real-time or as frequently as possible Datasource: Lightstreamer URL: wss:// I need the messages: d(1,2,4,'08:38:29','15977.2449') --> DAX d(1,1,'1.9600...

We are looking for PBI experts to work on a high-impact project which would include implementing on new initiatives such as Dashboarding, Sales Pipeline management, QnA bot, etc. More details: What data sources do you need integrated into the Power BI report? Excel, SQL databases Do you require data visualization or just data consolidation? Both What key performance indicators (KPIs) do you want to track in the Power BI report? We want to implement sales pipeline management via Power BI

Create a basic web based E2EE(secure messaging) as website of support system for interaction. There should be a knowledge repository where people share reading and learning materials. Besides the Login, Register, Messaging (view, send), Regular User role, your website should also have functionalities like following (to be assessed in last activity) • Data/Info hierarchy – how you organize user generated content • Admin Role - delete/mute user, delete a course guide • One specific user function – depending on your user investigation. You are required to design the website with usability and accessibility in mind. A series of recommended activities will be provided in this document as a guide for your action plan and discussion. Get a feedback, get results, prepar...

Need long-term C# developer for multiple websites / projects operated by our company. Must be VERY experienced with C# and ASP.NET as we have dozens of projects and a large base of existing code. Knowledge of threading and Windows Services is also very helpful so tell us if you have this experience. Additionally, we want someone who is very loyal and trustworthy who wants a stable, full-time, long-term project. If you want stability and long-term work for one client without having to jump from job to job, this is a great opportunity. Remote work from home is acceptable if your power, internet and hardware is satisfactory. Minimum 5 years C# / ASP.NET experience REQUIRED. Ability to write advanced T-SQL queries is REQUIRED. AGENCIES: If you are applying from any agency, write &q...

Hey all, so i have been building a database, all i need is someone to Finnish the last 3-4pages. One page needs to search by a query the database and show the results. One page loads the record and allows you to edit it One page shows the record there might be a few more but i can provide current work and this is the design i have done https://miro.com/app/board/uXjVMKvGVPs=/?share_link_id=322236887126

I am looking for an experienced freelancer to assist me with setting up my Oracle Cloud accounts. This will include working with Platform as a Service (PaaS) services, and helping with the registration process for up to five separate accounts. The freelancer should have proven experience in working with Oracle Cloud Services and be able to provide guidance on timescale, best practices and the resources required to get the job done. I'm sure that by working together we can achieve my goal of having all accounts running quickly and efficiently.

I am in need of a freelancer to develop a client/staff database that stores contact information and work history and stuff. The database should also provide automated reporting functionality to generate reports staffing should be inlclude filters, tab and formulars. This should record client demographic, start and end date, location, care plan, and all. This is not a website. Its a simple tool for recording all staff and client details

Design and implement a Clinic Management System. The system includes two modules: ADMIN and STAFF. Admin is responsible for maintaining the database containing data regarding the clinic. Admin can add, delete, update, and search details of staffs, doctors, patients, medications, and appointments. Admin can also generate the reports of staffs, doctors, patients, medications, and appointments at a particular time. For staff, the following information is required to register: Staff ID, username, password, date of birth, phone number, email address, and employment status (part-time or full-time). Staff can login and can view and update his/her personal details. Staff can also add, delete, update, and search details of doctors, patients, medications, and appointments. Doctor details include Doc...

I am looking for an experienced Power BI expert to create a custom dashboard for data analysis using Excel/CSV files as the preferred data source. The main goal of this project is to produce a visually appealing dashboard that provides insights into our data. The dashboard should be fully customized with custom design and features. I am looking for a freelancer who has experience in creating custom Power BI dashboards with a strong understanding of data visualization and analysis. Ideal skills and experience for this job include: - Expertise in Power BI - Strong data analysis and visualization skills - Experience with Excel/CSV files as a data source - Ability to create fully customized dashboards with custom design and features

More details: Our Existing ERP is product based, but created it using VB net and Dot net with old architecture, we would like to create a module (as a new project) with the old database connection and create QR for our products

More details: Our Existing ERP is a product based but created it using VB net and Dot net with old architecture, we would like to create a module (as a new project) with the old database connection and create QR for our products We have the design ready and QR code logic ready. The design and logic files are attached. Required to be completed in 24 hrs

Hello, I'm looking for someone experienced in both Excel Formula and SQL Query especially SQL Server 2019. The task is to convert excel formula to SQL Data tables and or views for 7 cells that needs to be tracked from end-to-end. The file is in xlsb format I need it urgent in 7 days and have progress at least 2 of 7 point I mentioned in 3 days. The excel has 46 sheets that has to be traced for getting the computed value required

Azure ADF Data Processing Project I am looking for a freelancer who is experienced in Azure ADF data processing. The project involves processing data from a source, such as SQL Server to another SQL server with some ETL. Ideal Skills:

I need someone to edit my Oracle queries and convert them to Postgres. I am familiar with Postgres syntax and features, but I need assistance with query conversion. There are 1-10 queries that need to be converted. Ideal skills and experience: - Strong knowledge of Oracle and Postgres databases - Experience with query conversion - Familiarity with SQL syntax and features for both databases - Attention to detail and ability to ensure accuracy in the conversion process.

Manage the contents of the Racks and Pallet Position of the warehouse with barcode and qr code capability

i need a oracle expert asap....

Hello i have create one query and i have double result ? Why ? I have sql server Contact me please

DOCUMENT AI GOOGLE . We are looking for people with proven capability document parsing. Database design: necessary tables : A) table for suppliers, B) customers, C) documents (invoices, orders) D) products Define the attributes of each table and the primary and foreign keys to establish the relationships between them. Database creation: Use a relational database management system (RDBMS) such as MySQL, to create your database. Data extraction: Use the information extraction techniques to extract the relevant data from the documents. Machine learning methods to extract the desired information and associate it with the corresponding database tables. Data insertion into the database: Use SQL language or a data import tool provided by your RDBMS to insert the extracted data into...

***** Only Indians **** Position: Full Stack Developer Type: Remote Screen Sharing Duration: Part-Time Monday to Friday 4 Hours a day & 3 Hours a day Salary: 60,000 INR per month & 45,000 INR per Month Start Date: ASAP I am seeking a skilled Full Stack Developer with expertise in Angular, Springboot, Java. The ideal candidate must have experience working with Agile methodology for development. This is a long-term project. We are looking for someone who can work in the EST time zone connecting via remote i.e zoom, google meet on a daily basis to assist in completing the tasks. Here we will be working via screen share remotely, no environment setup will be shared. Required Skills: - AWS - SQL - Angular - Java - SpringBoot - JavaScript

***** Only Indians **** Position: Full Stack Developer Type: Remote Screen Sharing Duration: Part-Time Monday to Friday 4 Hours a day & 3 Hours a day Salary: 60,000 INR per month & 45,000 INR per Month Start Date: ASAP I am seeking a skilled Full Stack Developer with expertise in Angular, Springboot, Java. The ideal candidate must have experience working with Agile methodology for development. This is a long-term project. We are looking for someone who can work in the EST time zone connecting via remote i.e zoom, google meet on a daily basis to assist in completing the tasks. Here we will be working via screen share remotely, no environment setup will be shared. Required Skills: - AWS - SQL - Angular - Java - SpringBoot - JavaScript

We had a power failure and our db crashed we tried innodb_force_recovery from 1 to 6 but can still not get into the db We need someone who can repair the db Server version: 5.5.68-MariaDB key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=0 max_threads=153 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466719 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48000 /usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x5609fe233cad] /usr/libexe...

need a ninjatread desktop version edit

Hi Need Database Admin for support my consultant Indian time 7 am to 8:30 am Tuesday to Saturday 10$/hourly. Payment every Saturday veai payplae Indian time 9 pm.i already have other Indian guys who are working with me for mulesoft support since 2019 to present. can you do data migration using code first method?

I am looking for a freelancer with intermediate expertise in data management to help me with my SpectrumIQ project. The main goal of the project is to manage data effectively. I would prefer to use SQL Database as the platform for this project. The ideal freelancer should have experience in SQL and data management. They should be able to organize and manage data, create efficient data structures, and ensure data accuracy and integrity. Additionally, they should have experience in designing and implementing data management solutions that meet the needs of the project.

Necesitamos crear una copia en forma de backup en un segundo servidor de un servidor en produccion de moodle

I'm looking for an experienced web developer to build a sophisticated webapp. The primary purpose of the webapp will be to analyze real estate data. I have a specific set of programming languages and frameworks in mind that I would prefer to use for this project, such as Python/Django. With this project I'm hoping to find a capable professional who can work well with these tools and create a user-friendly application that provides meaningful information and insights about the real estate market. The webapp should be stable and secure and should run smoothly on all major web browsers. In addition, the webapp should also be compatible with mobile phones and tablets. If you think you’re the perfect individual for this job, I’d love to hear from you.