Administrare baze de date Jobs

My site is showing a few stubborn functionality errors—most notably a date that refuses to update correctly—so the first task is to track those down and put them right. After the front-end is behaving, I want a thorough look at the database to confirm everything is healthy and consistent before we move on. While you have access, please harden the security of the entire installation. I’m already running over HTTPS, but I’d like you to double-check certificates, permissions, and any obvious gaps that could expose user data. Deliverables • Functionality errors fixed (including the date issue) • Database health report with any corrective actions applied • Security hardening completed and documented (SSL verified, permissions tightened) I’...

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 have started a roster of PKL participants along with the kind of transport they use—motorbike or public transportation—but it is incomplete. I need you to turn it into a neatly ordered, fully populated text file (.txt, UTF-8). Each entry must follow this structure: Name | Transport Type | Address You may stage the data in SQLite while working; that is the database format I am most comfortable reviewing should I ever need to expand or import the list later. However, the final hand-off must still be a plain text file. What you will do: • Use the twelve names I have already given as the starting point. • Fill in any missing numbering, fix obvious typos, and keep the transport notes exactly as stated (Motorcycle, GL Motorcycle, etc.). • Research or req...

Need a person well versed in LAN and making my systems secure from outsiders accessing it or not allowing any remote access. Also need an audit of my system Using windows and has some softwares More details: What type of systems are you using? Windows What specific security measures are you interested in? Firewall configuration, User access control Do you need to secure any specific applications or software? Database systems

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

Key Requirements: 3–5 years of hands-on Tableau experience Strong Tableau dashboard development and data source management experience Good SQL skills Exposure to Tableau Server, including publishing, schedules, permissions, and troubleshooting refresh failures Familiarity with AWS and cloud data warehouses such as Amazon Redshift, Snowflake, or BigQuery Strong verbal and written communication skills Comfortable working with unfamiliar datasets and taking direction from internal teams Willingness to work a night shift aligned to US Eastern Time Preferred Experience: Tableau Server administration AWS fundamentals and Tableau connectivity with cloud-hosted data sources Extract performance optimization Managed services or client-facing support environments Exposure to Tableau Cloud, Mu...

My current data platform is overdue for a full-scale health check and future-proofing plan. The workload is hybrid—heavy transactional traffic combined with analytics—and I need clear, vendor-neutral guidance on whether the existing setup should stay on-prem, shift to SQL, NoSQL, or even a NewSQL engine, and which cloud provider (AWS, Azure, or Google Cloud, or another) would suit the roadmap best. What I expect from you: • A concise audit of the present environment covering performance, security, scalability, backup/DR, and cost drivers. • Best-practice do’s and don’ts tailored to a hybrid workload. • A migration and integration blueprint that shows how the database layer should connect with the application, analytics, and orchestration layer...

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 have bike-sales data sitting in a SQL Server database and I need a clear, insight-driven view of what is really happening in the business. You will start by writing well-structured SQL—JOINs, GROUP BYs, subqueries, the works—to pull everything together. From that result set, build an interactive Power BI dashboard that surfaces the three core KPIs I rely on: Revenue, Sales Volume, and Profit Margin. Because our immediate focus is growth in Asia, the visual story must spotlight that region’s performance while still letting me drill into individual models to see which bikes are driving results. The finished dashboard should help my team make faster inventory and demand-forecasting decisions, so usability and speed matter as much as visual polish. Deliverables I expe...

Role Description This is a part-time remote role for a Power BI Developer. The Power BI Developer will be responsible for developing interactive dashboards, reports, and business intelligence solutions using Microsoft Power BI with a strong focus on SQL Server database development and data management. The role involves writing optimized SQL queries, designing data models, creating ETL workflows, and transforming raw data into actionable insights. The candidate will collaborate with cross-functional teams to understand business requirements, maintain data accuracy, and optimize reporting performance. The position is based in Chennai. Qualifications Strong expertise in SQL Server including queries, stored procedures, views, joins, indexing, and performance optimization Experience with Micr...

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 need an Active-Active High Availability (HA) setup for OpenNMS using round-robin load balancing. The components that require HA are: - Database - Application Server - Web Server Ideal skills and experience: - Expertise in high availability systems - Strong knowledge of OpenNMS - Proficiency in round-robin load balancing - Experience with databases, application servers, and web servers in HA environments Please provide a detailed plan and timeline with your bids.

We are seeking an experienced freelancer with in-depth knowledge of Oracle RMS for testing pub and sub messages. The engagement will be for one month, with the possibility of extension based on performance and requirements. Key responsibilities include thorough testing of Oracle RMS pub and sub messages to ensure functionality and reliability. Ideal candidates should have extensive expertise in Oracle RMS and a proven track record in similar projects.

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

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

I have a live database that holds several hundred records which now need to be migrated, field-by-field, into a new database. Everything is already structured; the task is strictly copy-pasting each value into its matching field while keeping the original order intact. Accuracy is critical—any typos or misplaced entries will break downstream reporting—so I’m looking for someone who is comfortable working inside database interfaces and double-checking their own work before saving. I will provide: • read-only access to the source database • write access to the destination database plus a short video walkthrough of the required workflow What I expect back: • every record copied over without omissions • consistent formatting of dates, numb...

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

