Sql server database administration project jobs

I'm in need of an expert to professionally clean and validate SQL database files. The files are smaller than 1GB, but they hold vital information that is critical for my business operations. - Qualifications: - Proven data cleaning experience, preferably with SQL databases. - Proficient in creating SQL queries. - Attention to detail and high level of accuracy. As the ideal candidate, you should have a confident grasp of database management and SQL programming. Your role will involve checking, rectifying, and validating the data, as well as identifying any errors or inconsistencies. The result should be a clean, reliable SQL database that my team and I can count on for our future operations.

I am needing a professional to address a critical issue involving my VPS Server, on Ubuntu 22.04. It has become increasingly unstable, crashing and requiring manual restarts every 10 minutes. I would appreciate assistance in investigating and resolving this. While I have personally reviewed the server logs, I have not been able to identify any specific error messages that may be causing this issue. Your task will be to conduct a comprehensive review of the problem, deducing the underlying issues from the server logs, even if no specific errors have been identified. Ideal Skills: - Expert knowledge of Ubuntu 22.04 - Robust experience in managing VPS servers - Troubleshooting and problem-solving skills in identifying and fixing software glitches - Capability to wor...

We are seeking a highly skilled Full-Stack Developer to create a Telegram channels and groups directory website from scratch. This project requires you to develop both the UI/UX design and the backend code. You will not receive any pre-existing design templates such as Figma, but you may refer to a competitor's website for inspiration. The goal is to build a platform that efficiently categorizes Telegram channels and groups by country and category, facilitating easy navigation. This website will be developed using React, Node.js, and PostgreSQL. It must be fast, secure against common web threats including SQL injections, Cross-Site Scripting, and IDOR's. It should also be optimized for search engines to achieve high visibility online. Key Features of the Website:...

I am looking for a skilled professional who can help with various aspects of data processing, storage and workflow management using Pyspark, SQL, Airflow, S3, Hadoop, and Kubernetes. Key areas of support required include: - Data processing in Pyspark: Assistance with data cleaning and transformation tasks in PySpark. - Querying databases in SQL: Advanced optimization techniques, custom queries and data retrieval. - Workflow management in Airflow: Custom workflow automation and scheduling tasks. - Data storage and manipulation in S3 and Hadoop: Support for large-scale data storage and processing. - Container orchestration in Kubernetes: Assistance with container deployment and scaling. Specifically, the ideal candidate should be able to set up tables on Iceberg in Parquet ...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.

Good I am making a script for a client in python, where I am building a program where the program will generate me 100 weekly emails at most, these emails must have a phone number associated with each of them a number, ie emails have to be valid, the customer wants to receive and send mails, I am looking for creation of server to receive and send mails with emails created by the python app. emails are created randomly and just like passwords with a custom domain. I speak a little English so if you know Spanish we would understand each other better.

I'm in need of a Spark Developer who has a good, intermediate level competence in Scala. Your primary task will include: - Processing and analyzing structured data similar to SQL databases. Given the nature of this project, prior experience with data processing and working with SQL databases would be a huge advantage. While performing machine learning algorithm implementation or real-time data streaming isn't explicitly required, any exposure to these areas would be beneficial.

I'm looking for a skilled ASP .NET web developer to work on a small project. Key requirements: - Fullstack development: The project involves both front-end and back-end development. The ideal candidate should be proficient in C# and ASP .NET. - Database Integration: The project will be using SQL Server, so experience with this database type is needed. Skills required: - Proficiency in C#, ASP .NET, and SQL Server - Experience in fullstack web development - Strong understanding of database integration and management Your role will be to take the project from concept to completion, ensuring that all elements are well-integrated and functioning smoothly. If you are a reliable, detail-oriented developer with a...

I'm experiencing issues with my Ubuntu desktop. When I try to boot the system, I'm unable to access the desktop. I've tried several troubleshooting steps to fix the issue: - Booting from a live USB - Acc...troubleshooting steps to fix the issue: - Booting from a live USB - Accessing recovery mode - Running fsck in terminal Despite these efforts, the problem remains unresolved. I can see error messages during the boot process. I am looking for an experienced Ubuntu specialist who can help me restore access to my Ubuntu desktop. The ideal candidate should have a strong background in Linux system administration and be familiar with troubleshooting boot-related issues on Ubuntu. A deep understanding of Ubuntu recovery processes and file system checks would be highly ...

