Database administrator jobs

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen issues th...

...it to draw IMEI numbers both randomly and from a database based on specific parameters. Key Features: - **Dual Functionality**: The tool should be capable of generating IMEI numbers randomly or by allowing me to specify certain parameters. - **Parameter Selection**: The parameters that I should be able to choose from when generating IMEI numbers are the device brand and the operating system (OS). - **Web Interface**: The tool should be accessible through a user-friendly web interface that allows me to easily generate the IMEI numbers. Skills and Experience: - Proficiency in Python, as I believe the tool can be built on existing scripts like ``. - Experience in working with databases, ideally with knowledge of the TAC database. - UI/UX design skills to create a simple an...

...competent freelancer with an understanding of MS Access Database creation. This project is aimed at developing a food manufacturing cost-tracking function on top of an existing product management database, while cleaning the existing database up and adding reporting functions. The project involves: 1. Cleaning up existing Database file of Products to a new layout (Can start again or build on existing file). 2. Adding the manufacturing cost analysis function to the database (Allows user to define ingredients and fixed costs for a product and calculate it’s cost price). 3. Adding the sub-recipe costing function – same as above, however, for internal products not sold. 4. Adding the ingredient purchase price and tracking to the database...

I need a NoSQL database system that can effectively manage our company's purchases, production, and inventory. The project needs to be completed within a month. Attached the Project details ... Key Features Required: - Scalability: The system should be able to handle large amounts of data and growing demands. - Flexibility in Data Modeling: I'm looking for a system that can adapt to our changing business needs without compromising on performance. - High Performance: It's crucial that the system can process data efficiently and provide real-time insights. Ideal Skills and Experience: - Proven experience in designing and implementing NoSQL database systems. - Strong understanding of data modeling and its impact on system performance. - Ability to d...

I'm looking to hire a web developer and designer proficient in building an aesthetically pleasing and functional character-storage site that is equally immersive. Key Features: - A platform for managing and displaying detailed character profiles. - Capabilities to categorize data such as names, descriptions, stats, abilities, and corresponding images or artwork. - An integrated search feature to filter out specific character types. Artwork Requirements: - The site should be able to host a variety of artwork formats like character illustrations, and digital paintings. - The developer should implement features for GIF support, to showcase more dynamic character pieces. The ideal candidate has previous experience designing and developing similar sites, a keen eye for aesthetics, exce...

I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen issues th...

I'm currently seeking an experienced Linux system administrator to connect my Ubuntu-based Digital Ocean server to a Pterodactyl panel. Your tasks for this project, ideally completed within a short timeframe, will include but are not limited to: - Seamless connection of the server to the Pterodactyl panel. - Full preservation of existing user profiles on Pterodactyl during the process. What you should ideally have: - Proven experience in Linux System Administration, particularly with Ubuntu. - A solid understanding and hands-on experience with Pterodactyl panels. - Capability to process tasks with full root access. It's crucial that you know exactly what is required to ensure a secure and functional connection. Also, you should be able to solve any unforeseen issues th...

I am looking for an experienced Data Entry Operator for a specific task. The main pur...Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s make our customer da...

Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other

I'm in need of an experienced MySQL and Neo4J expert who can help me with designing a database schema and an ERD Diagram from a CSV file. Make a report of the database with proper screenshots and run some queries. more details in chat... Requirements: - Proven expertise in MySQL and Neo4J - Solid understanding of database schema designing - Producing an ERD Diagram

I'm looking for a talented data researcher who can scour government databases to identify Pension variables. The data you'll be researching will be at the heart of the project, so it's pivotal that you are efficient, detailed, and reliable. Key Duties: - Methodically research and compile comprehensive data from government databases - Focus on economic indicator data - Ensure accuracy of collected data Ideal Skills & Experience: - Strong research skills, particularly in government databases - Background in economics, with a solid understanding of economic indicators - Keen attention to detail, ability to interpret and organize complex information effectively - Previous experience in data collection or analysis roles is a huge advantage. Perfect for those who prefer wo...

I'm looking for a skilled and experienced developer to architect a database for a Healthcare application using Node.js. The primary goal of this project is designing a robust, efficient and scalable database that can handle the data requirements of a healthcare application. The database should be able to effectively store and manage sensitive patient information, interaction records, and other relevant data. Key requirements include: - Expert level understanding of Node.js and database design principles - Previous experience developing databases for healthcare applications is a plus - Ability to ensure compliance with healthcare data security standards - Strong problem-solving and analytical skills - Effective communication and collaboration abilities, a...