Job Title: Senior SAP Developer – BW on HANA Location: Remote Experience: 5–7 Years Duration: 6 Months Contract Salary: ₹60,000 per month (No PF Deduction) --- About the Role We are looking for a highly skilled Senior SAP BW Developer (BW on HANA) to join our IT team and contribute to our ongoing SAP transformation journey. This role involves working on SAP BW 7.5 on HANA while supporting migration to modern platforms like BW/4HANA and cloud ecosystems including Azure and Databricks. --- Key Responsibilities - Design and develop scalable solutions in SAP BW 7.5 on HANA - Build and optimize data models, ETL processes, and reporting solutions - Perform performance tuning and ensure data integrity & security - Contribute to migration to SAP BW/4HANA and cloud platforms -...

I need a Power BI dashboard built from the ground up with one clear objective: give me an at-a-glance view of our sales performance. The data will come from our existing SQL database and a set of monthly CSV exports; you will connect, clean, and model everything inside Power Query and DAX so the reports refresh automatically. While the core focus is sales analysis, I am open to your suggestions on which visuals and metrics add the most value—think revenue by region, product performance, or even individual sales-team results if that helps highlight trends. What matters is that the final report tells a concise story I can share with executives and frontline reps alike. Deliverables • A ready-to-publish Power BI (.pbix) file with clean data model, measures, and interactive visual...

We are looking for an experienced freelancer who can help us generate qualified leads and business opportunities for Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central services. CentiQ Solutions specializes in Dynamics NAV and Business Central upgrades, SaaS migrations, custom development, integrations, support, and managed services. We are seeking a results-driven professional who can identify prospects, connect with decision-makers, and introduce potential customers interested in Microsoft ERP solutions. Responsibilities Identify and generate qualified leads for Microsoft Dynamics NAV and Dynamics 365 Business Central services. Reach out to potential customers through your network, LinkedIn, email campaigns, referrals, or other channels. Connect us with key decision-mak...

We are looking for a highly skilled Senior Data Engineer with 8+ years of experience in designing, developing, and modernizing enterprise-scale data platforms. The ideal candidate should have strong expertise in Google Cloud Platform (GCP) and hands-on experience building scalable data pipelines, data migration, and modernization initiatives. Key Responsibilities Design, develop, and optimize end-to-end data pipelines on Google Cloud Platform (GCP). Build and maintain scalable ETL/ELT solutions using GCP services such as BigQuery, Dataflow, Dataproc, Cloud Storage, Pub/Sub, and Composer. Lead data modernization and migration projects from legacy/on-premise systems to GCP. Implement data integration, transformation, and orchestration processes for large-scale datasets. Ensure data quality,...

I have a collection of text-based files and scanned images that must be transcribed and entered, by hand, into my online database. Accuracy is far more important than speed, so every record needs to be double-checked against the source before you move on. What you will do • Read each text document or scan, interpret the information, and key it directly into the designated database fields. • Flag any illegible or ambiguous items for my review rather than guessing. • Perform a quick self-audit at the end of each batch to make sure all mandatory fields are filled and formatting is consistent. Deliverable A fully populated database table that mirrors the original content, free of duplicates and obvious errors, ready for immediate use in reporting. I will run a spot...

I need help repairing and transferring an SQL database for my blog/personal site. Requirements: - Expertise in PHP and SQL. - Experience with database repair and migration. - Familiarity with blog/personal site setup. Ideal Skills: - Strong problem-solving skills. - Attention to detail. - Previous experience with similar projects. Please provide a brief overview of your relevant experience.

I am building a suite of customer-focused reports in Power BI that must draw live data straight from our PostgreSQL database. The goal is clear: sleek, reliable data-visualization and reporting that quickly tells stakeholders what they need to know about customer behaviour, trends, and performance. Scope of work You will set up the direct connection to PostgreSQL, write—or refine—any SQL needed for efficient querying, and then craft interactive visuals, drill-through pages, and summary dashboards that load quickly and refresh on schedule. Each visual should be intuitive enough for non-technical users yet detailed enough for analysts who want to dig deeper. Key expectations • A .pbix file containing all dashboards and report pages • Any PostgreSQL SQL scripts o...

I’m ready to roll out a fresh ERPNext instance and need someone who can take it from a clean server to a fully working system. The job starts with the actual installation of ERPNext (latest stable release) on a production-ready stack, then moves straight into configuring the key modules my team will rely on every day: • Accounting • HR & Payroll • Inventory Management • Project Management • Sales Because we’re starting from scratch, there’s no historical data to migrate—your focus is purely on getting the platform installed, fine-tuned, and tested so we can log in and begin entering live transactions. Acceptance criteria • ERPNext and Frappe correctly installed, secured, and accessible via our domain/SSL • Each l...

I need GLPI installed on an Ubuntu Linux server. Requirements: - Integrate with LDAP/Active Directory - Set up email notifications - Connect to a database Ideal Skills and Experience: - Proficiency in Linux, especially Ubuntu - Experience with GLPI installation and configuration - Knowledge in LDAP/Active Directory integration - Database setup and email notification configuration

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.