I'm in need of a versatile data engineer who can tackle various aspects of data analysis, AI development, and data engineering. - The ideal candidate should be proficient in Python and knowledgeable about Machine Learning algorithms, as these will be crucial to the AI development aspect of the project. - Sound experience in working with structured databases (e.g., MySQL, PostgreSQL) is essential. Introduction: Join our team as a Data Engineer, where you'll have the opportunity to contribute to cutting-edge projects and drive significant advancements in data analysis and machine learning. We are looking for a highly skilled professional who thrives in a dynamic environment and is passionate about transforming large volumes of data into actionable insights. Responsibiliti...

...importance of validating user input to prevent common vulnerabilities, such as SQL injection and cross-site scripting (XSS) attacks. 6. Secure Transaction Processing: The application will incorporate secure transaction processing mechanisms to ensure the integrity and confidentiality of financial transactions. This section discusses the implementation of secure communication protocols, such as HTTPS, to protect sensitive data during transit. It also highlights the need for transaction validation and auditing to maintain a transparent and accountable system. 7. Data Encryption and Storage: Sensitive user data, including financial information, will be encrypted and securely stored in the application's database. This section explores encryption techniques and sec...

I...list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen understanding of these laws would be highly preferred. Accuracy of data is of top importance, therefore meticulous cross-checking is needed for each entry. I'm looking for...

I need a Red Hat expert primarily for ...our Red Hat Enterprise Linux systems. Key Requirements: Certification in: Red Hat Certified Engineer (RHCE) Red Hat Certified System Administrator (RHCSA). Ideal Skills: - Proven experience in Red Hat Enterprise Linux system upgrades and maintenance. - Strong troubleshooting and problem-solving skills. - Spanish language skills would be an asset. It is a project to provide technical support in installation and administration of RHEL 9. Duration 2 months. Incident resolution by e-mail and videoconference. About 20 hours. It is mandatory as a requirement the Certification in: Red Hat Certified Engineer (RHCE) and Red Hat Certified System Administrator (RHCSA). Spanish language skills are a plus. In your proposal, please share you...

I'm looking for a freelancer who can help me set up a VPN server on Google Cloud using Linux as the operating system and OpenVPN as the VPN protocol. We need an IPSec-ready end device on our side (or hosted somewhere), where the data traffic should terminate. The service will route all the data traffic through the tunnel. Need to have an US based breakout then. So, when we are receiving the traffic on one central address, and there we can do the breakout and the NATing into the world wide web on our side.

I'm in urgent need of a Python Django developer to help me deploy my old website files on Namecheap. Here's a rundown of the tasks and requirements: - Deploying old website files on Namecheap: I need you to swiftly and effectively set up and configure the database for my project. - No new development or integrations: You won't be tasked with front-end or API work, just the deployment of the existing files. Your experience with Django and database setup are paramount. Time is of the essence, so I need a professional who can work efficiently and effectively.

I'm looking for an expert in Linux administration who is specialized in server setup. My project requires: - Setting up a LAMP on a Ubuntu server with MariaDB. - Configuring the server to respond to a specific domain name, empty folder mapping. - FTP and account mapping to the webserver's folder. Necessary skills: Ubuntu, LAMP setup (Linux, Apache, MySQL, PHP), FTP setup. Experience in managing and setting up servers is a must. This are a very easy setup so maximum 2 hours. Please add the word "Light" in your quote so I now you are not a bot...

I am looking for someone who can create a custom Minecraft survival server for me. Here are my ideas: - A group system where the initial group is predefined but can be changed by me at any time. - Players start in a spawn world where they can read and accept the rules through a fun animation before being allowed to enter the game. - Players can explore the area, buy and sell items, with NPCs distributed throughout the game world. - An in-game menu that allows users to teleport to different positions. This menu should also allow players to visit other players, enter their protected homes, and interact with them. - Different worlds: spawn world, farm world, and build world. The farm world is regularly reset, while the build world also has a protected spawn. - The spawn world and buil...

