Database project sql jobs

...looking for a skilled Data Engineer to assist in a large-scale data project that involves data cleaning and preprocessing. Key Responsibilities: - Integrate and process data from various sources including Databases, CSV files, and APIs - Handle a high volume of data (more than 10GB) efficiently - Implement data cleaning and preprocessing techniques to ensure quality and consistency Ideal Skills: - Proficiency in handling large-scale data sets - Strong experience with integrating and processing data from diverse sources - Expertise in data cleaning and preprocessing techniques - Knowledge of relevant tools and frameworks for data engineering Prior experience in similar large-scale data cleaning projects and proficiency in SQL, Python, and ETL tools would be highly advant...

...of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating daily database ...

...professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and data...

...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying...

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...

I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...

...areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailor solutions accordingly. - Familiarity with perfor...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Mic...

need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precis...

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 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 comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more

I need a fast turnaround to correct error messages in my PHP code and database. The main goal of my PHP application is to upload content to the database and ensure the site displays it correctly. Key Responsibilities: - Fixing error messages in PHP code - Addressing database issues - Ensuring smooth content uploading functionality - Ensuring the site can retrieve and display content from the database Ideal Skills and Experience: - Proficient in PHP - Strong understanding of database management - Prior experience in troubleshooting and fixing error messages - Ability to work fast and deliver under tight deadlines.

I'm looking for a task-oriented individual who can assist me with saving documents from an online database. Your assignment would primarily revolve around focusing on documents and seamlessly saving them off. Key responsibilities: - Download documents with my full permissions. - Make sure that all downloaded files are in audio file format and labelled correctly. The ideal candidate will have: - Relevant experience and proficiency in saving files to dropbox. - Excellent attention to detail ensuring the correct files are stored. May be 1-2 days of work.

MUST Read All DESCRIPTIONS! I'm seeking a highly skilled data engineer with a strong proficiency in Apache Kafka to work on a data integration project. The main objectives of this project are: - Integrate various data sources: structured (SQL database), semi-structured (XML, JSON), and unstructured (emails, documents) - Develop a robust data flow architecture - Ensure efficient data transmission across systems The perfect freelancer for this job should possess the following characteristics: - In-depth knowledge and practical expertise with Apache Kafka - Experience with integrating diverse data sources, such as SQL databases, XML, JSON and unstructured data (emails, documents) - Proven track record of successful data integration projects Fe...

...of the project. It should be designed to handle our Software as a Service (SaaS) licensing. The main functionalities required are: - **Payment Processing:** The portal needs to process payments from our clients. - **License Management:** The portal should manage our SaaS licenses. Ideal candidates for this project should be well-versed in web development, particularly in creating user-friendly and efficient customer portals. Experience with integrating Square and Zoho Books is a plus. It's crucial that the website and portal are secure and scalable. A good understanding of SaaS models would also be beneficial. Additional Requirements IoT Hybrid Solutions Website with Customer Portal for Product License Management and Payment Requirements Documents Project ...

I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. ----...

...crucial database issue with my website built on Node.js. There are certain missing tables that cause the application to crash whenever specific buttons are clicked on the site. Key Details: • The crashing issue is experienced when the Login button, Submit form button, or the Add to cart button is clicked. • Due to these unsolved errors, the terminal indicates that a certain table name is not found. Ideal Skills and Experience: • Solid background in solving database issues in Node.js platforms. • Experience in working with missing tables and rectifying database errors. Application Requirements: Freelancers interested in this project should include detailed descriptions of their previous and related experiences in their application. T...

...background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results. Project extension - If it's p...

I'm running a new PHP script on Linux and it's not pulling data correctly from an MSSQL Database. Since the script is new, I'd appreciate some help identifying what went wrong. Skillsets and Experience Needed: - Proficiency with PHP and MSSQL databases - Experience troubleshooting PHP script issues in a Linux environment - Experience with new script debugging - Knowledge of database connectivity issues and their solutions - Ability to communicate complex technical issues clearly

I'm looking for a skilled freelancer to assist with text data entry from online sources into a database. Key Responsibilities: - Inputting data from online sources into a database - Ensuring accuracy and consistency in data entry The ideal candidate should have: - Proven experience in data entry, particularly from online sources - Strong attention to detail to ensure accuracy - Proficiency in database entry methods This is a straightforward project that needs a reliable, detail-oriented individual.

...our dynamic IT team. The ideal candidate will possess expertise in Perl, Python, and XML/XSLT, and should be familiar with MySQL. Responsibilities: Develop And Maintain Software Applications Using Perl, Python, XML, XSLT, And Database Technologies. Design And Implement Data Transformation Processes Using XML And XSLT. Write Efficient, Clean, And Reusable Code That Complies With Company Standards And Best Practices. Collaborate With Project Managers, Business Analysts, And Other Team Members To Understand The Requirements And Provide Technical Solutions. Perform Database Management Tasks, Including Design, Modifications, And Performance Tuning. Assist In The Integration Of New Software And Systems Into Existing Environments. Maintain Documentation For System Proces...

I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication

...this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order and manually decide on what product to send the user. I will need an e...

I'm seeking a Laravel expert to help resolve a database connection error I'm experiencing on my website. This error occurs specifically when trying to access certain pages. Key requirements: - Experience with Laravel: You should have a strong understanding of Laravel's structure, especially concerning database connections, in order to diagnose and resolve this issue efficiently. - Troubleshooting Skills: You should be adept at identifying the root cause of the error, whether it be an issue with the code, configuration, or server setup. - Efficient Communication: As I have full access to the website's server and database configuration files, you may need to collaborate with me to access the necessary resources.

...issues with my Node.js site, I require an expert in database management to remap the database. Specifically, clicking on 4-5 specific buttons frequently crashes the site, displaying an error of "table not found". Understandably, this is impacting the usability and overall user experience of the website. The key project objectives include, but are not limited to: 1. Diagnosis and rectification of the error causing the site crash. 2. Remapping of the website database to eliminate the current recurring issue. 3. Arguably most vital, is the safe retainment and integration of the old member data within the newly rectified database. Ideal applicants should be proficient in Node.js and database management, especially handling and rectifyin...

I'm in need of a skilled .NET developer to create a functional web application that mainly handles user registration, login, and database management. Key Requirements: - User Registration and Login: The application should have a robust system for users to sign up, log in, and manage their accounts securely. - Database Management: Proficient database management within the application is a must. This includes data storage, retrieval, and manipulation. Additional Information: - External Integrations: There is a possibility that additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While th...

I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financ...

...an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project should have: ...

I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.

...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...

I'm in need of a professional who can help me with installing the Oracle 23c database on my Ubuntu Linux system. Key Skills: - Proficiency in Oracle database installation - Specific experience with Oracle 23c - Strong understanding of Ubuntu Linux The selected candidate should be able to: - Perform a detailed installation of Oracle 23c database (enterprise version) on Ubuntu Linux - Ensure proper configuration to meet the project's requirements - Provide guidance on any post-installation tasks that may be necessary Is there any possibility to install a 23c oracle database enterprise version not free version on docker?

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 currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.

I need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice versa. ...

...of using redis to improve performance. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. This task should be delivered in 1 day and if it is successfully completed we would like to keep the developer long term with 20-40 hours a week working on converting our angular.js to (we have already converted 50-60% to ) and also transfering our .NET to .NET CORE and our MS SQL to PostgreSQL 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 i...

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'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.

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 strong track ...

...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'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 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’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...