I'm seeking a WordPress developer highly skilled in WooC...landing pages and shopping pages for each customer, enhancing shopper experience. Key Features: - **Personalized Pages**: Your task is to construct unique landing pages and shopping pages, accessible only by the respective customer for personal interaction. - **Product Recommendations**: These unique pages must include personalized product suggestions, dictated by my manual selections as an administrator. Ideal freelancer for this project is proficient in WooCommerce and understands its functionality for implementing restrictions and personalizations. An understanding of user behavioral psychology can be an asset in creating an engaging shopping experience. Past portfolio demonstrating similar tasks will be great...

I am in need of a system administrator, highly experienced in Linux, who will best suit the following responsibilities: - Network Configuration: Properly set up, maintain and optimize our Linux-based networks - ensuring seamless inter-linking and efficient communication. - Database Management: Oversee the upkeep, troubleshooting, and security of our databases. This includes ensuring regular data backup, restoring lost data and maintaining database performance. Our setup currently comprises 1-5 servers and databases. As the successful candidate, you will be charged with managing and ensuring the smooth running of these systems. Prior experience in Linux, Network Configuration and Database Management is explicitly necessary. Your commitment to understand...

I am in urgent need of a developer to help me delete some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files do not involve any specific criteria for selection. The process is straightforward, and all relevant files need to be removed. Ideal skills and experience: - Proficiency in database management and SQL - Experience in managing ecommerce and affiliate systems - Ability to work under tight deadlines - Good communication and collaboration skills

I need an efficient and detail-oriented freelancer to populate a database with information about my customers. The project involves collecting, inserting and cleaning the following data of around 12,000 rows of potential clients. The main data management tasks would be analyze, identify and delete duplicates, and the main data to be collected would be only: - Customer Name - Email Address These data points will be provided, and your task is to efficiently and accurately compile this information into our database. Experience in data entry, database management, and customer service will be beneficial to complete this project. Knowledge of Excel and other data management tools is essential. The freelancer must be meticulous and trustworthy as they will be handling sensi...

Hi, We have an acrylic case website that we want to set up custom product search and filtering for. We are wanting to offer true fitment for cases instead of generic fit. With that mission, we need to provide users with a way to search for products that they wish to protect with a Fitment Search feature on our website. This will likely be a database and require one table. An administrator would populate the data in the table, which will power dropdowns provided to users to navigate to their proper product. I have a detailed multi page brief that I can send after making contact.

I'm searching for a proficient Python Developer to construct a high-performance database proxy and load balancer. This system should cleverly guide requests to compute engines in a manner that both reduces cost and heightens throughput. This system will run queries with minimal latency and virtually zero queuing. Key Aspects of Project: - Develop a robust database proxy using Python - Implement intelligent request routing to minimize cost and maximize throughput - Guarantee low latency and minimal to zero queuing while executing queries The ideal candidate will have the following experience and skills: - Proficiency in Python - In-depth understanding of database management systems, particularly Snowflake - Experience with handling structured data - Expertise...

I am seeking an experienced PHP developer to fix functional errors in my PHP code that's designed for searching text data in a MySQL database. The primary function of the code is to facilitate this search, hence it's crucial that these errors are addressed in a timely and efficient manner. Key Responsibilities: - Identify and resolve functional errors in the PHP code - Ensure smooth and accurate search functionality for text data in the MySQL database Ideal Skills and Experience: - Proficient in PHP programming with a strong understanding of MySQL database - Previous experience in fixing functional errors in PHP code - Ability to conduct thorough testing to ensure search functionality is robust, accurate and efficient This project is time-sensitive, so th...

... Key Features Required: - Customer Database Management: A well-structured and easy-to-use database to store customer details efficiently. - Sales Tracking: Built-in capabilities to track and analyze sales data, which will enable us to better understand our business growth and trends. - Inventory Management: An integrated inventory management system to efficiently monitor stock levels and streamline our operations. - App Integration: A feature that can seamlessly connect our clients to our business through an app. Core Skills and Experience: Ideal freelancers should possess: - Proficient skillset and experience in software development (specifically Windows and macOS compatible software). - Knowledge in developing systems for Customer database, Sales track...

I am looking for a detail-oriented freelancer to help convert my existing Excel spreadsheet data into a database format. Requirements: - Import and convert Text Data from Excel Spreadsheets to Database format - Accurate and efficient data entry skills required - Prior experience with Excel and database formatting is a must - The candidate should have an eye for detail and be well-versed in data management By the end of the project, I expect all data from the Excel spreadsheet to be neatly structured and readily accessible in the new Database.

