データベース管理 Jobs

I need a MySQL database dump sql hosted on AWS for backup and restore purposes. Key Requirements: - Expertise in AWS and MySQL - Set up MySQL without automated backups

- Designed automated ETL routines to standardize disparate source formats, reducing manual reconciliation time by 40%. Performed root‑cause analysis and cohort studies to identify process bottlenecks and cost drivers. Built enterprise dashboards with row‑level security, incremental refresh, and performance tuning; improved executive visibility into KPIs. Implemented and supported ERP reporting modules, mapped master data across modules, and led data migration and validation during upgrades. - Established validation rules, lineage documentation, and data quality KPIs to maintain trust in analytics. - Replaced manual spreadsheets with parameterized Power BI reports and scheduled dataflows, saving recurring effort and reducing errors. - Performance Metrics: Delivered dashboards that improved...

I'm seeking a consultant based in Johannesburg South Africa, with strong experience in Power BI, Power Automate, and knowledge of Syspro for a 6-month engagement. The goal is to build tables and dashboards and automate some of our internal workflows. Key Responsibilities: - Building tables and dashboards in Power BI - Automating internal workflows using Power Automate - Connecting to SQL databases and Excel spreadsheets as data sources - Ensuring that both management and operational teams can effectively use the outputs Ideal Skills and Experience: - Strong expertise in Power BI and Power Automate - Proficiency in SQL and Excel - Familiarity with Syspro - Experience in creating user-friendly dashboards for management and operational teams Please provide examples of similar projects...

I need to migrate to OVHcloud in Quebec. The primary goal for this move is better data locality and compliance. Key Requirements: - Expertise in Odoo and OVHcloud - Experience with data compliance regulations - Strong migration planning and execution skills Ideal Skills: - Cloud migration experience - Knowledge of data locality requirements - Familiarity with OVHcloud services and architecture Please provide a detailed plan and past experience with similar projects.

Our Magento 2 store suddenly refuses to complete the Product Price reindex and shows the familiar “no linked stock” message. Nothing was updated, no extensions were added, and I haven’t tried any quick-fix SQL scripts or CLI commands yet, so you’ll be starting with a clean slate. I’m looking for someone who has already wrestled with this specific indexing glitch and can get the catalog back to a fully reindexed state without disrupting live traffic. Acceptance criteria / deliverables: • Identify the root cause of the “product price index – no linked stock” error and document it briefly. • Apply the corrective fix (database clean-up, configuration adjustment, or code patch) on our staging site, demonstrate a successful bin/magent...

Need existing database of European countries which u scrapped earlier

Need help writing a 3-line script in Oracle 4GL based on pseudo logic related to VEE rules and VEE group. The deliverable is the script only, as testing and documentation will be handled separately.

We are looking for a contract Data Engineer with hands-on experience in Microsoft Fabric to support pipeline development and data movement activities. You will help me: 1) Develop and manage data pipelines using Microsoft Fabric 2) Perform data loading and data migration activities 3) Ensure reliable and efficient data flow across systems Required Skills: 1) Strong experience with Microsoft Fabric 2) Proven experience in pipeline development 3) Hands-on exposure to data loading and data migration projects

I already have the complete source code for a Python / Django project that is intended to run on a web platform. What’s left is the production-ready deployment. The task is straightforward: set up a reliable hosting environment, configure the required services (virtualenv, database, static and media file handling, SSL, and process manager), then push the code so the site is publicly accessible under my domain. I’m currently undecided on whether to use Apache, Nginx, or another stack; feel free to recommend what you know will keep things stable and easy to maintain. Please make sure that: • The application starts without errors via the chosen server stack. • Migrations, static file collection, and environment variables are handled cleanly. • A short read-m...

