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
ADMINISTRATIVO/A DESDE CASA 5h Se busca administrativo o administrativa trabajando en su lugar de mayor comodidad (siempre que se disponga de una buena conexión a internet y sea un lugar de concentración) y horario a elegir. Requisitos - 1 año de experiencia en administración - Organización absoluta - Buen cálculo matemático - Manejo de excel al 60% - Responsabilidad absoluta - Disponibilidad de 9am a 9pm hora España (elegir horario entre esas horas). - Disponibilidad para contactar con sus supervisores - Alguien en quien pueda descansarse brutalmente - Confidencialidad - Profesionalidad - Redacción perfecta Salario: 250$americanos/mes Si tu perfil se adapta a lo descrito, contacta por chat, envía tu CV y solicita hora de entrevista.
We have an SQL/Windows 2008 based DB that needs updating for functionality and we'd eventually like to migrate it over to a AWS - the db currently resides on a server.
Hallo, ich habe Fragen zu CSV Datein sowie SQL, zudem brauche ich auch Lösungsansätze für SQL Datenbanken und Hilfe zu einer Idee. Die "Besprechung" kann hier direkt über den Chat stattfinden. Dauer: 60 Minuten
THE PLAN IS TO FIND LOGIN AND PASSWORD FOR THE BLOGER TO DELETE IT.
Tengo problemas para migrar la base de datos mysql del alojamiento OVH a siteground. No tiene cpanel. Solo tengo una base de datos, pero más bien deben ser 2 y parece que están juntas y deben ser separadas.
This project will be to create a flow of sql deliverables. I am presenting and am going to create an ERD document from the project after it is finished. If you have any questions let me know, Thank you! "Description: 1. Pick a system to create from the following website Industry Data Models. Ie. ([login to view URL]). The system must have a minimum of 5 tables. Make sure when you pick the system that you get one with all the attributes showing not just primary/foreign key fields. "....
1) I am looking for freelancer who knows about NCR Aptravision and erstwhile Wincor-Nixdorf (current Diebold-Nixdorf) Proview Data structures fully well. 2) Idea is to build an alert & service management app (workflow) on top of the these two database schemas to have a common app for service or cash outage. Alert should come out in different ways: a) Net Cash volume remaining in the dispensers being (10-25%) threshold from the maximum cash hold possible, with data blow up and color coded showing Yellow flicker, net cash volume remaining in the dispensers being (0-10%) out of maximum hold possible and showing red flicker signage and also sending email and sms alert to service mobile phone number mapped. b) Fulfillment of service delivery type has to be segregated into (i) cash replenishment service needed (as mentioned in (a) above), (ii) power outage to be handled, (iii) cash jam alert to be handled, (iv) card reader issue to be handled (v) card stuck/clearance to be done, (vi) dispenser error to be handled, (vii) network error to be handled (power supply is already on). c) Statistics regarding issue count generated and handled / unfulfilled issue count against service delivery type and against SLA timings should be shown in dashboard to admin/ supervisor's panel. 3) Pivot database design, app design, build should be part of this contest. 4) Contest is divided into milestones: i)First milestone: Design and build concept shared with me. Convincing me that you have prior experience on entire data structure of NCR aptravision and Wincor's (now Diebold-Nixdorf's) Proview databases. If you don't have adequate skills on these two main parts, at least participate for one part and let me know (preference will be given to one who knows these specific data structures to be able to build the reference / pivot database). Most competent contestant will be chosen and award given for further milestones to be fulfilled: ii) Wireframe and Prototype done. iii) UI-UX done and front end interface done. iv) Data-structure build (reference database)+ API to Primary databases: (NCR:AptraVision+Wincor's Proview) and frequency set for interactions from source to destination database. v) App Server side programming done and released and made stable vi) App Backend completed and released vii) Testing completed and productionize the app to appstore (Android and later on iOS).
HI I have a requirement and a query with me but need to run that query to show data as it ran on last Tuesday of each month for past 12 months. So for current month the logic should be as follows: When the query runs on 5 Jun 18 (1stTuesday of current month) it should store the value against month column Jun'18 as say "a" when the query runs on 12 Jun 18 (2ndTuesday of current month) it should replace the value "a" from above with whatever value is obtained then say "b" when the query runs on 19Jun 18 (3rdTuesday of current month) it should replace the value "b" from above with whatever value is obtained then say "c" when the query runs on 26 Jun 18 (4thTuesday of current month) it should replace the value "c" from above with whatever value is obtained then say "d" Once it reads the 4th Tuesday as last Tuesdayof the month in this case it should retain it's value "d" Later for next Tuesday it needs to create another month column say July and follow the same steps as above. Let me know of you can get this done so I can share more details on this later.
Necesito un desarrollo en SAP B1 HANA para la gestión de despachos, que me permita generar las guías de remisión automáticamente de acuerdo a ciertas consideraciones en los artículos, clientes y direcciones.
Tenemos diferentes proyectos en Qlik Sense, estamos buscando personas que tengan conocimiento en Qlik, big data, ciencia de datos, inteligencia de negocios, HTML, SQL, QMS.
Looking for someone who can set up a MySQL redundancy on our existing database between 2 servers so that the information on both servers are always up-to-date. It must also be able to copy over new data that occurred back to master if slave has to take over when master goes down.
My hosting support (SiteGround) is suggesting to optimize our website database ([login to view URL]) so it will consume less RAM & CPU. If you are an expert, please bid. Attached their report. thank you
This is a river water quality monitoring project. I have been collecting water quality from multiple sites over 10 years. An enormous amount of data is in multiple spreadsheets from various labs needs to be organised into a database that is easy to work with. Access, etc? I'm not sure what is the best software to use. Would prefer someone with basic water knowledge but that is not critical.
Hello My website not handling more then 300 users and according to dedicated server we checked my SQL usages going very high due to some query of PHP side. so i need query optimisation. Over all i need to improve website so that website can handle more then 2000 Users Exp person only allow to bid here please
I have a DW database in a PostgreSQL database. I need to export the structure to analyze this data using Knowage. That is, assemble the cube, its dimensions and metrics and then import into Knowage. Note: I have attached the model and the bank pertinent to this project. Notice that it is very simple.
Need to import sql file in my c panel. | i have only sql file and theme files only
Project Description Design and Construct a database system for a business case for at least three entities (tables). The tables should contain a reasonable number of constraint tuples (rows), not too few and not too many. The following properties should be considered when submitting the final work: 1. Uniqueness: new and no duplicates 2. Originality: Creative effort invested by group members into the requirements that gives them a new quality or character. The problem statement contains indicators for freshness of aspect, design, or style. 3. Completeness: The state of being complete. 4. Readability: The ease in which anyone can read and understand the work. 5. Creativity: Artistic or intellectual inventiveness. We can define creativity as innovation which refers to the introduction of novel things. Final work should include the following: PART I: Project description and data modeling (total points 20) 1. Write an executive summary of the business case ( Maximum of one page, 5 points) 2. Draw the Entity-Relationship model by showing all necessary attributes and identifiers and relationships (10 points) 3. Construct a data dictionary table of all attributes in tables (5 Points) PART II: Implementation (Total points 70) 1. Create the tables identified in part I in SQL+ under Oracle (10 points) 2. Insert at least 20 rows in each table, and display the tables. (10 points) 3. Write at least 20 questions to display data from tables. Questions should span all topics covered in class (20 points) 4. Write the corresponding SQL statement for each question in step 3 and execute them. In this section, you should include a screenshot of your program’s output, based on the sample data that you provided. (30 points). PART III: Self Reflection (Total points 10) In this section, you should reflect on what you have learned in this project, and outline the challenges that you have faced while working on this project, and how you overcame them. Include contribution of each team members: Deadline: Saturday
I have alwayson enabled, but one server crashed and have backups (hyper-V VM). need them deployed and enabled again. Also need over check of sql server performance. Need to work with me using teamviewer. Available M-F 8-5 pacific time.
I have begun converting an MS Access Database to the web using PHP and MySQL, however, I am having doubts on my own work and feel I should learn from an experienced professional. There are four forms, 20 odd tables, and less than 500 records. The program is for a project working with urban refugees so someone who has similar experience working with smaller NGO's would be helpful. Thank you.
We are looking for a talented individual or team to help us build a Hubspot type reporting tool. Every month we generate reports for our clients. These reports include: - Google Analytics Dashboard - SEO Rankings - Social Media Analytics (Likes / Followers / Reach etc) - Facebook data - Sales (through Shopify - Google Adwords information - Mail Chimp & Campaign Monitor Stats - Reports on AB testing At the minimum we need to be able to have a platform that automates these reports so we can send them as a PDF - at most we are looking for a dashboard our clients can log into with individual logins and see realtime reports and updates from these third party tracking tools. Please send a proposal (NOT A RESUME OR LIST OF ACHIEVEMENTS), as well as ONLY ONE example of a similar project you have built.
Microsoft word, windows, office, also any computer database college accreditation.
Hi, I am Mr Sriram Kasturi from Chennai, India here. Using a freelancer that I hired from this site, I setup a dedicated centos linux 7.5 web host with cpanel/whm and setup whm/cpanel for 12 domains. I need help for troubleshooting ftp issues, MySQL Database issues, rvsite and rvsitebuilder issues for my cent os 7 dedicated server and check for general maintenance to find out whether there are other errors. I estimate two hours of effort and I can pay a maximum of Rs 1000/ for this work. Please place your bids and I want you to maintain strict confidentiality and non disclousure of the work in case I award you the project. Looking forward to bids asap. Warm Regards' Sriram.
I need help with some SQL questions. The deadline is three hours on a specific day. Message me and I will send you old questions so you know how it might look like. The new questions will be of same "difficulty grade" as those ill send you as exempel. So if you dont think you can answer them in 3 hours please dont bid, i will not pay anything if the deadline passes. You have to be available on a set date and time when i recieve the questions.
I have one computer in an office that used to open the program that uses the sql database just fine before it was upgraded to windows 7. Now it comes up with an error when launching the program that it can't connect. No other changes were made. All of the other computers in the office open the program without an issue
I need a visio Experts who have good knowledge of UML diagrams. I need a serious and hard working person who may work with us for LONG term
The goal of this mission is to support us about Postgres performance in the context of an important delivery in the end of June 2018. • Manage dynamic graph on Postgres • Monitor PostgreSQL usage (alerting, bottleneck…) and create relevant testing procedure to optimize performances • Optimize PostgreSQL configuration and maintenance procedure • Improve data management in Postgres to optimize the dynamic data management • Build/imagine procedure to minimize the impact of update (insert, update, delete) on graph (edge table). • Be able to perform analysis/processing on graph
I have the following structure in an MSSQL2008 database : I am in need of a script to replicate the output shown below. It is generated by: groupby on RPT_ID, FILE_ID, LINE_ID, distinct (dynamic !!!) columns from COLUMN_LITH and 'first' values in COLUMN_VALUES (COLUMN_NAME is dropped)
1, master one or more mainstream database structures such as MySQL, MSSQL, Oracle, PostgreSQL, and particularity. 2, familiar with the infiltration test steps, methods, processes, proficiency in various penetration test tools. 3, have host, network or Web security penetration test related project implementation experience. 4, master the security hole discovery and utilization methods, have a certain amount of actual combat experience, have rich penetration test actual combat experience is preferred. For details, please contact me at Gmail. My Gmail ID: Dengt575@[login to view URL]
Looks like my 200 files were exported from a MYSQL database or Access database and now they have all information in one field and won't display correctly. I want a freelancer to fix the format on the first file of 200K AND SHOW ME HOW TO FIX SUBSEQUENT FILES...
I need the database expert who has the good knowledge in access. Please bid if you have the experience. Details will be shared with winning bidder.