I am currently experiencing issues with my Moodle server database. Specifically, I'm encountering a persistent Cloudways error 524 and server timeouts. I am therefore looking for an expert with: - Deep knowledge in Moodle server databases who can troubleshoot and fix the error - Proficiency in server optimization to prevent future error occurrences and ensure seamless server performance - Familiarity with Cloudways would be a great plus, as I plan on reaching out to their support soon DO NOT put a Placeholder BID. Your role will involve diagnosing the issue, implementing a solution, and possibly optimizing the server to prevent this from reoccurring. Please confirm your relevant experience when bidding.

I'm seeking a Minecraft expert to help me set up a survival mode Minecraft server. Key Project Details: - **Survival Mode Setup**: The primary focus of this project is to create a distinctive survival mode suitable for a smaller player base. - **Unique Items**: I will need engaging, custom, and unique items for players to discover and utilize in the game. - **Crate Rankups Integration**: I also want to include a crate rankups system to add a layer of progression and reward for players. Ideal Skills and Experience: - **Minecraft Server Administration**: Experience in setting up and maintaining Minecraft servers is a must. - **Plugin Development**: Proficiency in developing Minecraft plugins is highly desired, specifically for creating custo...

I am looking for a skilled professional who can help me set up an AWS server for the purpose of uploading and hosting entertainment videos. While the exact size and quantity of these video files is yet to be determined, experience with large-file handling and optimization will be highly beneficial. The ideal freelancer for this project would: - Have a deep understanding of AWS server setup and configuration - Be experienced in video uploading and hosting - Ideally have prior experience handling large media files - Show aptitude in ensuring smooth video performance and accessibility.

I'm looking for a talented developer who can create a server for the old game Crossgate. The server should be accessible for casual gamers. Key Features: - Player Matchmaking: The server should facilitate the process of players finding and joining games. - In-game Chat Support: Implement a robust chat system to enhance player interaction. - Buy/Sell Special Items: Enable players to trade special in-game items. - Event Creation: Develop a feature that allows for the creation and management of in-game events. Ideal Skills and Experience: - Proficiency in server-side programming languages like Java, C++ or Python. - Previous experience in developing game servers and a solid understanding of networking protocols. - Familiarity with creating matchma...

I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

I need someone skilled in WordPress migration to move my old wordpress website to a new server. Ideal skills would certainly include WordPress expertise, familiarity with different hosting platforms, and a problem-solving approach to unforeseen challenges. Experience in crisis management would also be desirable as not all the necessary information is available at this stage.

I have a whm server with multiple wp blogs using wp automatic, a plug-in that has had multiple backdoors over the years, the plug-in is updated but the server probably has shell scripts or malware running

I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export...

...understand and implement complex backend features in my apps. - Firebase rules: A good understanding of how to set secure and efficient rules in Firebase is essential. - State management: I need to understand advanced state management techniques in FlutterFlow. - Data handling: I need to learn how to efficiently handle data within my applications and understand the best practices. I am a veteran PHP SQL developer and I find it difficult to wrap my mind around nosql and mobile app development in general. I am looking for: - An individual with advanced knowledge and experience in FlutterFlow. - Someone who can teach effectively in a one-on-one setting. - A patient mentor who can break down complex ideas into easily digestible concepts. - IMPORTANT: we need to understand each othe...

Full Karalina clothes store website creating - develop, design, administration, domain, structure.

I am looking for someone who can effectively install a simple server on Ubuntu and configure Wireguard / WG admin panel along with pihole. Your tasks will be; - Configuration of a fully accessible Wireguard WG admin panel - Setting up pihole on the server About 10/20 mins work depends Full access will be given Those who have prior experience in Linux server installation, Ubuntu system management and Wireguard configuration are highly desirable. An understanding of pihole configuration will be a plus. Complete details will be shared once I identify the right professional.

