Database Administration Jobs

Project Description: We are moving approximately 550 members from MemberLeap to Brilliant Directories. The ideal candidate must have a proven track record in complex database mapping and, most importantly, Stripe subscription migration to ensure no loss of recurring revenue or double-charging of members. Customers in BD will not to re-enter credit card information again upon their subscription renewal. BD will use same Stripe Account as MemberLeap did. Core Responsibilities: Data Mapping & Migration: Extract data fields from MemberLeap (CSV provided), map them to Brilliant Directories custom member categories, and execute a clean import. Stripe Billing Integration: Connect our existing Stripe account to Brilliant Directories. You must map existing Stripe Customer IDs to new BD prof...

I have a steady flow of printed documents that must be keyed into our online database with total accuracy and a quick turnaround. Each record needs to be entered exactly as it appears on the page, double-checked for spelling, dates, and numerical precision, then saved to the correct table in our web interface. The work comes in batches, so if you’re comfortable picking up extra hours when volume spikes, you’ll appreciate the overtime potential here. You will receive scanned PDFs and a secure login. I’ll outline the required fields and supply a brief style guide so every entry stays consistent. My priority is error-free data and reliable availability—no fancy formatting, just clean, verified information in the right place. Deliverables • All assigned pages t...

I have a single MySQL database sitting on my Hostinger account and three separate custom-built PHP sites that need to talk to it. At the moment the connection fails whenever the login page tries to authenticate a user, so I suspect the issue is buried somewhere in the backend configuration—possibly wrong credentials, hostnames, or overlooked privileges inside phpMyAdmin. Here’s what I need from you: • Inspect the current hPanel and phpMyAdmin settings, make sure the database user has the right privileges, and confirm the host names for all three sites. • Review each site’s PHP connection file, tidy up the mysqli / PDO code as required, and verify that user-authentication queries run without errors. • Test end-to-end on all three domains so logging i...

I am looking for an experienced Linux / cPanel & WHM administrator to troubleshoot and fix a database mapping issue on my self-managed VPS server. Server Details: VPS server (root access available) cPanel & WHM version: 11.134 MariaDB running normally Websites are working and databases are functional Problem: In cPanel → Manage My Databases it shows: "The database server is currently offline (adminbin Cpanel/cpmysql/DBCACHE: exit 255)" phpMyAdmin was also inaccessible earlier. Databases and MySQL users exist and websites connect successfully. After rebuilding DB mapping some databases appear but: Database privileged users are not showing in cPanel UI. cPanel database mapping seems broken. Troubleshooting Already Done: Verified MariaDB service is running...

I need an expert to configure Citrix Netscaler for load balancing. The primary goal is to ensure high availability for my applications. Key Requirements: - Experience with Citrix Netscaler - Expertise in configuring load balancing for high availability - Knowledge of both on-premise and cloud deployments Ideal Skills: - Networking and infrastructure knowledge - Experience with web applications, database servers, or email servers - Problem-solving skills for optimizing performance and uptime Please provide relevant experience and approach. Must be located in the US.

I need someone to bring my Oracle 11g server online and make sure it starts cleanly every time my Red Hat Enterprise Linux machine boots. The software is already on the box; what’s missing is a reliable, Standard installation-style configuration that finishes the setup, starts the database, confirms the listener is running, and registers the instance correctly with systemd so it survives reboots. You’ll connect over SSH, verify the existing Oracle home, adjust any kernel parameters or environment variables that were skipped, and walk me through the key commands so I understand how to start and stop the service myself. A simple set of notes or a shell script showing the steps you performed is all I need as a final hand-off.

Database Migration Specialist: MySQL to Supabase/PostgreSQL We're looking for a data migration expert who doesn't just move data — you ensure it arrives clean, complete, and production-ready. You have deep experience migrating large-scale databases and understand the nuances of moving from MySQL to PostgreSQL in Supabase environments. What You'll Do: - Plan and execute end-to-end migration of large MySQL databases to PostgreSQL on Supabase - Audit source data for inconsistencies, duplicates, and schema incompatibilities before migration - Design and implement migration scripts, transformation logic, and validation checks - Handle data type mapping, constraint differences, and stored procedure conversions between MySQL and PostgreSQL - Perform dry runs, staged migrati...

My Supabase-backed web application needs a solid, automated maintenance routine. The core of the project is to keep the database healthy and fast, so I want complete coverage for three areas: regular backup and reliable recovery paths, performance tuning that actually shaves time off the heavier queries, and a clean workflow for applying Supabase/PostgreSQL updates and security patches without downtime. I already have the project running on Supabase; what’s missing is the living set of scripts, schedules, and monitoring rules that turn ad-hoc admin work into a predictable process. You’ll work directly in Supabase (and the underlying Postgres layer) and can bring in any complementary tooling—pg_dump, cron, pgBouncer, Grafana, or similar—as long as it integrates smoo...

