Administrare baze de date Jobs

deploy and configuring a official private Signal server, deploying the official, open-source backend components and integrating them with various third-party services for full functionality. The source code is open-source and available on GitHub. The process requires significant technical expertise in server management, Java, database administration, and cloud services. Before diving in, could you clarify a few details to better tailor the guide? • Infrastructure: Are you planning to deploy on a our server • Version: Do you need the latest official Signal Server (Java-based) and WebRTC signaling server Node.js/Socket.io) • Customization : rebrand the app or simply run a private instance ________________________________________ Core System Requirements The official Si...

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

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

I need a complete, cloud-hosted database solution that I can reach from any browser. The core of the project is a secure web application that lets my team create, read, update, and delete two key data sets—our inventory and our customer records. A relational structure in a managed cloud service (AWS RDS, Azure SQL, Google Cloud SQL, or a comparable platform) is the target back-end; I’m open to whichever stack you feel delivers speed, reliability, and straightforward maintenance. Here’s what I expect: • A clean data model covering all inventory details and customer profiles, with the appropriate relationships, constraints, and indexing. • Web UI with intuitive forms, tabular views, and quick search / filter so staff can locate or edit a record in seconds. &...

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

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

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.