********LARAVEL ONLY, THIS IS AN ADDITIONAL FEATURE BEING ADDED TO AN EXISTING SITE********* Project Proposal: Dynamic Staffing & Scheduling Integration Project Overview This project introduces a synchronized scheduling ecosystem designed to bridge the gap between Employer demand and Employee availability. The system allows Employers to generate multiple unique shift slots from a single requirement, provides real-time hour/budget calculations, and offers Employees a targeted marketplace to claim shifts that match their credentials. Part 1: The Milestone Roadmap Milestone 1: Facility & Staff Demand Architecture -Employer Dashboard: Implementation of the core SCHEDULE tab. -Facility Management: Capability to create and store multiple Facilities (e.g., "Atlantis Scan Center&qu...

I need about three hours of guided, screen-shared help moving product data that currently lives in several related Excel sheets straight into my PostgreSQL database. No transformations are required—just a clean import exactly as the data sits now. During the session we will • create or confirm the target tables and column types, • choose the quickest import method (COPY commands, pgAdmin’s import wizard, or any tool you prefer), • load every sheet accurately, and • finish by writing a few SQL queries to verify row counts, join related tables, and pull sample SKU-level results. Deliverables for me at the end of the call will be: • a working, repeatable import script or step-by-step notes; • the example SELECT queries we ran together; a...

Quiero reducir al mínimo los gastos de mi suscripción en Azure sin comprometer rendimiento ni seguridad. Necesito que revises conmigo, paso a paso y en tiempo real, toda la configuración de: • Máquinas virtuales • SQL Database/Managed Instance • Servicios relacionados (storage, networking, backups, etc.) Trabajaremos mediante sesiones interactivas en TeamViewer, AnyDesk y Microsoft Teams con audio. No se permite el uso de chats de IA para elaborar respuestas; la comunicación debe ser directa y durante la sesión. Flujo esperado: 1. Auditoría inicial: identificas consumos elevados, licenciamiento inapropiado y recursos infrautilizados. 2. Propuesta inmediata de cambios (tamaño, auto-shutdown, reservas, elastic ...

It is my college final year project Basis. This project focuses on the design and implementation of a distributed NoSQL database system capable of handling large-scale, dynamic data with high availability, scalability, and strong consistency. The system uses dynamic sharding to automatically partition and distribute data across multiple nodes based on data growth and access patterns. It incorporates replication and consistency mechanisms such as quorum-based replication or distributed consensus protocols to ensure data integrity even during node failures or network partitions. The project aims to balance the scalability and flexibility of NoSQL systems with the consistency guarantees of traditional databases. Performance, scalability, and consistency are evaluated under different worklo...

I’m looking for a reliable way to mirror my on-premise SQL database to AWS RDS in real time. The web service you build will capture every change that hits the local tables—customer information, inventory data, and transaction records—then push those changes up to the cloud with minimal latency. My priorities are: • Zero data loss and consistent state between the two stores, even when connectivity drops temporarily. • Latency low enough to feel immediate to downstream apps that rely on the cloud copy. • A straightforward deployment path: I should be able to install the service on a Windows or Linux host beside the local database, point it at the RDS instance, and watch it run. Deliverables 1. Source code for the sync service (language and framewor...

Project Title MS Access CRM + Quoting + Line-Level Costing + Production Workflow (multi-user ready, split DB planned) Goal Build a complete Microsoft Access application from zero that manages: Leads → Customers → Projects → Quotes → QuoteLines (each line can have its own version v1/v2…) Line-level costing and part-level breakdown Approvals, revisions, release to production Production machine lists and phase tracking Task management for all roles Document/file linking with a standardized folder structure Reports (Quote PDF, Production Pack PDF, KPIs) Role-based login + menu + permissions Designed to be split (FE/BE) for multiple concurrent users. 1) Data Model (developer must create all tables + relationships) 1.1 Master tables Users UserID (PK, Aut...

I'm seeking a meticulous researcher/data analyst for contract work. Your primary responsibility will be validating data generated through automations to ensure its accuracy. Daily tasks will include: - Understanding the requirement for accurate data in all of our automations - Setting up tables in Airtable that connect to automation in various 3rd Party apps via APIs - Ensuring contacts are appropriate and company information is correct and up-to-date. - Proposing alternative methods to search for and validate data. This role offers growth opportunities into a more strategic position for the right candidate, with time and training to gain a full understanding of the process. Ideal skills and experience: - Experience with databases, online research, and third-party APIs - Strong a...

I need an experienced SQL professional who can take customer data sitting on a remote SQL Server and refresh the corresponding tables on our in-house server every day. The transfer must be reliable, consistent, and handled through SQL Server Management Studio (SSMS), as that is already part of our workflow and permissions model. Your job will be to analyse the source schema, map it cleanly to our destination tables, set up the daily pull / push routine, and keep concise logs so I can trace each run at a glance. Data consistency checks, graceful error handling, and verification reports are essential because the customer records drive several downstream apps on our side. The engagement is straightforward: configure the process, prove a few consecutive successful runs, document the step...

I need assistance with a MongoDB database on my Linode (Alkali) server. I'm looking to delete the data within the database. Requirements: - Access to my Linode server - Execute commands to clear the database content Ideal Skills and Experience: - Proficient in MongoDB - Experienced with Linode server management - Command over data deletion commands and database handling Please note if backups are required.

Our mission-critical stack—OpenShift, WebLogic, and Oracle DB—relies on Dynatrace, yet the current installation is tangled with mis-tuned parameters and component clashes. Configuration issues (incorrect settings and several compatibility quirks) are disrupting reliable monitoring and even nudging performance in the wrong direction. Here’s what I need: an expert hand to inspect every layer of the existing Dynatrace footprint, untangle the bad configs, and re-establish a clean, fully integrated deployment. That includes verifying the Dynatrace Operator on OpenShift, tightening up WebLogic JVM instrumentation, restoring deep-monitoring hooks for Oracle, and confirming all alerting pipelines fire correctly once we’re done. Deliverables • Complete audit rep...

We are looking for ongoing, reliable in-house IT and administrative support to keep our small but diverse internal environment running smoothly. This is a hands-on role supporting staff and systems day to day. Most of our stack is out-of-the-box software, complemented by custom in-house software and applications that support how we work. The work is varied and practical. One week you might be contributing to a project to improve or streamline existing systems; the next you could be onboarding new staff, troubleshooting a line-of-business application, assisting with configuration issues, or handling general administrative tasks that support the wider team. There is also an element of research and information gathering for internal projects, such as evaluating tools, documenting options,...

I need a relational database system designed and implemented for a small restaurant using PostgreSQL. This database should efficiently manage orders and provide insightful analytics. Key Requirements: - DBMS: PostgreSQL - Track Orders - Store Details: Items ordered Ideal Skills and Experience: - Strong PostgreSQL expertise - Experience in database design and implementation - Knowledge of generating analytical insights from database data The database should help us understand popular menu items, track daily sales, and maintain a comprehensive order history.

I need expert guidance to install a database server on a Windows operating system. Key requirements: - Experience with Windows server environments - Advise and whats required to install Sequoia Server/ sofware. - Ability to provide clear, step-by-step installation instructions and best practices

I need an expert to help me configure billing rates and internal prefixes in my ASTPP installation. Tasks: Import and set up billing rate cards. Configure internal prefixes for specific routing rules. Ensure the billing engine is capturing data correctly. This is a straightforward task for someone who knows ASTPP well. Please bid only if you have worked with ASTPP before and can start immediately.

Our live data sits in a PostgreSQL instance and some key queries are beginning to drag. I need you to step in, profile what is happening, and carry out light-touch changes that immediately tighten up performance while outlining any deeper work we should schedule later. During the engagement you will: • Capture the worst-offending queries, analyse execution plans, and benchmark current response times. • Review the existing schema and indexing strategy, then create or adjust indexes, vacuum/analyze settings, configuration parameters, and any other low-risk tweaks that deliver quick wins. • Produce a concise report that documents every change, the before-and-after metrics, and recommendations for larger refactors I can present to the wider team. All updates must be backwa...

I have an SSIS package that pulls data from an Oracle database through an connection and loads it downstream for ETL processing. The transfer works, but network-level performance is far below what I need. Here is what I’m looking for: • Diagnose the current ADO.NET-to-Oracle connection, identify any network, buffer, or packet-size bottlenecks, and benchmark the baseline throughput. • Tune the SSIS data flow (buffers, rows per batch, commit size, async settings, etc.) and, if necessary, adjust the Oracle driver or provider configuration. • Provide an updated package or detailed change list so I can reproduce the performance gains in other environments. • Produce a concise report summarizing findings, before-and-after metrics, and next-step recommendations....

I am completing a capstone project that must showcase end-to-end work inside Power BI. The source data sits in SQL Server and is modest in size—well under 10 k rows—so performance tuning will centre on clean Query Folding rather than heavy aggregation tricks. Here is what I need done: • Connect Power BI to the SQL Server instance through Power Query, document each step, and keep every transformation foldable. • Shape and load the tables, then model them with the correct many-to-many relationship where required. Please do this in the Model view so the links are visually clear. • Create essential DAX measures—CALCULATE(), RELATED(), and any supporting columns you find helpful—so the model answers typical summary and slice-and-dice questions. &bu...

I want to move beyond day-to-day administration and master the advanced stack of Oracle Database technologies through live online sessions. The trainer I am looking for should be an experienced Oracle DBA who can walk me through real-world scenarios, share best practices drawn from production work, and guide me as I practice each topic in my own lab. The areas I need covered are very specific: Performance Tuning, Backup & Recovery (RMAN), Data Guard, RAC, GoldenGate, ASM, and end-to-end migration, Mock interviews and upgrade strategies. Every concept should be backed by live demonstrations, scripts I can reuse, and practical troubleshooting tips. Because I learn best in an interactive setting, I prefer a schedule of live classes where I can ask questions on the spot and share my scre...

I need the full set of customer-related records lifted from my SQL database and dropped into a single worksheet that follows a template I’ll send you. The database holds tables for customers, payments, customer relations, sales and units. Your job is to write the necessary SQL (views, joins or stored procedures—whatever is most efficient), run it, and populate the template with: • each customer’s name and contact details • their complete purchase history and account status • the matching payment, sales and unit information Everything must end up in one sheet exactly where the template expects it, so column order and data types have to match. Once the file is filled, deliver it back together with the extraction script or query so I can repeat the proce...

Project Title Database Design & SQL Implementation – Content Management System for Movies and Series (Access Control & User Groups) Project Description I am looking for a database developer or DBMS expert to help design and implement a Content Management Database System for managing movies, series, and episodic content with hierarchical user groups and multi-level access control. This project simulates a real-world digital content platform (similar to a streaming service backend) and focuses on ER modeling, relational schema design, and SQL implementation. Scope of Work 1. Database Design Create a complete ER Diagram including: Content (Movies & Series) Series and Episodes Users User Groups (with nested group hierarchy) Access Levels Reviews and Ratings Con...

I’m looking for an experienced Oracle professional who can both teach and advise on PMI-aligned best practices. The engagement covers two fronts: first, delivering clear, hands-on sessions that walk my team through Oracle concepts mapped to the PMI framework; second, helping us design and fine-tune a practical lab so participants can experiment safely with the same features you demonstrate. Dates are flexible and the commercial terms can be shaped around your availability. I’m open to trainers, consultants, or architects—as long as you have a proven record teaching Oracle in a project-management context and can back it up with real-world examples. At the end of our collaboration I expect: • A concise training plan with slide deck or learning material we can r...

We are students seeking a skilled developer to create a small fraud detection extension specifically for Google Chrome. This extension will be focused on detecting fraud or phishing some Saudi government websites. We have a small list to work with as beginner. we are currently in development and testing phase so we have the details already to provide. Key Requirements: - simple and beginner design. - Compatibility with Google Chrome - Real-time detection of phishing scams - User-friendly interface and experience - Detailed reporting and alert system - explaining each steps to help in understanding the project. Ideal Skills and Experience: - Experience in developing browser extensions - Strong knowledge of web security and phishing tactics - Proficient in JavaScript, HTML, and CSS - Pri...

My Joomla 4.x website (running VirtueMart plus a few stock extensions) is still working to MySQL 5 and now needs to have an update onto MySQL 8. The core install is standard—no bespoke hacks or exotic plugins—so the work is mainly about a careful, methodical database upgrade rather than code refactoring. Current safety net Automated backups run nightly, but you still have to take on your absolutely safety work before touching anything. Timeline & tracking I want this wrapped up within by the end the coming week. You must work through Freelancer’s time-tracking app so I can follow progress. What I need from you • Confirm environment compatibility, run a pre-flight check, and flag any hidden MySQL 8 deprecations that might affect Joomla 4 or VirtueMart. ...

Seeking an experienced Oracle SQL developer for monthly work. The ideal candidate should have strong expertise in Oracle SQL development and be available to collaborate effectively. Tasks will be discussed and finalized upon selection.

We are looking for a database developer/compiler who can help us develop and maintain our databases. The ideal candidate will have experience with both SQL and NoSQL databases, and will be able to write efficient and reliable code. They will also be able to work with our team to ensure that our databases are up-to-date and meet our needs.