Database Programming Jobs

I need a secure, internal database for my company to track medical expert witnesses and their case histories. Key Requirements: - Case history tracking: Document and retrieve details on cases each expert has worked on. - Access restricted to company employees. Ideal Skills and Experience: - Database design and development - Experience with secure access controls - Familiarity with case management systems

I need a custom database solution to manage sales data and customer contact details. This database should be able to generate one-page reports and spreadsheets tailored to my needs, which I will send to my clients weekly. Key Requirements: - Manage and store large amounts of sales data - Handle customer contact details - Generate customizable one-page reports and spreadsheets - Allow multiple users on the database entering and researching at the same time - Able to create PDF, Excel, Label custom reports Ideal Skills and Experience: - Experience in database design and management - Proficiency in report generation and data visualization - Strong understanding of sales data and customer information handling - Ability to create user-friendly interfaces for easy data access and report genera...

I have an existing SQL database that needs regular, accurate data entry and ongoing management. The core of the work is keeping every record current, validating each new entry against our existing tables, and running simple queries to confirm that key fields stay consistent over time. You will receive raw data files (mostly CSV) on a scheduled basis. I’ll expect you to import them, reconcile any duplicates, flag inconsistencies, and confirm successful inserts. Familiarity with basic normalization rules, foreign-key constraints, and indexing is important because I want the tables to remain fast and reliable as they grow. Deliverables: • Cleaned, imported data sets fully integrated into the SQL database • A brief log of changes, issues found, and resolutions for each ba...

I want a sleek, self-refreshing Power BI dashboard that pulls customer counts from two sources—an Excel file and our Databricks environment—and visualises the 12-month trend for each line of business across Brand A, Brand B and Brand C. The core visual should be clean line charts with a rolling monthly view, allowing users to toggle brands or drill down by product line without losing the last-year perspective. You will work with my existing Databricks SQL endpoint (I’ll share the cluster URL and credentials) and a locally stored Excel workbook. I need the model set up so both sources refresh automatically through the Power BI gateway and any new month appended to either source rolls straight into the visuals. Deliverables • A .pbix file containing the data model, r...

I need a clean, well-documented Python script that connects to my existing MySQL database and inserts new records reliably. The script should: • Establish a secure connection to my MySQL instance (local credentials or .env file—your call as long as passwords stay out of the code). • Accept data passed in as variables, JSON, or a small CSV—whichever is easiest to parameterise—then build the corresponding INSERT statements. • Handle common edge cases gracefully (duplicate keys, NULL values, connection drops) and log any failed rows for review. • Be easy for me to run from the command line or drop into a larger workflow later. Please write with standard libraries plus mysql-connector-python or PyMySQL; SQLAlchemy is fine if you prefer. Include a b...

Developer Brief Build a secure, cloud-based sports performance data platform that consolidates data from multiple technology providers into one dashboard. This is an example dashboard I have built The initial scope is to integrate Catapult Sports, VALD, and Teamworks. The platform must support both API-based data ingestion and manual or automated uploads of Excel/CSV files. API connections should retrieve approved data on a scheduled basis, while spreadsheet imports should validate, map, and standardise fields before storage. Create a central database with a consistent athlete profile and identifiers, enabling data to be matched across systems. Athlete matching should prioritise unique IDs and verified email addresses, with an administrator review process for unmatched or duplicate rec...

I have a matchmaking service I want to launch, It has a Tally questionnaire which needs to connect to Airtable Make, and Stripe. I have the code already in Javascript and just need someone to deploy so I can test and mov forward. Would suit a junior no coder automation specialist, no dev required. Thanks, Jo Key Requirements: - Database management setup in Airtable - Integration of Tally, Make, and Stripe into Airtable - Deployment scripts and tools provided Ideal Skills: - Proficiency in Airtable, Tally, Make, and Stripe - Experience with database management and tool integration - Strong scripting skills for deployment automation Looking for a freelancer who can efficiently set up and integrate these tools within my Airtable environment. Details: Records/tables to create or update...

CORE-103 Data & SQL Foundations. 10 topics. Almost every system these students build or support will store its data in a relational database, and almost every serious production incident involves one. From what a database is for through querying, joins and aggregation to schema design, transactions and indexing. Real time goes to reconciliation - checking that a query returned the RIGHT answer rather than a plausible one - because a wrong number delivered confidently is worse than no number at all. Note: this course shares ground with DB-101, the Databases track foundation, at a much shallower depth. You will be asked to coordinate with that trainer so the two reinforce rather than repeat each other. THE 10 TOPICS — FIXED 1. What a database is for (6 h) - persistence, con...

I have a dataset that must be loaded into our online database without errors and, at the same time, I want the source text that accompanies each record rendered in both Spanish and simplified Chinese. All source material is in English and arrives as clean text files; your job is to: • Populate every field in the database exactly as specified in the schema I will share (SQL-based back-end with a web form for input). • Translate the English content into Spanish and Chinese before the final save, keeping sentence structure natural and industry terminology consistent. I will give you step-by-step screencasts on how to access the system, a glossary of preferred terms, and a small test batch so we can confirm quality. I expect native-level accuracy in both languages, correct char...