Azure sql database for the sql server dba jobs
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Deliver...
I have a website template that needs customization in terms of layout. The main purpose of the site is to showcase my portfolio, the template is ready it needs the to be filled with the correct data. Key Tasks: - Customize layout: I need a professional to make the necessary changes to the layout of my website template, ensuring that it is visually appealing and functional. - Ensure responsiveness: The website should be mobile-responsive, so the freelancer should ensure that the layout changes are consistent across all devices. This project is ideal for a freelance web designer/developer who has a good eye for design and is committed to delivering high-quality work. A portfolio demonstrating similar projec...
...to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal Skills and Experience: - Pr...
I am in need of a skilled software engineer to develop a DICOM printer server software. This software should: - Be compatible with Windows operating system. - Have the capability to print to HP, Canon, and Epson desktop printers. - Support image printing and multiple printer use. Ideal candidates for this job should have strong experience in software engineering and a solid understanding of DICOM features. Familiarity with printer server software is a must, as is the ability to ensure compatibility with named printer brands and operating systems.
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid i...
I am experiencing slow query processing and management issues with large ...experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?
I'm seeking a professional logo designer to create a wordmark style logo for my company, P32 Capital. The primary color I'm looking for is blue, as it should convey professionalism. P32 Capital is Real Estate Asset Manager company.
Could not find platform independent libraries <prefix> Could not find platform dependent libraries <exec_prefix>
The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL tab...
...completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project is crucial ...
I have a series of videos with basic thumbnails with clickthrough rate 3-5% - public transport topic, metro systems, full journeys. I need help to rework those thumbnails in order to increase the clickthrough rate to 7-10% Please reply with examples you did before
I'm in need of a SOCKS Proxy server as my ISP has closed port 25, which is essential for email services. Key requirements: - Set up a SOCKS Proxy server: The server's primary function will be to support email services. - Implementation: The server should be configured to support my email client. - Security: Ensure the server is secure and reliable. Ideal skills and experience: - Proficient in setting up SOCKS proxies. - Expertise in configuring services for email clients. - Knowledge of network security standards. The project might involve more tasks depending on the specific needs of the proxy server.
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Profic...
Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive f...
Hello, I need a quick fix for my DNS server running on a 2012 R2 system. The major problem encountered is that I'm unable to access my shared files. However, I can ping the IP addresses of the devices hosting these shared files. An RPC Error is shown and some Group Policy issues occur when trying to access these files. • I need someone who understands DNS thoroughly. • Experience with Server 2012 R2 is necessary. • Knowledge of RPC errors and Group Policy is required. Would appreciate quick and effective troubleshooting. Thank you!
I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts a...
...translation during calls, facilitating seamless communication between speakers of different languages. The ideal candidate will have experience in speech processing, real-time communication systems, and cloud services. Responsibilities: - Design and develop a high-performance backend system for real-time audio processing and translation. - Integrate speech recognition and translation APIs from leading providers. - Implement a scalable real-time communication architecture to support voice calls. - Ensure data privacy and security compliance in voice transmission and storage. - Work closely with UX/UI designers to create a seamless and intuitive user interface. - Test and optimize the system for various devices and network conditions. Requirements: ...
...experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-based independent developers. If you meet the requirements an...
have anyone can help me to install the Laravel system which buy from themeforest, thanks i will provide the domain and also the login of the hosting, thanks
I'm looking for an experienced individual to help me set up a VPN server on my TP Link Omega E707, running Windows OS. The primary goal of this is to allow secure remote access to my home network. Key Requirements: - Set up a VPN server on a TP Link Omega E707 running Windows - VPN server must be accessible outside my network - Ensure security and privacy in the VPN configuration - Establish a reliable connection method for remote access The ideal candidate should have: - Proven experience in setting up VPN servers on TP Link routers - Extensive knowledge of Windows OS - Understanding of network security and remote access protocols. Please note that my TP Link Omega E707 has a dynamic IP address.
... of the configurations and parameters of the site /////CONFIG AND INSTALL SCRIPT //// I want a complete configuration of all parameters URL DEMO SCRIPT. 7437.Cj0KCQiA5rGuBhCnARIsAN11vgR0IAOeV3fZLehJ28mJeOVeC35qXrrXFJfbYhlUK8e9nraqPybSIxUaAic2EALw_wcB .................................................. ................ ......... I want a complete script setup with all systems working. CREATION OF ACCOUNTS AND EMAIL ADDRESSES TO MAKE THE WHOLE SCRIPT WORK example add: :add languages EUROPE AND ENGLISH : account creation, facebock, instagram, twitter X, (create an email address on the domain). :CONFIGURATIONS
...representing the relationships between employees, the groups they belong to, and the training they have attended. 1. "Employee": They are characterized by: name: The employee's last name. first_name: The employee's first name. date_of_birth: The employee's date of birth. position: The position held by the employee. establishment: The establishment where the employee works. hire_date: The date the employee was hired. contract_type: The type of contract. seniority: The seniority. 2. "Group": They are characterized by: group_name: The name of the group. group_selection_criteria: The selection criteria of the group. 3. "Train...
Hello, i need help for a Update from Contao 3.5 to the newest version. We must Update PHP 5.6 to the PHP 8.x Version. Thanks
I'm looking for an experienced Azure Analytics specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may ...
...ISO27001 certification project. The focus will be on assessing the security of our GlobalView application hosted on Azure and our WordPress website hosted on WP Engine. Objectives: Conduct a thorough security assessment of the GlobalView application and WordPress website. Identify security vulnerabilities and threats. Provide actionable recommendations for remediation to meet ISO27001 standards. Scope of Work: GlobalView Application: Hosted on Azure. Developed with PHP and JavaScript, code on GitHub. Emphasis on application, data, and cloud security. WordPress Website: Hosted on WP Engine. Focus on CMS security, plugin vulnerabilities, and web application security. Deliverables: Penetration Testing Report: Detailed findings with severity rat...
...Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling...
...involves migrating a medium-sized database (between 1GB and 10GB) to Oracle, and optimizing its performance. The database schema will also need to be designed, as this is not yet finalized. Key responsibilities include: - Migrating existing data: I need an expert who can handle this without losing any data or causing downtime. - Performance optimization: Once the data is migrated, the database needs to be optimized for speed and efficiency. - Designing the database schema: Your ability to design a schema that aligns with our business goals is critical for this project’s success. Ideal candidates should have extensive experience in Oracle database development, with a focus on data migration and performan...
I need a Node.js expert to help me integrate SSO from my system with Azure Active Directory B2C. You'll focus on writing the NodeJS part, not Azure. We prefer someone with prior experience in this. Key Responsibilities: - Implementing user authentication with Azure Active Directory B2C - Ensuring the integration works seamlessly with my system Ideal Candidate: - Proficient in Node.js - Previous experience working with Azure Active Directory B2C - Strong understanding of Single Sign-On (SSO) implementation The project may involve additional communications during the work, so prefer someone with prior experience in this.
...Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existi...
...Project description : I want the details of 200 companies and their CEO's with very specific criteria. This is an intensive, manual work project that will take at least 4 hours of dedicated effort of searching through Linkedin / Google/ general web search. Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be sourced from databases such as Apollo.io. Please do not waste your valuable time trying to do either. The criteria are: 1. Top 100 companies which are listed on this webpage : 2. Top 100 companies which are listed on this webpage : The data you will need to fill in
...team in the United States. This position is ideal for someone with a passion for sales and digital marketing, willing to work on a commission basis and capable of cold calling to generate new business opportunities. Responsibilities: Conduct cold calls to identify and contact potential clients. Present and sell our digital marketing services to businesses. Develop and maintain strong relationships with clients. Identify sales opportunities and convert prospects into clients. Meet and exceed established sales targets. Maintain accurate records of all sales activities and potential clients in the CRM. Collaborate with the marketing team to develop effective sales strategies. Requirements: Previous experience in sales, preferably in a commission-base...
1. Introduction: This requirement document outlines the necessary features and functionalities for developing a recruitment website. The website aims to serve as a platform connecting job seekers with employers, facilitating the job search and recruitment process. 2. Scope: The recruitment website will provide a user-friendly interface for job seekers and employers to register, search, and manage job postings and applications. It will include job search, resume upload, employer profile creation, job posting, application management, and communication tools. 3. Functional Requirements: 3.1 User Registration and Authentication: • Users (job seekers and employers) should be able to register on the platform. • Authentication mechanisms...
I need a skilled DevOps engineer with deep expertise in Ansible and experience in working with Microsoft Azure and Azure DevOps. Key Requirements: - Integrate Ansible into our Azure DevOps environment for setting up a comprehensive CI/CD pipeline. - Automate the deployment of applications using Ansible across our Azure infrastructure. Ideal Skills and Experience: - Extensive experience with Ansible, particularly in CI/CD context. - Proven track record of working with Microsoft Azure and Azure DevOps. - Strong understanding of automation tools and methodologies. - Excellent problem-solving skills and attention to detail. - Ability to work efficiently under pressure to meet tight deadlines.
I am in need of a M...specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for...
I'm in need of a professional developer to handle the architecture implementation of an IOT server. Key Responsibilities: - Connecting sensors and GPS based Telematics devices to the server. - Handling data collection and storage. - Managing device commands. - Setting up real-time monitoring and alerts. Your expertise in setting up a NoSQL database is essential for this project. I'm looking for someone who can not only execute this task but also provide valuable insights and inputs to enhance the overall performance of the server.
...need to connect my Azure Function to an Azure MySQL database. The function is being used as a Web API, and I need it to be able to both read and write data to the MySQL database. Key Requirements: - Development: You will need to establish a secure, reliable connection between the Azure Function and the Azure MySQL database. - Data Handling: The API should be able to retrieve data from the database as well as input new data into it. - Security and Optimization: Ensure proper security measures are in place to protect the data, and optimize the API for performance. Skills and Experience: - Proficient in C#: You should have strong experience working with C# and Azure...
I'm searching for a seasoned professional with expertise in cold calling, Facebook messaging, and sales, to help us find leads and pitch our web development services to service providers. Key Responsibilities: - Conduct cold calls, Facebook messaging, and emails to generate leads and convert them into appointments for a sales team. - Draft and deliver compelling sales pitches that highlight the benefits and value of our web development services, with the aim of securing appointments with interested service providers. - Collaborate with our sales team to ensure that all appointments are well-documented and followed up on. Ideal Candidate: - Proficient in cold calling, Facebook messaging, and sales. - Experience in lead generation and appointment setting. ...
You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it
Hi Riki - this is a separate project so will require some new art in a similar style. I'll explain the details
I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project...
...STATEMENT Due to missing connection to database, the website on clients local machine is generating errors thus preventing development. SOLUTION: Create a replica of RDS production server (to be called "dev") on AWS, that can be used for development on local environment and for staging testing later on. CONTRACTORS ANTICIPATED TASKS (high level) 1. Take backup of production database on AWS 2. Create new RDS instance (server) using the backup and restore the backup. 3. Configure and verify the network settings to make connections over internet. 4. Test connection of new dev database with web application on local environment. DELIVERABLES 1. Demo showing the website on local environment worki...
Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. ...process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for...
I'm currently experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client comm...
I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases
I'm in need of a seasoned IT professional who can set up a Windows-based VPN server for my company. The primary purpose of this server is to allow our employees to access the company's resources securely from remote locations, which is currently a pressing need for us. Key Requirements: - Configuration of a VPN server on Windows OS - Setting up a secure connection for remote employees - Allowing simultaneous connection for a small user base (1-10 users) Ideal Skills and Experience: - Proficiency in Windows OS - Hands-on experience with VPN server configuration - Knowledge of network security best practices - Prior experience with remote access solutions Your expertise will play a crucial role in enhancing ...
I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.
...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that th...
