Database Programming Jobs

Years ago (Office 2013) we developed a customized Access DB which we had hired a programmer to customize with links to Outlook to sync contact information from one to the other. We upgraded to Office 2019 a few years back and need the links reestablished. We also need to have some reports repaired, and ongoing updates / maintenance provided. A confidentiality agreement will be required of the person chosen.

I am looking for a skilled freelancer to help me with coding a large Excel sheet. The specific functions and calculations are simple (averages, rank, sum) however there are numerous steps and involves a large data set. I have a specific layout in mind. However, given the large data set, it may be better to run the calculations in Python or the like. Data Complexity: - The data that will be inputted into the Excel sheet is of moderate complexity, including dates and formulas.

I am looking for a freelancer who can help me automate the search in a large number of PDFs and categorize the output keyword information for data analysis purposes. Requirements: - Experience in scripting and automation - Strong knowledge of PDF processing - Proficiency in extracting and categorizing keywords - Ability to work with large datasets The project involves processing approximately 120 million PDFs and extracting keywords from them. The extracted information should be organized and categorized into a CSV file for further analysis. If you have the necessary skills and experience, please bid on this project.

I am in need of a skilled database coder who has experience with MySQL. I have specific tasks in mind for this database and I require the project to be completed within a week. Skills and Experience: - Proficient in MySQL database coding - Strong understanding of database design and optimization - Experience in creating and modifying database tables, queries, and stored procedures - Knowledge of data migration and integration - Ability to troubleshoot and resolve database issues - Familiarity with security and data privacy principles in database management Tasks: - Design and implement a MySQL database based on specified requirements - Create and modify tables, queries, and stored procedures to meet project needs - Perform data migration and integration tasks as necessary - Optimize dat...

I am looking for a freelancer who can help me convert a large Excel file (more than 5MB) into an Access database. Presently the file is used as an invoicing system to generate invoices and save information. This is it's primary function. There is additional recording with each invoice showing manufacturing details. Requirements: - The data should be updated in both Excel and Access after conversion. - I need the Access database to have reporting and analysis features. -The file has a few macros which are used to generate PDF invoices and save them to a folder. -I want to ensure I can see the information and use filters in the same way as I can in excel - so we don't need a special form to display the data. Ideal skills and experience: - Strong knowledge and experience in Ex...

I am seeking a SQL query expert with experience in MySQL for assistance with an advanced level database design project. There are 4 tasks in total. You can solve them in any order. There's no option to pause. Make sure you will not be interrupted for 135 minutes. Your solution(s) should consider all possible corner cases and handle large input efficiently. If you accidentally close your browser, use the invitation link to get back to your test. Assessment and hiring policies: For testing purposes, we'd consider using copied code, code from opensource websites, Generative AI (GAI) responses, or anything but your own code, as not meeting the requirements of this test. We are hoping to see how you create your own code, and your unique approach to the challenges set. Responses tha...

I have a Powerbuilder application where I need to print data from my database into an employee ID card both front and back. I need help to achieve this. I'm using Powerbuilder 12.6 and SQL Anywhere 16.

Database for Small Business Inventory Management - Preferred Database System: Open to either SQL or NoSQL - Primary Purpose: Inventory Management - Anticipated Data Storage: Less than 1GB Skills and Experience: - Proficiency in SQL and/or NoSQL database systems - Experience in designing and implementing database solutions for inventory management - Knowledge of data storage optimization techniques for small-scale databases - Familiarity with data backup and recovery procedures - Understanding of data security measures for protecting sensitive business information Business logic description: Preparation of Shelves and Racks Labeling of Shelves and Racks: Create unique barcodes for each shelf and rack. This will allow for quick identification of the location of each item. Coding System:...

Offline Library Database I am looking for a freelancer to create an offline library database for a public library. The ideal candidate should have experience in creating databases using MySQL. Requirements: - Create a database management system using MySQL - The database should be able to hold less than 1,000 books/items - Design a user-friendly interface for easy navigation and searching within the database - Implement a system for organizing and categorizing books/items - Allow for adding, editing, and deleting book/item records - Include features for tracking book/item availability and borrowing history Skills and Experience: - Proficiency in MySQL and database management - Knowledge of library systems and book/item organization - Experience in designing user-friendly interfaces - At...