Our data team is about to build a proof-of-concept for an AI-driven agent that relies on Informatica IDMC MDM, and I want an experienced specialist (around 7–12 years in the MDM space) who can jump in right away. The work centres on material master data: pulling existing material records from IDMC through the platform’s APIs, allowing a user to modify or enrich that data in real time, and finally creating brand-new material entries via the same service layer. You’ll be the point person for every technical decision, comfortable debating approaches with our Data Architects and translating those ideas straight into working configurations. Hands-on knowledge of the native MDM APIs is essential; exposure to cloud or ERP endpoints such as GCP or SAP will make integration ...

Project Overview: Development of a centralized Queue Management System using a MySQL database (Cloud-hosted). The system must support real-time synchronization between a Web-based booking portal, on-site Kiosks (TouchPOS), Operator Panels, and a Waiting Room Display. ⚠️ CRITICAL REQUIREMENT: The User Interface (UI) of all components (TouchPOS, Operator Panels, Monitor, and SMS/Tickets) must be in Azerbaijani Language. 1. Technical Stack & Architecture: Backend: PHP (Laravel) or Node.js. Frontend: React, Vue.js, or Angular. Database: MySQL. Real-time Communication: WebSockets () for instantaneous updates (max 0.5s delay). 2. Core Modules & Functionality: A. Web Portal (Online Booking): Patients select a department (Registration, Insurance, Analysis Results). System generates...

IWe are looking for a freelancer to install Apache Superset using Docker and connect it to our existing PostgreSQL database. Tasks: - Install the latest stable version of Apache Superset using Docker - Configure Superset to connect to an existing PostgreSQL/PostGIS database - Verify that dashboards and queries work correctly - Provide clear documentation of the installation and configuration process Environment: - Linux server - Docker - PostgreSQL / PostGIS Requirements: - Experience installing Apache Superset - Strong Docker knowledge - Experience connecting BI tools to PostgreSQL - Ability to document the setup so our team can maintain it Estimated effort: 1–2 days of work. Por qué es mejor así

I maintain several large, structured datasets spread across MySQL, PostgreSQL and SQL Server instances. Only portions of the existing schemas are documented, so the very first step will be to inspect each system, reverse-engineer any missing metadata and confirm table relationships. Once the landscape is clear I need all records extracted, cleaned, normalised and deduplicated, then merged into a single, well-organised MongoDB database. Your work should include a carefully planned document model that supports growth, fast look-ups and straightforward analytics. Proper indexing, sharding strategy (where appropriate) and query optimisation are critical because future workloads will be heavy and latency-sensitive. Please deliver: • An optimised MongoDB schema and architecture diag...

I'm seeking an expert to help normalize my SQL database to the 2nd Normal Form (2NF). The primary goal is to reduce redundancy. Key Requirements: - Expertise in SQL databases - Strong understanding of 2NF principles - Experience in database normalization Ideal Skills: - SQL proficiency - Database design and architecture - Problem-solving skills for redundancy issues Please provide relevant experience with your bids.

Our historical sales data is signalling shifts that we don’t fully understand yet, so the priority is a diagnostic analysis that tells us not just what changed, but why it changed. The raw tables cover order details, customer attributes, product SKUs and daily revenue going back three years. Primary questions on the table: • How have sales trends evolved month-to-month and season-to-season? • Which customer segments are driving (or dragging) revenue, and how has their purchasing behaviour shifted? • Which products or product groups are over- or under-performing once promotions, returns and stock-outs are factored in? A clean, reproducible workflow in SQL, Python (Pandas, NumPy, Sci-Py) or R is essential so the team can rerun the analysis after future data drops...

## **Project Title: Senior WordPress Performance Engineer – WPresidence Theme Optimization** ### **Project Overview** We are seeking a highly skilled WordPress Performance Specialist to optimize a real estate website built on the **WPresidence theme**, hosted on **WP Engine**, and utilizing **Cloudflare**. Our primary challenge is a high **Time to First Byte (TTFB)** and sub-optimal mobile performance. We are looking for deep, manual optimization—not just the installation of "all-in-one" speed plugins. You must be comfortable working within the restricted environment of WP Engine (where many caching plugins are disallowed) and configuring Cloudflare for maximum edge performance. --- ### **Technical Environment** * **Theme:** WPresidence (Heavy real estate theme ...

