Database Administration involves system installations, configuration, monitoring and upgrading. System owners would love to maintain the performance of their systems. This requires a qualified personnel to undertake the project and keeping their operations afloat. With this requirement, the system owners conduct searches for the right person with relevant skill and experience that can guarantee Database Administration for their organizations. It is for these reasons that Freelancer.com come in handy. A professional should be able to monitor the systems to ensure proper operation of the organization. Whenever software installations are required, then they should conduct configurations during the installation process to ensure proper tasks are conducted.
With a surging demand for Database Administration freelancers, you will be sure that your services on Freelancer.com attract employers. This means that you have a high chance of meeting with recruiters who are searching for professionals with prerequisite knowledge and experience that you can provide. In addition, you can improve your competitiveness every time a client leaves a review at the end of the contract. Looking for fast paying gigs on Freelancer.com can be very rewarding.Database Administrators 분야 채용
There are more than 10k sql records and some records are duplicated i want to learn which records duplicated regarding below conditions Conditions If = and = and = and – <= 95 days and <= 1,5 TABLE Column1 | column2 | column3 | column4 | column5 Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5 Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5 Row 3 |8800 | pencil | 1234 | 2021-04-05 | -650 RESULT Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5 Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5
I have a MySQL database with some tables and data. I need to add some additional fields to my main table and then have a update routine that that can read the record in the table , get matching data from other tables and update the main table with calculations and the results to be written in the database table. We can connect and share my screen to discuss further, I need this done immediately so must be done today. If you cannot do it today please do not reply and waste time
We're looking for a certified MySQL DBA who has an exceptional experience in DB performance optimization. You will join our engineering team and help client's project for more than 3 months. We're in middle of implementing archiving strategy so your initial project would be to carry out those archiving scripts and update them with ongoing basis. Project stack: MySQL, .NET Web APIs, Entity Framework, GCP Cloud SQL Requirements: • MySQL DBA certification • Fluent in spoken and written English You'll need to be available during the US business hours.
I am a quality and patent safety director , i am responsible for 14 hospitals , 61 primary health care centers I have alot of data , i hope to give me a professional work analysis and analytics to introduce these data to my boss Time i hope to finish work 4 days
Modyfikacja istniejących procedur MS SQL Server (500 do 1000 linii), ok. 200 tabel, dodawanie endpointów. Jezyk Polski wymagany. Pełen wymiar czasu. 6 tygodni. Od zaraz. Praca zdalna.
I need to build a search/query engine where a user will type a query in english which will be mapped to a correct or relevant sql query. Post a trigger, sql query will fetch the details and display some insights, graphs and visualisations.
I am using Perfex CRM and a MySQL database. I need a loop routine that must select my data within a date range read the record find the correct price do a calculation and update the same record in the table and then move to the next till all us done. I require this as a option on the menu that we can reuse at any time. Must be able to work live online on my server as we will not be sharing the application or database to any outside person
Installing new server to small established network of 5 computers, database exceeded 10 gb so we have to upgrade to sql standard from sql express. Small optometric office we run office mate ’ll be able to call office mate for help in transition to new server.
I would like a directory database that is simple to use. I would like a search filter option so that shippers can search for a truck and find matches based on the information provided by my carriers.
We develop cloud applications for which we are in need of creating Technical and user documents starting from the beginning of the project
busco crear un base de datos para poder registrar a mis clientes (alumnos y padres) y poder lleva run mejor control de estos alumnos, un base de datos que cuente con lo básico (nombres, apellidos, teléfonos, direcciones, etc.) y agregarle campos adicionales.
We have an existing system built on top of MySQL. The system uses a lot of various filters / queries and is very slow. It was built and modified as the needs changed so it is a bit of a “Frankenstein” creation. Our immediate need is to: (1) review the DB structure and suitability for our use cases, (2) optimize tables and queries/filters, and (3) determine if – long term - we should stay with MySQL or switch to something like PostgreSQL.
We are looking for an experienced SQL Developer to join our existing team of web-based enterprise application developers. The primary responsibility of the candidate is to develop Stored Procedures and Functions that perform the applications business logic. The candidate should demonstrate strong logical, analytical, coding and debugging skills. Ability to write medium to complex Stored Procedures & Packages, T-SQL queries (DML, DDL statements, etc.), Functions, Transactions, Triggers, Database designing, Indexes, Query optimization, Troubleshooting Desired Candidate Profile - Desired candidate should have excellent knowledge of T-SQL - Good understanding of query optimization and indexing - Good database designing skills - Knowledge of various packages like SSIS, SSRS, SSAS would b...
a. Activity diagrams, describing the algorithm of possible actions, happening in the system; b. Functional diagrams of all components (services) describing a structure of the application; c. Sequence diagrams, describing API calls and low-level access; d. Class diagrams for all the services e. YAML file Use of Swagger Editor I can provide the data model and tables, etc. for reference Please connect for more details. There will be continuous tasks for 1 whole month or more
I have two lists of data sets need to compare and populate another list according to the screenshot that I attached.
I have a query that is taking 4-5 seconds to finish in mytop. This query is running multiple times at the same time and because of this is generating a slow load behavior in our backend. I need you to find if it's possible to optimize the query so it runs faster by either adding extra index or tweaking the MariaDB config. If none of that works I will need to setup either ProxySQL or MaxScale to cache this query and prevent to generate CPU usage and generating the slow load behavior explained above. No server access will be given, you will need to work through me.
We have a corrupted QBW file (saved from a crashing server) that cannot be repaired. Using Quickbooks Forensics tool we are able to see the tables but they are severely damaged. Our recent backup in QB was done in Dec 2021. What we are looking for is a DBA and QB DB expert who can use the tables exported from Quickbooks Forensics and add add then to the restored QB file (or provide readable data so we can manually enter it to QB). Its QB Desktop Premier 2017 nonprofit edition. The corrupted company file size is 164 MB, and the restored company file is 158 MB.
Need someone who is experienced in server configuration and MySQL databases. SQL queries are currently very slow getting a response from the server. Operating System Control Panels - cPanel & WHM on Centos 7 Latest Memory 64GB CPU E3-1240 V6 @3.7GHz CloudLinux