Database Programming Jobs

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add the Con...

Need freshers who want his first job with good visibility.

I need an experienced data entry professional to update contact emails in 3 databases All of them are updated I need someone to crosscheck & update if they are incorrect & highlight if it is incorrect. DB 1 MC- 5972 DB 2 H- 754 DB 3 AC- 1033 Bid with the exact price you can do this for. I will go with the lowest bid as its an easy task.

I need to convert a conceptual ERD to a logical ERD (See attached image below). The logical ERD should only include primary and foreign keys. I need the prpject ready by 25th/26th Skills and experience needed: - Proficient in database design, specifically with MySQL - Understanding of primary and foreign keys - Familiarity with normalization forms - Ability to convert conceptual ERD to a logical ERD

I'm in need of an experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, ...

I'm seeking a professional with expertise in Visual Software to adjust my company's quote template. Key responsibilities would include: - Adding permanent text, specifically our company's terms and conditions, to all of our quotations. Your skill in precision and attention to detail will be key as we need this text to always appear directly below the quote details. Ideal freelancer should have: - Proficient skills in Visual Software - Experience in document formatting - Strong attention to detail Your job will ensure our terms and conditions are always visible and clear, enhancing our business professionalism and clarifying our policies for our clients.

I'm in need of a skilled computer expert to help me develop a database. This database will essentially serve as an accounting tool for food. It's crucial for me to keep track of various aspects of my food-related transactions, including purchases, sales, and expenses. I require a professional who can translate these needs into a well-structured database. Key requirements include: - Data on food purchases, sales, and expenses should be efficiently stored and easily accessible - The database should be designed to facilitate clear accounting procedures - The system should be user-friendly and reliable, making it easy for me to input data and generate reports as needed Ideal skills and experience for this project are: - Proficient in database design, particularly for accounting pu...

I'm in need of a PowerBi expert to resolve a critical error for me. The error message reads: "Failed to save modifications to the server. The error returned: 'Relationship '59f250b2-ca16-47f4-8a50-ba4d8636a1ed' points to deleted column 'Setter 2' in table 'Bridge of Setter'." - Urgency: The task should be completed within 24 hours. - Documentation: I don't need any documentation on how the issue is resolved, just the solution itself. - Dataset Access: Unfortunately, I can't provide access to the original dataset. The expert will need to resolve the issue without it. Skills and experience required: - Proficient in PowerBI with experience in resolving server-related errors. - Ability to work under tight deadlines and deliver work ...

We are currently experiencing significant performance issues with our Oracle database under heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuri...

We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and cod...

I'm seeking a professional to help me establish a reliable system for managing my personal inventory data. - You need to create a user-friendly database where I can keep track of my personal items, their quantities, and possibly other relevant details. - The system should be intuitive and straightforward to use, as I'm not a tech-savvy person. - Importantly, it should be secure, ensuring that my personal data is protected. Ideal candidate will have experience in database management, creating user-friendly interfaces, and a strong understanding of data security. Previous experience in inventory systems will be a big plus as well.

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven track record in creating high-performance and secure API...

