Administración de bases de datos Jobs

Buscamos Ingeniero de Telecomunicaciones / Administrador de Sistemas Senior con experiencia avanzada en VICIdial y Asterisk PBX (Habla Hispana). Responsabilidades y tareas clave: Optimización de infraestructura: Configuración, mantenimiento y tuning de servidores VICIdial (arquitectura Single o Cluster). Bases de datos: Optimización fina de base de datos (MySQL / MariaDB) para soportar alto volumen de llamadas simultáneas y evitar bloqueos de tablas. Desarrollo e IVR: Configuración de campañas predictivas, gestión de IVR avanzado, enrutamiento inteligente y scripts AGI personalizados. Soporte y conectividad: Resolución de problemas de latencia, calidad de audio y configuración de troncales SIP / carriers. Requisitos indis...

I’m struggling to locate a specific User ID on my website and need someone who can quickly pull or reveal it for me. The goal is simple: identify and deliver the exact User ID tied to a user record on the site. Please be comfortable navigating typical website back-ends or databases, reading server logs, or crafting a quick script if that’s the fastest route. Once you have the ID, I’d like a brief note on where you found it so I can repeat the process in the future. Deliverable • The correct User ID sent back to me, plus a concise explanation (screenshot or short text) of the retrieval method. That’s all—let me know your approach and how soon you can hand it over.

Olek Sys admin project Olek Sys admin project Olek Sys admin project

I’m running Odoo 19 (Enterprise) and need to stop everyday users from editing the product cost field (standard_price). At the moment anyone can overwrite it, putting our margins at risk. The goal is simple: make that field read-only on every product form and list view for everyone except a small, changeable set of authorised managers. I distinguish those managers by specific user accounts rather than fixed roles, and the exact roster may change over time. Because of that, I’d like a clean, maintainable approach—ideally a dedicated security group that I can toggle per user through Settings—while still meeting the requirement that the restriction is enforced on the frontend (XML) so unauthorised users literally cannot click into the field. Deliverables • XML vi...

I need a well-structured SQL database that turns raw sales transactions into clear insight for our monthly analytics and reporting. The core job is to design the schema, import existing sales data, and build the queries (or stored procedures) that generate our standard monthly sales report with totals, trends, and key breakdowns. Right now the data lives in CSV exports from our point-of-sale system. I want it migrated into a relational database—engine choice is open (PostgreSQL, MySQL, MS SQL, or another you recommend) as long as it handles growth and lets me run additional ad-hoc reports later. Good indexing and normalization are essential because report runs must stay quick when the dataset scales. Deliverables: • SQL scripts for creating all tables, constraints, and index...

After a sudden power cut the server came back up cleanly—Apache, MariaDB/MySQL, Asterisk and all VICIdial services report as running and phpMyAdmin shows the database online. Yet every agent now sees “Invalid Username/Password” on the campaign screen and the admin page just reloads when credentials are entered. Here is what I have already done: examined the Apache, MySQL, Asterisk and VICIdial logs for obvious errors, repaired and optimized the vicidial_users table, and confirmed the credentials being typed are correct. No browser-side tricks helped. We also do not have a usable database backup, so whatever fix you apply must leave the current data intact—no wipe-and-reinstall options are acceptable. I need you to: • Identify the exact point in the s...

I have a raw file of roughly 1.5 million B2B contacts pulled from several sources, and I need it converted into a campaign-ready database that maximises email deliverability. The work revolves around four core actions: cleaning, verifying, standardising and finally organising the data for import into my CRM and marketing platforms. Key focus • The main objective is to eliminate hard bounces and spam-trap risks so every outbound send has the highest possible delivery rate. • Three fields must come back fully standardised and de-duplicated: – Email addresses – Company names – Contact names Scope of the job You will run the list through proven large-scale email verification tools and apply additional checks for syntax, domain health and catch-...

I am an older database programmer in need of up-to-date training on how to access and manipulate MySQL databases. I have had one of my website applications updated. It uses Hostinger Hosting for the host sql database on their Linux server. I am using Visual Studio 2026 Community with local host MySQL database. 1. I need someone in USA that can talk to me over the phone and Any Desk onto my desktop 2. Take a look at my Local Host MySQL database and show me a simple way to identify and view the tables, make direct changes to the data within the database, and insert new tables into the database. 3. Show me how to Back-up my operational database on the host server, and to copy my local host database over to the Hostinger server to replace the old database with the updated one. I am a quick st...

