SQL Jobs

I need a professional to set up SQL Server 2019 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: - Installation of SQL Server 2019 on Windows - 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 2019 - 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'm looking for an experienced data engineer who can help me migrate my 2010 SSIS package to Azure Data Factory. The primary goal of this project is to scale my data processing capabilities. We seek an experienced developer proficient in Azure Data Factory and SQL Server Integration Services (SSIS) to help us streamline our data workflows. The ideal candidate will be responsible for migrating, designing, implementing, and optimizing data pipelines to ensure efficient data processing and integration. - Migrate 2010 SSIS packges to ADF using lift and shift.   - create a successful connection to on-premise and ADF to execute SSIS packages. - Support and configure Azure infrastructure to handle the migration. - Create a new ADF pipeline to mimic the Windows Task Schedule Jobs....

I need an experienced professional to deploy my fully developed Angular+Node+SQL application to cPanel on Hostinger. Note, this isn't a standard setup - specific configurations are required. Key Requirements: - Proven experience with deploying applications on Hostinger's hPanel and cPanel. - Proficient in Angular, Node.js, and SQL. - Capable of implementing specific environment configurations and dependencies. - Able to troubleshoot and resolve potential deployment issues. Please ensure to bid only if you meet these criteria.

I'm looking for a skilled professional who can create a SQL backend and a C# API for my project. The SQL backend needs to handle: - CRUD operations - Complex join queries - Stored procedures The primary purpose of the SQL database will be to store transaction records. Therefore, you should have a strong understanding of handling and optimizing transaction data. The C# API will need to implement JWT (JSON Web Token) for authentication. A deep understanding of secure API development and JWT implementation is required. Ideal Skills: - Extensive experience with SQL and C# - Strong understanding of complex database operations - Proven record in creating secure APIs - Familiarity with JWT implementation The API should be optimized for interaction with a web application frontend. The ...

I am looking to create a secondary income source through freelance programming work, specifically focusing on HTML. Ideal Skills: - Proficiency in HTML - Experience in freelance programming - Ability to find and secure freelance gigs - Time management skills to balance primary job and freelance work Responsibilities: - Identify, apply for, and secure freelance programming jobs - Maintain high quality standards in all freelance work - Manage time effectively to meet all deadlines This project is perfect for someone who can help me navigate the freelance programming space and secure a steady stream of work.

I'm in need of a dedicated full-time professional to develop and manage my MSSQL server. The primary responsibilities will include creating new database schemas, overseeing database performance, and safeguarding data security and integrity. You will be tasked with developing new databases and managing and optimizing existing ones. Key Responsibilities: - Designing and implementing new database schemas - Monitoring and enhancing database performance - Ensuring the security and integrity of data - Developing new databases - Managing and fine-tuning existing databases The primary focus of this role will be managing existing databases. Therefore, the ideal candidate should have a strong background in database management, with proven experience in handling MSSQL server. Skills in databas...

I'm looking for an expert in database design and coding to help me create a new database. The primary purpose of this database will be to store user data. The project is standalone, so there's no need for integration with existing systems. Key Requirements: - Expert knowledge in various database types with a strong ability to provide advice on the most suitable one for user data storage - Proficient in coding for database creation - Experience in developing standalone databases Please note, the ideal candidate will not only be skilled in database design but also able to communicate effectively and provide sound advice on the best database type for this project.

Hi, I'm designing a web-based SaaS project and looking for quotes on how long you believe it'll take to develop. I'm looking to begin development in the next 3-6 weeks. I already have a sample UI that I designed in Figma but it's a little amateur (see screenshots), so you might want to tweak a few things here and there if you think it'll make the project turn out better. Before we start development I'll send you a more complete, detailed spec with a wireframe and walkthrough videos for all of the pages. This will be a web-based workflow, scheduling, and organization tool for custom car mechanics and builders. I have a partial roadmap of features to add after this and would love to find someone who can stay on to build those out after we finish version one. Fo...

I'm looking for an expert in Oracle SOA to help configure file transfers to and from an FTP server. Skills & Experience: - Proven experience with Oracle SOA - Familiarity with FTP configurations - Prior work with file transfer protocols The main task will involve setting up the necessary configurations to facilitate seamless file transfers. Please note that the specifics about the types of files (binary or text) haven't been determined yet, so flexibility and adaptability will be key. A successful project will lead to potential future collaborations.

