数据库管理 Jobs

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

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

I'm looking for an Azure expert who can provide me with comprehensive documentation on how to connect my dbForge client to an Azure MySQL App Services Database. Key Requirements: - **Azure Proficiency**: The ideal candidate should be highly experienced with Azure, especially in working with Azure MySQL App Services Database. - **dbForge Expertise**: Familiarity with dbForge would be an added advantage. Your main goal should be to create a step-by-step, comprehensive guide that will help me effectively use dbForge with Azure, particularly for database management purposes. I'm not looking for a one-time setup, but rather a detailed documentation that will serve as a reference for future tasks.

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 talented Copy Writer with a knack for enhancing product listings in the beauty field. Knowledge about using Lazada/Shopee Websites is essential. The task at hand is optimizing existing descriptions for beauty products on these online platforms. You'll focus on making them more attractive, and conversion-friendly. Ideal Skills and Experience: - Experience with Lazada/Shopee product optimization - Proficient in writing engaging product descriptions - Familiarity with beauty products - Ability to work creatively, enhancing existing content Your task will be all about making the product descriptions shine while keeping the core information intact. If you're someone who can blend creativity with the actionable intent in product descriptions, this project is for y...

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 require an experienced professional knowledgeable in 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 ...

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

I'm in need of an Oracle expert with extensive knowledge in Exadata infrastructure. Coming into this project without any experience in the field, I am eagerly searching for someone who can guide me and transfer their knowledge, so I can gain a deeper understanding. - SKILLS REQUIRED: Extensive experience in Oracle Exadata Infrastructure, excellent communication skills, teaching/mentoring experience would be a bonus. - EXPECTED OUTCOMES: Teaching me the technicalities of Oracle Exadata Infrastructure, and making me feel at ease with managing and understanding this field. Specific topics to be covered would be discussed in further detail with the chosen freelancer. Ideally, these would cover resource management, operational tasks and data warehousing, but I am open to learning abou...

I'm in need of a customized Point of Sale (POS) system that caters to the needs of my business which operates across 7 or more physical stores. The system should be developed to efficiently manage Inventory, generate Sales Reports, and facilitate a comprehensive Customer Database. Key Features Required: - **Inventory Management**: The system should track stock levels, reorder points, and provide notifications when stocks run low. It should also allow for easy categorization and organization of products. - **Sales Reporting**: I need a robust reporting functionality that can provide insights into sales trends, popular products, and overall store performance. - **Customer Database**: The system needs to be able to store customer data, such as purchase history and contact information....

We are currently facing an urgent requirement for the implementation of Oracle SCM/demand planning modules. We are in search of SCP experts or IT consultancy partner companies with proven experience in SCM/demand planning module implementation in Oracle EBS R12. The scope of work will cover the following aspects within Oracle SCM EB R12: Predictive Analysis based on MRP Demand forecasting for peak and off seasons Demand Sensing Multi-Dimensional Analysis: Analyze demand by product, customer, region, channel, and other relevant dimensions for deeper insights and better decision-making Supply chain integration Forecast accuracy tracking Reporting and Analytics

I'm looking for a skilled professional to assist me with various customer support, operation, and management tasks. - Handling Customer Inquiries: Please be prepared to manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database plat...

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

I'm 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 looking for a proficient data entry freelancer to assist me with an online data migration project. Key Tasks: - The primary task will involve accurately and efficiently transferring data from Excel/CSV files into an online database. - Ensure data integrity and make necessary corrections where needed. Ideal Candidate: - Proficiency in working with online databases and Excel/CSV files. - Attention to detail and accuracy is crucial. - Prior experience handling data migration tasks, preferably in a similar context. - Familiarity with data verification practices. The end goal of this project is to successfully migrate all the data from the provided Excel/CSV files into the online database without any loss or corruption. A successful freelancer will have the ability to work indepen...

I'm eager to find an accomplished Power BI and DAX expert who can help me develop a comprehensive dashboard for data analysis. Key Responsibilities: - Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated manually, so a part of this...

I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a 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...

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

I'm currently experiencing an issue with my Moodle application when I try to access it from remote devices. It's working perfectly on the local server but not remotely. I've configured the necessary network settings on my IIS server but the problem persists. I'm looking for a skilled troubleshooter who has experience with Moodle applications on IIS servers. The ideal candidate should be able to: - Investigate the root cause of the issue. - Provide a solution to make the application accessible remotely. - Assist in reviewing the current network configuration and making any necessary adjustments. Your expertise in resolving similar problems in the past will be highly beneficial in ensuring the smooth functioning of my Moodle application.

I'm in need of an experienced PostgreSQL Database Administrator to assist with a few key tasks. - Connecting to Database: I need assistance in establishing a connection to the database. This is a crucial task that requires a skilled professional who can set up the necessary configurations and ensure seamless communication between the database and applications. Your expertise in PostgreSQL is paramount, especially having worked with different versions (9.6, 10, 11,16). A deep understanding of database management and connectivity is essential, as well as experience in working with Windows as the operating system of the database. I need remotely to connect to database. Locally its working. is not properly set.

