Administración de bases de datos Jobs

La tarea a realizar es bastante sencilla. Se requiere agilidad a la hora de procesar los datos. Tenemos una base de datos con productos y tenemos que corregir los siguientes datos: - Titulo - Categoria - Color - Tipo de producto - En caso de que sea necesario, reordenar las imágenes Es importante estar familiarizado con la nomenglatura de cada prenda en Castellano (España) Estamos contratando bloques de horas. La asignación de más o menos carga de trabajo dependerá de la eficiencia a la hora de editar estos datos. Al comenzar el trabajo debemos picar en una plataforma online, y hacerlo de nuevo cuando se pause la jornada.

Se tiene una plataforma creada en Retool y es necesario crear un mecanismo que integre vía API a MercadoLibre y así extraer los datos a una Base de Datos en PostgreSQL. Storytelling: Un usuario entra a nuestra plataforma, encontrará un botón que indique "Vincular cuenta de MercadoLibre" al dar click deberá de ingresar a su cuenta de MercadoLibre y mostrará una página pidiendo autorización para la integración. Una ves aceptada, se tendrá un proceso de descarga de datos a una base de datos y la plataforma mostrará una serie de reportes basados en dichos datos.

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

Indicative scope (members of our team to provide final feedback and approval, looking to shortlist some candidates we will share our final scope with) Description: VeriCO2 is seeking a skilled developer to assist in completing the development of Phase 1 of our automated quantification of scope 3 emissions project. The selected developer will be responsible for conducting a thorough code review and integrating an emissions factor database into the existing codebase. Responsibilities: 1. Code Review and Functionality Check - Review the existing code to ensure there are no backdoors from the previous developer. - Verify that the code is functional and all equations for each method within the 15 scope 3 categories under the GHG protocol are correct. 2. Emissions Factor Database Inte...

I'm looking for a skilled freelancer to help me in creating a database of entry-level IT working professionals. The database is intended for recruitment purposes and should focus on professionals within our country. Key responsibilities will include: - Identifying and collecting database of entry-level IT professionals. - Categorizing the database based on different IT fields like software development, cyber security, network engineering, etc. Ideal candidates for this project should have experience in: - Database creation and management - IT recruitment - Strong knowledge of the local IT job market Your work will be critical to our hiring processes and future IT recruitment strategies.

I'm in need of a reliable colleague who can assist me with data entry. The main task at hand is database creation. Key Responsibilities: - Data Entry: Your main responsibility will be to input data into a database. - Database Creation: You will be actively involved in the creation of a new database from scratch. Ideal Skills and Experience: - Proficiency in Data Entry: I need someone who is both fast and accurate in data entry. - Familiarity with Databases: Experience in creating and managing databases will be a great advantage. - Attention to Detail: The data involved in this project could potentially be complex, so attention to detail is crucial. I appreciate someone who is detail-oriented, reliable, and can work efficiently with minimal supervision. Looking forward to working ...

I'm seeking assistance in incorporating 2D Data Matrix barcodes within both BI Publisher and Oracle EBS. The primary goal of this integration is to enhance our current inventory tracking systems by printing the Labels with 2D barcode and business users can scan the barcode by using the RF scanner in the inventory. This project should be relatively straightforward for someone who is proficient with BI Publisher, Oracle EBS, and barcode implementation technologies. Key requirements and considerations include: - Proficiency in both BI Publisher and Oracle EBS - Strong understanding of 2D Data Matrix barcodes - Proven experience in integrating barcodes into inventory management systems The successful candidate will be able to not only implement the barcode system but also provide us wit...

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 is intermediate, focusing on tasks like j...

I'm seeking a skilled developer who can create a customized Grafana dashboard that will display real-time data on both water levels and contour land. This project is specifically aimed at monitoring water levels Key Responsibilities: - Develop a functional Grafana dashboard that can display both water level and contour land data. - Ensure the dashboard is updated in real-time, as this data will be used for flood monitoring and prevention. - Implement a user-friendly and intuitive design for easy data interpretation. Ideal Skills and Experience: - Proficiency in Grafana or similar data visualization tools. - Experience with real-time data visualization. - Proven track record of developing dashboards with a focus on monitoring and prevention. This project has the potential to signifi...

