SQL Server Stored ProceduresJobs
Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve together!
Need additional hands to add new features and bug fixes in existing web applications Tech Stack .NET6, C#, SQL 2019+, HTML, JQuery, Azure Dev Ops Experience in Deploying application in Windows and Ubuntu 20.04.6 LTS mandatory Preferred fullstack developers with experience in following areas : Messaging, Sharefiles, ShareScreen and Remote Desktop, Audio/Video Calls, Survey cum Poll Platform with real time dashboards enhance UI/UX design and Interactive Graphical Dashboard While its a short term engagement depending on skills can be extended.
I am in need of an e-learning module that simplifies complex technical procedures and industry standards. This module is for employees, with the goal of enhancing their knowledge base and streamlining their understanding of these topics. Key Tasks: - Creating a series of 30 videos, ranging from 15 to 25 seconds each. - Basic 2D animation: these videos should be engaging and visually appealing to ensure optimal learning experiences for the audience. Ideal Skills and Experience: - Proficiency in 2D animation and video creation - Experience in instructional designing, particularly in e-learning modules
...that can efficiently handle receipt management. Key Features: - The main feature required is the ability to Print and Email receipts. This feature should be easy to use and reliable. Customer receipt information should be easily accessible for printing and emailing. - The software should be user-friendly with a simple interface for non-tech savvy retail staff. Data Storage: - I prefer data to be stored locally on the device. This means the software should be able to store all receipt data within the Windows device it's installed on. Ideal Skills and Experience: - Proven experience in developing software for Windows - Strong background in receipt management and/or point of sale systems - Ability to create a user-friendly interface - Understanding of data security and stora...
I'm seeking an experienced WordPress developer to handle the migration of my current website to a new server. I also require a redesign of the website's layout and SEO optimization. Key Responsibilities: - Moving WordPress site from current server to a new one. - Implementing a fresh, modern layout. Desired Skills and Experience: - Proficient in WordPress and server migration. - Experience with website layout design. - Expertise in SEO optimization.
I'm looking for an expert to quickly upgrade my existing Windows server to Windows 11. The main reason for this transition is to ensure compatibility with new software, even though the specific software necessitating the upgrade hasn't been specified. The ideal freelancer for this task should have the following qualifications: - Extensive experience with Windows server upgrades - Knowledge of compatibility issues and tactics to resolve them - Ability to work under tight timelines as this project needs to be concluded ASAP. Your proposal would be more favorably considered if you can detail similar past projects you've completed, and their outcomes.
I'm in need of a skilled developer to create an Android application with ASP.NET C# backend and SQL SERVER database. Key Features: - The app should primarily function as an e-commerce platform, allowing users to browse through products and services. - I require the app to have a chat functionality where users can communicate with the sellers. - Users should also be able to leave reviews for products. Specific Chat Features: - The chat functionality should support text messaging, image sharing, and voice messages. Skills and Experience: - Proficiency in Android app development - Strong experience with ASP.NET C# and SQL SERVER - Previous experience in developing e-commerce apps - Proven track record in integrating chat functionalities within an app - Fami...
I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen is...
I'm looking for an expert in architectural design, specifically for residential projects. My primary need is for detailed, high-quality arch...architectural drawings. Although the style of the property is residential, I want the drawings to exhibit a modern aesthetic. Ideal skills and experience: - Proven experience as an Architectural Designer in residential properties - Proficiency in CAD software - Expertise in modern architectural design - Ability to deliver detailed and high-quality drawings - Solid understanding of construction procedures, building codes, and regulations - Good communication and project presentation skills I encourage those with a strong background in modern, residential architectural design to bid. Show me how your skills and experience can bring my ...
I'm currently undecided about whether to upgrade my existing hardware from Windows Server 2012 to Windows 11 or to implement the upgrade on a new system. Uncertain factors include the advantages of Windows 11 and the requisite technical skills for a successful upgrade. Key Requirements: - Expertise in Windows Server 2012 and Windows 11 conversions - Ability to provide guidance on whether an existing system upgrade or a new system would be more advantageous - High degree of flexibility in project delivery as the completion date remains undetermined Desirable Skills and Experience: - Extensive experience in Windows system upgrades - Demonstrated knowledge of Windows Server 2012 and Windows 11 features - Excellent problem-solving skills and adaptability - Strong...
...negotiating with the insurance companies to ensure the highest possible settlement for me. Ideal candidate would have: - Proven experience in handling home insurance and property damage claims, especially those related to fire damage. - Strong negotiation skills and a track record of successful outcomes in dealing with insurance companies. - Knowledge of the insurance industry, policies and procedures. - Excellent communication and interpersonal skills to ensure effective interaction with all parties involved. Your role will not only be to negotiate with the insurance companies but also to guide me through the process, ensuring I understand the steps, timelines and the requirements. The aim is to secure optimal settlements in a timely manner while also providing a high level of...
I'm in need of a professional to monitor a set of CCTV cameras that will be installed both indoors and outdoors. This role can be performed from the comfort of you...- Detecting and reporting any signs of theft or suspicious behavior. - Ensuring that safety measures are being followed and compliance with regulations is maintained. It's important that you're able to manage monitoring 1-5 cameras simultaneously. Ideal skills and experience for this job include: - Previous experience as a CCTV operator. - A good understanding of surveillance protocols and procedures. - Strong attention to detail and the ability to stay focused for long periods of time. - Excellent communication skills to report any observations effectively. Note: If you fit these criteria, I'...
I am in need of expert assistance to help set up my Apache Tomcat 7.061 server on a Windows 2019 machine, compile a War file and get it up and running. The War file serves as a dashboard to an app previously functional before migration to a new server. Encountered issues include server configuration and deployment errors. The ultimate goal is to have the file accessible here: Ideal candidate should have: • Proficiency in Windows server management • Extensive experience with Apache Tomcat server setup • Proficiency in War file compilation • Ability to debug and fix server configuration and deployment errors Knowledge of the app/dashboard's functionality or code changes made post-migration may not be necessary, as specif...
I need an experienced IT expert to install SQL Server 2019 and the Landmark Compass software on a Windows Server 2019 based system. Key Responsibilities: - Install SQL Server 2019 on Windows Server 2019 - Setup Landmark Compass on the same server Key Skills: - Familiarity with Windows Server 2019 operations and configurations - Extensive experience in SQL Server 2019 installation and setup - Working knowledge of Landmark Compass software The ideal freelancer should have a proven track record of managing and adjusting settings in Windows Server 2019 and a firm understanding of SQL Server 2019 installation. Your role is primarily installation and setup, so no coding or SQL development is ...
I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen is...
I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen is...
I require a proficient Pl/SQL programmer to assist me in writing stored procedures for my database. Your primary goal is to focus on the programming aspect of Pl/SQL, specifically in creating stored procedures. This is key to the project and will require a deep understanding of both database management principles and the syntax of Pl/SQL. Key skills and experience needed: - Proficiency in Pl/SQL programming - Proven experience in writing stored procedures - Strong understanding of database management and architecture - Excellent problem-solving skills - Attention to detail and accuracy in coding Your work will contribute significantly to the efficiency and effectiveness of my database system. Please be sure to have a ...
...Design : Design already done on Figma English version : (Copy)?type=design&node-id=0%3A1&mode=design&t=fWuFnb5PnhqXNVYT-1 French version : The project includes : - UI integrations in apps - API development - API integrations - Server deployment and configurations - Testing and bug fixations - Beta live - Go live Timeline : The preferred timeline for app development is less than 6 weeks Ideal Skills and Experience: - Strong experience in developing native mobile apps for both Android and iOS platforms - Proficiency in app development languages such as Java or Kotlin for Android, and Swift for iOS - Ability to work efficiently
I'm seeking a savvy IT professional to establish a large-scale business email server with over 500 accounts. Furthermore, successful integration with Mailchimp for cohesive email marketing purposes is paramount. Essential aspects of this project include: - Setting up 500+ accounts flawlessly - Ensuring the potential for analytics and reporting Ideal candidates should have: - Extensive experience with email server setups - Profound understanding of Mailchimp integration - Previous experience in working with Google Mail Server - Capacity to provide detailed analytics/reporting tools I am looking forward to working closely with you to achieve streamlined email systems. Your expertise will drive email marketing success within my organization.
I'm in need of a skilled professional who can help manage my Woocommerce, Wordpress, and Linux server. Ideal Skills: - Proficiency in Woocommerce and Wordpress - Experience in Linux server management - Knowledge of SEO and site optimization - Ability to work on a weekly basis, maintaining and updating the website Key Tasks: - Weekly website updates and maintenance - Plugin and theme installations - Server optimization and security updates - Critical optimization for website speed and performance Your work will be essential in keeping my website running smoothly, secure, and optimized for speed and search engine visibility.
I require a dedicated developer who can effectively create the backend logic for my college project; an E-commerce website. This site will primarily deal with physical products. Key Features Required: - E-commerce Capabilities: The site should facilitate the buying and selling of physical goods. Familiarity with creating product listings, shopping carts, and checkout procedures is a must. - Content Management System: I need a simple and efficient way to upload, remove or modify the products on the site. - Payment Gateway Integration: The website must securely process payments. Prior experience with integrating payment gateway services is required.
...a Linux operating system. The aim of this project is to ensure a sophisticated and smoothly running CRM solution at the earliest. Specifically, here's what I'm looking for: - Speed: The project should be completed ASAP. Please only bid if you're able to deliver within a short time frame. - Expertise: You should have past experience installing SuiteCRM, particularly on Linux. We will: Set up SQL database Provide database username and password. Provide cPanel access The project is to install SuiteCRM v. 7.10.4 No modifications or importing of data is needed Set up one Admin account – we will provide a username and password When your installation is complete we will (within one business day) test your installation by creating a Lead, and converting the Lead...
...Laravel based SaaS systems. The purpose of this staging server would be to test changes to the system before deploying them live. It's crucial that it accurately simulates the live environment to ensure a smooth transition and minimize potential issues. I've been running into licensing error with the SaaS when attempting to setup the testing environment so I would like try to do the following: a. I need a backup taken of the Production server. b. Then I need to have it restored to a subdirectory on the new server c. I need all the passwords, FTP logins, admin logins or any other sensitive information changed, and any URL’s updated. I'm also open to other suggestions on how I can have a restore my prod environment on a separate cloud se...
I'm...Azure expert to help me enhance the remote desktop services (RDS) on my Windows Server 2019 Datacentre. Key tasks involve: - Increasing the concurrent RDS remote sessions from 2 to 5. - Users are already configured and operational- it is just concurrent sessions that are the issue beyond 2. - Ensuring the transition is seamless for users and does not disrupt existing services. Ideal skills and experience for this project include: - Proficiency in Azure and Windows Server 2019, with a proven track record of successful RDS configuration. - Strong understanding of user access control and permissions, particularly in a business context. - Familiarity with accounting applications and their configuration on a server. - Excellent communication skills and the abi...
Looking for skilled programer to create for me a server based bot which use my twitter account and monitors people i follow to instantly create a reply when they create a new tweet. Should have limitations on -replies per hour -replies per day -reply max x time per week on single specific account
...email notifications do not work for some reason (on server with webUI @159.65...) The email sending works with cron there contains 1 task here /var/spool/cron/tabs/root and 4 here as i understand /var/spool/cron/tabs/serg guess user serg is not configured properly(but it is a full disk copy, so not sure) or cron tasks are not active or lunching.. also i see 3 cron procs on old sever (ps-A|grep cron) and only 1 on new server... you can change email in scripts and test (the email sending is working ok tested it with small /root/) p.s. you can check working details on old server @213.168.... I. the most important but could take more time The statistics section do not work at all on the New server here is active clients on OLD server(s) (Active se...
...Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong Excel proficiency: The successful freelancer will be highly skilled in Excel, with a proven track record of creating user-friendly and effective forms. - UX/UI design: An understanding of user experience and i...
I'm looking for a proficient Codeigniter developer who can urgently dive into my project and rectify unspecified bugs/errors. The details of the issues...properly working The exact pages or functionalities affected are not clearly pinpointed yet. It's a task that requires you to have an in-depth understanding of Codeigniter, and the ability to quickly identify and resolve problems within the project. Key Skills and Experience: - Strong experience with PHP and Codeigniter framework - Advanced troubleshooting and debugging skills - Proficient in SQL and server/database connections - Ability to detect and fix broken code rapidly Kindly note, this work is time-sensitive and needs to be completed ASAP. Please bid if you are immediately available and can dedicate e...
...need expert assistance with my live server running on Linux. I have specific tasks related to Plesk web admin configuration that I need to get done. - Email Server Configuration: I require help with server email send and receive settings. You should know how to work with Plesk to ensure seamless email transmission. - Security Settings: Solid experience in configuring security settings in Plesk is important. You should be aware of best practices to secure a linux server running Plesk. - Backups: I also need help in setting up backups. Previous experience in backup configurations in Plesk on Linux Server is ideal. A proven track record in handling Plesk Administration, specifically on Linux servers, along with an in-depth understanding of email ...
I urgently need a server expert to bring my CentOS server back to life. The server stopped working after I messed up the iptables. I have rescue mode enabled , I need someone work over any disk and solve this and fire the server again now
Dear developers, I am looking for a skilled python engineer that is able to create a ML engine which is capable to extract specific datapoints from the pdf files and save them as per set of rules to sql table. system has to run offline, so no online solutions will be accepted as they cannot be used for this project. current problems: 1. large part of documents are scanned, but data is digital. essentially form was printed and scanned upon completion. 2. scanned files are tilted. 3. scanned files have noise which require removal of it. 4. few scanned documents require quality enhancement. 5. some scanned documents have different zoom. 6. all files have checkboxes. 7. specific datapoints can change location within the file, so engine must search for it and find it. there is maste...
I'm looking for someone who can help me set up a dedicated game server on my Windows PC specifically for V Rising. Here are more details of the project: - **Purpose**: The dedicated server will be used solely to run the game V Rising. - **Player Anticipation**: The server should be able to accommodate up to 10 players simultaneously. **Skills and Experience Needed**: - Experience in setting up game servers, especially for V Rising. - Proficiency in working with Windows operating system and related server configurations. I am seeking someone who is reliable and can commit to delivering a functional game server in a timely manner.
As a thriving business, we're seeking an experienced Laravel and SQL developer for our upcoming web development project. The developer's main task will be to bring to life our concept of designing and implementing a responsive, user-friendly web application. We're in need of: - Laravel Web Development: Building a robust, intuitive web application using Laravel PHP framework. Utilising Laravel's features to their maximum potential. - SQL Database Management: This includes maintaining and optimizing our SQL database for this upcoming project, ensuring the data structures are well-designed and functional. - Backend API Development: We have several third-party services which need to be integrated into our application through backend API Developmen...
I am looking for an experienced professional who can assist me in purchasing and setting up RDP on a dedicated server. Here are my specific requirements for this project: - Set up RDP on a dedicated server with Windows - Must include remote access software in the set up - Anticipating more than 20 simultaneous connections for the RDP, the system needs to be optimized for this high volume - Prioritize strong security measures for the setup Ideal candidate should have experience with Remote Desktop Services, Windows server management, and understanding of proper security protocols. A strong understanding of networking and high connection environments will also be highly desirable for this project.
More details: What specific website(s) do you want to scrape data from? Website 1, Website 2 What specific data do you want to scrape from the selected websites? Text content, Tables What information would you like to extract from the text content and tables? Product names, Prices, Descriptions, reviews, size and color, occasion, return and country of origin, category, fabric, weartype
Skills Required Python Aws services-S3, glue, athena, sagemaker, feature store Sql UI/ API/SWAGGER PAGE Good in ML 5 days in a week Remote support role You will have to help developer for completing the task Timings - 9 to 11 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 400 INR /h
We are urgently looking for very good system admins with many years experience handling linux servers to solve a boot issue where installing Grub is corrupted. A very good Freelancer has been working on it already but even with his very high score and good skills he hasnt been abkle yet to get it done. So, please do not react if you are not very good in solving...where installing Grub is corrupted. A very good Freelancer has been working on it already but even with his very high score and good skills he hasnt been abkle yet to get it done. So, please do not react if you are not very good in solving these kind of things as you need to work with the freelancer who works on it now and he has done already the basic things. So we need someone who can help him. Server is linux/ubuntu and...
I am in urgent need of a developer to help me delete some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files d...some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files do not involve any specific criteria for selection. The process is straightforward, and all relevant files need to be removed. Ideal skills and experience: - Proficiency in database management and SQL - Experience in managing ecommerce and affiliate systems - Ability to work under tight deadlines - Good communication and ...
...a skilled writer who can create engaging blog posts for my site. The focus will be on immigration services. Key Requirements: - Your writing should be informative, engaging, and easy to understand by a diverse audience. - Your content will need to be well researched and should include citations from reliable sources. - You must have a strong understanding of immigration services, laws, and procedures in the US. Deliverables: - A series of well-written, SEO optimized blog posts on immigration services. - Each post should be around 800-1000 words in length. - The content should be ready to publish with minimal editing. Ideal Candidate: - Proven experience in writing engaging blog content, preferably on immigration services. - A background in law, HR, or similar field would be a...
I'm seeking experienced professionals who can help transi...to a new one. My old page has met with a permanent advertising restriction, necessitating this move. Below are the specific tasks required: - Configuring settings of the new Facebook page - Expert fan transition from the old page to the new one - Addressing any potential issues encountered during the process The ideal candidate will have: - Exceptional knowledge of Facebook's policies and procedures, particularly fan migration - Proven experience handling similar projects successfully - Ability to handle possible difficulties arising during the transfer I do possess access to the old Facebook page which should ease the transition process. Your expertise and assistance are, however, fundamentally necessary f...
...added advantage Must have executed at least 3 medium/large implementations on ThingWorx Experience in writing ThingWorx services in JavaScript Industry standard UI creation using ThingWorx Mashups Experience with PTC Kepware Experience with DevOps is a plus Experience on working in scrum framework DBMS Skills: RDBMS (PostgreSQL, MSSQL and others) and NoSQL Basic understanding of SQL and API connections Functional understanding of JSON, REST APIs and read API documentation Understand business requirements and translate them into well engineered and integrated technical solutions Certification in Cloud Technologies is a big plus Client focused to understand and appropriately respond to our client’s business needs Guide and mentor team members Versa...
Saya sedang mengerjakan project server API menggunakan FastAPI dan saya perlu mengimplementasikan memory cache menggunakan memcache untuk komunikasi antara workers. Server ini memiliki sistem autoscaling dengan object Server yang saya ingin share diantara setiap workers dari FastAPI. Requirements: - Experience in Python - Experience in Multithreading / Multiprocessing - Memcache, redis, or any other in memory database
... One of the forensic artefacts was a computer containing a single hard disk. A forensic imaging technician has created a forensic image of this hard disk and stored it securely on one of your organisations servers alongside a file containing the hash value of the image. Your task is to analyse the forensic image as part of the investigation and produce a report based on your management of the case, your analysis and your findings. You will have to: setup your forensic workstation for your analysis, which would include any forensic tools that you feel are appropriate for the job, download a copy of the forensic image from the server to your forensic workstation while addressing continuity and integrity issues, carry out a forensic examination of the evidence file that yo...
...service experience, create engaged customers and facilitate organic growth ● Manage large amounts of incoming queries through multiple channels (voice, in-app, email) ● Taking ownership of customers issues and following problems through to resolution ● Keep accurate records and document customer service actions and discussions ● Analyze statistics and compile accurate reports ● Follow communication procedures, guidelines and policies ● Take the extra mile to engage customers Skills and Experience Required: ● Experience in providing customer service support, preferably in the financial services industry (min 2 years) ● Excellent knowledge of management methods and techniques ● Proficiency in English ● Ability to work 9-7 pm Indian Standard Time with the requisite devices to unde...
I'm seeking an expert to build a PowerBI solution, primarily for financial planning and analysis (FP&A). Key project requirements: - Robust Integration with our SQL database to pull the necessary data. - Proficiency in creating illustrative Charts and Tables in PowerBI, enhancing data interpretation. - The dashboard should effectively track and analyze the key metrics such as Revenue, Profit Margin, and Sales growth. Ideal freelancers applying for this project should have: - Demonstrable experience in PowerBI and SQL database integration. - Solid background in creating visually engaging dashboards, specifically using Charts and Tables. - A solid understanding of FP&A metrics. - Proven track record in delivering similar projects. Please submit your bid with...
Currently, my project requires changes in the Content-Type in Wowza Server to ensure compatibility with a custom video player. * You will need to edit the Content-Type to "application/" from "text/plain; charset=UTF-8". This change is crucial to support our unique player. Ideal skillsets for this project include experience in streaming protocol modification, familiarity with Wowza Server, and working understanding of Apple HLS. Knowledge of various container formats is also beneficial.
... One of the forensic artefacts was a computer containing a single hard disk. A forensic imaging technician has created a forensic image of this hard disk and stored it securely on one of your organisations servers alongside a file containing the hash value of the image. Your task is to analyse the forensic image as part of the investigation and produce a report based on your management of the case, your analysis and your findings. You will have to: setup your forensic workstation for your analysis, which would include any forensic tools that you feel are appropriate for the job, download a copy of the forensic image from the server to your forensic workstation while addressing continuity and integrity issues, carry out a forensic examination of the evidence file that yo...