I am looking for a freelancer to develop a platform that combines training, project management, and a database using Odoo. Specific features required for this project include: Training Platform: - Interactive quizzes to engage and assess learners Project Management Component: - Reporting tools to track project progress and generate insightful reports Database Component: - Data analysis capabilities to analyze and extract valuable insights from stored data Ideal skills and experience for this job: - Proficiency in Odoo development - Experience in developing training platforms with interactive quizzes - Strong understanding of project management principles and tools - Expertise in database management and data analysis Please provide examples of relevant work in your proposal.

I am looking for a freelancer who can assist me with database design using ERD and SQL. Purpose: - The main purpose of this project is database design. Specific Entities and Relationships: - I have a detailed list of specific entities and relationships that must be included in the ERD. Scale: - The scale of the database is small, with less than 50 records. Ideal Skills and Experience: - Strong knowledge and experience in ERD and SQL - Proficiency in database design - Attention to detail in following specific requirements - Ability to handle small-scale databases efficiently

Project Goals and Purpose: to develop a paperless solution that will streamline workflows between the office and the field, as well as to make the external and internal environmental audit process painless, by organizing documents and automating audit work papers. Overall. The solution will optimize the environmental audit processes to digitally transform the organization’s system. Thus, providing access to compliance and safety inspections, and improved efficiency of field-team among others. Project Outputs and Indicators: I. Customizable Checklist that can adapt to the organization’s/projects’ audit type; II. Automatic Scheduling which will handle scheduling scenarios; III. Designs for Mobile, to allow for audit performance from any mobile device; IV. Accountability fo...

I am looking for a web developer to create an E-commerce website with user registration and login functionality. Skills and Experience Required: - Strong experience in E-commerce website development - Proficiency in HTML, CSS, and JavaScript - Knowledge of user authentication and security measures - Familiarity with database management and integration - Ability to create a responsive and visually appealing design - Understanding of SEO best practices for E-commerce websites Key Requirements: - Develop a user-friendly and intuitive E-commerce website - Implement user registration and login functionality - Ensure secure data storage and protection - Optimize the website for search engines - Integrate payment gateway for smooth transactions If you have prior experience in building E-comme...

Largest Excel database you most likely have seen: 1. 10 millions indivdual records with 6 fields 2. Each file represents the 50 USA States 3. Some files (States) may have 500 records 4. Some States may have 1 million records 5. Need to export each State (50) into individual (50) Excel reports 6. Evaluate each State (50) records to determine how data may be extracted into Excel 7. After evaluating the Excel Data recommend Data export options for searching ease Successful appiicant(s) will review Excel Data via a DropBox connection.

Project Title: O365 SQL DBA I am seeking assistance with database administration tasks as an O365 SQL DBA. Specifically, I need help with the following: - Database administration - Performance tuning - Backup and recovery I require this service on a regular basis and my expected timeline for this project is within 1 year. Ideal skills and experience for the job include: - Strong knowledge and experience in O365 SQL DBA - Proficiency in database administration, performance tuning, and backup and recovery - Ability to work on a regular basis and meet project deadlines

Job Title: Database Developer with Snowflake and MDM Location: HYD/Remote Duration: Full Time Required Skills: • At least 7plus years of experience in Snowflake development which includes creating Stored Procedures, Tasks, Stages, Views and Tables. • Experience working with SQL Query optimization and Cost optimization of Snowflake resources. • implement security measures to protect sensitive data such as, Role-Based Access (RBAC), Data Encryption and Data Masking. • Proficiency in building ELT/ETL pipelines with focus on Change Data Capture (CDC), History Snapshots, Audit logging and other best practices. • Working experience with any of the ETL tools such Five trans, Informatica, etc., • Perf...

I am actively searching for an experienced freelancer on Oracle APEX Developer with proficiency in Python integration to support my job. I work in PST hours. I joined a job recently and need job support for the same. I will be assigned the work through JIRA's and need to finish these work within the sprint. Responsibilities: APEX Application Development: Design, develop, and maintain Oracle APEX applications tailored to meet client requirements. Python Integration: Seamlessly integrate Python components, scripts, and libraries into Oracle APEX applications to enhance functionality. Database Integration: Integrate APEX applications with Oracle databases, ensuring a cohesive and efficient connection between front-end and back-end systems. Customization and Enhancement: Customize ...

