Administración de bases de datos Jobs

Estoy por arrancar una migración con Informatica PowerCenter y necesito apoyo directo en la construcción de los procesos ETL. El conjunto de datos con el que trabajaremos está en Oracle y lo extraeremos desde una base de datos SQL; el objetivo es una migración limpia, controlada y auditable hacia el nuevo esquema. Qué espero de ti • Diseñar y desarrollar mappings, sesiones y workflows en PowerCenter que cubran todo el flujo de extracción, transformación y carga. • Incluir manejo de errores, validaciones de calidad y registro detallado de eventos. • Documentar cada mapping en el repositorio y entregar un pequeño manual de despliegue/rollback. Aceptaremos el trabajo cuando: - Todos los procesos se ejecu...

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 ...

I need a clean, up-to-date installation of the open-source ERPNext suite deployed on my existing shared-hosting account. At the moment I’m not even sure whether the host is running cPanel, Plesk, or DirectAdmin, so the first step will be to look at the control-panel details with me and confirm the environment. Once we know the panel you can decide whether the built-in tools are enough or if we should work over SSH to set up the full Frappe bench stack (Python, MariaDB, Redis, Nginx, etc.). For this first phase I am only after the standard ERPNext package—no extra modules, no code tweaks, just the out-of-the-box build running smoothly, secure, and ready for data entry. I will supply the hosting credentials and a sub-domain; you take it from there and hand back a working URL plu...