...lot of very good LMS availables. Im thinking in integrate by API with some of them or use some if accomplish my expectations. The platform that I would like to have, includes 3 modules: A. Client. Administrator of the client company. I need for the client (manager) 1. Client registration (companies), and acceptance of terms of use. Validate email and mobile number. 2. Selection of a Course and the numbers of students. 3. Payment and invoicing process 4. Setup (add emails of the students) 5. Send invitation to participate by email with unique link.      6. Follow up dashboard for administrator (statistics, accomplishment rate, resend messages, download data) 7. Create users (assistants) B. Student. Worker receiving a training. I need f...

I'm currently using Oracle and MySQL database management systems and I'm in urgent need of a dedicated database administrator who can expertly handle performance tuning, backup and recovery, and security management. The ideal candidate should have an extensive background in both Oracle and MySQL, as well as a solid understanding of the nuances of these database management systems. Here's what the project covers: - Performance Tuning: I'm experiencing sub-par performance with my existing workloads, and I need someone with a knack for diagnosing and resolving complex performance issues. - Backup and Recovery: An integral part of the project is to safeguard the digital assets by implementing robust backup and recovery strategies, thus to ensu...

I require an experienced ERPnext developer who can optimize my business operations. Key tasks include: 1. Migrating my database from to hostmonster.com. Due to this, expertise in data migration, specifically regarding these platforms, is vital. 2. Establishing a connection with "ClaimMd" through its API. For this, proficiency in API integrations, preferably with ClaimMd, is essential. I currently have the necessary API credentials on hand. API instructions can be found here: ( ) 3. Implementing a bidirectional connection between a custom doctype, timesheet, and invoicing. Therefore, knowledge in generating, managing and integrating custom doctypes in ERPnext is necessary. Your experience in installing new themes on ERPnext will also be highly regarded

I'm seeking assistance in creating registration forms generated directly from a database. The key deliverable is a dynamic, user-friendly registration form that features predominantly mandatory fields for personal details and contact information, and a few optional ones as well. Specific requirements include: * Fields for personal details such as name, age, gender, etc. * Contact information fields like phone number, email address. * Optional fields that users can choose to fill if they wish. The successful freelancer should have: * Proficiency in database management and form generation. * Experience in user-friendly and intuitive form design. * Attention to detail to ensure all mandatory and optional fields are accurately represented.

...of a skilled FoxPro developer who can help me in managing my small and simple FoxPro database. The ideal candidate should be equipped to: - Perform regular management tasks such as data entry and data organization. - Conduct troubleshooting and bug fixing when necessary. - Focus on optimizing the database's performance to ensure smooth operations. - Implement data analysis and reporting features for better decision-making processes. The project is relatively straightforward given the size and complexity of the existing database. I am, however, looking for someone who can provide efficient and effective solutions for the aforementioned tasks. Ideal candidate should have: - Proficiency in FoxPro database management and troubleshooting. - Experience in optimi...

I'm in need of a data entry specialist to assist in the creation of a new database. The primary task will be to input text data from digital files. Key responsibilities include: - Accurate and efficient data entry of text information - Organizing data to ensure it's ready for database implementation - Ensuring data integrity and consistency Ideal skills for this project include: - Proficiency in data entry - Attention to detail - Familiarity with database management - Excellent organizational skills The goal of this project is to have a comprehensive and well-structured database, primarily populated with the text data provided. Please pitch your relevant experience and approach for this task.

I am seeking a professional for a data entry project. The task will involve transferring numeric data from digital files into a specified format in a database. Key tasks will include: - Accurate translation of numeric data from digital files, - Adherence to specific formatting as required by the database, - Ensuring the integrity of the transferred data, - Timely progress and completion of assignments. The ideal candidate should: - Have a keen eye for detail, - Have solid experience in data entry, - Be familiar with database systems, - Have excellent time management and organizational skills. This project will require precision and reliability. It's essential to ensure the accurate and systematic input of the numeric data. I look forward to your support in ...

I need a well-organized individual who is skilled in numeric data entry. Your task will be to gather numeric data from online resources and enter it into a database file. This job requires precision, so I need someone who pays great attention to detail. Ideal Skills: - Proficiency in gathering data from online sources - Experience in numeric data entry - Knowledge in creating and managing database files - Attention to detail and accuracy

