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
We have a fairly large database (MySQL) with some of the tables having 1.5 million to 2 million records. We are accessing this DB from a django application, sometimes running SQL queries from the app and at other times using the django ORM. The process is very sluggish at the moment, and we want this to be remedied so that we can get the results in a few seconds (ideally within 3 seconds) at least. We would like someone with excellent database optimization skills plus a working knowledge of django apps. In addition to solving the above mentioned issue, we would also like to have the following points addressed: 1) Enhancing the scalability and performance of existing database architecture. 2) Protecting data by developing data security and restoration policies, procedures, and controls. 3) ...
Product for full accounting of employees. It is possible to transfer employees to structural departments. Also the registration of employees and their dismissal. An extensive database on the management of employees and their responsibilities in your company.
I am using SQL Server 2019 I have an SQL query it takes more than an hour to finish a friend told me this can be improved significantly and finish this query in a few minutes. The query and tables files are in the attachment files end with csv should become a table in SQL there is a function called Dist() and query called just make an offer if you really can improve significantly and tell me what is the time it will take to run the query
Need: Old age (60+) data for the UK. Just need phone numbers, nothing else... just list of phone numbers. Must be valid, fresh and unused. NO SCRAPED DATA NO OLD DATA easily accessible NO SCRAPED DATA (like: LinkedIn etc... - don’t need) Need either from proper database or from CPA marketing etc...
Hi, I am facing an issue in mysql and cpanel, server was fine since yesterday, but one drive went faulty, after installing new hdd, and rebuild raid, node is bootup properly, vps also bootup. but cpanel whm url are not working also most of services inside ssh are down for cpanel. need to be fixed those without loosing data and mysql. Thanks
Please type "Sync SQL Database" to be considered for this project. We have an on-prem SQL Databases and I would like to auto sync to Azure SQL database for power BI Report. We are not MS Experts and you will be asked questions related to the project such as gateway connection, allowed sync bandwich, etc.. Ideal sync interval will be every 15min. The prem server is running on MS Server 2019 Standard. Due to policy, we can't give out access to our SQL server or Azure Cloud. We will allow the technician remote to a workstation and work under supervision. Thanks
I'm looking for somebody whose happy to work with us on a flexible basis, supporting and developing SQL Server databases. This would be ongoing and ideally suit somebody whose doesn't need to rely on this being their main source of income.
We need a report which will indicate differences between the selling prices of products on sales orders at the time sales orders have been added to SAP (therefore approved and added by the creator of the sales orders) vs the selling prices of those products at that point in time on the price lists related to the customer being sold to. This will therefore require referencing the history tables of the pricelists and comparing to the price list and prices related to the customer at the point in time of adding the sales orders. The query should therefore compare the final selling prices of the products on the sales orders (closed sales orders) and compare it to the selling prices of those products which was applicable at the point in time the sales order was originally added to SAP.
Project on metrics, tracing and logging with opentelemetry and nosql database
Exadata DMA and ODA Oracle DBA Training: Oracle databases in Exadata machine and ODA(Oracle Database Appliance) environments. Troubleshooting and supporting databases in Oracle Linux, Oracle RAC, and Oracle ASM configuration ODA architecture and patching experience. Oracle Exadata architecture and internal framework ; Must have worked on X3/X4/X5/X6/X7/X8 Exadata machines ( at least 2 models), Oracle 19c grid, Oracle 12.2/18/19c RAC databases, 13c cloud control. Monitor Oracle DATABASE, Check alerts and take care of DATABASE issues (issue resolution) in Exadata Exadata and database monitoring using Oracle Enterprise Manager(OEM) - Agent installation, DATABASE discovery, Database alert configuration. Setup various default and customized metrics in cloud control for Exadata Training to work...
Hi, A colleague needs continuous help with Tableau and SQL until she gets confortable with the tools. Can pay on hourly basis. The applicant must be available when anytime required. Also they must be an expert in Tableau and SQL. Thanks
Monthly Salary – Between 150 euros and 200 euros Responsibilities : 1- Build one Website. 2- Extracting data from websites using web tools 3- Organize the Data end send it to the website. 4- Periodically Refresh the DATA. 5- Maintain database on regular basis, Verify data and correct database. 6- Maintain the records Confidential. Skills Required: - ENGLISH (Speaker) - Good Computer skills - Website Building - Web Data Scraping - Data Collection - Web Search - Market Research - Web Services - Internet Research - Good typing speed - Remot Job Job description: -Keep the Data Website updated Desired Candidate Profile: Communication skills in ENGLISH Qualification - Minimum 12th can apply UG : Graduation Not Required Must have the below for applying : 1- Personal Laptop with activ...
phpmyadmin schedule some database field & export it every day as database CVS extension to FTP server
I need a detail orientated marketing assistant to support marketing administration and social media posting. Expert level proficiency in English writing is essential. Experience with Zoho Social is an advantage. Flexible hours and work schedule - able to correspond during the UK timezone.
I have an oracle virtual machine, a CentOS7 operating system virtual machine is established, I have installed and enabled Oracle 12c database, sqldeveloper and sql plus. You will be given remote desktop connection to mine. And perform the tasks below: 1. Enable auditing and audit trail, audit logs 2. The logs must be stored in Operating system of Linux - centos7 3. The logs needs to be sent to a remote syslog server. 4. Do simple events in CentOS like create, alter, delete table and share the sample syslog server using tools like kiwi or anything else. Note: The salary will be less as it is less work. Will be transferred online.
Database Administrator who can restore .sql data from .ibd and .frm files
Restore database .sql File from .frm file and .ibd file in mysql
I have website hosted on network solutions , they set sql db quota to 300MB . I need to reduce the current DB size below 300MB , the current db size is 301MB. No credentials will be provided , freelancer should work on my PC using anydesk or team viewer.
Job Description: We are doing migration of the data from MS Dynamics to Other CRM tool. In this, we have successfully migrated all the Contacts, Accounts, and Opportunities to Other CRM tool. But while migrating the activities we are facing some difficulties in exporting the activity data such as emails, notes and etc. We need someone to help us in exporting all the activities from MS Dynamics into a MYSQL databases/excel files. For this migration, we require all the activities exported with all the possible data fields. We need the details of contacts, accounts, and opportunities associated with an activity to identify the relationship between an activity and contact/account/opportunity. It would be really helpful if you could kindly provide the required data in the form of a spreadshee...
Need MYSQL Database Administrator to restore .sql data from .ibd and .frm files
Español preferente. Crear un Dashboard en Power BI con importación de base de datos MySQL, las tablas ya se encuentran definidas, se le entrega al desarrollador usuario y contraseña de solo lectura, el sistema es un sistema para transportistas donde a detalle se pide lo siguiente. Costo por kilo desplazado $/kg. Este dato es el más importante y PPK quiere poder obtenerlo en todas sus interpretaciones. Total, por periodo, Por embarque, Por proveedor, Por tipo de Unidad (cam, th, trailer), por Cliente. Spend, de igual manera en todas sus versiones. Total, por proveedor, por Planta, por tipo de unidad, por cliente. Cantidad de embarques (operaciones) y todas sus versiones, # de embarques totales, # de embarques en CAM, TH, TR, operaciones de recolección, d...