Sql server 2005 stored procedures jobs
I am seeking a proficient Yellowfin developer to assist in creating and modifying reports and dashboards. The primary data source will be SQL databases, and the preferred method of data visualization is through tables. Key Responsibilities: - Design and implement new reports and dashboards within Yellowfin - Modify existing reports and dashboards to meet changing needs Ideal Skills and Experience: - Extensive experience with Yellowfin - Proficiency in working with SQL databases - Strong skills in data visualization, particularly in creating and interpreting tables - Prior experience in creating and modifying reports and dashboards The project needs to be completed within 1 month.
...insights and actionable solutions. With a strong background in data analysis, statistical modeling, and data visualization, I have the expertise to tackle complex problems and deliver meaningful insights to drive business growth. I have extensive experience working with various industries, including healthcare, finance, retail, and technology. My skills include using tools such as R, Python,SAS, SQL, Shiny, PowerBi and Tableau to manipulate and analyze large data sets, as well as presenting findings in a clear and compelling manner. I am a self-starter and enjoy working independently, but I am also a strong team player and thrive in a collaborative environment. I am constantly seeking new challenges and opportunities to grow my skills and deliver value to clients. If you'...
...that will use the app - a Section where the professional/assistante can CRUD clients, services that will be provided, working hours (to lock or to be free on the calendar) - Automated reminders: The app should send automated reminders to users about their upcoming appointments - using whats app and e-mail - Find free hours to schedule appointments based on the calendar - All data must be cloud-stored - for now it is only a web-based application, but soon I will request a mobile app follow some examples I am basing on: Ideal candidates for this project would be developers with experience in creating booking apps or appointment scheduler web apps. Understanding of user-friendly interface design and experience
I'm looking for an expert to help me connect my Visual DataFlex v17.1 application to a Microsoft SQL Server through a VPN. The primary use of this connection will be for data storage and retrieval. Key Requirements: - Extensive experience with Visual DataFlex, particularly v17.1 - Proficient in Microsoft SQL Server - Familiar with VPN configurations - Strong understanding of data storage and retrieval systems Your task will be to ensure seamless integration and optimal performance of the application with the SQL server. Please include in your bid your relevant experience and any similar projects you have completed.
...advanced analytics Certifications - Databricks Certified Data Engineer Associate, Databricks Certified AI/ML Practitioner AI/ML Development- TensorFlow, PyTorch, Hugging Face, OpenAI GPT models, Google Vertex AI Generative AI- DALL-E, ChatGPT, MidJourney, Runway AI Data Engineering- Data lakes, pipelines, Tableau, Power BI Process Automation- UiPath, Automation Anywhere Programming- Python, R, SQL, APIs, cloud platforms (AWS, Azure, Google Cloud) Security Data encryption, access controls, real-time threat monitoring Key Use Cases: Industry AI Solutions Impact Sales & Marketing- Conversational AI for real-time insights from sales/marketing data and competitor benchmarks Improved decision-making, enhanced campaign ROI, faster go-to-market strategies Finance- Predictive...
I'm looking for an experienced Java backend developer to help build a robust web application using Spring Boot. Key Requirements: - Expertise in Java and Spring Boot - Proven experience in web application development - Strong understanding of user authentication processes - Proficient in database integration Ideal Skills: - Extensive knowledge of RESTful API services - Familiari...application development - Strong understanding of user authentication processes - Proficient in database integration Ideal Skills: - Extensive knowledge of RESTful API services - Familiarity with security protocols for user authentication - Experience with various databases Please provide examples of previous projects that demonstrate your capabilities in these areas. The application should use a SQ...
I need an experienced WHMCS coder to modify my existing tokenized payment gateway code. The modifications should ensure that the correct card expiry date is stored during tokenization and that certain payment error codes trigger the removal of stored data. Key Requirements: - Modify the code to store the correct card expiry date during tokenization. - Ensure that specific payment error codes lead to the removal of tokenized data from the user's profile and the payment switch vault. - Codes that should trigger immediate removal include but are not limited lost/stolen card and expired card, therefore they should be configurable. - Implement a system to notify the user via email to load a new card ASAP. Ideal Skills: - Extensive experience with Tokenized WHMCS payments....
Job Title: Full-Time Oracle PL/SQL Developer (Remote) Location: Remote (Work from Home) Job Type: Full-time, Freelance Experience Level: Mid-Senior Level About Us: We are looking for a dedicated and skilled Oracle PL/SQL Developer to join our team on a full-time, remote basis. In this role, you will work primarily with Oracle 19c, focusing on developing and supporting both Online Transaction Processing (OLTP) and Batch Processing systems. The ideal candidate will bring deep expertise in Oracle database technologies, including PL/SQL and SQL, and be able to work independently while collaborating remotely with our development team. Job Description: As an Oracle PL/SQL Developer, you will be involved in designing, developing, and maintaining critical OLTP ...
Project: Configuring NATS Server in Docker Container Objective Hire a developer to configure the NATS Server within a Docker container, designed to support a real-time communication application. The server must handle user authentication, store messages in buckets using JetStream, and facilitate communication via WebSocket and MQTT. Project Scope Technical Requirements Authentication: Implement user authentication using username and password, assigning specific permissions per account. JetStream: Configure efficient message storage in buckets with a robust organization. WebSocket and MQTT: Configure support for simultaneous WebSocket and MQTT connections, enabling communication between users. Account Management: Create isolated namespaces for each user. Configure topi...
...button number 7. Task 8 (14p): Write a macro that asks for eight numbers from the end user with an Userform. If any of the numbers in the User form is negative, the macro changes the number to zero. Then the macro gives the unique numbers, but not the number zero, one by one to the end user with a message box and writes all numbers (except zero) in cells Q1, R2, Q2, R3 and so on. You must use procedures. Note that if all numbers are zero before printing, nothing is given to the end user nor printed. If the end user has not given all the eight numbers (there are empty boxes on the Userform) the macro will give an error message to the end user and does not start with any printing until all eight numbers have been given. With unique numbers means that if there is for example the n...
...payment gateways (e.g., Stripe, PayPal) using secure and compliant methods to handle transactions. 3. Performance Optimization: Caching: Use caching strategies (e.g., Redis, Memcached) to reduce load times and server requests for frequently accessed data. Load Balancing: Implement load balancing to distribute incoming traffic across multiple servers, ensuring high availability and reliability. Efficient Queries: Optimize database queries to ensure fast data retrieval and minimize server load. 4. Security Best Practices: Input Validation: Validate and sanitize all input to prevent SQL injection, XSS, and other common attacks. Secure APIs: Protect API endpoints with rate limiting, secure headers, and token-based authentication. SSL/TLS: Ensure all data in transi...
...payment gateways (e.g., Stripe, PayPal) using secure and compliant methods to handle transactions. 3. Performance Optimization: Caching: Use caching strategies (e.g., Redis, Memcached) to reduce load times and server requests for frequently accessed data. Load Balancing: Implement load balancing to distribute incoming traffic across multiple servers, ensuring high availability and reliability. Efficient Queries: Optimize database queries to ensure fast data retrieval and minimize server load. 4. Security Best Practices: Input Validation: Validate and sanitize all input to prevent SQL injection, XSS, and other common attacks. Secure APIs: Protect API endpoints with rate limiting, secure headers, and token-based authentication. SSL/TLS: Ensure all data in transi...
...Development 1. Cross-Platform App Development: • Frameworks: Flutter or React Native (to build for iOS & Android simultaneously). 2. UI/UX Implementation: • Skills: Expertise in translating design mockups into responsive and user-friendly interfaces. • Tools: Figma, Adobe XD, or Sketch integration. Backend Development 1. Database Management: • Tools: Firebase, AWS DynamoDB, or a lightweight SQL/NoSQL database for storing recipes, user profiles, and preferences. 2. API Integration: • Experience with APIs for: • Recipe databases (e.g., Spoonacular, Edamam). • Food delivery platforms (e.g., Swiggy/Zomato API, Uber Eats API). 3. Authentication: • Tools: Firebase Authentication for secure and scalable user logins. Third-Part...
I'm seeking a developer to create a web scraping tool that will extract reviews from the Salesforce Appexchange on a daily basis. The scraper should collect the reviewer's name, review text, and rating. The data needs to be both stored in a database and displayed on a dashboard.
We are expanding and require a dedicated developer to work on our back-end service upgrades. We need of a dedicated developer who can commit 5 hours a day for 4-5 days a week. The project involves building a new scalable server-based platform with socket support to mobile apps. Key Skills Required: - Proficiency in Java, c, PHP Codeigniter, MySQL - Experience in React Native, React Mobile, Angular 1 or 2 or above to port to React Web, and / or Flutter - Familiarity with MERN stack is a bonus - Strong understanding of server-side code development and management - Able to build and maintain web editing tools to enable us to update content - Able to follow well documented React Web Mobile First UX re-design (we may separate this task - if you have this skill apply for it sepa...
I'm looking for a talented full stack developer with extensive knowledge and experience in both React.js and Vue.js for frontend development, and either Node.js or Django for backend. The ideal candidate should also be proficient in both SQL and MongoDB databases. Key Requirements: - Expert in JavaScript, HTML/CSS, React.js and Vue.js - Proficient in either Node.js or Django - Skilled in both SQL and MongoDB - Full stack development experience is a must - Ability to work with both frontend frameworks and backend technologies - Excellent problem-solving skills and attention to detail I am open to proposals from developers who can demonstrate their ability to deliver high-quality work on time. Your bid will be assessed based on your experience, skills, and proposed timel...
...working on this project. - Full of integrities : Trustworthy, independence, responsible, firmed-straightforward, modest-humble, care-empthatically, fair, and hard worker. - Willing to learn new things. ----- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for making a new code. You can negotiate after our website is fi...
...Quotation (RFQ): Blazor Server Application Debugging Assistance** I am seeking a skilled developer to assist in troubleshooting and resolving a runtime issue in my Blazor Server application. The application fails to update the part table and throws a server-side runtime error. Below is a summary of the error: - **Error Type**: `` - **Message**: "An error occurred while saving the entity changes. See the inner exception for details." - **StackTrace Summary**: - The issue occurs during the `SaveChanges` operation within Entity Framework Core. - The error seems related to database save operations via `IRelationalConnection`. **Requirements**: 1. Experience in debugging server-side errors in Blazor Server applications. 2. P...
I need a professional to set up SQL Server 2022 on a Windows machine that I will provide access to. The server needs to be externally accessible but secured from major ports. It should be reachable via a namespace on the domain koddu.co. Key Requirements: - Configuration of server for external access, with security measures in place - Setup of server to be reachable via namespace -security to the server should be via sql auth Ideal Skills and Experience: - Extensive experience with SQL Server 2022 - Strong understanding of network security - Proficiency in Windows OS - Ability to configure domain name access Please note that I will be providing Administrator level access to this server.
I have a server with two 4TB drives currently showing only 1.6TB of usable space. I'd like to reconfigure it to access the full 8TB as a single volume, likely with RAID 0 or whichever you recommend. The server will run the latest Linux Ubuntu 64. Key Requirements: - Reconfigure the RAID setup for maximum usable space Ideal Skills: - Proficient in Linux Ubuntu 64 - Extensive experience with RAID configurations - Knowledgeable in software and hardware RAID Please note that all current data can be wiped. Therefore, the focus will be solely on setting up the RAID for optimal performance and space. And install last Linux Ubunt x64. Let me know if you need more details. Thank you! No data backup is required before proceeding with the RAID reconfiguration.
I'm looking for a professional with extensive experience in setting up Nginx as a web server on Linux. The installation should include SSL/TLS (HTTPS) for secure connections. Please ensure the server is configured optimally for performance and security. Ideal skills and experience: - Proficient in Linux system installation and configuration - Extensive experience in setting up Nginx - Knowledgeable in SSL/TLS implementation - Strong understanding of web server security and performance optimization
I'm looking for a professional with extensive experience in setting up Nginx as a web server on Linux. The installation should include SSL/TLS (HTTPS) for secure connections. Please ensure the server is configured optimally for performance and security. Ideal skills and experience: - Proficient in Linux system installation and configuration - Extensive experience in setting up Nginx - Knowledgeable in SSL/TLS implementation - Strong understanding of web server security and performance optimization
...an experienced Excel expert to create a comprehensive spreadsheet that serves dual purposes: aiding in our preparation for client presentations and collecting pertinent client data. The spreadsheet should: - Collect client contact information and specific case-related details that our business processing team can utilize to prepare necessary paperwork. - Incorporate logic to verify that all procedures have been adhered to. - Implement advanced data validation rules to ensure the accuracy and completeness of client inputs. - Utilize conditional formatting to highlight key information or flag any discrepancies. Ideal candidates should have strong Excel skills, and experience with data collection and presentation preparation. A keen eye for detail and ability to create intuitive, ...
...(HADR). This SOP is intended primarily for military personnel. The SOP should cover the following key aspects: - Response Coordination: Detailed procedures on how to coordinate efforts during a disaster response. - Resource Management: Efficient strategies for managing personnel, equipment, and supplies. - Risk Assessment: Identification and analysis of potential risks and their impact on operations. - Evacuation Procedures: Steps to safely evacuate personnel and civilians from affected areas. - Logistics Planning: Detailed planning of logistics including transportation routes, supply chain management, and warehousing. - Public Information: Procedures for disseminating information to the public and media. - Medical Support: Guidelines for providing medical assista...
I'm in need of a professional to set up a server specifically designed for creating AI-generated marketing videos. The server should incorporate features such as automated video editing, customizable templates, and text-to-speech capabilities. Ideally, the server should be optimized for use as a web-based application. Key Requirements: - Expertise in setting up AI video creation servers - Experience with creating and implementing features for automated video editing, customizable templates, and text-to-speech capabilities - Proficiency in optimizing servers for web-based applications Please note that the primary use case for this server will be the production of marketing videos. A strong understanding of the requirements for this type of content will be ...
I need an expert to set up a new server for me. This server will be primarily used for database storage. The specifications are: - 2x1.7TB NVMe-SSD in RAID 1 for the Ubuntu OS - RAID 5 with 6x-7.8TB NVMe-SSD The database I plan to use is MySQL/MariaDB. Please note, I need Nginx pre-installed on the server as well. Skills and experience required: - Extensive knowledge on server setup and management - Proficiency in Ubuntu OS - Experience with RAID configurations - Proficient in MySQL/MariaDB - Familiarity with Nginx
...following tasks on my new Server tha I purchased from Hetzner: * Install and configure LiteSpeed Web Server on a server running Almalinux 9. * Setup & Configure PHP with LiteSpeed LSAPI and LSWS for optimal performance. * Migrate cPanel from an old server (approximately 13 GB of data). * Set up resource utilization: Configure the server to allow maximum or unlimited usage of all available resources for all websites on the server. * SSL Configuration: Set up SSL certificates for all websites hosted on the server using Let’s Encrypt or any other SSL provider, ensuring secure HTTPS access for all websites. * Backup Configuration: Implement a reliable backup solution to automatically back up all websites, databases, and configurati...
...administrative assistance, customer support, and organizational management. Key Responsibilities: Assist in managing and organizing property rental operations. Communicate with property owners, tenants, and guests to provide excellent service. Handle guest inquiries and resolve issues effectively. Maintain accurate and organized records. Ensure adherence to property management policies and procedures. Requirements: 1. Location: Candidates must reside in: Europe, North America (U.S. or Canada),South America (Argentina, Colombia, Paraguay, Uruguay, or Mexico) Airbnb Account: Must have an active Airbnb account (as a guest or host). 4. Availability: Flexible working hours, part-time or full-time options. 5. Equipment: Reliable computer and stable internet connection. 2. S...
Our long term server admin died and we require a new person to take over ongoing server support. We run a small business with 2 servers running Proxmox and 4 VMs. (3 Linux 1 Win) We run a separate Proxmox backup server. We run Hestia for our webserver and Mailcow. Backups are done the the Proxmox server, NAS and Mega (cloud) We often need small tasks done to support the web devs (ssh, DB work etc etc) and we require monthly maintenance to ensure reliability and updates etc. You need of course to be fully able to work with all of the above, and also be available during NZ time in mornings and evenings. (Our previous admin was from Serbia and this time zone worked ok) We will pay a one off hiring fee to FreeLancer and work with you on an hourly rate moving fo...
I need a straightforward implementation to conduct basic arithmetic operations. The workflow should be capable of performing: - Addition, subtraction, multiplication and division. The results of these calculations should be: - Displayed immediately - Stored for future use. Ideal candidates for this project would be proficient in and have a solid understanding of basic mathematical operations. Experience with creating workflows on is essential, and the ability to ensure that results are both instantly visible and saved for subsequent reference will be key to the project's success. This will be implementing the workflow on the existing site, please send your best quote. I have tried to run the calculation myself but I am struggling to make it work due to lack
I'm seeking a freelancer who can create a dashboard in a SQL database tailored for data visualization, specifically for operational data. I'm particularly interested in the use of line graphs for visualizing this data. Ideal Skills: - Proficient in SQL and data visualization techniques - Experience in creating dashboards - Ability to interpret operational data and represent it visually - Experience in developing interactive dashboards with real-time updates Please provide examples of previous dashboards you have created.
I need professional assistance to respond to a court summons. Key Requirements: - Drafting and submitting a motion on my behalf. - Professional and legally sound approach to the response. - Timely submission in accordance with court deadlines. Ideal Skills and Experience: - Proven experience in legal writing. - Familiarity with court procedures. - Ability to communicate effectively with the court.
...an experienced cybersecurity expert to help develop an application-based honeypot. This honeypot will simulate both web and mobile applications in order to attract and monitor potential attackers. The main threats we aim to detect with this honeypot are SQL Injection, Cross-Site Scripting (XSS) and DDoS attacks. Skills & Experience Required: - Extensive knowledge in cybersecurity, specifically in the development of honeypot applications. - Proficiency in simulating web and mobile applications. - Expertise in understanding and detecting SQL Injection, XSS and DDoS attacks. - Experience with conducting interviews and assessing candidate suitability for technical roles. I have posted 5 profiles of users we need. Please ensure that you that the profiles are read. Interest...
...animations for my medical website. The primary purpose of these animations is to explain various medical procedures to patients. Key requirements: - Expertise in 3D animation - Ability to create highly detailed and realistic animations - Experience in medical animation preferred - Strong understanding of patient education - Portfolio showcasing previous medical animation work The freelancer will need to translate complex medical procedures into easy-to-understand, visually compelling animations. A keen eye for detail and a commitment to quality will be essential. The project will include 5 animations, each approximately 1-2 minutes long. The animations should cover various surgical procedures. The anatomical features should be highly detailed and accurate. The a...
...programming languages such as HTML, CSS, JavaScript, and Java, along with experience in SQL. Recently, I completed a full-stack Java internship at IIDT(International institute Of Digital Technology) by APSCHE(Andhrapradesh State Council Of Higher Education, where I developed various applications and collaborated with teams on project development. I also gained valuable skills during my web development internship with Brain O Vision, where I focused on building web applications. One of my notable projects is a full-stack meat delivery application, designed to meet the growing demand for online grocery shopping, especially during the pandemic. This project allowed me to utilize my skills in Java, HTML, CSS, and SQL to create a user-friendly platform. In addition to my tec...
...free-form text. Key Features: 1. A mobile app for iOS, along with a web app, that sends daily push notifications for users to log their feelings. 2. A cloud-based backend database to store user information such as email and profile details. 3. APIs connecting to OpenAI or similar Google APIs, processing the input data to ascertain user stress levels (low, medium, high). Only the stress level will be stored in the database. 4. The app will display a graph depicting the trend of user stress levels. It will send alerts when users may need assistance. Users can respond with a 'YES' to a help notification if they feel it accurately reflects their mood. 5. Implement user authentication ensuring secure access to the app. The ideal freelancer for this project should: - Have e...
...specific activities. 7. Feedback & Suggestions o Form to collect user feedback dynamically. o Backend for analysing feedback and suggestions. 8. Our Volunteers o Dynamic gallery of active volunteers with photos and brief bios. 9. Entertainment and Cultural Events Calendar o A calendar showing upcoming events and activities. 10. Why Do You Want to Join? o Interactive section where user responses are stored and analyze dynamically. ________________________________________ Hybrid Pages (Static + Dynamic) These pages combine static information with dynamic features for engagement. 1. Testimonials o Static: General layout and description of testimonials. o Dynamic: Updated testimonials from members or visitors. 2. FAQ o Static: Predefined common questions. o Dynamic: Allow visitor...
...looking for a dedicated professional to manage and market my Minecraft server aimed at casual players. Your primary tasks will include: - Community Management: Foster a positive and engaging environment for our players. You should have strong interpersonal skills to handle any disputes and maintain a healthy community. - Social Media Marketing: Promote our server on various platforms to attract competitive players. Experience with gaming-specific social media channels will be a plus. - Partnership Development: Build and maintain relationships with influencers, streamers, and other gaming communities to expand server reach. - Content Creation: Develop high-quality content including videos, blogs, and tutorials to promote the server and provide valuable resou...
I'm looking for a seasoned professional who can set up an Asterisk server for me. This server should be capable of recording calls, integrating with ChatGPT for customer service automation, and transcoding call recordings to email them to specific users. Key Requirements: - Set up Asterisk server with call recording capabilities. - Integrate ChatGPT for enhanced customer service automation. - Transcode call recordings and email them to designated users with the recordings attached. Ideal skills for this project include: - Extensive experience with Asterisk server. - Proficiency in integrating AI tools like ChatGPT. - Strong understanding of audio transcoding and email systems. Your expertise will help improve our customer service efficiency. PLEASE NO...
I'm looking for a talented developer to create a baccarat roadmap that visualizes game mechanics and can be stored in JSON format. Key Requirements: - Translate baccarat game mechanics into a structured, clear and accurate roadmap. - Focus on visualizing Player/Banker/Draw outcomes and Betting patterns. - Use graphical icons for the visual representation on a web browser. Ideal Skills: - Strong experience in game development. - Proficiency in JSON formatting. - Understanding of baccarat rules. - Web development expertise. If you're a passionate gamer with the right skills and experience, I would love to hear from you!
...Openfire server and the Android SDK Spark. When users reconnect after being offline, messages are being delivered with a considerable delay, often taking several minutes or more. This problem is affecting the user experience and needs urgent attention. Key issues Sometimes messages do not get received. - Messages being delivered with a delay upon reconnection - Delay often taking several minutes or more Offline msgs read recipient doesn't show, means no ticks received Random Offline msgs getting skipped after turning-on internet and xmpp connection establishes Ideal Skills and Experience: - Extensive experience with Openfire and Android SDK Spark - Strong troubleshooting and problem-solving skills - Ability to enhance message delivery efficiency - Good understanding of ...
- Dedicated server Installation, setting and migration of websites - 1 time support/update/security check after 3 or 6 months on websites - Speed optimisation - Emails settings on server
- Dedicated server Installation, setting and migration of websites - 1 time support/update/security check after 3 or 6 months on websites - Speed optimisation - Emails settings on server
I need a skilled professional to set up a React and Flask project on my Linux server. Key Requirements: - Expert knowledge in setting up React and Flask projects on Linux servers. - Proficiency in PostgreSQL as it is the database used for this project. - Understanding of Linux OS to troubleshoot any potential server issues. I have all the necessary files and dependencies ready for the project. Your task will primarily involve the setup and configuration on the server. Please include your relevant experience in your bid.
...databases - Skilled in handling complex SQL queries effectively - Ability to manage high process concurrency and large volume inserts Key Responsibilities: - Diagnose the root cause of long wait times and system locks - Optimize the database performance through careful tuning of queries and indexes - Implement strategies to manage high process concurrency and large volume inserts The scale of our data processing needs is small to medium-sized datasets, and our priority is to ensure that the system is responsive and reliable. Your role will be crucial in streamlining our database performance and preventing future issues, allowing our business processes to run smoothly. Problem Description: We operate a MySQL 8.0 Enterprise database hosted on the GCP SQL service. This s...
