Sql server 100 million rows jobs

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 the security and efficiency of our remote w...

I have been doing online business for more than five years. The 2023 revenue is $4.5 millions. I'm on the hunt for a professional high ticket sales closer with an in-depth understanding of the e-commerce industry. I'm launching an online school focusing on teaching individuals how to build successful multi-million-dollar e-commerce businesses. My target audience is motivated individuals eager to learn the e-commerce ropes and willing to invest in high-level education. Key Responsibilities: - Convert interested prospects into students - Possess persuasive consulting services skills - Foster relationships with potential clients Ideal Skills and Experience: - In-depth knowledge of the e-commerce industry - Proven track record in high ticket sales - Expertise in consult...

...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 the new PySpark script can handle a large volume of data and maintai...

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

...up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming languages.  Strong understanding of database design principles and data modeling techniques.  Experience with database performance tuning and optimization.  Excellent communication and leadership skills.  Ability to work effectively in a fast-paced environment and manage multiple priorities.  Relevant certifications in Netezza and Oracle te...

...members of India’s rising working class. Our mission is to connect people to opportunities and help reduce the skill and employment gap. We help candidates build their digital professional identities, find the best-fit hyperlocal jobs, grow their network, and learn new skills to grow their careers. Employers can find the best talent and hire for over 70 different roles. Having raised $190+ million from marquee investors like Insight Partners, Tiger Global, Lightspeed India, Sequoia Capital, , and Greenoaks Capital, Apna is on a mission to enable livelihoods for billions in India. About the Role We are seeking a dynamic and creative Senior Copy Writer to join our Marketing team. As a Marketing Scriptwriter, you will be responsible for crafting compelling and engaging s...

Our existing ...CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

I've encountered an internal server error on my website when accessing a specific page. This issue is particularly critical as some of my visitors are unable to access my site due to this error. While some visitors can browse the website, others are completely blocked. Key Project Details: - The error is triggered when accessing a specific page. The rest of the website is accessible. - The issue is causing a split in visitor access, with some able to view the site consistently and others unable to access at all. - The problem is particularly urgent as it is directly impacting my site's usability. Skills and Experience Needed: - Proficient in troubleshooting common internal server error causes. - Experience in addressing website access discrepancies for users based...

I encountered an internal server error while trying to access a specific webpage on my website. The error is isolated as it only occurs on certain pages. Some visitors can access the site and some cannot. For example: I can access with WiFi but not with my mobile connecction. The ideal freelancer for this project should have: - Proficient understanding of server-side technologies and the workings of web servers. - Strong problem-solving skills and the ability to troubleshoot technical issues effectively. (Wordpress) and (godaddy) - Experience in handling internal server errors, ideally on specific pages. - Good communication skills to effectively inform me of the error's cause and resolution. Please contact me if you have experience with this issue and think you...

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...with the data visualizations, such as filtering views based on time or sentiment. Tools & Techniques: Web Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. D...

I'm in need of an experienced web developer with strong shell scripting skills. While the main purpose of the website application is not specified, it's targeted at the general public. Ideal Skills and Experience: - Proven expertise in web application development - Experience in creating websites geared towards the general public - Robust skills in shell scripting - Ability to independently make decisions to enhance website functionalities Note: As the tasks for shell scripting are undefined, a flexible way of working is preferred for meeting emergent needs in the project.

...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills,...

I'm in need of an IT professional to set up an SMTP server on my Debian server. The primary purpose of this setup is to allow the server to send out automated email notifications for a custom-built application. Key requirements and expectations for this project include: - Setting up an SMTP server specifically utilizing Sendmail software on a Debian server - Ensuring that the configuration is optimized for automated email notifications - Providing guidance or documentation on how to integrate the SMTP server with my custom-built application Ideal candidates for this project should possess the following skills and experience: - Proficiency in working with Debian servers and setting up SMTP servers - Prior experience with Sendmail configurat...