I'm in need of a composition diagram based on a provided ERD, but starting from either products or categories. Your deliverable should be in PNG format, keeping it black and white, and should include detailed notes for each constraint and enumeration listed. Key Deliverables: - Create a composition diagram based on the given ERD - Diagram starting from 'products' or 'categories' - Output format should be PNG - Keep the diagram black and white - Include detailed notes for each constraint and enumeration listed Ideal Skills: - Proficient in creating ERD diagrams - Experience with composition diagrams - Ability to clearly indicate datatypes and multiplicities - Familiar with check constraints and enumerations - Excellent attention to detail and communication skills...

I am in need of a professional QlikView developer capable of seamlessly integrating and modeling our substantial sales data. This project revolves around: - Data Integration and Modeling: Your primary task is manipulating our vast trove of sales records - more than 10,000 - for incorporation into QlikView. - Sales Data Expertise: A solid track record in handling sales data is crucial. Yours should include previous experience with large datasets. The success of this project hinges on your ability to model our data precisely, thereby facilitating informed decision-making on future sales strategies. Excellent knowledge of QlikView, along with a strong background in data integration, will prove invaluable.

I'm in need of an experienced Talend Studio developer to assist with a database migration project. Key Project Details: - **Data Sources**: The project entails integrating data from various databases. - **Primary Goal**: The primary focus of the project is to migrate the data accurately and efficiently. - **Data Processing**: The data migration will primarily be through batch processing, therefore real-time processing is not required. Desired Skills: - **Talend Studio Proficiency**: A strong understanding of Talend Studio and its capabilities is essential for successful project completion. - **Database Integration Skills**: Experience working with database integration is a must. - **Data Migration Experience**: Previous experience with data migration projects will be highly valued....

Our development team just wrapped up front end development for a large-scale website. At this critical juncture, we're seeking advice to ensure that our back-end databases - PostgreSQL and Cassandra - will be optimally performing and highly available. Key areas of consultation include: - Performance optimization strategies - Replication and high availability options - Ideal design of databases to accommodate the scale of our website Ideal professionals would bear extensive experience with both PostgreSQL and Cassandra databases, as well as a keen understanding of integrating front-ends to back-end databases. Your prior work with large-scale website infrastructures will greatly benefit our project. Database optimization and design aptitude is a crucial requirement for this task.

Por favor, regístrate o inicia sesión para ver los detalles.

I need a seasoned Java developer with a strong background in utilizing NetBeans 8.1 and Derby Database. The primary task would be to improve the performance of an existing Java application. Key Requirements: - Expertise in Java and NetBeans 8.1 is essential. - Familiarity with Derby Database and how to optimize its use. - Proven track record in enhancing application performance. - Ability to identify and address performance bottlenecks in the system. Performance Improvement: - The main area of improvement is managing data processing speed. - Analyze the application for possible performance improvements and suggest appropriate solutions. Please note, the client has not specified details about user interface responsiveness or server-side operations. Thus, the focus should primarily be o...

I need a system for an IoT-based project in which a WiFi module will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer w...

I'm in need of an expert in Machine Learning who can successfully build a Language Model for me. Train this LLM on data that I'll provide. The key specifics about the project involve: - Data Handling: My data currently lies in PDF format. Therefore, you need to be proficient in working with PDF data and possibly transforming it for the training process. - Database Knowledge: The data is stored in a MySQL database. You must have experience working with MySQL databases and effectively extracting data from them. - Document Types: This project solely revolves around PDF documents. I require somebody with a proven track record of handling and working with PDF data. Skills required: Machine Learning, MySQL, knowledge of handling PDF data and documents.