I need an experienced developer to create a bot for many Ragnarok Game private server. Key requirements include: - Capabilities for farming, auto-levelling, and auto-looting; - Ability to use potions; - Selecting certain Mobs and Items. - and many more • Advanced character leveling • Detailed item farming • Skill automation Additional features essential for these bots to possess are: • Auto potion consumption: The bot should be able to intelligently consume potions whenever required • Mob detection and avoidance: Bots must have the ability to detect and evade mobs automatically The bots should be able to bypass Gepard anti hack I'm looking for detailed project proposals that clearly outline how you'd tackle these requirements. Experience...

Buscamos incorporar especialista programador .net freelance con conocimientos en: c# .net, asp, sql server se valorará experiencia en: integraciones api, en back-end y front-end. Trabajo principalmente en remoto, para colaboración continuada en desarrollos propios de nuestra empresa, con un mínimo de 40 horas mensuales.

Hi Dear my website is up and running on hostinger. Only need to make https available. It is on cloudpanel. Issue is looking around location ~ /.well-known { auth_basic off; allow all; } IF you have experience, before kindly ping me. When you fix it, I need complete steps for it.

As a startup in AI and AI/ML solutions, we are seeking a part time senior data scientist to help us to design a text 2 sql solution using existing open source solution, integrate with other data service. Having a deep understanding of ,LLms , NLP, Text2SQL and AI Agent (OpenAI) , stream-lit will be essential. 3 hours days in average for a part time jobs for months; - The successful applicant must be fluent in Python and have a solid understanding of latest GPTs, GenAI and langchain, GenAI etc The ability to develop and fine-tune algorithms as per project requirements is paramount. If you are able to make AI comprehend and utilize human language, efficiently and effectively, your expertise is needed here.

I'm looking for a skilled developer to create an ef...skilled developer to create an efficient FTP script that will allow me to upload files to a specific folder in cPanel. Key Requirements: - The script should be optimized for small files, as large file handling is not a priority. - It should be developed in a language suitable for FTP functionality. The script will be used to automate the process of uploading files to a specific folder on a cPanel server. The ideal developer should have experience in: - Building FTP scripts for file uploads - Working with cPanel and its file management system - Ensuring the script runs smoothly for smaller files Please include in your proposal your experience with similar projects and any relevant skills that make you the ideal candidate...

DotNet developers required for "'Errors removal and Improvement work in thenafter Host on server"'. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Errors removal and Improvement work which has to be done is explained in below link-

We are looking for a part-time virtual assistant to support our online store. You will be handling vario...virtual assistant to support our online store. You will be handling various tasks, including: - Email Management: Regularly checking and responding to customer inquiries, inquiries from suppliers, and other related communication. - Customer Support: Assisting customers, resolving complaints, and ensuring their needs are met in a timely and friendly manner. - Accounting: Basic financial administration, such as registration, tracking transactions, updating spreadsheets, and providing basic financial reports. The potential candidates should have a valid security number and a utility bill in Cyprus as our based is in Cyprus. Your expected workload will be less than 10 hou...

...- Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated manually, so a part of this project will involve making recommendations for automating the data update process. Please only apply if you're confident in y...

I urgently need a qualified freelancer to install Red Hat Linux on my server. This will be specifically for running SAP applications. Key points to consider: - You should be experienced in setting up Red Hat Linux for server use - The installation must be completed as quickly as possible - ASAP This project needs immediate attention. The quicker you can get this done, the better. Bid with confidence if you are confident in your speed and skill set.

I am in need of a skilled professional to assist me in setting up my almalinux 8 VPS and then installing cPanel on it. Specifically, I would like to have the following services installed and configured as part of the initial server setup: - Apache - MySQL - PHP It's essential for the freelancer to have experience in setting up VPS servers, particularly with a specialization in almalinux 8. You will also need to have a thorough understanding and experience with cPanel installation.

I need a Full Stack Developer comfortable with React, Sass, .NetCore, and SQL Server to work on my website, web application, and mobile/desktop app. The primary goal of this project is to develop a responsive, high quality website that also functions as a web application, with the potential for further expansion into mobile and desktop applications. We are looking forward to have a complete Computerized Maintenance Management System (CMMS) / Maintenance Work Order(MWO). A Complete Control Pannel on Web based asapplication along with the Mobile APP + Desktop APP. With the below added features.:- + It will have Website Fully responsive, Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and...