1. Issue Rural commodity growers face challenges in accessing markets due to high air and sea freight costs. To support these farmers and producer groups, our organization provides upfront funding for freight expenses. However, the existing process lacks a robust database system with simple bookkeeping features. We need a comprehensive solution that streamlines the entire process, ensures transparency, and automates accounting and reporting tasks. 2. Solution: Commodity Transportation and Funding App Key Features: User Registration and Application: Commodity growers, shipping companies, and airline carriers register through a user-friendly web interface. User details, including CRM data, are captured during registration. Freight Tracking and Reimbursement: Record transportation details (d...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient solution, as the generat...

Looking for a skilled developer to help with an issue related to Livewire gadgets. The key points of the project are: - The problem: Currently, the save functionality of one of the gadgets, namely Index Filter, is not working as intended. It's not saving data correctly. I need this to be fixed. -Also need to fix livewire library issues please Ideal candidates for this project should have: - Proven experience with Livewire gadgets - A strong understanding of database systems, particularly in the context of web applications - The ability to troubleshoot and solve issues efficiently - Strong communication skills to understand and implement the necessary changes to the saving mechanism.

I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.

I'm seeking a professional to design an ERD (Entity Relationship Diagram) for use in business analysis. I've skipped clarifying the specific type of ERD needed, implying flexibility on how to best approach the task. This task includes, but is not limited to: - Drawing up an ERD based on data provided - Creating a simple EVA on the data provided - Guiding its use for business analysis tasks - Assuring its potential for further business application Ideal candidates will have experience in ERD design, business analysis, and applicable database knowledge. Please include applicable skillsets in your bid. Your approach and understanding of the task will make a difference when choosing the freelancer.

I have 29 SCADAVIS panels on Grafana that are not displaying properly, they're not showing data as they should. Key Requirements: - Fix the problem with the panels not displaying data correctly. Ideal Skills and Experience: - Proficient in Grafana and SCADAVIS. - Experience in troubleshooting and fixing SCADAVIS panels on Grafana. - Strong data visualization capabilities. Please note that I'll provide the necessary data source for these panels.

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I require an advanced database to streamline church operations. It must include: - Member management: This involves recording personal details of each member, tracking attendance, and allocating to the right departments. Each member's record should also include household and family details, with specific fields for spouse and children. - Functionalities: Capacity to sort data based on each individual (organize by member). It should also capture other input fields like gender, age, membership status, notes, and whether they serve as workers or ministers. - Financial management: The platform should have capabilities for recording and tracking financial contributions. Ideal freelancers will have experience in building similar database systems, with a keen understanding of how to tran...

looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Tools -> MySQL...

I'm seeking a skilled developer to create a script that can download the complete list of sanctions data from OpenSanctions database. Once the data is obtained, the script needs to perform a comprehensive database search, identify any country-specific sanctions, and provide a detailed report of these connections as well as a option to show a visual mapping. Key Requirements: - Download the complete list of sanctions data from Open Sanctions database - Conduct a thorough database search to identify country-specific sanctions - Create a report summarizing the identified connections The final report should be in an interactive web page format. The visualization should be clear and easy to comprehend, allowing for an intuitive exploration of the connections found. Ideal Skills & E...

I require an expert in MS Access and Visual Basic programming to design a user-friendly form input interface for my project. - This interface should be intuitive and be capable of capturing and effectively managing predominantly text data. - Familiarity with database systems and strong understanding of user interface design principles will be extremely advantageous. - I'm looking for someone who can deliver quality work promptly. Demonstrative past experience in similar tasks will be highly advantageous.

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the customer data This system wi...

I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigat...

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system features. - An understa...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Proven track record in ...

I need a Student Information Management System developed with SharePoint and PowerApps. This will be a comprehensive tool for tracking attendance, storing documents, and managing information from contact details to medical records. Key components should include: **Attendance Tracking** - The system should enable manual entry by teachers. **Student Profiles** - Each student should have an individual profile displaying personal details, contact information and medical details. - Student details and parent details will be collected using Office 365 Forms and the replies should write directly into the student management system. **Document Storage** - A document storage section is required for maintaining relevant records and resources. Including student documents like passports, reports, ...

I have an existing design of a hospital with roles etc. i want some improvem ents and an interface with and write a report I will sned you analytical details in chat deadline 21/5 budget $60 USD

I'm looking for a Power BI expert to create a dashboard primarily for our executive team. - The main goal of this project is to create a visually appealing and easy-to-understand dashboard. - The dashboard should be tailored to the needs of executives, providing them with the key information they require at a glance. - Database of 2,000 cases and 11,090 variables Ideal skills and experience for this job: - Proficiency in Power BI - Previous experience in creating dashboards for executives - Great data visualization skills - Ability to integrate data from databases The successful freelancer will have a good understanding of what makes a dashboard not only visually appealing but also functional for high-level decision-makers. Your experience in data integration and visualization...

I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MySQL: The ideal candidate shou...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

I have a high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintain the same output as the present T-S...

Our existing CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need this prob...

 We are seeking a highly skilled and experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I'm searching for a developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data secur...