Our job portal’s search results page is being dragged down by slow data retrieval, and it’s directly affecting the overall speed and load time of the site. I need someone who can dive in, pinpoint the bottlenecks, and deliver measurable gains without disrupting existing features. Here’s how I see the engagement: • Analyse current queries, API calls, and any middleware that sits between the database and the front-end to uncover why the data feed to the search results is sluggish. • Optimise what you find—whether that means rewriting SQL, adding smart indexing, implementing server-side caching, or fine-tuning backend code. • Validate improvements with before-and-after metrics: Time To First Byte, total page load, and server response time for typic...

Tenho instalado um terminal de controlo de acessos Hikvision DS-K1T344EBFWX-E1 e preciso que cada evento gerado pelo equipamento seja gravado em tempo real numa base de dados SQL Server. O serviço ou aplicação deverá receber o evento assim que ele ocorre e inserir, de forma confiável, três campos principais: horário de entrada/saída, identificação do usuário, status do acesso (permitido ou negado)e ID do Terminal onde a picagem foi efectuada. Busco uma solução estável, capaz de se reconectar automaticamente ao dispositivo caso o link caia, e que traga logs para auditoria. A opção de desenvolver em C#/.NET usando o Hikvision SDK ou chamadas ISAPI é a que mais faz sentido no...

Access-to-SQL-Server Migration — Experienced Developer Needed (Paid Assessment First) We run a business ERP built in Microsoft Access (front-end / back-end split, ~40 users). We are looking for an experienced developer to move the data (the Access back-end tables) onto Microsoft SQL Server, while keeping our Access forms as the user interface. The database is small (~300 MB of tables). This project is a short PAID ASSESSMENT — not the full migration. Before committing, we want you to review our system and tell us whether the migration is worthwhile, what it involves, and how many hours it would take. The full migration would be a separate engagement afterwards, only if we decide to proceed. Requirement — proven migration experience We will only consider developers who hav...

I run several production workloads on Oracle 19c and need an expert DBA who can handle three core activities for me around the clock: building new databases from scratch, tuning performance on existing instances, and carrying out version or patch upgrades without downtime to the business. Here is what I expect from you: • Database creation – end-to-end installation and configuration of fresh Oracle 19c environments, including listener setup, tablespaces, and all basic security hardening. • Performance tuning – proactive monitoring and remediation using AWR/ASH reports, SQL Tuning Advisor, indexing strategies, and statistics management to keep response times low. • Upgrade & patching – planning and executing PSU/RU installs or full-version upgrades...

Overview: We are looking for an experienced Backend Developer / Systems Integrator to set up and configure a local MCP (Model Context Protocol) Server on a dedicated Windows PC. The goal is to bridge our local, on-premise SQL Database with AI tools (such as Microsoft Copilot, Claude Desktop, or Cursor) so we can query our database securely using natural language. Remote Access & Working Method (Important): Full Remote PC Access Provided: You will be given direct remote desktop access to our dedicated Windows PC using AnyDesk, TeamViewer, or UltraViewer to perform the entire installation and configuration. Database Access: We will provide you with a secure, Read-Only SQL credential strictly for testing the database connectivity from the MCP server. Technical Environment: Host OS: D...

I’m looking for a seasoned database administrator to take charge of our SQL Server environment for a Bank of India–related platform. The immediate focus is on keeping the core banking data layer fast, resilient, and secure. Here’s what the assignment covers: • Database optimisation – analyse slow queries, tune indexes, and improve overall throughput without disrupting live operations. • Backup & recovery – design and automate point-in-time backups, test restores regularly, and document the full recovery strategy. • Security management – harden user roles, apply the latest patches, set up auditing, and make sure compliance standards are met. You’ll be handed full access to a staging instance first, followed by production onc...