I have some frm and ibd files on my computer for a MYSQL database. I need to make a SQL file of certain tables or the whole database - and i need help with it it must be done via anydesk or help me via chat as i cannot give u the database files

Note: This is a short deadline project. Only experts who can finish in 1 day respond. Others plz ignore I am looking for a skilled SQL developer who can create complex SQL queries to generate reports and dashboards on Databox. Database: SQL Server Report Format and Data Points: - I have specific requirements for the report format and the data points that need to be included. Deadline: - The deadline for this project is 1 day. Skills and Experience: - Strong SQL skills and experience in creating complex queries - Knowledge of Databox and its reporting capabilities - Ability to understand and interpret specific report requirements - Attention to detail to ensure accurate and reliable reports - Ability to work quickly and efficiently to meet the tight deadline

Note: This is short deadline project which has to be completed in a day. Freelancer who quote more than 1 day plz stay away. I am looking for a skilled freelancer who can write multiple complex SQL queries on Databox to generate dashboards. The purpose of the dashboard is to analyze sales data, track website traffic, and monitor customer behavior. Specific metrics or data points that should be included in the dashboard will be provided by me. Although there are no specific SQL functions or commands required, I can provide guidance on the desired outcome. Ideal skills and experience for this job include: - Proficiency in SQL and Databox - Strong analytical and data visualization skills - Ability to understand and interpret business requirements - Attention to detail and the abilit...

Hello, i would like to hire a database administration but needs ti prepare for some exams before Please contact mee!!

Seeking an expert developer to create a dynamic medical research networking platform. The ideal candidate should have experience in PHP programming language and be able to implement collaboration and communication tools. Additionally, proficiency in MySQL for the backend is preferred. Key requirements for the platform include: - User Profiles: Allow users to create and manage their profiles, including personal information and research interests. - Collaboration/Communication Tools: Implement features such as messaging, forums, and file sharing to facilitate collaboration among researchers. - Data Analysis Tools: Develop tools for analyzing and visualizing research data, including statistical analysis and data visualization. Skills and experience required: - Proficiency in PHP pro...

Project Description: E-Service Development I am looking to develop a recommendation system for courses within a month. I have some ideas for specific features and functionalities, but I am open to suggestions. Ideal Skills and Experience: - Strong knowledge and experience in e-service development - Proficiency in developing recommendation systems - Familiarity with course management systems - Ability to understand and implement client requirements - Creative thinking and problem-solving skills - Excellent communication and collaboration abilities

I am looking for a Stimulsoft expert to help me with designing reports. Skills and experience needed: - Proficient in using Stimulsoft for designing reports - Knowledge of data visualization techniques and best practices - Ability to create visually appealing and user-friendly reports The client does not have a preferred data visualization style or format, so the expert will have the freedom to suggest and implement the most suitable style for the project. The client does not have a strict deadline for the completion of the task, providing flexibility for the expert to work at their own pace.

Project Title: Bank Account Handling Project Tasks: - Balance reconciliation - Transaction categorization - Account statement generation -saving details in database Maintenance: - This is a one-time task, no ongoing maintenance required. Preferred Communication Method: - In-app messaging Ideal Skills and Experience: I am seeking an individual to develop a "bank account handling project" for my college using Java, and they can utilize Spring Boot. The project should be kept basic in scope. The deadline for completion is December 8, 2023. If interested, please provide details on your Java and Spring Boot proficiency. - Knowledge of transaction categorization methods - Ability to generate account statements efficiently

Project Details: We are looking to find a way to match extracted data from a document to certain specific fields in our own system. For example, a data extracted from a document can be [Customer Name: Company ABC PVT LTD], but in our system the field may be called [Client Name]. We want the LLM to help match Customer name and Client name, so that the data gets filled into the field in our system. I am looking for a long term freelancer with database development, LLM and AI experience to help us achieve highly accurate results using 2 specific LLM models (OpenAI and vertex, but we are still open to others) Specific requirements for the project include: - Experience with LLM models, particularly the specified model - Strong understanding of programming languages and development of API...

I am looking to hire a Rust developer to optimize the performance of my near completion Rust project. The project is in its final stages and I need assistance in improving its performance. The ideal candidate should have experience in Rust development and be knowledgeable in performance optimization techniques. The expected timeline for the completion of this task is more than 3 weeks.

