Databases > SQL
Principal Duties and Responsibilities: To design, create, and implement web applications. To utilize database objects, including tables, and so on. in Web Applications and/or Web PagesTo design, create, and implement end user forms (web based and/or application based) Trains new users on how to use web pages, applications, and so on. Duties as defined by Clients and/or SupervisorKnowledge, Skills and Abilities Required: Proficient Typing skills. Strong Organizational and Analytical SkillsAbility to understand and write code using such languages as: HTML, ASP, ASP. NET, C#, VB, VB. NETUse and/or knowledge of Crystal Reports/Microsoft Reporting ServicesAbility to write Scripts using C#, VB, Java and/or other Scripting languagesUnderstanding of Enterprise Databases (MySQL, MS SQL Server, Oracle) Ability to understand and write simple SQL - Create Table Statements, Triggers, Stored Procandrsquo; s and so on. Ability to Query Data and Analyze Dataandnbsp; andnbsp; Interpersonal Skills: Proven ability to manage multiple tasks with shifting priorities and time framesAbility to understand and prioritize work and workload assignedAbility to meet deadlinesWorks well in and supports a team environmentStrong oral and written communication skillsDemonstrates problem solving skills.
Posted on Sat, Feb 4 at 8:29am
======================================I have a large scale project in mind and I 'd like YOU to help me with part 1. All going well, this could evolve into a lot more work for you. ======================================We are going to start off with a tool that scrapes data from Google's keyword tool (https://adwords. google. com/select/KeywordToolExternal). We will store that in a database table. Next, we will use Namecheap's API to check for domain availability, marking the results back in the database. Pretty simple. To make it a bit more smart, scraping will made through private proxies to spread the load. We will also de-duplicate repeat keywords. That's the summary; full details are provided in the details section. Remember, this is just part 1 to get the ball rolling. The tool gets seriously cool later on:) Part 1 really doesn't have a UI. But later on it will have some basic features. However, design isn't important since the tool is not public-facing. Serious bonus points if you were able to make use of something like Twitter's Bootstrap library (http://twitter. github. com/bootstrap /) and Glyphicon's icons (http://glyphicons. com /) to make it user friendly and slick. I 'd welcome use of PHP and MySQL for this task as I am able to code a little and would then be able to make tiny tweaks myself. If you have a strong preference for another language, then just let me know. You will notice that I have a glowing profile on oDesk, so rest assured that I am great to work with:) All applicants must understand the task details before submitting their bid. Please also include the word " bananas " in your bid so that I know you have read this! Template answers will be ignored! ======================================Full Specification: ======================================The tool starts off with a large empty textarea box. This is where users will enter in a line separated list of keywords (they 'll typically put in around 50 each time). A submit button then adds those keywords into a 'queue ' (ie, into the database with a status of 0 = newly added, we should also store the timestamp of entry, and give each keyword an incremental ID number). The form then refreshes blank and that's all the user sees. Next, the tool needs to fetch data from Google's keyword tool. https://adwords. google. com/select/KeywordToolExternal< / a> is the URL. They use CAPTCHAs if you are not logged in, so we need to have a dummy Google account that is logged in with a cookie to be able to fetch the data. The keywords will go into the " word or phrase " textarea. We also need to select only the " [Exact] " " match type " option. Location should be only " United States " and the rest as per default. We are going to get back a bunch of results broken down into two sections; " search terms " and " keyword ideas ". We are interested in booth. We need to collect and store: " global searches ", " local searches ", and " CPC ". We will also have a database field to store keyword type; 1 for " search terms ", 0 for " keyword ides ". Google provides the resulting data in CSV/XML which might be easier to parse into the database than scraping the HTML table. We are then going to do a domain availability lookup for keywords where local search volume is >1000 and CPC is >$1. We will use Namecheap's free API: http://developer. namecheap. com/docs/doku. php? id=api-reference: domains: check< / a> (I can provide you with the API access code/key, or you can create your own free account for testing). We need to check for availability for. com /. net /. org domain names for the keyword phrase, removing word spacing. So if the keyword is " free ipod nano " then the domain we want to check for is " freeipodnano. com ", " freeipodnano. net " and " freeipodnano. org ". We will have three fields in the database and use 0/1 for availability. That's the process. But we need to add in an additional process that limits the amount of scraping we are doing from our server's IP. I will provide a list of around 50 private proxies (http://proxybonanza. com /). We should make use of them all to spread the load. I suggest only submitting 5 keywords per IP each 15-minutes. Maybe be need to use something like a CRON job to process another batch of KWs every 15-minutes? It would be really great if we could even find a way for those 15-minutes to be less predictable (ie. generating a random 0-5 minute time to add on to the 15, or perhaps sleep/rand would be useful?). The scraper should do what it can to appear as close to a real user as possible (so using a browser user-agent, for example). We don't need to worry about this kind of balancing when performing availability checks with Namecheap. Lastly, we can also filter duplicates. So when the user submits their list of keywords, we can ignore those already in the database. Also, when we fetch for suggestions, we can ignore those that are already present.
Posted on Sat, Feb 4 at 3:18am
SHORT TERM ASSIGNMENT leading to LONG TERM ASSIGNMENTThis is a small project which can lead to an offer for a much larger, 12 months project when you have proven yourself (see the other Job Posting we have - do not apply to that one yet) I operate a small software development house based out of Bangkok, Thailand for the past 8 years, dealing mainly with Canadian and Australian Clients. We are now looking for 2 developers to assist with some maintenance work for bugs and small issues on an hourly basis over the next 4-8 weeks. Developers will need to communicate from time to time to help each other. The project is a Management Information System for a direct-sales Jewellery company out of Canada, its a custom system to handle Client Lists, book Shows, send Newsletters such as show Invitations and Thank you's, track appointment in a Diary (like Google Calender), bulk SMS sending, runs in French and English. Its running SQL Server 2008 rather than MySQL. Its now in its first months of use, so keeping users happy is critical. Its quite stable but we have fallen behind with issue fixing and need urgent help. Interested parties will need to have strong PHP v5/OO, Codeignitor, JQuery, AJAX, and some basic SQL Server. SubVersion and JIRA also very helpful, as is Linux also for occasional Server VPS issues. As this is an short-term urgent requirement, its CRITICAL that you can be productive immediately, so you will need to be 100% familiar/current with all the skills listed, no exceptions. As we have current Developers working on this project we know how long work should take, and will be very carefully monitoring this. The KEY attribute needed is TRUST and RELIABILITY, as this is a LIVE site with hundred of users, and you will need to access their TEST Server directly via our Server, so you will need 2 access logins. The KEY skills are CodeIgnitor and JQuery, as well as some SQL Server (MySQL is not enough, there are too manyandnbsp; andnbsp; differences). When you apply please clearly show us WHY you have built your CLients trust and suggest how we can verify this ie. by us contacting your Clients or other means. WE NEED DIRECT RESPONSES TO THESE QUESTIONS: 1. A quotation to fix issues from JIRA generated emails, with a 4 hr response and 24 hours fix/test/pass time. You will login and use JIRA for this, uploading to our test server. 2. Your skill rating from 1-5 and both #hours (approx) and #projects done in eachPHP5CodeignitorjQueryAjaxSQL Server 2008JIRASubVersion3. Your reasons HOW you have won clients trust and HOW we can verify this4. A guarantee you will be available online in chat (Skype) every work day, and your SkypeID so we can make contact5. A mobile phone number to contact you in case of emergencies if not online, supplied now. 6. If you are prepared to do a shortandnbsp; andnbsp; test task to prove your skills and suitabilityBefore committing to a long-term arrangement we will need a short skills test/task done first as a proof of your suitability. We know from hard experience this is the only sure way to know a person will perform as expected, as outlined by 37Signals here: http://gettingreal. 37signals. com/ch08_Kick_the_Tires. php< / a>---My name is Shayne Micchia, I have been in software development for 25 years, and you will be dealing directly with me.
Posted on Sat, Feb 4 at 2:57am
We are currently looking for 1 or 2 competent programmers. We are a growing company and have many projects lined up. Right now we are looking for UKRAINIAN and RUSSIAN based personnel ONLY!!! If you are not from one of these countries, please DO NOT APPLY, you will only waste your time. We prefer if you are actually in Odecca, Ukraine. That is where our Ukranian office will be. You MUST have EXCELLENT knowledge and lots of experience with: PHPJavascriptHTMLCSS3JSONSQLLAMP server environment (Linux, Apache, MySQL, PHP) Twitter API and app developmentFacebook API and app developmentExperience with other social network API's and Amazon services is a big plus for you also. Knowledge of current web standards is essential. You should be able to develop clean and compliant code that is Search Engine Optimization (SEO)-friendly and easily validated across platforms and browsers. Advanced AJAX experience is also a definite plus!!! You MUST also have a complete understanding of the MVC programming model. This is what we are working with and developing with. You MUST speak 100% fluent Russian and your English MUST be good enough to communicate effectively with our American office. We use Skype to communicate both over VOIP and thru regular messaging/chat. This is an ongoing position and we are looking to build solid relationships for the long term. We also prefer a person who has a good sense of style and design so that the front-end can look as good as the code that makes it run. You must be responsible, professional, and available to reply to various issues within 24 hours, no later. We don't expect you to stay up and respond immediately. We understand you have a life too. But a response at the very least to any message we may send you is absolutely crucial within 24 hours. So for example, telling us you are alive and that you received the message but you are unable to fix the problem immediately is much better than simply ignoring the message for 3 days. I think that's not too much to ask. Please read these requirements carefully. These are the things we require and expect from every qualified candidate. Reply ONLY if you feel you completely fit these requirements and are able to deliver according to our expectations. Good luck!!!
Posted on Fri, Feb 3 at 10:40pm
IMPORTANT: Apply for this job only if you can complete this in less then 24hours from starting! Hi, I am looking to develop a long term relationship with a good Microsoft SQL developer with good c# skills. This is a test project to determine your capabilities. The project will consist of a simple database and one table. the table (UserSettings) will have this column: WebID (nchar 50, not null); UserID (nchar 100, not null); SettingID (nchar 500, not null); Value (nvarchar mx, null). The purpose of this table is to store user setting relative to the web. The WebID, UserID, SettingID will be treated as a " composite primary key " Task 1: Write this stored procedures to perform the most optimum operations: 1) GetSetting (@WebID, @UserID, @SettingID) return Value If the three provided parameters much a query result (1 or 0 records) then return the Value 2) SetSetting (@WebID, @UserID, @SettingID, @Value) return integer (1 or 0) If the specified WebID, UserID and SettingID match a record then update the Value field with provided parameter (@Value). If no such much found then insert new record. if operation successful then return 1 else return 0.3) GetBulkSettings (@WebID, @UserID, @SettingIDCol) select dataset SettingID, Value@SettingIDCol parameter is a semicolumn "; " dilimiated collection of SettingIDs. If the specified WebID and UserID match then select\return all SettingID and Value dataset that match the specified SettingIDs in the SettingIDCol parameter. Task 2: Write a C#. NET Console application that creates and manages a data connection (parameters stored in web. config) to the sql table. Then create these three methods1) public string GetSettings (string WebID, string UserID, string SettingID) returns the Value fieldandnbsp; andnbsp; that matches the specified parameters from the UserSettings table2) public bool SetSettings (string WebID, string UserID, string SettingID, string Value) insert/update the Value parameter in the UserSettings table that match the specified parameters. return true if the operation completes successfully. 3) public DataTable GetBulkSettings (string WebID, string UserID, string[] SettingIDCol) gets many record from the UserSettings table that match the specified parameters and the collection of StringIDs in the StettingIDCol parameter. Returns a DataTable that contains the columns SettingID and Value as the populated result set. Thanks
Posted on Fri, Feb 3 at 10:35pm
Company maintains multiple HTML5 and Flash templates that require Editing and Re-Branding. Sources Available:. SWF;. HTML;. PSD;. FLA. PSD;. PHPSoftware Required: Adobe Dreamweaver 8+; Adobe Photoshop CS+; Adobe Flash 8+; For uncompressing a template ZIP package: WinZip 9+ (Windows); Skills: UI; Flash Action Scripting- AS 2 and AS3 | 3D Effects; Graphic DesignAdobe CS5 DesignerandDeveloperTitle: DMG Adobe Creative Content Developer Skills: Adobe Creative Web/Production Suite CS5/5.5Company uses a variety of technologies including the full range of Adobe Creative Web/Production Suite CS5/CS5.5 integrated with provided ASP. NET, PHP5, VB-Script; VB. Net; Java API, JavaScript code while connecting to MS SQL 8 in a heterogeneous environment that includes Windows and Cloud Sphere. Mobile CSS2.0andnbsp; andnbsp; UI Device Integration- Create GUI for wireless devices: WP7andreg;, Blackberryandreg;, IPhoneandreg;, Android andreg;, Nokiaandreg; - Implement Transactional and web Services- API- Optimize and implement J2ME /. Net Apps- Code client-side portion of wireless applications in J2ME, C#Software unit-testing and bug-fixingWeb CSS3.0 UI Platform Integration- Create GUI for wireless devices: - Implement Transactional and web Services- API- Optimize and implement ASP. Net, JQuery- Code client-side web applications in C# / VB. Net (source-code) Developer ToolsAdobe Professional Design Software: andnbsp; andnbsp; InDesign CS5; Photoshop CS5 (Extended); Illustrator CS5; Acrobat 9 Pro; Flash AS3; Dreamweaver CS5; Fireworks CS5; Contribute CS5; After Effects CS5; Adobe Premiere Pro CS5; SoundatabaSearch Engine Optimization (SEO)oth CS5; and, other such programming languages typically utilized in web 3.0 Content developments.
Posted on Fri, Feb 3 at 9:48pm
- Responsible for ensuring availability and performance of the databases that support the system. andnbsp; andnbsp; andnbsp; andnbsp; - Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning. andnbsp; andnbsp; andnbsp; andnbsp; - To proactively monitor the database systems to ensure secure services with minimum downtime (both SQL Server and SharePoint 2010 interface). andnbsp; andnbsp; andnbsp; andnbsp; - Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management. andnbsp; andnbsp; andnbsp; andnbsp; - Responsible for troubleshooting and problem solving of SQL and SP10 development. andnbsp; andnbsp; andnbsp; andnbsp; - Responsible for improvement and maintenance of the databases to include rollout and upgrades. andnbsp; andnbsp; andnbsp; andnbsp; - Responsible for implementation and release of database changes according to agreed timescales and costs. Qualifications Required (Experience, Skills, Academic): andnbsp; andnbsp; andnbsp; andnbsp; - 3-5 years IT operation with strong understanding of database structures, theories, principles, and practicesandnbsp; andnbsp; andnbsp; andnbsp; - 3-5 years Microsoft SQL Server experienceandnbsp; andnbsp; andnbsp; andnbsp; - In depth SQL Server Database Administration experience, Atmos Cloud, SharePoint experience a plus. andnbsp; andnbsp; andnbsp; andnbsp; - Understanding of, and experience with, server-client computing and relational database environmentsandnbsp; andnbsp; andnbsp; andnbsp; - Experience with data management and data processing flowcharting techniquesandnbsp; andnbsp; andnbsp; andnbsp; - Knowledge of reporting and query tools and practicesandnbsp; andnbsp; andnbsp; andnbsp; - Good understanding of the organizations goals and objectivesandnbsp; andnbsp; andnbsp; andnbsp; - Good interpersonal, written, and oral communication skillsandnbsp; andnbsp; andnbsp; andnbsp; - Ability to present ideas in user-friendly languageandnbsp; andnbsp; andnbsp; andnbsp; - Self motivated and directed, with keen attention to detailandnbsp; andnbsp; andnbsp; andnbsp; - Able to prioritize and execute tasks in a high-pressure environmentandnbsp; andnbsp; andnbsp; andnbsp; - Experience working in a team-oriented, collaborative environmentandnbsp; andnbsp; andnbsp; andnbsp; - Experience of Transactional SQL, and DTS stored procedures. andnbsp; andnbsp; andnbsp; andnbsp; - Good written and oral communication skillsandnbsp; andnbsp; andnbsp; andnbsp; - Responsible for ensuring availability and performance of the databases that support the system. andnbsp; andnbsp; andnbsp; andnbsp; Required Skillsandnbsp; andnbsp; andnbsp; andnbsp; - SQL Server 2008andnbsp; andnbsp; andnbsp; andnbsp; - Database Administrationandnbsp; andnbsp; andnbsp; andnbsp; - Database Tuningandnbsp; andnbsp; andnbsp; andnbsp; - Database Managementandnbsp; andnbsp; andnbsp; andnbsp; - Database SecurityMobile Device Intergration- Create database schemas and xml messaging specs for wireless devices and adapters- Implement GPS mapping and tracking using JSR-179 Location API- Optimize and implement barcode scanning and mobile printing using JSR-82 Java APIs for Bluetooth and peripheral connection protocols- Code client-side portion of wireless applications inandnbsp; andnbsp; XML, XPATH and Java-based scripting language- Software unit-testing and bug-fixingResponsible for product development from concept to delivery; lifecycle- Define functional specifications, content requirements, information architecture and interaction design, through wireframes and detailed design docs- Spec out XML feeds or content and data APIs for apps- Work with multiple brands, technology teams and vendors
Posted on Fri, Feb 3 at 9:22pm
We are looking for a person to make our website, www. totallyfreestuff. com< / a>, look more modern. andnbsp; andnbsp; andnbsp; We don't necessarily want the layout to change drastically, just a more up to date look and feel, as well as user experience. andnbsp; andnbsp; We would like the discussion forums and form submissions to utilize ajax rather than the current method of having entire pages reload. We would also like to add two new features. One is a picture upload option that also allows the user to crop and resize the picture to 150 pixels wide by a maximum of 150 pixels high. The other feature is a calendar based on the calendar at http://arshaw. com/fullcalendar / < / a>The calendar must be customized to allow users to add new items, remove items, and change items. Our new calendar feature is designed to help our users find out which in-store deals, contest/sweepstake closures, and other notable dates are relevant to their interests and needs. andnbsp; andnbsp; As such, a calendar page must be generated that will allow users to choose categories of interest and view the calendar by day, week, or month. andnbsp; andnbsp; Each calendar entry will be a link to a live posting on our site. Our posting system will need to accept new input for automatic posting on the calendar. andnbsp; andnbsp; This job will include adding new fields to our posting system that will interact with the web calendar. Our site is currently running on Classic ASP and MS SQL. andnbsp; andnbsp; We are willing to have the site changed over to PHP/MYSQL if the price is right and no functionality is lost. andnbsp; andnbsp; Otherwise we would like to stick with Classic ASP and MS SQL. Please submit examples of your work.
Posted on Fri, Feb 3 at 7:56pm