I have a Computer Science systems-design assignment due in three days that focuses specifically on database design. I need a clear, well-structured submission that demonstrates solid theoretical understanding and practical application. Scope – Analyse the problem statement I will share and extract data requirements. – Produce an ER diagram, explain entity choices, relationships, cardinalities, and constraints. – Normalise the model up to 3NF, documenting each step and the rationale. – Provide the final relational schema with primary and foreign keys clearly indicated. – Supply brief written explanations (2–3 pages) that justify design decisions and reference best practices. Acceptance Criteria • Diagram delivered in a common format (PDF or...

deploying the official open-source backend components and integrating them with various third-party services for full functionality. • mainly our requirements our own infrastructure Self-Hosted with Custom Instance public rebranded messaging app. • Only people who have previously studied and worked on production-style Signal server architecture and structure should communicate • Those who have not previously studied and worked on production-style Signal server architecture and structure should not submit bid proposals. • The official source code is open-source and available on GitHub. • You only need to deploy and configure the Signal server only. The process requires significant technical expertise in server management, Java, database administrati...

I need my operational data—currently stored across several Excel workbooks—turned into interactive Power BI reports that make trend-spotting and drill-downs effortless. The focus is on robust reporting and analytics rather than a one-off dashboard, so the solution should be scalable and easy for me to refresh whenever new spreadsheets arrive. If you’re interested, send a detailed project proposal outlining the steps you would take to: • connect and clean multiple Excel sources • model the data for accurate relationships and DAX measures • design intuitive visuals that highlight KPIs, variances, and historical trends • deliver a ready-to-share .pbix file plus a short hand-off guide Everything will be built on Excel inputs for now, though I...

We are seeking a highly organized, proactive, and reliable Bilingual Virtual Assistant to join our growing team. This is a full-time remote position requiring fluency in both English and Spanish (spoken and written). The ideal candidate is professional, detail-oriented, and comfortable working in a fast-paced, business-driven environment. Must be proficient using LLM models and similar tools such as : Chat GPT and / or Claude. ------>>> (Generating videos with AI tools and Video Editing skills is not required but is a "Big Plus" because we may need to create a few videos throughout the week whenever work gets slow..) -----KEY RESPONSIBILITIES----- Provide customer support and assist with inbound calls from customers and sales agents Conduct research and perform ac...

We are building a network of experienced Oracle ERP functional and technical consultants for upcoming UK and international transformation programmes. Engagements will include both Oracle E-Business Suite (EBS) and Oracle Fusion Cloud environments. Key focus areas: • Oracle Financials • Supply Chain Management • Human Capital Management • Enterprise Asset Management • Technical integrations (OAF, SOA, middleware, custom extensions) We are particularly interested in: • Senior Functional Consultants • Technical Consultants / Developers • ERP Architects • Integration Specialists • Database & Middleware experts Consultants should be comfortable working independently, contributing to design workshops, producing configuration or technical ...

I need an Elasticsearch cluster set up to store and manage log data. On premises Requirements: - Install and configure a new Elasticsearch cluster from scratch. - Ensure the setup is optimized for log data ingestion and querying. - Provide basic documentation for accessing and managing the cluster. Ideal Skills and Experience: - Proven experience with Elasticsearch installation and configuration. - Strong understanding of log data and its requirements. - Good documentation skills. Install on premises on windows servers

I need a local Access database migrated to a MySQL web platform. The primary function will be data entry and retrieval. Requirements: - Setup a MySQL database - Create a user-friendly web interface for data entry and retrieval - Ensure the platform is secure and accessible to 1-10 users - Migrate existing data (text and numbers) from Access to MySQL Ideal Skills & Experience: - Proficient in MySQL and web development - Experience with database migration - Knowledge of data security practices - Familiarity with creating user interfaces for database interaction Please provide examples of similar work done and ensure you can meet the project requirements within budget.

I have a backlog of financial figures that must be transferred accurately into working spreadsheets and then reflected in our existing SQL database. The spreadsheets will be the primary source, so precision in every cell—dates, currency formats, formulas, and cross-sheet references—is essential before the data is pushed to the database. You will receive scanned source documents, the current Excel template, and credentials to a staging schema in our SQL environment. Once each spreadsheet is complete and vetted for errors, the corresponding tables in SQL need to be updated so that our reporting dashboards stay in sync. Deliverables • Completed Excel workbook with all financial data correctly entered and formatted • SQL script (or direct upload) that mirrors the sp...

Private Matter - SM Private Matter - SM

***Please provide past projects and resume. Issued by: Pierre Souligny On behalf of: Garage J&S Fournier Inc. Proposal Deadline: February 12, 2026 at 8:00 AM EST Project Completion: March 13, 2026 1. PROJECT OVERVIEW Garage J&S Fournier Inc., a small industrial equipment repair business (4 fulltime employees, <$500k revenues), seeks a consultant to recommend, procure, and implement Quebec(Canada) -based cloud hosting infrastructure for our Odoo 18 ERP system. Scope: Select and deploy Production and Staging environments using Quebec datacenters with Quebec backup/disaster recovery sites. Migrate existing Odoo 18 instance (currently under development) from current cloud-based hosting to Quebec-based infrastructure to ensure compliance with Quebec's Law 25 (An Act to mo...

Hi, - CPU: AMD EPYC 7571 (8 core(s)) - Version: Plesk Obsidian v18.0.75_build1800260102.11 os_RedHat el8 - Operating System: AlmaLinux 8.10 (Cerulean Leopard) - Amazon Cloud Server - Currently we have 10 domains created in Plesk - Website is secured by - Wordpress, theme and plugins are up-to-date The problem: the CPU at a random time can spike and reaches up to 98% this is an example - We have reported this issue to our IT team multiple times, but we always get back to the same reply "check your plugins code and fix slow queries", and this is not possible, we are using the same WooCommerce plugin and them across many other domains and we dont have any other issues on our other servers. - From my understanding changes were applied in php-fpm settings - I contacted sucuri and...

My WordPress site went offline after I updated the database host setting and I’m now getting a connection error. Everything else—database name and user credentials—remained untouched, so I’m certain the issue is tied to that host change. I need someone who can quickly trace the problem, adjust or any server-side settings as needed, and bring the site back online without data loss. cPanel, phpMyAdmin and SSH access can be provided right away. Deliverable acceptance criteria • Front-end loads normally with no database connection warnings • wp-admin is fully accessible • A brief note outlining the exact fix applied (for my records) If you have solid experience with WordPress, MySQL and typical hosting panels, this should be a straightforward ...

I have several disparate sources holding our inventory information and I want it all pulled together into one clean, well-structured Microsoft SQL Server database file. The job is straightforward in principle: extract every piece of inventory data you can reach, reconcile duplicate SKUs or mismatched item descriptions, then load the final result into a single .sql or .bak file that I can restore through SQL Server Management Studio. Please preserve every existing field that carries operational value—quantities on hand, reorder thresholds, location codes, cost figures, and any audit timestamps—and normalise the schema where it clearly improves reporting speed or data integrity. If a field appears under different names in different systems, map it consistently; if you uncover ga...

We’re Hiring: Data Analyst (Work From Home) We’re expanding our team and looking for a Data Analyst who can turn data into clear, actionable insights that support smarter business decisions. If you enjoy working with KPIs, dashboards, and reporting systems, this role is for you. This is a 100% work-from-home position. Role Focus Data Management KPI Tracking Reporting and Business Insights Key Responsibilities Manage data collection, validation, and analysis Design, build, and maintain KPI tracking systems Develop dashboards and performance reports Support monthly and quarterly reporting requirements Translate complex data into actionable insights for leadership and stakeholders Ensure accuracy, consistency, and reliability of data across systems Qualifications At least 2 y...

Je suis un professionnel avec une solide expérience en gestion des entreprises, spécialisé en travaux administratifs et design graphique. J'ai élaboré un portfolio mettant en avant mes projets antérieurs et je suis maintenant prêt à offrir mes services sur Freelancer.com. Voici ce que je peux vous apporter : - Conception de documents administratifs : bons de commande, livraisons, ordonnances, factures, etc. - Création de visuels attractifs pour le design graphique , incluant logos, et carte visite. - Gestion et organisation administrative efficace pour garantir le bon déroulement de vos opérations. Idéalement, je recherche des clients qui apprécient le souci du détail et la qualité...

I have a fresh Manatal instance that needs to be structured correctly before we bulk-import roughly 300,000 candidate records. My immediate priorities are: • Field architecture – designing the custom and default fields so every profile, job, and placement record is future-proof and reports cleanly. • Matching logic – fine-tuning job title, sector, department, and location rules so relevant candidates surface instantly. • ATS workflows – mapping each recruitment stage, trigger, and status to match our real-world process while keeping it lean. Once you complete this foundation, another team member will handle the CSV import, so your configuration must be solid enough to absorb that volume without rework. I’ll provide admin access, our current proc...

I’m running a web application on a custom-built PHP framework and it currently sits on an ageing database that I now want fully migrated to MySQL. The job is strictly a database migration—no codebase refactor is required at this stage—so the focus is on cleanly lifting all existing data structures and records into a fresh MySQL schema while keeping the application functional throughout the transition. What I’ll hand over: the current schema dump (or direct access if you prefer), sample data, and a brief outline of the application’s data flow so you can map dependencies accurately. What I expect back: • A MySQL-ready schema that mirrors the original structure, optimised where obvious gains are available (indexes, data types, constraints). • Reli...

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...

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...

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

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.