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
Design and build a drop box file system to house CAD/Revit files within file folders by customer and project and rev control the various documents. Allow only authorized individuals to enter the partitions within drop box and fewer individuals to make changes - rev control. Write complete SOP
simple question for a SQL automation code and a SQL question: 1.D_CALENDAR is a table with a record for every DATE_KEY, and holds a variety of information about the company’s internal calendar, which can help automate processes. used the attached SQL code to answer the following questions: see the documents for details.
I have a virtual machine, Centos7 is installed in it. I linked my centos logs to send logs to loggly account, now need to set the audit_trail to "OS" by using sqlplus, i tried by using external file location, but the oracle database gets corrupted. So have to use sqlplus to configure the audit logs to be written in the OS logs. Please provide your number below for further communication. As the task is very less, amount will be discussed later.
We have a website running on GODADDY.com. We need a DBA on a temporary basis (per hour) to: 1. upload/append data from GODADDY FTP site into MSSQL database, 2. monitor the performance of MSSQL DB, and 3. preserve data integrity.
I want a simple database that will allow me to generate a list of all someone’s bills including the company name, address and phone number. The database needs to be prepopulated with the names and addresses of all US registered companies.
I Need to write a thesis (theory 60-70 pages and practical for the same) . writing should be self written not copy paste from google. it can have diagrams also but have to mention source. You can check thesis format for better understanding or i can explain more). I have more students who needs this so we can discuss further.
Hola, buscamos un perfil que sea exclusivo de nuestra empresa, necesitamos analizar bases de datos, sacar porcentajes, y obtener cual de ellas funcionará mejor, etc... Y apoyar al departamento de sistemas con gestiones. Imprescindible hablar español y poder cubrir horario de España.
Mysqld is down on our cpanel whm server. We need a really experienced guy who can help resolve the issue.
Write, in your own words, a summary on the Database Design Tips tutorials while incorporating your own experience and understanding. Apply critical thinking and an academic writing style that demonstrates your understanding of the difference between a Microsoft Access database and an Excel spreadsheet by comparing the features of each and when they would be used as personal computer applications if applicable. Additionally, include basic diagram for a database that includes at least 2 tables and at least 3 fields on each table.
Hi, as the title suggests, my mysql instance crashes after a certain number of loaded or modified elements .. I have a snapshot of the server so for data recovery it is not a problem, but I would like to understand why this happens and how to remedy the problem
I have a database that I need to combine from several different tables. I have the index, not a DBA to put it all together. The DB is posted on a public site, it would be great if we could have someone build a tool that exports the DB and maps it. If that is too much, a 1 time putting the tables together and saving the template so we can do it each month would be good. Thanks
Assist a recruiter (virtually) in searching for candidates profiles on databases, identifying candidate matches based off search criteria, collate lists of names and profiles to pass on. Assist in administrative tasks for searching for candidates. Assist in CRM administration.
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.