I’m looking for a patient, knowledgeable ERPNEXT instructor who can guide me one-on-one through the platform. My goal is to feel completely comfortable running day-to-day operations on my own, so I need hands-on, practical sessions rather than theory. Scope of the training • Cover Accounting, Inventory Management, and CRM workflows from the ground up. • Show best-practice navigation, data entry, reporting, and user-level configuration inside Frappe ERPNEXT. • Walk me through real examples that mirror typical small-business scenarios so I can immediately apply what I learn. Preferred format & pace Live video sessions (screen-sharing is fine) scheduled around my availability, with short homework exercises in between. I’d appreciate recordings or conci...

I need help transferring numerical data that currently lives in a company database into clean, well-structured Excel spreadsheets. The task is straightforward: open the records I will grant you access to, verify each figure against the on-screen source, then enter it accurately into the matching Excel fields I provide. Consistency is crucial, so a quick eye for spotting outliers or missing values will be appreciated. I will supply clear field-by-field guidelines and a small sample sheet so you can see the desired formatting before you begin. A short check-in after the first batch will confirm we’re aligned, then you can proceed with the remaining rows. If you have solid experience with data entry, understand basic database navigation, and are comfortable working in Excel, this ...

Azure Data Factory + Azure SQL Expert Needed to Debug and Implement Data Processing Change Description I'm looking for an experienced Azure Data Engineer with strong knowledge of Azure Data Factory, Azure SQL, SQL Stored Procedures, and Databricks to help implement a change in an existing production data pipeline. Environment Azure Data Factory Azure SQL Database Mapping Data Flows Azure Data Lake Storage (ADLS) Databricks SQL Stored Procedures Current Situation I have already completed the initial analysis: Identified the source table. Traced the ADF pipeline. Reviewed the Mapping Data Flow. Identified the destination Azure SQL table. Identified SQL views and stored procedures referencing the table. Reviewed one of the stored procedures. The remaining work is to: Trace the com...

I need a proactive virtual assistant to take over the daily task of responding to emails that come into my main business inbox. Your focus will be full-cycle email management—specifically drafting and sending timely, well-written replies that reflect our brand’s tone and resolve enquiries without escalation. Scope of work • Log in to my Gmail workspace twice per day (morning and late afternoon in my time zone) • Read, prioritise, and craft clear responses using templates I’ll provide, tweaking language when a personalised touch is required • Flag anything that needs my direct input, then circle back once I’ve added notes so the conversation closes out • Keep a running spreadsheet of common questions so we can refine or add templates over...

I’m updating our internal CRM and need all “Generated new name” entries brought fully up to date. You’ll use reputable online directories I provide, extract the relevant contact details, then validate them before entering them into our database. **This is ongoing work, and I need someone who can start immediately.** **Workflow:** * Retrieve each “Generated new name” record from the assigned directory source. * Confirm the contact is active using a reliable verification method (e.g., lookup or test message), and document how it was verified. * Input the cleaned and verified data into the correct database fields, following the formatting rules in the style guide I’ll share. **Deliverables:** 1. Updated database entries for approximately 50,000 c...

Customer Data Analysis using SQL: Recently completed a hands-on Customer Data Analysis Project using SQL, where I explored and analyzed 81,446+ customer transaction records to uncover valuable business insights. Key Analysis Performed: Identified total transactions based on gender, product category, and payment method. Analyzed which gender purchased the highest number of products. Calculated total revenue generated by each gender. Compared category-wise transactions, units sold, and revenue. Evaluated purchase patterns across categories and genders. Examined payment method-wise revenue and transaction performance. Segmented customers into different age groups to analyze buying behavior. Found the age group with the highest product purchases. Identified the most frequent categor...

I need a full-stack ASP.NET web application—C# on the back end, SQL Server for data—delivered in both English and Arabic with complete RTL rendering on every screen. The build is split into two clear areas: External Applicant Portal • Public registration form that captures entity details and uploads supporting documents. • Submission triggers a reference number so applicants can log in later and track real-time status updates. • All outward-facing pages must switch seamlessly between English (LTR) and Arabic (RTL) without layout shifts. Administrative Portal • Review queue showing every incoming application and its attachments. • Configurable, multi-level approve / reject workflow. Each step records the acting user, decision, and timestamp. ...

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.