Tips and Tricks.
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.Hire Database Administrators
1. Provision MySQL (v5.7 or higher versions) instances, both in clustered and non-clustered configurations 2. Experience with replication configuration in MySQL 3. Ensure performance, security, and availability of databases 4. Handle common database procedures, such as upgrade, backup, recovery, migration, etc. 5. Profile server resource usage, optimize and tweak as necessary 6. Proficient in writing and optimizing SQL statements 7. Knowledge of MySQL features, such as its event scheduler 8. Ability to plan resource requirements from high level specifications 9. Collaborate with other team members and stakeholders 10. Good to have: Hands on experience in Tungsten Cluster and Tungsten Replicator
Blue Clean is a cleaning company based in Sydney - Australia since 2013, specialised in Residential, Commercial and Accommodation Cleaning for short term rentals. As the business continues to expand, we are currently looking for 2 Bilingual Virtual Assistants (English and Spanish) A Virtual Assistant is required to provide sales, customer service and team support with taking and scheduling customers’ bookings and assigning jobs to cleaning contractors. You will build strong relationships with our customers and teams and will enjoy being part of a team and learn from the process. You will speak Spanish and English as most of our contractors speak Spanish and all our customers speak English. You will be the main point of contact to liase between the two to get the job done. Duties...
Chinook Database Introduction In this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows. All of the below instructions are discussed in detail as you work through this lesson on your way to completing this project. The below serves as a quick reference of what you will be doing as you progress through the completion of this project. Instructions You will need to follow the instructions on the next three concepts to ge...
Hi, THIS PROJECT IS FOR MYSQL DATABASE EXPERTS NOT FOR WP DEVELOPERS. A few months ago I have changed my WordPress hosting and that host converts my WordPress database into latin1 while migration of my site. Now I have changed my host but due to latin1 few features (e.g. WordPress multisite) of WordPress are not working. When I changed following line in wp-config from define('DB_CHARSET', 'latin1'); to define('DB_CHARSET', 'utf8mb4'); My whole text matter (Hindi and Marathi) getting messed up, can you please fix and cover my database smoothly. see the URL all Unicode text got messed up Here is the WordPress manual Here is one more person who faced an issue like me First, you need to fix the issue on the staging site and then you can work...
You must be an experienced (7 years or more) SQL Server Programmer who can write (1) Optimized Queries (2) Clean up our existing stored procedures (3) Introduce transaction handling in the existing procedures (4) Introduce exception handling in existing stored procedures. The highlight of your eligibility for this requirement is your expertise and experience in writing clean and optimized stored procedures. Any experience in ECommerce and Fintech domain would be a great advantage. You will be required to spend around 25-30 hours a week initially abd You must be a person of high integrity , whom we can depend on for long term projects. Some of the consultants working for us have stayed with us for more than 4 years.
We are workinf with a client in migrating thier custom developed ERP to Odoo 14. We need all transactional data such as invoices, PO's, GL entries to be extracted from their ms sql database to csv so we can import to odoo
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
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
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...
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.
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.