I have a plain PHP script where users can select teams, but I haven't imported the players yet. I already have SQL queries for this, so they need to be imported and linked to their respective teams. When a user selects League 1 and, for example, Team Feyenoord, they should automatically get access to the players from that league. A league can only start if there is at least one real user active in that league. There are 10 leagues in my database. Nothing should happen if there is no active user linked to a league/team. Now, here's the exciting part. Every match should be generated at 00:00 with certain random variables. So, for example, if a player is in League 1, I want all matches in that league to be generated. I've created an example of how I want to visu...

I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive design w...

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a...

I need to install a Microsemi 600 NTP server for my network, which is a mix of wired and wireless connections. The primary goal of this installation is to ensure time synchronization across a range of devices, which totals between 10 and 50. Key Tasks: - Installation of Microsemi 600 NTP server - Configuration for both wired and wireless network environments - Synchronization of 10-50 devices Skills/Experience: - Previous experience with NTP server installation and configuration - Expertise in network infrastructure, particularly in mixed wired and wireless setups - Understanding of time synchronization protocols - Proficiency in handling multiple devices for a uniform operation

...I require product details and price information from the site. - The main task involves capturing a comprehensive car database, including all car brands and models present on the site. The focus here is on the complete car directory, not just specific brands or models. If you have experience in web scraping, particularly in the automotive sector, this project is for you. Accuracy and completeness are key, as the success of the project hinges on the comprehensive nature of the dataset. I attached RAR file (Scraping code). by running this script, fetching yourself full database of cars. pocketbase queries to supoprt filters and run them on pocketbase server side routes, so that they can be used to feed data to views. (looks not important for now). S...

I've devised a dummy website primary for understanding log analysis which is a major concern in today's advanced technology world. To test its vulnerabilities, I require a well-rounded professional equipped with proficiency in PHP and Node.js. - Focus Area: Your tasks will encompass SQL injection techniques over my website's user login systems, data retrieving systems, and contact forms. - Skill Set: An experience with SQL injection tests is crucial. Knowledge of web technologies such as PHP and Node.js is essential. Understanding of website log analysis will also be advantageous. Your comprehensive reports on the performed tests and findings will enhance the robustness of my website and will aid in my understanding of the log analysis for future developmen...

I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Exper...

...in both AWS and Debian server management. The job involves setting up and maintaining the AWS and Debian infrastructure and networking. Key Responsibilities: - Setting up and managing AWS services such as EC2 and S3. - Handling Debian server administration, particularly focusing on networking. - Ensuring that the EC2 instances can handle a small workload and that the S3 bucket meets our small storage capacity needs. Ideal Skills: - Proficiency in setting up and managing AWS services, particularly EC2 and S3. - Strong experience in Debian server administration, with a focus on networking. - Ability to ensure that the EC2 instances can sustain a low workload and the S3 bucket meets our minimal storage capacity requirements. Your successful execution...

I need a highly competent developer experienced in RS232 and RJ45 Ethernet for a specialized project. The principal purpose of this project is to convert serial data to Ethernet data. This data conversion is specifically tailored for Industrial control systems. Key competencies and preferences: - Expertise in RS232 and RJ45 Ethernet. - Familiarity with TCP/IP and Modbus TCP because these are the communication protocols the server host needs to support. - A strong background in industrial control systems development. The desired outcome of this project is a seamless data dialogue between devices via Ethernet. Can't wait for your input.

I am looking for an experienced developer to set up an Airtable Database for me. This project involves creating a systematic way to handle, organize and manage our client information, employee management details, and project tracking. Key tasks include: - Setting up an Airtable Database - Enabling specific functionality such as data import/export - Custom form creation for easy data entry and extraction - Integration with other apps for streamlined operations Ideal Skills and Experience: - Proven experience in using and setting up Airtable databases - Strong understanding of data integration and manipulation - Familiarity with custom form creation - Experience with app integration for seamless data sharing - Knowledge in handling sensitive data with an emp...