We have initiated the deployment of a collective video call service using an open-source platform within the Microsoft Azure environment. The virtual machine (VM) and network resources have already been configured, but the project requires finalizing the setup to ensure the service is accessible both within and outside of Azure (internal and external IP). We are seeking an experienced professional who can complete the following tasks: Required Services: Review the current configuration of the virtual network and VM in Azure. Complete the network parameter setup to ensure the video call service is accessible over the Internet, including the configuration of firewall rules and network security if necessary. Install and configure all necessary components and dependencies on the virtual mach...

I require a freelancer to assist with the addition of images, links, and information in my database, hosted on Wix.com. Your task involves: - Taking screenshots of images in provided links - Uploading these images, information and links provided in a prescribed format. Ideal freelancer will have: - Familiarity with - Data entry experience - Experience in image handling - Keen attention to detail for successfully linking to correct destinations.

I am nearing the completion of my mobile student-teacher interaction doubt app developed using Flutter, and have executed the front-e...and I need online assistance with that. I need to submit my project on 15/04/24.I need assistance anytime before that. Key tasks include: - Assisting me to effectively integrate Firestore Firebase. - Explaining and demonstrating ways to perform CRUD operations. - Highlighting how to securely store and retrieve data. Freelancers with the following skills are preferred: - Proven experience in database integration with Flutter Apps. - A rich depth of knowledge in Firestore Firebase. - Tremendous problem-solving skills. - Good communication and teaching ability. Interesting candidates should note that no API integration tasks are required for thi...

I'm on a quest for a comprehensive European mailing list, inclusive of Interior Designers and Architects, for networking purposes. This list should cover all regions: Western, Eastern, and Southern Europe. Notably, I'm keen to connect with industry veterans — the list should primarily feature individuals at a senior-level experience. Ideal skills include: - Research & data collection - Knowledge of the interior design and architecture communities in Europe - Great attention to detail to ensure the accuracy of the data collected.

I'm seeking a thorough and accurate compilation of flooring distributor's or contractors, home builders, or property management companies/apartment complexes, within my area, both at the residential and commercial levels. The information should be geared towards the following: - Contractor Contact Details: Your bid should reflect your capacity to provide me with a comprehensive list of names, phone numbers, email addresses, and physical addresses for these flooring contractors. Having familiarity with data entry, web scraping, and the construction industry would be a plus for this task. My end goal is to have a dependable directory I can refer to as needed. It's essential the information gathered is accurate and up-to-date.

I have an Ubuntu VPS on Hostinger and faced an issue while setti...via the command line. - The MySQL service is currently running on the VPS, but it's empty as I need to recover old databases. - I have specific information about the databases and tables that were deleted. I'm in urgent need of a skilled professional who can help me recover the lost databases. The ideal candidate should possess: - Profound experience in database recovery, particularly on Ubuntu VPS. - In-depth understanding of MySQL database structures. - Ability to work efficiently through command line interfaces. - Strong problem-solving skills and a methodical approach to data recovery. Given the criticality of the situation, I'm looking for someone who can help me swiftly but without any c...

I need a competent professional to smoothly facilitate the migration of my MSSQL 2019 database to a new server. Additionally, the ownership of SQL Management Studio must be changed effectively. Key job responsibilities: - Safe and efficient migration of the MSSQL 2019 database to a new server - Successfully transfer ownership of SQL Management Studio Ideal Skills and Experience: - Proven expertise in MSSQL 2019 and prior versions - Proficient in handling SQL Management Studio - Experience in successful database migration projects - Detail-oriented in project proposals Please note that only freelancers providing detailed project proposals will be considered. Your proposal should demonstrate your understanding of the project requirements as well as how you intend to ...

I need an expert in data management and social media analytics to help create a database for my Instagram followers. Key tasks will include: 1. Organizing the database by follower engagement level. 2. Including both the username and follower count of each Instagram follower in the database. 3. Providing monthly updates for the database. The ideal freelancer for this project should have extensive experience with data organization and social media analytics. Mighty beneficial if you have prior experience creating or managing similar databases. Comfort with Instagram's platform and an understanding of how to categorize user engagement will be crucial to this project.

I'm looking to hire an experienced WordPress developer to restore both my WordPress database and website files from a backup I have. The site was running on a version of WordPress earlier than 4.x. The restoration will take place on the same domain. Skills & Experience Required: • Proficiency in WordPress database and website restoration. • Experience with restoring older versions of WordPress, specifically versions prior to WordPress 4.x. • Understanding of domain configurations and restoration processes. Please provide evidence of similar projects you have completed in the past. This project requires an expert touch so as not to lose invaluable data during the restoration process. Therefore, knowledge of data handling and previous experience ar...