I am looking for an experienced Power Automate professional to streamline and optimize my workflows across Microsoft Office 365, SQL Server, and Power BI. The primary goal of this project is to enhance productivity through the automation of key processes. Key Responsibilities: - Automate Approval Processes: Streamlining our approval workflows to save time and resources. - Data Entry and Updates: Automating repetitive data handling tasks to reduce human error and free up valuable time. - Report Generation: Setting up automated report creation to ensure timely and consistent updates. Ideal Skills and Experience: - Proven experience with Power Automate and Microsoft Office 365. - Familiarity with SQL Server and Power BI. - Prior work involving automation of approval processes, data handling...

I'm needing an experienced professional who can assist with automating tests for an bank product. Key Requirements: - Develop automated test scripts for product. - Ensure these scripts are compatible specifically with browser. Ideal skillset for this project includes: -using AI tools and creating automation frameworks from scratch and integrating CI/CD, generating reports, integrating with test rail, writing code for parallel execution and categorising frameworks pages. - Proficiency in Behaviour Driven Development (BDD) - Extensive experience with C#, PowerShell and jenkins - Solid understanding of C# PowerShell and jenkins, SVN. Improve existing framework plus need to run parallel execution Capability to timely deliver high-quality scripts is paramount for this project. Flex...

I need assistance with enhancing the "Reporting Period" formula in my Fact Table. The specific data source and issues have not been determined yet, but I'm open to discussing these further. Ideal Skills: - Proficiency in SQL and Excel - Experience with Data Warehousing - Strong analytical and problem-solving skills - Ability to simplify complex data for easy understanding.

I need a professional to develop a leave management database for my employees. It should be compatible with both Excel and MS Access. Core Features: - The primary function of this database should be to generate comprehensive leave reports. Types of Reports Needed: - Monthly leave summary - Individual leave history - Department-wise leave breakdown Ideal Skills: - Proficiency in both Excel and MS Access - Experience in designing databases - Knowledge in leave management systems - Ability to generate complex reports Your expertise will help streamline our leave management process and provide valuable insights into our leave patterns.

About Us: We are building a cutting-edge sports betting platform designed to offer a seamless, secure, and engaging experience for sports enthusiasts worldwide. Our platform leverages advanced technology to deliver real-time betting, secure transactions, and personalized experiences, and we are looking for talented developers to help bring our vision to life. We are seeking a skilled Node.js Backend Developer to enhance and maintain our online sports betting platform. Your responsibilities will include development and maintaining backend APIs and services to support betting functionalities, real-time data processing, and user account management. Our immediate need is to integrate third-party data sources for live sports updates, and scores. Structure the sport feeds to support betting nee...

As a software company based in Portugal, we are currently developing a monitoring product utilizing Microsoft Azure. We are in need of a specialist who can assist us in our transition from Azure Monitor to Grafana. Our current process involves creating dashboards in Azure Monitor with logs in Log Analytics workspaces. We need a professional who can: - Utilize the Azure Monitor plugin to access our Log Analytics workspaces as a Data Source in Grafana. - Replicate existing graphs from Azure Monitor to Grafana. - Create new graphs based on detailed instructions we will provide. The ideal candidate for this project should have: - Extensive experience with Grafana on Azure. - Proficiency in interpreting and implementing detailed graphing instructions. - Ability to replicate complex data v...

I am seeking an SAP Consultant with a minimum of 5-8 years of experience, specifically in Production Planning (PP). The consultant will be working in a government organization located in Hyderabad. A BE/B Tech in Computer Science is mandatory. Key responsibilities: - System configuration: Tailoring the SAP system to meet our production planning needs. - Process optimization: Identifying and implementing improvements in our current processes. - Issue resolution: Addressing and solving ongoing issues at the plant. Ideal skills and experience: - Extensive IT skills with a strong background in SAP, particularly in the Production Planning module. - Proven track record of resolving ongoing issues in a production environment. - Excellent problem-solving abilities and a knack for process optimi...