I'm seeking to be a full-time data analyst in the tech industry. Key Responsibilities: - Analyzing complex data sets, interpreting trends, and providing insights for decision-making. - Developing and maintaining data models, databases, and dashboards. - Identifying opportunities to enhance reporting processes and data accuracy. Ideal Candidate: - Strong background in data analysis, with experience in a tech-related field preferred. - Proficiency in data visualization tools like Tableau, Power BI, or similar. - Ability to communicate complex data findings to non-technical stakeholders. - Solid understanding of database management and data warehousing. - Familiarity with statistical tools and techniques for predictive modeling. If you've got the right experience and skills, I&#...

I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

We are looking for an expert in MongoDB + ElasticSearch infrastructure. We are looking to build from the ground up, in the cloud (AWS), a very complex infra with 500M Person object, 50M Company, and dozens more challenges. The dataset will be always evoling, with hundreds of thousands of updates a day on every object etc. Please see the screenshot that explain the technical setup wanted: []() The final goal is to have a full blown searchable database, with list feature, and respond time always staying below a clean 100ms. The main DB will be Mongo, that needs to be optimized (shard, cluster config, index...) properly. On top of that DB will live Elastisearch, which will require a near real-time and bulletproof syncing between the two. The server budget expenses is 5-10k$ which should b...

I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change database values, as a proof of concept. T...

I need an expert with in-depth experience in ZFS pool management on a Linux operating system. The data lost from the corrupted pool wasn't critical to our operations, but we primarily stored databases, and the loss was still a hassle. Your main responsibilities would be to: - Investigate the root cause of the pool corruption and provide a detailed report on your findings. - Suggest and potentially implement steps to prevent such incidents from happening again. Ideal skills and qualifications: - Extensive experience with ZFS and Linux systems. - A history of troubleshooting and resolving data corruption issues. - Prior experience with database storage and recovery. - Strong problem-solving capabilities. - Excellent communication skills to explain complex technical concepts in layman...

I'm looking for one have experience in data center, and I need your expertise for this project.

I'm in need of an experienced Tableau Developer/Analyst/Designer to help me enhance an existing dashboard, and improve its performance and functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professi...

We are in need of an Oracle Database Administrator (DBA) who can provide coverage from ~8pm to ~4am PDT for one or two weeks starting May 27th, while a current employee is on vacation. Those hours are somewhat flexible. Ideal candidates should have the following skills and experience: - Proficiency in Oracle database administration for versions 11 through 19 - Must be proficient from the Linux command line - there is *no* OEM for these databases - Will respond to emails & alerts for end-clients - Will Investigate any reported problems during that shift - Must be completely fluent in English It is possible there will be nothing to do during the shifts, but if something comes up, rapid response is required. There may also be a need for weekend coverage, and possible future work.

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-driven - C...

As an organization, we've successfully implemented both Intapp and Boomi platforms within our workflow. However, the abundance of possible improvements we could make has led to the need for an experienced specialist to help us maximize usage. The tasks waiting for you will include, but are not limited to: - Automation of existing manual processes within our systems - Integration between various applications, primarily iManage and Elite 3E The ideal freelancer for this project will not only have substantial experience with the Intapp and Boomi platforms, but also a deep understanding of iManage and Elite 3E. We're excited about the potential improvements in efficiency and effectiveness these automated and integrated processes will bring to our organization.

I am currently in need of a part-time assistant skilled in data entry. The main task will require you to input customer records into databases. Key Responsibilities: - Accurate Input of client records into the database - Ensuring that data entries are correct and up-to-date Ideal Skills: - Previous experience in data entry - Meticulous attention to detail - Familiarity with digital databases Looking forward to connecting with detail-oriented and reliable bidders.

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

I'm in need of a reliable and experienced freelancer who can provide ongoing virtual assistance for tasks that include managing Airbnb, booking personal appointments, travel arrangements, and finding a handyman when needed. Key responsibilities include: - Coordinating Airbnb operations: managing bookings, coordinating with guests, and handling any issues that may arise. - Arranging personal appointments using online platforms or over the phone. - Coordinating travel itineraries: booking flights, accommodations, and transportation. - Finding suitable handyman services as needed. For a successful application, please include details of your previous experience in similar roles. Ideal candidates must demonstrate the ability to work remotely and must be well-organized, proac...