i want some one who has a classifieds database or website with below data 1 - categories and subcategories 2- filter and sub filters For example property - house, land, apartment phone - 1) android 2) ios filters under them 1)ram 2)rom 3)colour under that filters ram 4 to 16 gb ,rom 4 to 16 gb and colour black,white ,red like that below example with different categories property ,cars, bikes, furniture , jobs etc ................. need data in excel

As a client, I'm looking for a Flask expert who can seamlessly integrate an existing Firestore database into my project. This requires a deep understanding of Flask, Firestore, and how to make them work together efficiently.

I need a data entry expert to transpose textual data from word documents into a database system. The data is ready for immediate start and the project will ideally suit someone with solid experience in data entry, particularly with word and MySQL or SQLServer. The ideal candidate for this job should: - Have proven experience with data entry. - Be proficient with Word documents. - Have working knowledge of database systems especially MySQL or SQLServer. - Be detail-oriented and accurate. Note that this is not a one-time job, as more projects of similar nature are lined up. Therefore, demonstrating good performance might lead to more future collaborations.

I have a profile page for logged in users, and he needs to sign up for some preferences. The code will be in HTML - I need it to be saved in the database and integrated into my website on the individual profile page. The code model is this:

I am seeking a skilled network administrator to help me with a specific firewall configuration on my Asus Dr 68-R router. This configuration includes the following specific requirements: - Set up a firewall rule that blocks all incoming DNS requests except for those from the Cloudflare DNS servers. This is to ensure that my internet filtering remains effective, despite efforts by my kids to bypass it by changing their DNS servers. - Implement content filtering in the configuration to ensure that the internet access is still secure and appropriate for my children. These configurations need to be implemented at the router level, as this is where the issue is originating. The ideal candidate for this job will have: - Profound experience in working with Asus routers, particularly the...

we have a website with woocomerce and woomart plugin recently we get this error Error establishing a database connection. we want someone to check the whole website and cehck if any problem or malware. the database sometimes works and the we get back this Error establishing a database connection

...5.5 database to MariaDB 10.11. Key requirements: - Code Change: The project involves updating the PHP codebase, ensuring compatibility with PHP 8.2. Your role will include identifying and applying necessary changes for syntax updates, security patches, and performance optimization. - Database Migration: You'll also be responsible for migrating the database from MySQL 5.5 to MariaDB 10.11. This includes ensuring data integrity and minimizing downtime during the transition. - Framework Experience: The PHP codebase uses the Zend framework. Familiarity with this framework is essential for completing the code updates effectively. - Automation Rector: Knowledge of the PHP update version automation rector would be highly beneficial. Your experience with PHP f...

...have a Microsoft Access database built to help manage various aspects of my business. Ideal Skills and Experience: - Proficiency in Microsoft Access database development - Understanding of the commercial cleaning business operations - Knowledge of database design and implementation Key Features: - **Employee Database**: - Store employee contact information - Track employee work schedules - Monitor employee performance - Manage Payroll - **Client Databases**: - Store client contact information - Track client preferences for tailored services - Ability to generate client reports - **Alert System**: - Employee task reminders: to ensure tasks are completed on time - Client appointment reminders: to facilitate timely service delivery - ...

I need to migrate my current MySQL/PHP database site to Hostinger. I have migrated the website, but the database needs to be migrated manually. I then need to check it is working on the preview version. I will then need you to upload the most recent version of the database, once the DNS is changed to the new host.

...competent freelancer to develop a unique carbon trading website specifically for Renewable Energy Certificates (RECs). It needs to be user-friendly with easy registration and login, efficient REC trading facilities and integrated with a cryptocurrency wallet for our custom digital currency named "Gaga". The platform should be designed to accommodate three main user roles: 1. Trader 2. Investor 3. Administrator Each REC listed on the trading platform must display the following information: - The price of the REC - Quantity available - Seller's information Ideal candidates must possess expertise in web platform development, cryptocurrency wallet integration as well as a profound understanding of the carbon trading environment. Experience in projects related to...

...Website A. The focus of this scraping will be: • News articles: Leveraging tools for expansive retrieval of the articles and their related details. The purpose behind this data scraping and database management task is to: • Collect data for Scrap purposes The ideal candidate possessing skills and experience in: • Proficient in web scraping. • Expertise in automated systems for scraping. • Excellent knowledge of database management and updating. • Experience with Website A scraping will be advantageous. Upon successful scraping, the data will be systematically updated into the existing database with consistent accuracy. This requirement demands a professional with the capability to design and implement a system that will ensure r...