Project Title: USA, Australia customer database I am looking for someone to help me create a customer database for the USA and Australia. The database should focus on customer purchase history and be specific to a particular industry. The main purpose of this database is for sales and marketing purposes. Skills and Experience: - Proficiency in data collection and analysis - Knowledge of customer segmentation and targeting - Strong understanding of sales and marketing strategies - Familiarity with the specific industry chosen for the database

Pervasive PSQL database has crashed and I need a DBA to import a table into Pervasive and export data to .xlsx DBA must use their own software as the PSQL is no more available to us

I need to develop a software can check the correct closing line odds of the bookmaker. The online sports gambling industry employs teams of data analysts to build forecast models that turn the odds at sports games in their favour. While several betting strategies have been proposed to beat bookmakers, from expert prediction models and arbitrage strategies to odds bias exploitation, their returns have been inconsistent and it remains to be shown that a betting strategy can outperform the online sports betting market. We designed a strategy to beat football bookmakers with their own numbers. What I need its have a software can detetect the correct odds and here I attach the info to make this project:

I am looking for a skilled Database Administrator to assist me with creating a new PostgreSQL database for my medium-sized ongoing project. The ideal candidate should have experience in database creation and management, specifically with PostgreSQL. Skills and Experience: - Proficient in PostgreSQL database administration - Experience in creating and managing databases for medium-sized ongoing projects - Knowledge of SQL and database design principles - Strong problem-solving and troubleshooting skills - Ability to optimize database performance and ensure data integrity - Familiarity with relevant database tools and technologies - Excellent communication and collaboration skills Responsibilities: - Collaborate with project stakeholders to understand database requirements - Design and cr...

I am looking for a freelancer who can assist me in preparing a solution design and writing procedures in Oracle SQL database. I already have an established database structure, but I need help with queries and procedures. The level of complexity for the queries and procedures is intermediate. Ideal Skills and Experience: - Strong proficiency in Oracle SQL database - Experience in designing and implementing queries and procedures - Knowledge of intermediate level SQL concepts and techniques - Familiarity with Oracle database structure and best practices

I require a landing page system capable of generating pages from a database. 1. I will furnish the wireframe for the design of the landing page. The page design remains constant, and the page data varies based on the database line item. 2. Each page should be able to have its own domain - multisite can be utilized if necessary. 3. The wireframe sections will include an image scroller, title section, text section, video section, text section, map section, and footer. The data for these sections will be sourced from the database. I will provide the form link for the form integration on the page.

1. Website with all the necessary details for patients and doctors 2. Patient: login/signup , create profile, find doctor, book appointment as a patient and make payment, rate the doctor with comment post treatment, see- treatment history, prescriptions or other documents, send receive messages or calls to doctors 3. Doctor: login/signup , create profile, add patients, manage patients, add treatments done for the patient, create order, create and share invoice for the treatments provided, send payment link or QR code in the invoice, set up time in the future when patient should get automated reminder by SMS/WhatsApp/email, create automated reminder message, pre filled prescription templates which can be pushed as WhatsApp/email or message in the chat box to the patient, excel upload of p...

Necesitamos hacer unos cambios en un diagrama de flujo en MYSQL serven necesitamos que sepa hacer gráfico y también sepa hacer tablas quedo atento para comenzar de inmediato es un trabajo urgente que para un experto no sea mucha complejidad el tiempo de entrega es para hoy el presupuesto es de 17 dolares

Necesitamos hacer unos cambios en un diagrama de flujo en MYSQL serven necesitamos que sepa hacer gráfico y también sepa hacer tablas quedo atento para comenzar de inmediato es un trabajo urgente que para un experto no sea mucha complejidad el tiempo de entrega es para hoy el presupuesto es de 17 dolares

Write SQL statements (MySQL/MariaDB SQL) to: Create a relational database named ‘GourmetHub’ using MySQL/MariaDB SQL (write also the statement to use it). Create the following table: RESTAURANT (CODE, name, location) with the following restrictions: CODE is the primary key. It is an alphanumeric code designating each unique restaurant. The code can have 1 to 5 characters. NAME is an alphanumeric sequence, it is required, and it is unique. LOCATION is an alphanumeric sequence, indicating the address or area of the restaurant, and it is required. Create the following table: DISHES (CODE, name, type, price) with the following restrictions: CODE is the primary key. It is a four-character alphanumeric code designating each unique dish. NAME is an alphanumeric sequence, it is requir...