I am in need of a talented developer who can create a robust test management tool that can be used across Windows and Mac platforms. Key Requirements: - The software should support more than 50 users, so it needs to be scalable and have a user-friendly interface. - It should have the capability for test case creation and management to help us organize and track our testing efforts effectively. - Real-time reporting and analytics features are crucial for us to understand our test results promptly and act upon them swiftly. Ideal Skills: - Proficient in cross-platform software development, with a focus on Windows and Mac. - Prior experience in developing test management software is highly desired. - Strong understanding of real-time reporting and analytics tools. - UI/UX design experience...

I'm seeking a skilled data analyst to work with food quantity data to improve our decision-making processes. Key Responsibilities: - Analyze our food quantity data set to provide prescriptive insights - Offer strategies that will enable us to make better decisions - Collaborate with our team to implement and test these strategies Ideal Skills and Background: - Proven experience in prescriptive data analysis - Strong understanding of food quantity data - Excellent communication and collaboration skills - Previous experience in the food industry would be advantageous, but not essential The successful candidate will provide actionable recommendations that can directly enhance our decision-making process. They should be able to distill complex data into clear, understandable insights ...

I'm looking to test the scalability of my web application. The goal is to assess how the application performs when subjected to a significant load and to identify any potential bottlenecks. Specifically, I'm probing: - User interface functionalities - Database interactions For these tests, we'll simulate the activity of 100-500 concurrent users. This task would be best suited to a professional experienced in using JMeter for load testing web applications. Skills in web development would be advantageous, to help understand functionality and potential errors. Your deliverable is a detailed report with insights and recommendations on where and how the web application can be upgraded for scalability. Work location - North Bengaluru (North Bangalore). Remote working...

I am seeking a talented freelancer to conduct an audit of our company's data and create an availability map. - **Data Audit**: Your primary task will be to delve into our data sources and types, understanding what we have and how they're stored. - **Data Availability Mapping**: Based on your audit, you'll then create a clear, comprehensive map of where our data is and how it can be accessed. Ideal candidates for this job should have a solid understanding of data management, analysis, and storage. Experience in data auditing and creating data maps would be a significant advantage. A meticulous eye for detail is crucial, as we need a thorough and accurate representation of our company's data landscape. A data audit refers to the examination of data to assess its quali...

I'm in need of a proficient developer capable of integrating an API that reflects financial statistics onto a visual dashboard. Key components of this task include: - Integration of an API that conveys financial figures. - Representation of Investment performance stats in a table format. - Visualization of portfolio return via a line chart along with portfolio assets and diversification. Experience and skills ideal for this task are: - API integration knowledge - Experience in financial data representation - Advanced proficiency in creating visual dashboards A ready-made template will be used so as not to have to develop the visual part.

As a MongoDB Expert, my primary need is to work with someone who can assist with two key 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 tailo...

I am seeking a developer experienced in AspDotNetStorefront and email server settings. I am currently experiencing email-related issues with my AspDotNet storefront. I have checked the admin panel email settings and are correct and temperamental. They sometimes work, then completely stop. The project involves: • Identifying and resolving email issues, as neither sending nor receiving emails is functioning properly. • Assisting in effective troubleshooting without error messages or codes. Ideal skills and experience for this task include: • Knowledge and experience with AspDotNetStorefront. • Ability to troubleshoot and resolve email dysfunction issues. • Excellent problem-solving skills with minimal available data. • Experience in working with email serv...

We are looking for a database developer/compiler who can help us develop and maintain our databases. The ideal candidate will have experience with both SQL and NoSQL databases, and will be able to write efficient and reliable code. They will also be able to work with our team to ensure that our databases are up-to-date and meet our needs.