We are looking for a skilled database architect to design and manage the database architecture of our social media platform . The ideal candidate will have a deep understanding of database management systems and data modeling techniques. Feature in application : 1. User details 2. Upload a video feature like shorts and reels 3. Post a content like Linkedin 4. There are different types of video's category 5. Likes, comments, share 6. Other features Relevant skills for this role include: - Proficiency in database management systems in PostgreSQL - Expertise in data modeling and schema design - Strong understanding of database optimization techniques - Hands-on experience with SQL queries and performance tuning - Knowledge of database security best practices - Excellent problem-solvi...

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server ...

As a growing organization, we are seeking skilled administrators to join our team. We are looking for passionate individuals in three specializations - office administrators, HR administrators and database administrators. The ideal candidates should possess the following: - Strong communication skills, - Proficiency in Microsoft Office Suite, and - Experience with database management. Applications should include: - A cover letter explaining why you're the right administrator for us, - Educational certificates to validate your qualifications, and of course, - A detailed CV showcasing your previous experiences. Looking forward to receiving your applications and potentially welcoming you to our driven team. Apply now and make a difference!

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server ...

I need someone to post jobs for me on indeed and reply and orginziae replys into google sheet

Seeking an expert to restore my website stored on an AWS server. The main goal is to recover lost data; specifically, substantial MySQL database information which unfortunately went missing. Key Skills and Experience: - Experience with AWS and MySQL is critical. - Proven track record of effective database recovery. - Proficient in database management and data retrieval. If you are adept in these areas and can ensure a successful recovery of my data, I would be interested in discussing further.

I require a competent freelancer with experience in creating management systems to develop an automated spreadsheet for my insurance business. It will encompass the management of multiple insurance policy types including, but not limited to life, health, motor, travel and term insurances. Key Requirements: - Accurate tracking of policy details: This will span essential areas such as policyholder's name, policy start & end dates, insurance company details, premium amounts, policy type and number, beneficiary information, registration number, contact numbers, email IDs, premium collected, next expiry and other insurance related parameters. - A fully functional dashboard: Capabilities include report generation, tracking of premium payments, calculation of policy expiry dates, disp...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I need a proficient expert to help establish, configure, and visualize data using a Power BI server. The data for visualization will be pulled from several resources such as SQL Server, SharePoint, Excel Spreadsheets, and Teradata. Key Responsibilities: - Setup and configure the Power BI server - Connect the server to mentioned data sources - Implement interactive data manipulation capabilities into the Power BI reports Ideal Skills and Experience: - Proficient in Power BI server setup - Experience with SQL, SharePoint, and Teradata - Excel data management skills - Competence in interactive data manipulation and visual analytics - Familiarity with report generation and data analysis Please note that this project requires an emphasis on interactive data manipulation in the Power BI re...

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple dat...

I'm seeking a professional to set up Oracle DR using the Data Guard feature, focusing particularly on Disaster Recovery. My database runs on Oracle 19c and carries a data size of over 500GB, hence the need for expertise in handling large databases is imperative. Key Skills and Experience: - Proficient with Oracle 19c - Competent with Oracle Data Guard technology - Previous experience handling large database sizes over 500GB - Excellent understanding of disaster recovery strategies Task Expectations: - Set up Oracle Data Guard to enhance disaster recovery - Ensure effective management of our large scale database - Provide advice on best practices for utilisation and maintenance post-setup. Only freelancers with proven track records in similar tasks should apply. This task requires...

I need an in-depth and comprehensible 2000-word report on relational databases. This should include: - A focus on normalization and handling of relational database constraints. - An E-R diagram and an SQL query. The project description doesn't specify requirements for these, so use your expert judgment to determine what is necessary. - The report should also be accompanied by a 15-slide PPT presentation summarizing the report's highlights. Ideal Skills & Experience: • In-depth knowledge of DBMS • Expert understanding of relational databases • Proficiency in E-R diagrams and SQL query • Excellent report writing skills • Experience in creating engaging PPT presentations.

I'm seeking a professional who can help me craft a comprehensive 2000 word report on Database Management Systems (DBMS). The report needs to cover the key concepts of DBMS, including E-R Diagrams, Normalization (3NF), and crucial SQL queries. The report should be well-researched, well-structured, and free of any plagiarism. I also need a PowerPoint presentation to be created, consisting of 15 slides based on the content of the report.

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must choose Scenario 10. If...

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

I am currently experiencing failure in MariaDB replication and need an expert to troubleshoot and resolve this issue. Despite attempting to restart the server, the problem persists. Key Considerations: - The issue at hand is specifically in the realm of failed replication. - I have engaged with server restart as a potential solution but without success. Your Expertise: - Proficient in MariaDB 10.3 (The version I am currently using) - In-depth knowledge of MariaDB replication and diagnosing replication failures. - Ability to review server logs and configuration files for error detection and solution implementation. Though not mandatory, previous experience in addressing similar issues will be highly valued. You would be expected to diagnose the problem and suggest/ implement solution...

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.