Programare baze de date Jobs

I need a reusable SQL/PL-pgSQL routine that can handle Create, Read and Update actions against any table in my PostgreSQL database. Table names, column sets and primary keys will be supplied at runtime, so the logic must build its statements dynamically while remaining fully safe against SQL-injection. The procedure has to accept and correctly persist or retrieve every column type I might throw at it—numeric, text, date/time, JSON, arrays and any other standard Postgres datatype—without me having to hand-code separate cases. Deliverables • One well-commented function or set of functions packaged in a .sql file • A short README showing call examples for each action (insert, select with filters, update) and explaining required parameters • Proof it work...

I need an experienced SQL Server DBA specializing in DACPAC operations for database deployment. The project involves deploying a DACPAC package to SQL Server 2019, including schema changes. Key Requirements: - Expertise in SQL Server 2019 - Proficient in DACPAC deployment and management - Experience with schema changes and database upgrades - Strong problem-solving skills and attention to detail Ideal Skills: - SQL Server Database Administration - DACPAC and BACPAC knowledge - T-SQL proficiency - Experience with SQL Server Management Studio (SSMS) Looking for a reliable professional to ensure smooth and efficient database deployment.

I need a single, fully-parametric SQL solution that can handle Select, Update and Delete operations—as well as Insert—against any table in my PostgreSQL database. The goal is to pass in a table name, a dynamic list of column names, variable data types and the necessary filter or value clauses, then have the function build and execute the correct statement on the fly. Here is what I expect: • A PL/pgSQL function (or clear alternative, such as a prepared statement generator) that accepts: – target table – columns and their values or filters – operation flag (select / insert / update / delete) – optional returning clause for selects • Robust handling of variable data types so the same call works for integers, text, timestamps, JSO...

Overview: We are Fluxxcore, an enterprise AI compliance and data analytics ecosystem built for international FinTech, NeoBanks, and InsurTech companies. We solve critical infrastructure and regulatory pain points for corporate clients, including AI model failures (Schema Drift), hidden data vulnerabilities (Shadow Data), and global regulatory audits (EU AI Act, ISO 8000). Our architecture is fully ready, and our operational cycle and enterprise sales pipeline are already set up and running. We are currently scaling our operations and building a core pool of high-caliber experts and data specialists to execute upcoming enterprise projects, run client audits, and participate in technical diagnostics. Compensation & Partnership Model (CRITICAL): This is a Commission-Only / Revenue-Share...

I need help transferring text-based records that currently live in my MySQL database into a clean, well-structured format I can work with outside the system. The job is purely text data entry; no calculations or analytics are required. You will connect to the MySQL tables I specify, pull the relevant fields, and re-enter that information exactly as it appears, maintaining case, accents, and punctuation. Because the source is a live database, accuracy and consistency are critical. I will supply read-only access credentials along with a field-mapping guide so you know which columns belong in which destination fields. Deliverables • A final file (CSV or Excel—your choice) containing every required record, fully cross-checked against the source tables. • A quick summary o...

I need help configuring an email trigger based on an SQL event using SMTP. Our IT Services has set up email service using SMTP2GO and has sent successful test emails. I know how to write queries (I typically run queries in Excel using database connection). I don't know how to set up a trigger. I'd like a learn how to do this in addition to just having it done. Requirements: - The email should be triggered on an "insert" action. - Email content must include: - Updated data details - Timestamp of update - User who made the update Ideal Skills and Experience: - Proficiency in SQL - Experience with SMTP and email configuration - Knowledge of working with database triggers and sending emails on database events

I'm seeking a skilled developer to create a tailored Applicant Tracking System (ATS) for my placement consultancy. The ATS should streamline our recruitment process and enhance efficiency. Key functionalities needed: - Resume Screening: Automate the initial resume screening process. - Candidate Tracking: Monitor candidates throughout the hiring pipeline. - User Roles: Support for Admin, Recruiter, and Hiring Manager roles. Resumes should be submitted via direct upload to the system. Ideal Skills and Experience: - Proven experience in building ATS or similar recruitment software. - Strong understanding of recruitment processes and user needs. - Proficiency in database management and user interface design. - Ability to incorporate automation features for efficiency. Please provide ...

I have a set of digital files that contain purely numerical information, and I need every figure transferred accurately into my existing database. You will be working directly with the database layer—so familiarity with typical SQL interfaces or import tools is essential. The files are already in clean digital form; your task is to extract each number, verify it matches the source, and insert it into the correct tables and fields. Once the upload is complete, a quick cross-check against the originals will confirm that no values were missed or altered. Deliverable • A fully populated database reflecting 100 % of the numbers in the supplied files, with spot-check verification passed. If you’re comfortable manipulating numeric datasets and working inside a live dat...

I need an experienced Notion builder to create a streamlined personal-organization hub focused on two things: keeping my tasks under control and tracking the goals that matter most to me. The core database should open in List view—this is how I naturally process information—yet still be structured well enough that I can later switch to Kanban or Calendar if I ever change my mind. Here’s what the workspace must cover: • A task-tracking system with statuses, priorities, due dates, and a clean List view as the default. • A goal-setting area that links seamlessly to the tasks so every action clearly rolls up to a bigger objective. Once the build is complete, I’ll also need a quick loom or written walkthrough so I can tweak properties and filters on my ...

