SQL Jobs

I’ll like to do servicenow integration with psql. May be through aws lambda or any other best way that you suggest. Acceptance criteria If ticket is opened with sql file attached and got approved it should trigger changes to psql database so Just to be clear Servicenow ==> lambda ==> psql ==> return result to servicenow comment section

OWD -dimensions -facts -snowflake schema -star schema -ETL/SSIS Documents -Design & Architecture Document -Information Sourcing -Mapping-Document -ETL - Strategy Document Data Quality Services (DQS) -The discipline of Data Quality Assurance -SQL Server DQS capabilities and features -Creating DQS solutions -The SSIS DQS Cleansing component -Matching Policies and Projects -Administering DQS

Little PHP SQL Issue to fix. Only at Team Viewer.

I need some one to give me an research based article. I am expected from someone who have a knowledge of SQL n NOSQL to conduct research about current and future Database technologies by mantioning topic: List and discuss the four basic categories of NoSQL databases: outline the differences between these categories and give examples where these are used. Note: Word limit 500 to 550 words. Time i...

data needs to fetch in ui5 ,odata services issue

I’ll like to do servicenow integration with psql. May be through aws lambda or any other best way that you suggest. Acceptance criteria If ticket is opened with sql file attached and got approved it should trigger changes to psql database so Just to be clear Servicenow ==> lambda ==> psql ==> return result to servicenow comment section

This project's goal is to build a simple management system for a travel agency using exclusively PL/SQL. The travel agency is called Fly Club and this system should help the internal operations team to manage clients, suppliers, sales, travel offers. It should have at least 10 build in complex reports like sales by clients, by seasonality, destination,etc. It should also have guideline. I h...

3 user types - employee, hr, approver screens - employee master, department master, leave / permission application, attendance, payroll backend - sql; front end - dot net or php

I have a healthcare dataset in Excel. Need to draw insights from the given dataset. Requirements are given in separate word document. There are 4 questions which need to be answered. Need some one with strong data analysis skills who can use SQL and ETL to validate and load data and present analysis in power point presentation. Dataset has 25000 rows. Also need couple of Tableau visualizations. Ne...

Your task is to write the SQL developer application for the Smartcard Financial Settlement System. You are required to create the daily settlement system and associated report. The application is to run in the Oracle Database and is to be written using the PL*Sql language. For further info pls message me thanks

Long term work for a dedicated Core PHP, MySQL and Javascript developer to work on a existing Accounting system. I DO NOT NEED ANY COMPANIES. I DO NOT NEED FRESHERS. MUST BE EXPERIENCED. The developer must be able to work full time You should have an understanding of Accounting and Inventory functionality and be able to work as part of a team. To Do: 1: One issue you will need to solve is mul...

RESPONSIBILITIES/DUTIES: Heavy Data entry/Administrative tasks Updating client information in computer system Running and processing multiple documents utilizing Microsoft Word, Excel, and Access Inputting purchase orders Other various administrative tasks,Inputs information from a variety of sources into a computer database. May take customer orders and enter them into a pre-established tracking ...

SQL JOIN two tables and assign some video link for owner. All must be done from chrome remote or teamviewer. This script is pure php... not wordpress

I have data files in excel format that contain thousands of rows of information that when i load into powerbi is slow. This database will grow to millions of lines of data soon. I need help building a sql database that excel can easily feed to lighten the load in powebi.

Need help with actico tool building

Actico rule modeling insert fb into the database need to work with someone need a help

We are looking for English person that can teach php and mysql. English a must. Thank you

Require a freelance Tally Definition Language developer for creating interface from tally to other Applications. More details when connected.

I developed a wordpress plugin and I need the development of php files to install and uninstall the plugin itself. The installation file must copy all the plugin files to the [login to view URL] folder and execute the statements of a sql file to create tables and indexes. The uninstall file must delete the tables and indexes created by executing the statements of a sql file. Furthermore the uninst...

Hello I have the SSRS 2016 Application which pulls the data from SharePoint list (SP2016) and need assistance in how to build reports and show the report in a particular way e,g, show by month, by car, by year and then shall all ... etc. its like a KPI board. I shall allow invite you via webex for the demonstration where you can also gain control. Contact me please for questions.

Location - Bengaluru (This is not a remote project) Salary - 80k per month Contract duration - 6 months Experience - 3 to 5 years Skills - Java, AngularJS Description - We are alooking for a full time, full stack developer with expertise in Java + AngularJS. This is a 6 months contract engagement with a multi national client company with more than 10k employees in India. Responsibilities # Ana...

I have a fiscal printer Tally and Bixolon SRP-350 i need to integrate my fiscal printer with www.lightspeedhq.com. Create a API to fetch data from LS to sql database Create a local web portal, to audit all transactions. Print report x, report z, re-impressions, credit notes and reset printer. the invoices and credit notes must be printed using the fiscal driver.

We need someone who can work on High Level Architecture Diagram, Dataflow Diagram, Security Diagram and Interface Specification

Looking for MSBI/SQL professionals with the following credentials: At least 4+ years of experience in SQL development Proficient in writing T-SQL queries, stored procedures, functions, views, CTE etc. Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels Ability to understand functional / technical specifications Should ...

