Database Programming Jobs

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational sk...

I require a proficient database administrator to import large XML file dumps (3gb, 20gb, and potentially larger sizes) into a MySQL database. The purpose of this task is database migration. The task will involve: - Handling entire data of moderately complex XML files, including several nested tags. - Ensuring the conversion captures all data comprehensively and accurately for smooth database operation. Ideal Skills and Experience: - Strong proficiency in MySQL and XML - Robust experience with database migration - Background in handling complex file structures - Demonstrated ability to manage large datasets.

As an individual, I'm looking to develop a medical app called "MedCheck". This application must be specialized in medical records management. Key Functionality: - The essential functionality of this app is to manage medical records. A well-structured, user-friendly interface is key for easy input and retrieval of data. Security Requirements: - The app must have session timeout feature to ensure data security. The inclusion of this mechanism is critical as it will automatically sign out the user after a specified idle time, preventing unauthorized access. Ideal Candidate: - Candidates should ideally have experience in medical app development and a clear understanding of HIPAA regulations. - A strong background in implementing security measures, especially session timeout...

We are looking for a skilled database architect to design and manage the database architecture of our social media platform . The ideal candidate will have a deep understanding of database management systems and data modeling techniques. Feature in application : 1. User details 2. Upload a video feature like shorts and reels 3. Post a content like Linkedin 4. There are different types of video's category 5. Likes, comments, share 6. Other features Relevant skills for this role include: - Proficiency in database management systems in PostgreSQL - Expertise in data modeling and schema design - Strong understanding of database optimization techniques - Hands-on experience with SQL queries and performance tuning - Knowledge of database security best practices - Excellent problem-solvi...

I require a competent freelancer with experience in creating management systems to develop an automated spreadsheet for my insurance business. It will encompass the management of multiple insurance policy types including, but not limited to life, health, motor, travel and term insurances. Key Requirements: - Accurate tracking of policy details: This will span essential areas such as policyholder's name, policy start & end dates, insurance company details, premium amounts, policy type and number, beneficiary information, registration number, contact numbers, email IDs, premium collected, next expiry and other insurance related parameters. - A fully functional dashboard: Capabilities include report generation, tracking of premium payments, calculation of policy expiry dates, disp...