I have a set of digital files that contain purely numerical information, and I need every figure transferred accurately into my existing database. You will be working directly with the database layer—so familiarity with typical SQL interfaces or import tools is essential. The files are already in clean digital form; your task is to extract each number, verify it matches the source, and insert it into the correct tables and fields. Once the upload is complete, a quick cross-check against the originals will confirm that no values were missed or altered. Deliverable • A fully populated database reflecting 100 % of the numbers in the supplied files, with spot-check verification passed. If you’re comfortable manipulating numeric datasets and working inside a live dat...

I need an Access 2010 database to be accessible online via web browsers for 2-3 users. The database primarily handles data entry and storage. Key Requirements: - Web-based access for users - Multi-factor authentication for security Ideal Skills and Experience: - Experience with Microsoft Access and database migration - Knowledge in setting up secure, web-based database access - Familiarity with multi-factor authentication integration I currently have an odoo and Microsoft 365 Business subscription and need it to connect to either of these, with advice which is the better platform to use

URGENT HIRING – Freelance Power BI Developer Company Description A and TN Technologies is a technology services company committed to delivering innovative and customized IT solutions across various industries. We leverage cutting-edge technologies to help businesses streamline operations and make data-driven decisions. Based in Coimbatore, we foster a culture of collaboration, excellence, and customer satisfaction, making us a trusted partner for technology-driven growth. Immediate Requirement We are urgently looking for an experienced Freelance Power BI Developer to join our team remotely. Candidates who can join immediately or at short notice will be given preference. Key Responsibilities * Design, develop, and maintain Power BI reports and dashboards. * Create and manage...

I’m running a DHIS2 instance for a health programme and need reliable support for ongoing data entry and management. The work is entirely within DHIS2—importing routine service data, checking for completeness, running the built-in validation rules, and resolving any inconsistencies before the monthly reporting deadline. You should already know your way around DHIS2 data entry forms, the data import wizard (CSV/XML), and basic data management features such as bulk editing and metadata maintenance. If you can also create simple pivot tables or charts once the data are clean, that’s a plus, though the core focus remains accurate, timely entry. Deliverables will be measured by: • 99 % accuracy against validation rules • All assigned datasets entered and validate...

I have a set of digital files that contain purely numerical information, and I need every figure transferred accurately into my existing database. You will be working directly with the database layer—so familiarity with typical SQL interfaces or import tools is essential. The files are already in clean digital form; your task is to extract each number, verify it matches the source, and insert it into the correct tables and fields. Once the upload is complete, a quick cross-check against the originals will confirm that no values were missed or altered. Deliverable • A fully populated database reflecting 100 % of the numbers in the supplied files, with spot-check verification passed. If you’re comfortable manipulating numeric datasets and working inside a live dat...

I run an on-premise Oracle Retail v16 estate and I now need focused, ongoing production support for the Retail Merchandising System (RMS). Day to day, I’m looking for both technical troubleshooting and functional guidance so users can keep working without interruption. The most pressing items are: • Resolving current integration issues that are preventing clean data flow between RMS and the surrounding applications. • Developing and implementing lightweight monitoring scripts so we can spot job failures or performance dips before they impact the business. Once those pains are addressed, I’d like you to stay available for routine health checks, root-cause analysis when anomalies appear, and advice on best-practice configurations or minor functional tweaks. If...

I keep all live sales transactions in a SQL Server database and receive additional monthly CSV extracts for legacy channels. I need the whole dataset blended, modelled, and surfaced in Power BI as a single, lightning-fast dashboard my exec team can open and immediately understand. Scope of work • Connect directly to the SQL database and configure an automated import for the monthly CSVs. • Build an efficient star-schema model in Power Query and DAX so refreshes remain snappy. • Create intuitive Bar Charts, Line Graphs, and Pie Charts that highlight the three critical metrics we track: Total Sales, Sales by Region, and Top Products. • Publish the report to the Power BI Service and set up a reliable weekly scheduled refresh (no manual steps). • Optimise vi...

I have a set of digital files that contain purely numerical information, and I need every figure transferred accurately into my existing database. You will be working directly with the database layer—so familiarity with typical SQL interfaces or import tools is essential. The files are already in clean digital form; your task is to extract each number, verify it matches the source, and insert it into the correct tables and fields. Once the upload is complete, a quick cross-check against the originals will confirm that no values were missed or altered. Deliverable • A fully populated database reflecting 100 % of the numbers in the supplied files, with spot-check verification passed. If you’re comfortable manipulating numeric datasets and working inside a live dat...

Project Overview We're a fast-moving, performance-marketing-driven telemedicine company looking for an experienced Financial Planning & Analysis Analyst to take ownership of our financial visibility on a contract basis. This is a hands-on engagement: you'll work directly in our data, build the reporting and models we run the business on, and help us understand our unit economics. We're open to an ongoing part-time arrangement or a defined-scope project to start, with the potential to extend based on fit. What You'll Do - Build and maintain our company P&L, including daily revenue, COGS, and expense tracking - Generate daily, weekly, and monthly reports from our Bask database - Reconcile expenses inside and outside Bask for complete financial visibility - Moni...