Sql Jobs

615 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Intermediate ($$) - Est. Budget: $1,000 - Posted
DO NOT CALL SCRUBBING WEB SERVICE (WEBSITE) Goals: * Prevent our sales agents to dial out to prospects or leads that are registered with the Do Not Call Registry (National DNC, State DNC and also our internal list) * If the prospect is registered with the Do Not Call Registry (NDNC, STATE DNC OR INTERNAL DNC), ask them for verbal permission to call them back at a later time National DNC is under the FTC (https://telemarketing.donotcall.gov) and they provide us with text files or XML files, containing all numbers within an area code registered on DNC. One file for each area code in the US. This process must be done manually on their website (telemarketing.donotcall.gov) and results are downloaded to our pc. phone numbers are added to the list every day, but we are REQUIRED to update the lists EVERY 30 DAYS. Is our job the check before we dial out, that the number we want to dial, is not present in one of those files that we downloaded. Creation: Create a simple website (web service or web app) where we can check (scrub) phone numbers against do not call list. ***Must have two options for lookup, 1- by typing the 10 digit phone number into a box and getting a response on the screen, saying for example...."CLEAN" OR "DO NOT CALL" or "REGISTERED" or "NOT REGISTERED" 2- By uploading a .CSV file containing phone numbers in column A. and seconds later, get a file back with a .CSV file scrubbed, and in the column B to get response like ...."CLEAN" OR "DO NOT CALL" or "REGISTERED" or "NOT REGISTERED" ***web service must be on the cloud, be accessible from anywhere, but we need two types of login methods, SALES AGENTS with the only option to search for individual phone numbers or to upload a .csv file. and another one for ADMINISTRATORS where they can upload files from FTC, STATE DO NOT CALL LIST and also OUR INTERNAL DO NOT CALL LIST (Costumers that are not registered with DNC but they ask us, not to call them back), manage credentials, IP addresses, etc. *It must have a limitation regarding IP addresses to allow access to page. *create and maintain credentials for the site (AGENTS and ADMINS) ***Also I need to integrate my phone system with the web application, so my phone system will be passing caller id info (in real time when a call comes in to our office) to a URL (web service), and expect a response back, a VALID XML RESPONSE, whether caller id is present in the DNC database or not. For example like "0" or "1" or "registered" or "not registered" so my phone system will know how to handle that call. I can manage the phone system as long as I get the responses back. Example: http://www.webservise.com/cgi-bin/app.cgi?account=%CALLERID Relevant Information: In the US, there are between 265 and 293 area codes, but I currently subscribe to around 20 area codes but planning to add more in the future. Each area code has its own text or xml file, containing the list of phone numbers that CANNOT be called. Prospects that call our office are mostly from those 20 area codes, but sometime we have callers from other areas numbers that we do not subscribe. In this case, we would like to see a result like "CANNOT BE CHECK" or something similar after submitting the phone number for scrubbing. Each text file downloaded from FTC, or state DNC, OR Internal DNC must be uploaded to a database. Files are downloaded from sites often in Compressed Zip files, so to make process faster, we need to be able to upload compressed files directly into web service. The upload section should include (3) sections, to upload NDNC, State DNC and Internal DNC. FTC also, provided me with documentation about how to fetch those text or xml files automatically via API, passing our account id info and a password. (So we do not have to download files manually) ****THIS CAN BE DONE EVERY DAY OR WEEK AND WILL SAVE US TIME, INSTEAD TO DOWNLOAD EACH FILE TO OUR DESKTOP AND THEN UPLOAD IT TO THE WEBSITE, THE WEB SERVICE WILL AUTOMATICALLY FETCH EACH FILE. ATTACHED YOU WILL FIND DOCUMENTATION ABOUT API PROCCESS. IS THIS IS SOMETHING YOU CAN DO, LET ME KNOW, IT CAN BE DONE IN THE PHASE 2 DEPENDING ON THE PRICE. On the web, there is software available for download, but you need to install them on each Agent's Computer and mantian database on each computer which is a thing of the past. If you want to check for those services, just google "DO NOT CALL SRUBBING SOFTWARE" DO NOT CALL SRUBBING SERVICE" Or I can attach screenshots of those programs. I am just telling you this, so you can have an idea of what I need but instead of being installed on each computer, I want to have it as a web service. Attached you will find some files for better understanding, also will be providing some of the software I found on the internet as a reference: http://www.dontphoneme.com/ https://www.evs7.com/free-do-not-call-list-scrubber-2 http://www.donotcallscrublite.com/ https://thedncproject.org/?gclid=CPqz18vz184CFQQIaQodUlUN_A PLEASE SEE REQUIREMENTS IN THE ATTACHMENT FILE
Skills: SQL HTML XML
Fixed-Price - Intermediate ($$) - Est. Budget: $2,500 - Posted
Requirements: - Strong business knowledge of Investment Banking with minimum 4 years’ IT Security/ Logical Access experience - Good understanding of technology and extensive experience with a myriad of IT systems - Solid MS Excel (Intermediate level) and basic Shell scripting and SQL query skills - Experience of Governance Frameworks, in particular IT (SOX for example) - A solid understanding of standard change control policies and procedures and experience working in a dynamic and fast pasted IT - A solid understanding of access control management, recertification and provisioning/de-provisioning principles We offer: - Stable and long-term work among professionals on the basis of contract of employment, B2B contract, contract of mandate or contract of specific work - Real influence on progress of your career path - Work in a team for which your opinion matters - Support of Business Assistant dedicated to the Specialist throughout the entire period of cooperation - Integration events, sport events e.g.
Skills: SQL Microsoft Excel Security Analysis
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
We have existing SSRS Reports We need to deploy them to Reports Server Also RDL reports are not loading in Visual Studio 2013 report designer and not getting deployed
Skills: Microsoft SQL SSRS
Hourly - Entry Level ($) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
You must have advanced experience with rapid miner which is an open source tool. Excel, python, and advanced sql skills are extremely helpful Please reach out. many thanks, Paul
Skills: SQL Data mining Rapid Miner
Hourly - Intermediate ($$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Curiosity and constant urge to learn new technology A critical eye for design and usability Ability to clearly articulate complex technical and business issues to a wide variety of audiences Ability to take a task and deliver on it in an agile environment Team player, great attention to detail, desire and passion to make a difference Database administration experience with Oracle 11g, SQL, PL/SQL, MySQL, PostgreSQL is desired Able to read source code, and basic coding/scripting ability in Java, Perl, Ruby, C#, and/or PHP Previous start-up experience is a strong plus Familiarity with supply chain, transportation, or logistics Bachelor’s degree in Information Science / Information Technology, Computer Science, Engineering, Mathematics, Physics, or a related field Strong multi-tasking skills and open to working non-standard hours.
Skills: Oracle PL/SQL Amazon EC2 Amazon S3 Amazon Web Services
Hourly - Expert ($$$) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
Seeking an advanced analytics architect to help propose an end-to-end, cloud-based, PaaS solution (rough wireframe), blending the best of Big Data, Machine Learning, Predictive and Prescriptive analytics for my startup in development.
Skills: SQL Apache Spark Big Data C
Hourly - Entry Level ($) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
We are a property management company in Grand Rapids MI USA using a property management software called Rent Manager. They have a module that has open access to the files and we have a need from time to time to have specific reports that are not part of there standard report options. I do not foresee these to be large projects or very often. Looking for someone that is an expert in this area that would be very dependable and has vast experience. References will be required. Must have scored the highest in the English language testing
Skills: SQL database programming