I have a PostgreSQL database hosted on AWS. When trying to connect to my database server from my web application, I'm consistently receiving a TCP/IP error. Key Project Points: - The issue is specifically related to the TCP/IP connection between the web application and the AWS PostgreSQL database server. - The PostgreSQL database is hosted on AWS; it's not a local instance. - The web application is the only service experiencing this issue with the server. Ideal Freelancer: - Proficient in AWS services, particularly Amazon RDS for PostgreSQL. - Strong background in dealing with network errors, particularly TCP/IP. - Experience in troubleshooting web application and database connectivity issues.

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

Hello After a reboot of a server our cpanel not working anymore, need urgent helpwith IMMEDIATE availability

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portf...

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...

I'm looking for a server administrator with intermediate Drupal experience to handle ongoing maintenance. Key responsibilities include: - Monitoring the server's performance and troubleshooting any issues that arise. - Ensuring the server remains secure and up-to-date with the latest patches. - Regularly backing up the server's data to prevent loss in case of failure. - Updating and maintaining the Drupal installation, ensuring compatibility with the server setup. Ideal skills and experience: - Proficiency in Linux server administration and management. - Intermediate level of experience with Drupal, including installation and configuration. - Strong troubleshooting and problem-solving skills. - Understanding of best security practices for server...

...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled f...

Bought a react eCommerce template (front-end & back-end) from theme-forest. Provided documentation is not enough for server side installation. I need professional assist to install the project on server side and install the theme on server side.

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

I'm seeking a skilled grant writer to secure $5 million funding for an addiction treatment center predominantly serving adults battling substance abuse. Key services we plan to offer include: - Detoxification programs - Counseling and therapy sessions - Support groups and aftercare programs The ideal freelancer will have extensive experience with grant proposals focused on healthcare or substance abuse treatment. Understanding of the unique challenges related to addiction treatment is preferred. Please highlight relevant examples of successful substantial grant procurements in your proposal.

I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.

I'm seeking a skilled REDM game developer, who takes a particular interest in creating a Roleplay server on the REDM network. Expertise in developing game mechanics are key for this project. The primary task involves: - Developing a Roleplay server game. - Incorporating customizable characters, multiplayer functionality, and an in-game economy system. A successful freelancer will have a good understanding of how to create immersive and engaging Roleplay environments, and experience in implementing character customization options, multiplayer functions and economy system into such a game. Candidate should possess expertise in REDM server game development and game design principles. A proven track record in similar projects will be advantageous.

I'm looking for a skilled AWS expert to help me set up a highly performant proxy server that can support multiple protocols. Key requirements include: - Setting up the proxy server in AWS - Configuring elastic IPs for the proxy server - Ensuring it runs at an optimal performance level - Supporting multiple protocols The proxy server should be designed to accommodate a high volume of traffic and provide a seamless, fast browsing experience. Ideal candidates should have: - Extensive experience with AWS services - Proficiency in configuring and managing proxy servers - A strong understanding of networking and server optimization Please bid with a clear outline of how you plan to approach this project, including any relevant experience you have that...

I require a skilled Linux administrator to assist setting up a server on my local machine. I currently have a domain, cloudflare, WSL, ubuntu, ollama and ollama webui. I'm getting stuck on connecting my domain through cloudflare tunnel to my linux server so that I can access ollama's webui remotely. Key Responsibilities: - Install and configure Linux server for accessing the Cloudflare tunnel website - Ensure the server is optimally configured for devices outside the network Ideal Skills: - Proficient in Linux server setup and administration - Experience with Cloudflare tunnel configurations - Knowledgeable about server configuration for network accessibility - Background in IT security to ensure secure network access. -Experience with...

I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.

I need someone to post 100-200 posts on my instagram page Content has to include pictures and reels and has to be good enough to get some views/likes Niche will be picked