I am in search of a skilled developer with expertise in both MsSQL and ADF to assist me in achieving the following project goals: - Database Management: Your primary responsibility will be to manage our MsSQL database. This includes designing the database and ensuring smooth data storage and retrieval operations. - Data Integration: A crucial aspect of this project would be integrating MsSQL with various other systems and databases, mainly focusing on MsSQL itself. This will involve ensuring seamless data flow between these systems. Key Skills and Experience: - Proven experience in MsSQL database management. - Strong capabilities in database design and data storage and retrieval. - Adept at data integration, specifically integrating MsSQL with other systems. - Familiarity with ADF (Azur...

I am in search of a skilled backend developer with proficiency in Python, for a project that necessitates a relational database system for user authentication and authorization. Key Requirements: - Proficiency in Python: The project is built on Python, so the ideal candidate should have a strong command of this language. - Experience with Relational Databases: I am looking for someone with a background in working with relational database systems such as MySQL or PostgreSQL. - Security Conscious: Given the focus on user authentication and authorization, a strong understanding of security principles and best practices is essential. Additional Skills (preferred but not mandatory): - Experience with NoSQL or Cloud-based databases could be a plus, as these might be integrated into the project...

I'm in need of a talented developer proficient in VB6 application conversion to both iOS and Android platforms. The main task will involve modernizing a data analysis VB6 application, bringing it to a mobile platform while preserving its core functions and unique aspects. Key tasks: - Convert VB6 application to a hybrid mobile app for both iOS and Android. - Please make an educated suggestion about what should be preserved since I didn't indicate specific features from the original VB6 app. - The application's primary purpose is data analysis, which needs to shine in the mobile version. Ideal skills: - Proficient in VB6 and mobile app development. - Good understanding of data analysis applications. - Nice to have: a portfolio of similar completed projects.

Project Title: MongoDB Aggregation Performance Optimization Project Description: We are experiencing significant delays with a MongoDB aggregation pipeline in our application. The specific controller takes about 36 seconds to complete when a user has a large amount of chat data in the database. We need a MongoDB expert to review and optimize the aggregation pipeline for improved performance. Details: Our application is built using Node.js with Mongoose as the ODM for MongoDB. The current issue arises when retrieving a user's chat list. The aggregation pipeline fetches chat messages for a given user, including related user information and performs various operations like sorting, grouping, and filtering based on certain criteria. Current Function: Here’s the function that h...

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored Approach:** Each lesson ...

I'm seeking a professional to set up Oracle DR using the Data Guard feature, focusing particularly on Disaster Recovery. My database runs on Oracle 19c and carries a data size of over 500GB, hence the need for expertise in handling large databases is imperative. Key Skills and Experience: - Proficient with Oracle 19c - Competent with Oracle Data Guard technology - Previous experience handling large database sizes over 500GB - Excellent understanding of disaster recovery strategies Task Expectations: - Set up Oracle Data Guard to enhance disaster recovery - Ensure effective management of our large scale database - Provide advice on best practices for utilisation and maintenance post-setup. Only freelancers with proven track records in similar tasks should apply. This task requires...

I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore excellent comm...

I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must choose Scenario 10. If...

I'm looking for a proficient Python coder who can develop a program that effectively reads numerous reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related projec...

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.

Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collabor...

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.

I am seeking a database expert who can successfully migrate mixed structured and unstructured product data from Oracle to SQL. This project requires a comprehensive understanding of database architecture, data migration best practices, and extensive knowledge of Oracle and SQL. Key Tasks: - Analyze and understand the structure of existing Oracle database - Prepare a thorough plan for data migration ensuring minimal downtime - Coherently migrate mixed structured and unstructured product data to SQL Ideal Skills and Experience: - Previous experience with Oracle to SQL data migration - Understanding of both structured and unstructured data - Deep knowledge of database architecture and design - Ability to troubleshoot any issues that arise during migration - Excellent attention to detail a...

I'm looking for a skilled developer who can create a Springboot application that connects to our Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced wi...

I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help

I am in need of a skilled professional to develop software. We have all barcodes in EAN formats in excel (14-15 digits format) Everyday we sell products online. We would like to be able to find a certain barcode on a shelf as we have many EANS on the same shelf. We have bought a wireless handheld scanner. So we would like to be able to transfer those eans (EAN ) to use this wireless scanner to find a certain product on shelf. Or maybe not transfer but to export some batch of eans everyday in order to find them faster everyday ob the shelf.

Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering of info...

I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.

I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server maintenance would be required. I am only looking for professionals who h...

As an experienced PL/SQL user, I am looking to collaborate with a seasoned developer to help further scale my project. The role primarily involves: - Building novel PL/SQL procedures - Innovative database architecture and design You would be perfect for this job if you can demonstrate: - Extensive background in PL/SQL - Expertise in database architecture - Experience in crafting innovative procedures The tasks will encompass: - Data manipulation - inserting, updating, and deleting data - Data retrieval using the 'select' function - Implementation of integrated business logic I am excited to see how we could improve database structure and efficiency together.

Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.

I'm in need of an experienced SQL professional to assist me with data warehouse. The ideal candidate is someone who has: - Proven experience in designing data warehouses - Advanced SQL skills - Excellent understanding of data volumes and the implications for data warehousing If you are interested in this project, please provide details of your experience in similar projects. Thank you.

I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

Build a PMS property management software, in conjunction with an ERP and CRM. Improvement and structure in the organization: productivity, communication, occupation and positioning. Divide it according to the areas of work (Management, Administration, Channels, Properties -follow-ups, active contracts, owners-, Communication and Maintenance (cleaning, deliveries). Examples of user experience design references (interface layout, navigation, usability, accessibility, and aesthetics): Hubspot, Idealista, Asana, Airbnb. – simple, intuitive, comfortable- Web app and mobile app (IOS and Android)

I am seeking a mobile app developer to help me upload my code on my google app engine. I am unable to update or edit certain code segments. Need some to fix this for me asap. The code is already deployed there just need help in updating and editing it. I will provide the code.

I am seeking a talented developer who specializes in BioTime database development. The database will primarily be used as an attendance system for my staff. Key Functionalities: - Data Entry and Retrieval: You will implement mechanisms to input and retrieve staff attendance records. Data to be Managed: - Staff Attendance Records: The system should capture and store staff's check-in times, check-out times, and leave entries. Ideal Skills and Experience: - Proficiency in working with BioTime databases. - Demonstrable experience in building data entry and retrieval functionalities. - Prior projects dealing with attendance systems or related fields will be a significant plus.

I have a small FileMaker Pro 12 database that requires a conversion to an SQL-based database. The structure is to largely remain the same, but there are some minor issues that need rectification. Details: - The conversion task requires no major changes to the original data structure. - However, some calculation errors need fixing. Therefore, you'll need a keen eye for identifying and rectifying them. Skills & Experience Required: - Experience with FileMaker Pro 12 and SQL databases. - Understanding of database structures and functionalities. - Ability to identify and correct calculation errors. - Great attention to detail. Please ensure that during the conversion process, no data is lost, and the end product works seamlessly. The bid proposal should reflect your understandi...