Building Insurance Aggregator Platform (Frontend + Backend + DB) – Onsite Team Opportunity We are building a regulated insurance aggregator platform and are looking to form a small, focused engineering team to develop the MVP. This is not a simple website project. The system will involve: Integration with multiple insurance companies via APIs Quote generation and premium calculation Secure user flows (OTP, payments, policy issuance) Financial data handling Admin dashboards Reporting and logging Scalable backend architecture The team must be open to working onsite (relocation or local presence preferred). Required Roles (3 Developers): - Frontend Developer (React or Angular) 2–4 years experience Experience building production-grade dashb...

Project: Cash flow help has a financial analyst excel spreadsheets program that uses financial data to review the current business situation and then do “what if” analyst to improve business cash flow using the six cash drivers. The project is dissected into 3 stages to develop a web app, upload/synch the business financial data via API with accounting software program XERO, MYOB & Intuit. The final stage is to make the App mobile friendly. STAGE 1. PREPARE THE WEB APP Ideation stage 1. Source an idea – to use the excel spreadsheet as a source for calculations and data input to prepare a website app to used by business and accountants. The App will be a subscription model with the ability to change levels of subscription. 2. Market research – The web app will be...

I need two focused Python utilities that help me keep both of my data platforms tidy by flagging objects that haven’t been touched in X days and suggesting safe-to-drop SQL. Program #1 – AWS Athena • Connect to my Athena catalog (I work from the AWS Management Console, but in code I’d like you to stay with boto3). • For every table and view in a specified database, look back over completed query executions for the chosen time window. • Views can nest CTEs or reference other views, so the script must walk the full dependency chain to decide whether a reference is direct or indirect. • Return one CSV with the following columns exactly: database , objectname, objecttype, last_reference_datetime, referencetype (direct/indirect) , referencedBy,...

I am looking for an experienced MySQL database expert to recover my database from .ibd (InnoDB) files and convert them into a proper .sql dump file. Background My production server crashed unexpectedly. I took a backup while the server was running. The backup contains .ibd files only (no .sql dump). I do NOT have .frm files.

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.

Tengo una base de datos MySQL 5.7 (compatible con MariaDB) que alimenta una aplicación PHP / Laravel con tablas de millones de registros. El principal dolor que quiero resolver son las consultas lentas; necesito que el sistema responda con la agilidad que nuestros usuarios esperan. Busco a alguien con experiencia probada en entornos de alto volumen que analice a fondo la base, detecte cuellos de botella y me entregue soluciones listas para producción. Valoro el dominio de EXPLAIN, performance_schema y cualquier otra herramienta de análisis de consultas. Quiero trabajar específicamente en: • Optimización de consultas • Revisión de índices • Revisión y ajuste de la configuración de MySQL Entregables espera...

Actualmente gestiono un inventario de productos en una base de datos de Microsoft Access y la limitación de un solo usuario está frenando el crecimiento del negocio. Quiero trasladar toda la información a Microsoft SQL Server para que varias personas puedan leer y escribir datos simultáneamente y, de paso, incorporar algunas mejoras sobre la funcionalidad actual. Lo esencial del encargo: • Migrar por completo la estructura y los datos del inventario desde Access a SQL Server, manteniendo la integridad y las relaciones existentes. • Configurar roles y permisos que permitan a distintos usuarios leer y escribir datos de forma segura. • Replicar las funcionalidades que ya uso en Access (formularios, consultas clave, reportes básicos) y pr...

Potřebuji uvést do provozu svůj informační kryptoweb. Veškerý obsah i strukturu mám připravené – texty, sekce s grafy aktuálních cen, novinky i návody. Hledám tedy člověka, který celý projekt nahraje na hosting, propojí s doménou a dohlédne, aby vše běželo bez chyb. Co od vás očekávám: • nasazení webu (CMS, statický generátor či jiné řešení podle krátké domluvy) • konfiguraci databáze, SSL a základních bezpečnostních prvků • kontrolu funkčnosti částí zobrazujících cenové grafy a články • optimalizaci na...

Estamos buscando un telemarketer proactivo, orientado a ventas y con experiencia, para contactar a gerentes de Recursos Humanos de hoteles en México y presentar nuestra aplicación especializada en capacitación de idiomas para la industria hotelera. Nosotros proporcionamos la base de datos de contactos y el script de ventas, por lo que el enfoque principal será realizar llamadas, generar interés y agendar demostraciones o cerrar ventas. Horario inicial: 3 días por semana Martes, miércoles y jueves 2 horas por día 9:00 am – 11:00 am (hora de México) Responsabilidades: Realizar llamadas telefónicas a gerentes de Recursos Humanos en hoteles Presentar brevemente nuestra aplicación de capacitación ...