As an individual making use of Google Maps for specific personal applications, I am in need of a freelance developer adept at using VB.Net and SQL database to develop a program that will post activities on Google Maps. This software will be particularly handy in marking and recording various personal activities. The Successful Freelancer: - Should provide evidence of experience in VB.Net coding and SQL database management. Showcasing past work that is similar to this project will be beneficial. - They should also understand the implementation of access levels in software development as the map posting feature will be restricted to admin use only. Main Activities: - Create a software application using VB.Net. - Link the application to Google Maps. - Develop a feat...

I'm seeking a professional to help set up a Windows-based server using virtual machines for the purpose of managing remote profiles. Key requirements: - Proficiency in setting up and configuring Windows Operating Systems - Experience in creating and managing Virtual Machines, particularly in a VPS environment - Prior work in server configurations and network management The ideal candidate will be able to work efficiently, communicate effectively, and provide guidance on scalability and security for the server setup.

...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great opportunity...

...one-time analysis. The dataset to be worked on is quite large, with over 1000 rows, so I need someone who is well-versed in handling and analyzing large datasets in this platform. Key tasks for this project include: - Data analysis and visualization: I require someone who can understand the dataset thoroughly and present insights in a visually appealing manner. - Formulas and functions calculations: You should be able to create complex formulas and functions to derive the necessary insights from the data. Ideal candidates should possess the following skills and experience: - Proven track record in data analysis and visualization using Google Sheets. - Strong expertise in working with large datasets (1000+ rows) within Google Sheets. - Proficiency in creating and implemen...

Our website/blog has been done on standar WP template 2024: Our website/bloge has been planned in these rows: 1. Head: our logo 2. Blog with 3 news 3. Field of actions (aree di intervento) 4. Events 5. Services/Programs 6. Books to buy 7. Video to watch The changes we need in our website template, row to row: 1. Head: our logo It is ok. 2. Blog with 3 news 2.1 Titles of the news has to be changed in lowercase (only first letter uppercase) 2.2 The text of the news have to wrap at the end of the word, not interrupting the word 3. Field of actions (aree di intervento) 3.1 The the written texts (Empowerment delle Persone, Empowerment delle Aziende, Empowerment delle Comunità Locali) have to be centred in the middle (horizontal direction) of 3 columns of news 4. Events

Hello, I would like to hire someone who can create a complete discord server, with bot design, channels, etc.

As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.

Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project...

I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI

We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, with up...

We are seeking a Business Data Analyst for our team who is willing to work with new ...Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...

I'm in need of an experienced individual to migrate my current Moodle site from a shared server to a dedicated server. This move is primarily to prepare for an expected increase in traffic, and I'm looking for someone who can not only handle the technical aspects of this migration but can also help with optimizing the server for improved performance. Key Requirements: - Expertise in server migration, specifically Moodle - Ability to create a custom configuration for performance optimization - Prior experience in handling increased traffic on a dedicated server Please only apply if you have experience with Moodle and can guarantee a smooth migration process.

I need a skilled CorelDraw expert to create a beautiful and intricate wedding invitation template. Key Requirements: - Create a template similar to the provided sample - Add various ornaments like leaves, flowers, twigs, etc. to enhance the design. Skills: - Proficiency in CorelDraw is a must - Previous experience designing wedding invitations is highly preferred. - Ability to create intricate, detailed designs with various ornaments Size and Color Scheme: The color scheme and size for the template are open to your creativity as the user skipped this information. Feel free to make suggestions and propose your ideas for these elements. Please ensure that the design is elegant, visually pleasing and suitable for a wedding theme.

We are looking for a skilled freelance...parsing, DOM traversal, and data extraction. Experience with optimizing scraping scripts for speed and scalability. Familiarity with cloud-based infrastructure and services for deploying and managing web scraping scripts. Excellent problem-solving skills and attention to detail. Nice to have: Experience with optimizing scraping scripts to achieve high-speed data extraction rates (e.g., scraping 10M rows per day). Knowledge of proxy management, IP rotation, and other techniques for avoiding IP bans and accessing blocked websites. Familiarity with databases like MongoDB for storing scraped data. Terms: This is a remote freelance position. The project duration is [specify duration]. Payment will be negotiated based on the scope of work and del...