I have a Stripe account in which I bill approximately 90 people on a monthly basis. These 90 people have signed up for various programs. (e.g. "Customer1" is taking "Program1" and is paying $100/month OR "Customer2" is taking "Program1" and "Program2" and paying $149/month). I need the following metrics/reports. A list of all Customers with Sub...

1) Student Profile (Institute can only add students) 2) Institute can add or remove student any time. 3) Attendance Notification (institute will get complete attendance notification of present and absent students by their selected class and courses) 4) Online database. 5) Attendance will work on biomatrix. 6) Institute can get/print complete attendance of particular student. 7) Student data base...

Seeking SQL expert for the creation and modification of database triggers for Dynamics GP ERP application. See attached for full project scope.

I have two databases: 1st one is with a free text description and the 2nd one has records that has to matched with the first one. See the picture attached. You may choose the technology and the platform to develop it. I need an approach similar to this one: [login to view URL]

We are looking for a Senior Java developer with J2EE project- and RDBMS experience to help scale, optimize and maintain our database environment. This is a 100% Remote/Work from home opportunity with a California, US based IT company who develop SAAS software. You will focus on improving performance and platform integration of our MSSQL and MySQL database implementations. This includes building...

Mysql database Optimizations for Microsoft applications

Mysql database Optimizations for Microsoft applications

Need to develope Easydev template (ReactJS based). Main menu: deposite system, e-commerce, email, transaction history. Note: don't ask budget over I placed. Thank you.

We are working on the data center project, we get the requirements related database administrator time on time. we looking some one based on project on project how now about Data optimizations.

oracle adf back up needed immediately

We have a SQL scripts that function properly until now. We need modifications to the script to produce a different format Currently we cannot provide access to the database that been used (but this script only accesses two tables from the database mention above) Please see and study the attachment as follows 1. The script that is currently used 2. CSV file generated ( AirNZ monthly db APR 19 AK...

Oracle and MySql database administrator

I am looking for a professional team to develop website like WikiHow with similar features including: Articles posting, review, Sub Admin allocation etc. You need to confirm what plugins you would require to build the site and list all the features from your understanding to agree before allocating the project. PLUS: If you have knowledge of GAMIFICATION (like badges to entice people posting, r...

Looking for freelance IT trainers for SERVICENOW, SELENIUM, SALESFORCE, PLSQL, We're currently looking at these courses and certification : [login to view URL] Fundamentals for ServiceNow Admin Certification [login to view URL] Development Fundamentals for ServiceNow Developer Certification [login to view URL] Specialist (ITSM) -CIS IT Service Management

We have our wearable device finished. We just need a full stack developer with working experience on a framework and SQL to set up a web app(angular, react, vue). Our wearable sends biometrics data to our app. The app will send data to our database. We need a web app to request data from our backend and display it. The web app will also serve as an admin site. This will be a basic web app to he...

Export, Transport and Load (ETL) SQL Developer needed for remote work. Must be proficient with SQL Server, Stored Procedure, Trigger, Functions, Transactions. Must have at least 7+ years experience!!!

The purpose of this project is to create programs that will transform IMS UNLOAD (Utility) files into comma delimited files that can be imported into SQL Server Database tables. This will require reading the Unload files and transforming them into a usable input format utilizing the schema definition files that are also included. See attached files.

android home appliance application for home electronic repair service

Looking for 4-5 Azure professionals / developers who can start work immediately. Please see skills requirement underneath and let me know if you have require competency. This requirement is open for all levels but would prefer the candidates with more than 4 years of experience (no upper limit on years of experience). Skills Required 1. Azure Container Instances (Docker) 2. Azure SSIS, SQL Server...

Planning the development of a mobile application available on android and ios. This one will have to integrate the following functionalities: User account, login with Facebook or Google, Location, mapping QR code Scanning Point accounting system via QR code scan Basket Push notifications Thank you !

need help of and database specialist to design a cms design er model design databse inset/upload data from dataset then normalize it upto 3nf ITS simple work for learning purspose

In attached document there are two tables which contains ID,AccountNo,Date,Amount need to match the values between table based of different rule No of records in table will be more than 10,000,000 so need to mange time complexity and matching rule will be based on priority

I need help to modify a sql database. i have a "name" table which has a ManyToMany relationship to another table called "hobbies". The third table "hobbies_id_name_id" contains the relationship between name and hobbies table. I need a sql query to fix the relationship table and delete the duplicates from the name table name table: id name 1 tom 2 tim 3 lisa 4 jan...

Hello I am trying to build form/ redesign the form from the OEM application where it can establish search fields and provide a customised form as well as provide the data in the different form as well. The application is built on .Net & SQL. I do not have the source code, however as per the OEM I need only the RestAPI for performing the action. We can have a call regarding the same for you...

I had a Point of Sale software program developed for clothing stores. The programmer is now other-wisely occupied. The official Value Added Tax rate has changed and the software does not allow the user to change the tax rate. My short term solution is to reprint the tax invoice from a query that takes the data from the database and recalculates the tax. I have an MS DOS batch file that connects t...

I have the database need to review and make work on my computer 64-bit ACCESS 2016