I'm in need of a skilled developer to convert my current code into Entity Framework Core (EFCore). The project involves: - Converting in-line queries into Lambda expressions - Ensuring compatibility with a SQL Server - Tailoring the conversion for an API service, primarily focused on data retrieval A deep understanding of EFCore, SQL Server and API service development is essential for this task.

I am in need of an experienced SQL database engineer who can assist with the design of an SQL database primarily for analytical purposes. Key Responsibilities: - Database Design: Creating a robust, flexible and efficient database structure that can support complex analytical queries and data manipulation. Ideal Skills and Experience: - Proficiency in SQL: Deep understanding and hands-on experience with SQL and its various functionalities. - Database Design Expertise: Proven track record in designing databases, particularly for analytical uses. - Analytical Mindset: Ability to foresee potential data requirements and design the database accordingly. - Query Optimization: While not the primary task, experience in optimizing queries for efficiency would be beneficial. Your expertise will p...

Reynolds and Reynolds is currently seeking candidates with prior experience of systems design and development. REQUIREMENTS: 2+ years prior work experience is required in one or more of the following: .NET (C# or VB.NET) Microsoft SQL Server (database design, DBA, stored procedures, OLAP and reporting) Web services integration using SOAP or REST APIs Training in C/C++ will be provided but prior experience will be an advantage Proven track record of the delivery of successful projects A degree in Computer Science would be an advantage - User Authentication: Implementing a secure and efficient user login system. - Data Processing: The ability to handle and manipulate data seamlessly. - Reporting: Generating insightful reports based on the processed data. The ideal candidate for this pro...

I'm seeking a data analyst proficient in Python, SQL, and Visual Basic to assist with analyzing logistics data. The primary focus will be on supply chain optimization and transportation analysis. Key Responsibilities: - Analyze logistics data to identify trends and insights. - Use Python and SQL to perform data manipulation and analysis. - Apply Visual Basic for data visualization and presentation of findings. - Develop and maintain dashboards and reports to visualize key performance indicators. - Automate data extraction processes to streamline workflows and ensure timely data availability. - Collaborate with operations, procurement, and other teams to understand their data needs and provide analytical support. - Conduct statistical analysis to support decision-making and strategy ...

Our MySQL database on GCP is experiencing significant performance issues, leading to long wait times and system locks. While I have not undertaken any optimization efforts yet, it's clear that our database is struggling due to a range of factors, including complex queries with outer joins, high process concurrency, and large volumes of inserts. The ideal candidate for this project should have the following skills and experience: - Proficient in MySQL database performance optimization - Prior experience with Google Cloud Platform (GCP) 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 performan...

We are seeking a skilled and enthusiastic Software Developer to join our dynamic IT team. The ideal candidate will have a strong background in C#, expertise in integrations, and experience with Blazor/Razor and SQL. As a Software Developer, you will be responsible for developing, maintaining, and enhancing web applications and integrating various systems to streamline our business processes. Additionally, there will be opportunities to upskill in cloud computing, particularly in Azure functions and service bus, as we continue to expand our cloud-based solutions. Key Responsibilities: • Develop and maintain web applications using C# and Blazor/Razor. • Design and implement integrations with various internal and external systems. • Write clean, scalable, and efficient code fo...

We have a server with databases and sites that have Windows 2003 server, we had to change to a newer environment

I need a professional to enable data synchronization from my Excel files into my SQL .net website database via the Google Cloud Platform. The synchronization should occur hourly. Key Requirements: - Implement a reliable hourly data sync from Excel to the SQL database. - Utilize Google Cloud Platform for this integration. Ideal Skills: - Proficient in .net development with SQL database experience. - Familiar with Google Cloud Platform. - Excel expertise for data manipulation and understanding of the requirements. - Experience with API integration and handling data flow between different systems. - Ability to write scripts for automation of data synchronization processes.

We are seeking a senior Java developer as a backend developer who will join the agency. Requirements: - English Fluency - 5+ years of professional software development experience (Must have done hands-on development in most recent projects.) - 4+ years of hands-on experience with Java - and are very familiar with Java 8 and 11 and comfortable developing with it - REST API development experience using Spring Framework (Spring Boot, Spring Data JPA, Spring-Core, Spring MVC) - Unit and Integration testing experience with Junit 5+ - In-depth experience designing and working with n-tier architectures (UI, business logic layer, data access layer) as well as experience in distributed architectures using integration hubs such as Data Power, Mule or any ESB’s - Knowledge of SDLC processes an...

I have an ODOO V12 backup containing my accounting, production, and client data in SQL. I need a professional to help me install an ODOO V12 instance on my Linux computer and guide me through restoring the backup. Requirements: - Installation of ODOO V12 on my Linux PC. - Assistance in preparing the system with necessary dependencies and libraries. - Step-by-step guidance in restoring the ODOO backup. - No additional software or tools installation, just ODOO V12. Ideal candidates should have: - Proven experience with ODOO V12 installations. - Strong understanding of Linux operating systems. - Excellent communication skills for clear, step-by-step guidance.

Looking for a specialist who can supplement our in-house SAP and Power BI Manager. We have a full integration infrastructure and are using Power Apps, Power BI and SAP integration now. Our first project with the right candidate is to build a couple reports and workspaces in Power BI for our laboratory metrics. Comparing raw material receipt dates to time spent in the lab (using release date) and tying to our production schedule to establish order or priority.

I'm looking for a data engineer to help me design a data warehouse and an ELT/ETL data pipeline, with a preference for the snowflake schema. Key Responsibilities: - Design a data warehouse using a snowflake schema - Develop a suitable data model - Implement ELT/ETL data pipelines for data integration and warehousing Ideal Skills: - Proficiency in SQL Server - Extensive experience in data engineering - Expertise in designing data warehouses and data models - Familiarity with snowflake schema - Strong ELT/ETL skills The main goal of this project is to integrate various data sources into a well-structured data warehouse for efficient business intelligence and reporting. The data warehouse will handle a small volume of data (up to 1TB).

Inicialmente recopilar datos de webs y trasladarlos a base de datos, para su posterior tratamiento. Imprescindible amplio dominio ingles y español. Muy deseable, domicilio en Malta. Initially collect data from websites and transfer them to a database for subsequent processing. Extensive command of English and Spanish is essential. Very desirable, domicile in Malta.

I'm in need of support for my upcoming SQL exam. The exam is of a general nature and will involve a range of topics within SQL. It's crucial that I have the assistance of someone who is not only proficient in SQL, but also has experience with exam preparation and programming. Ideal Skills and Experience: - Proficiency in SQL - Experience with exam preparation - Programming skills - Ability to develop a program

Our AWS-hosted web application intermittently experiences slowness that affects performance. The application relies on SQL databases and uses a combination of SOAP and REST services for data handling. We are seeking an experienced performance specialist to: 1. Analyze and identify the root cause of slowness in the application. 2. Suggest optimizations to enhance performance and reduce latency. 3. Provide clear documentation of findings along with actionable recommendations. Requirements: • Strong background in optimizing web applications hosted on AWS. • Expertise in SQL query optimization, identifying high CPU/memory usage sources, and overall performance tuning. • Familiarity with diagnosing issues in SOAP and REST APIs under heavy data loads. Deliverables: &b...

I'm in need of a professional with extensive experience in Dynamics D365 F&O. My requirements include ongoing support for the environment, configuration and troubleshooting issues. Key Responsibilities: - Resolving issues and troubleshooting problems as they arise - Creating ad-hoc reports as needed - Updating the environment regularly Ideal Skills: - Deep understanding of Dynamics D365 F&O - Excellent problem-solving skills - Experience in creating reports - Ability to perform regular environment updates I am looking for someone who can provide reliable and timely support to ensure the smooth running of our Dynamics D365 F&O system. The following availability is required: Support during business hours only.

I'm facing an issue with my salary report. It seems that there's absolutely no data to display. The report is supposed to pull information from our database, and I've confirmed that the database connection is functioning properly. I need a skilled data analyst or database expert who can help troubleshoot this issue, identify the cause of the missing data, and implement a solution. Experience with salary report generation and database management is a plus.

I'm in need of a seasoned PowerBI developer who can help me track and analyze a variety of metrics related to sales, financials, operations and key performance indicators. The ideal candidate should: - Have extensive experience in PowerBI. - Be proficient in connecting PowerBI with both Excel spreadsheets and SQL databases. - Be adept at analyzing diverse sets of sales data including revenue trends, product performance and customer demographics. - Have experience in creating user-friendly and interactive dashboards. - Be proficient in Data Analysis Expressions (DAX) for complex calculations. - Have experience with ETL (Extract, Transform, Load) processes to clean and prepare data. - Be adept at integrating PowerBI with various APIs for seamless data flow. - Have experience setting u...

Requirements to fulfill in my current Job: ==================================== Configuration changes to monitor critical BIP reports as part of the ESS dashboard In HCM Extracts, the Sub process (based on requirement, should be able to include or exclude) should be displayed in the Dashboard. In HCM Extracts also monitor the count of records process successfully or failed. In ESS Dashboard, require an additional section which displays the ESS Jobs scheduled which are not yet started and capture the ESS Job Status Have a graphical representation on the jobs running in the instance based on Module (SCM, HCM, FIN) Further Improve the look and feel of the dashboard. Dashboard monitoring Jobs failing frequently due to huge volume of data.

I'm looking for a web developer to create a straightforward study website for me. The UX is already created. The site should have a few key features: - User Authentication: The login function should employ a standard Email and Password authentication method. - Timer Functionality: The site should incorporate a timer. This could be a Countdown timer, a Stopwatch timer, or a Pomodoro timer. I'm open to suggestions regarding which timer would be most effective for study sessions. - User Levels: The site should include a leveling system based on experience points (XP). With those levels a little design element of the timer upgrades (e.g. a house becoming cooler). - Daily Goals: Allow users to set and monitor daily study goals and tasks. The current stage of UX design is below. The...

I'm looking for a Microsoft Fabric expert, specifically a data engineer, to assist with my project. The main focus will be on creating data pipelines and integrating APIs as data sources. Key Responsibilities: - Design and implement efficient data pipelines - Integrate various APIs into Microsoft Fabric Ideal Skills: - Extensive experience with Microsoft Fabric - Strong background in data engineering - Proficient in working with APIs - Expertise in data pipeline creation Please note, the majority of the tasks will revolve around API integration, so experience with various APIs will be a significant advantage.

I'm in urgent need of support for my family, and I'm ready to tackle any administrative tasks you may have. My skills include: - Data Entry: I can efficiently input and manage data, ensuring accuracy and attention to detail. - Customer Support: I have experience in handling customer queries and providing excellent service. - Scheduling and Coordination: I can assist in managing schedules and coordinating events or meetings. I am proficient in Microsoft Office Suite and can leverage it for all your administrative needs. I am dedicated, hardworking, and committed to delivering quality work.

I'm in need of a professional data collector proficient in mining information from online databases.

I'm seeking an experienced software developer to create a comprehensive hospital management software using ASP.NET. Key Features: - Patient records management: The software should have a robust system for tracking patient histories, treatments, and progress. - Appointment scheduling: An intuitive interface for arranging and managing patient appointments is necessary. - Billing and invoicing: The software must include a seamless billing system that can handle invoicing, insurance claims, and payment tracking. - Product and service management: The software should be able to monitor hospital inventory and manage services offered. - Multilanguage Departmental Coverage: The software should cater to various departments within the hospital including: - Outpatient Services - Emergency Ser...

I'm seeking a PySpark specialist to assist with data processing and ETL tasks. The primary focus will be on optimizing existing scripts to enhance performance and efficiency. Ideal Skills and Experience: - Proficient in PySpark with extensive experience in data processing and ETL - Strong background in script optimization - Familiarity with data handling from SQL Databases, Cloud Storage, and CSV/Excel files - Excellent problem-solving skills and attention to detail

I am a dedicated Business Analyst with a deep understanding of the intricate U.S. healthcare landscape. I have 6 hours a day to devote to your project, and I'm eager to bring value to it. Key Areas of Focus: - **Data Analysis**: I can assist with comprehensive healthcare data analysis, interpreting complex data sets to uncover trends and inform decision-making. - **Operational Efficiency**: I specialize in identifying and streamlining processes to enhance operational efficiency. - **Regulatory Compliance**: With extensive knowledge of HIPAA, I can ensure that all processes and recommendations are compliant with this crucial regulation. I also have experience in requirements gathering, effectively bridging the gap between stakeholders and development teams to ensure clear and actiona...

I need a Windows desktop app that facilitates two-way synchronization of my SQL Server database records. Key Requirements: - Develop a desktop application compatible with Windows. - Implement two-way synchronization for SQL Server database records. - Ensure the application is user-friendly and efficient. Ideal Skills: - Proficiency in SQL Server. - Experience in Windows desktop application development. - Expertise in data synchronization techniques. Please provide examples of similar projects you've completed in your proposal.

I'm seeking a Power BI specialist to assist with data analysis and insights. Your primary role will be to connect Power BI to various data sources and extract meaningful insights from the data. Key tasks will include: - Connecting Power BI to various data sources, particularly SQL databases and Excel spreadsheets. - Conducting in-depth data analysis to derive insights and inform business strategy. Ideal candidates will have: - Extensive experience with Power BI, including dashboard creation and custom report generation. - Strong skills in data analysis, with a proven ability to derive insights from complex data sets. - Experience with SQL databases and Excel spreadsheets. - Excellent communication skills, with the ability to explain complex data in a simple and understandable mann...

I need an Access database developed primarily for automating workflows. The project entails: - Designing an Access database that effectively automates various workflows (specific workflows are to be determined in the course of the project). - Integrating the database with Microsoft Excel for smooth data transfer and manipulation. Ideal candidates should have extensive experience with Access database development and Microsoft Excel integration. Skills in workflow analysis and automation, as well as excellent problem-solving capabilities, are also crucial for this project. This is for a betting matrix on horse racing It is a small simple one page system that I need I will pay $50aud with a guarantee of UNLIMITED REVISIONS FROM YOU

Need customization programking for Acumatica ERP. Have many small project lined up. Should be able to work RDP or anydesk. If you never worked with Acumatica DO NOT BID. Im gonna report your profile.

I'm looking for a skilled professional to enhance our operational efficiency through a well-planned and executed integration of a CRM and ERP systems. Key Requirements: - Identify and implement the right CRM software for our needs. - Seamlessly integrate this with our current ERP system, Happit. - Connect our existing system, Aurora Solar, to either the ERP or CRM. - Conduct a thorough needs review, design the optimal solution, and oversee its implementation. Ideal Skills: - Extensive experience with CRM and ERP systems, particularly Happit. - Strong knowledge in system integration. - Prior work with Aurora Solar is a plus. - Excellent problem-solving and project management skills. The goal is to streamline our data flow and improve our operational efficiency. I am ...

I'm seeking a seasoned DevOps professional to bolster the reliability of my database management system. Key Responsibilities: - Analyze current system reliability and identify areas for improvement - Implement strategies to enhance database management reliability - Collaborate with me to understand specific needs and concerns Ideal Skills: - Extensive experience in DevOps, particularly in improving system reliability - Strong knowledge of database management - Excellent problem-solving skills - Ability to communicate technical concepts in an easy-to-understand manner Please note, the specific database technology we are using has yet to be determined. An understanding of both SQL and NoSQL databases would be beneficial.

Desarrollo de Bot de Atención al Cliente para Desguace con Integración en WhatsApp y Consultas SQL Estamos buscando un desarrollador experimentado para crear un bot de atención al cliente que se integre con WhatsApp. Este bot debe tener la capacidad de interactuar de manera natural con los clientes, comprender sus consultas y brindar respuestas precisas sobre piezas de repuesto. La solución debe cumplir los siguientes requisitos: Características del Bot: 1. Interacción Natural: Responder de forma breve y directa, ofreciendo una experiencia de conversación fluida y personal. 2. Procesamiento de Fotos y Matrículas: Capacidad para recibir y procesar fotos enviadas por los clientes y extraer referencias de las fotos. 3. Integraci&o...

Necesitamos apoyo de un experto en .NET tiempo completo hasta Diciembre 31 de 2024. Back end. Pago por hora.