Database Administration is a professional service that allows organizations to create, maintain and secure their data architecture from the most basic structure to the most complex. Database Administrators (DBAs) typically have vast technical knowledge and specialize in installing and configuring database management systems, configuring access controls for secure data, improvement of data architecture and monitoring system health. A great Database Administrator can be an invaluable asset by helping clients increase efficiency and reduce redundancies in their databases.
Here's some projects that our expert Database Administrator made real:
- Constructing highly secure IT infrastructures - tailored systems that help boost overall security.
- Ensuring safe data transfers between different systems, such as from a previous cPanel installation.
- Building, maintaining and improving database systems for businesses ranging from websites to lead generation services.
- Efficient query tuning for SQL or MongoDB databases for businesses seeking optimized performance.
- Creation of database structures and processes catered to the needs of any business, such as an HACCP database.
- Deployment of various database structures, such as Azure websites with ABP framework support.
- Installation of SQL database solutions on Macbooks, maximizing performance with the help of a skilled professional.
Our Database Administrators are highly skilled professionals whose expertise can help any organization establish and maintain an effective database infrastructure that meets the requirements of their business. Freelancer.com is a great platform to hire a Database Administrator; you can find qualified professionals who can complete all types of database related tasks quickly and cost-effectively whatever your size or budget may be. Post your project now to take advantage of our amazing pool of talent, or browse existing projects on our platform if you are interested in learning more about what it’s like working with our professionals.171,430レビューから、クライアントは Database Administrators 4.88/5個の星で評価します。
Database Administrators を採用する
Migrate an Access database to Microsoft SQL Server
Un cliente quiere montarse un sistema de BI para analizar a sus usuarios. Tiene unos 500K clientes con unas 10K ventas mensuales. El tamaño como ves es mediano/pequeño. El tema esta en que hay que montar un ETL para sacar los datos de distintas fuentes MySQL para el email, Navision, SQL, para las ventas off-line y Magento, MySQL, para las on-line. Con todo esto hay que hacer un profiling de los usuarios y montar un dashboard para dirección. Lo suyo es empezar con algo simple, extrayendo datos de las distintas fuentes y luego hacerlo en semi-tiempo-real. Como herramienta de explotación de BI tienen un Power BI muy simple que coge los datos de Navision. Lo suyo seria extender esto con otras fuentes provenientes de MySQL. Estoy buscando a alguien que pueda llev...
Hello Freelancers! I'm looking for an experienced Mulesoft Architect to join me and help with a project. The ideal candidate will possess proven expertise in Mulesoft Integration and API Development, specifically design and construction of integrations, configuring data and various processes, maintaining, testing and deploying on cloud platforms, as well as cloud platform setup and administration. The successful applicant will demonstrate extensive experience in the Mulesoft technology stack, as existing Mulesoft expertise is essential for this role. If you possess the right qualifications and experience, and are excited to join on an incredible project, please get in touch! I look forward to hearing from you.
I am looking for an experienced data warehousing expert who is knowledgeable in database design, data integration, and data warehousing design big data. Deadline: 1-2 days
Hi there, I am looking for an expert to help me recover deleted data from postgres tables. The database platform that contains this lost data is PostgreSQL. Unfortunately, I don't have backups of the data, but I have some similar data. The good news is that I do have access to the original database. Therefore, the job requires someone that has the necessary know-how to recover the deleted data from postgres tables. It’s important to note that I must be able to access the recovered data from the original database. If you have the skills to help me retrieve this data, then I look forward to hearing from you soon! i have run thease commands delete from job_order_challan;delete from joborder_challan_receipt; need to recover job_order_challan table data
Hello, I have a project I need help with. I need someone to create a Code Unit in Microsoft 365 Business Central 2019 that has a Function to Read and Write from Data Tables. The technology stack to be used is C# and it will be accessing the Business Central Database Tables. The type of Function that needs to be added to the Code Unit is Read/Write Records. If you think you have what it takes to do this project, please reach out and we can discuss the details. Thank you for considering the project!
Hello, We have setup a replication from MSSQL to MySQL. SymmetricDS auto creates the schema, but one table in source (MSSQL) contains trailing space => 'Artikelnr '. This gives an error with MySQL. This project is about fixing this issue so it automatically corrects it and creates the table. <!DOCTYPE database SYSTEM ""> <database name="dataextractor"> <table name=""> <column name="Artikelnr " type="VARCHAR" size="50"> <platform-column name="mssql2016" type="varchar" size="50"/> </column> Must be future proof so no one time manual fixes. A pastebin log file can be supplied for more info.
I am looking for an expert in coding SQL to help with a project. Specifically, I need help with debugging existing code, creating stored procedures and working with a MySQL database. The ideal candidate should have extensive experience in coding SQL, including working with databases, debugging code and writing stored procedures. An aptitude to problem solving is also essential.
As per our project scope, we need to save the data from the primary server to the secondary server. However, In the secondary server, the field of date-time is considered the same server system date-time. According to the requirement Need to pass the value of date-time parameters from the primary to the secondary server. Find strings in multiple tables of the Database. Hence, I would like to request you please do the needful for the same. please let me know if you have any concerns.
Creating B+ Trees and B- Trees and hashtable buckets.
Module Learning Outcomes The following LOs are achieved by the student by completing the assignment successfully 1. Evaluate techniques used to ensure security in a database-oriented information system. 2. Manage user access and user profiles within a complex and DBMS. 3. Conduct database audit. Assignment Objective 1. Understand the security attacks in the database. 2. Create database security auditing plan. 3. Implement user management controls to achieve security requirements. Write assignment
Hello I need mysql expert within DB and hosting.i have files,i will share it .it is simple work if you are check and solve my problem. Thank you
We have a MySQL DB, hosted on web server with Cpanel (phpmyadmin available) we need to make some optimisation and define some helping tables and views (all database is less than 10 tables) We should also define a periodic routine to take data from one table and translate it to other table inside the DB. Please bid if you have Vast experience with MySQL DB This is first job we will need in this DB, its a couple of hours work, Budget is 70$ for this project, we would like to work with a good supplier further more on our DB issues. Good Luck
Require a DBA , to manage server at client location
I need assistance with the Airtable base design. I have a data set of responses to a lengthy questionnaire. It is a flat “dataset” - one row contains all of the responses for each respondent. I want to do some basic analysis and run various scenarios - if we filter out all persons who respond X, Y, Z and A, B, C - what does the remaining group look like (measured by a response in the instrument (a self rating the respondents have did)). I’d like to set up the base so that I can adjust the criteria - the filter - and see how this effects the remaining pool.
I need the best of the best of the best dashboard customization to monitor (everything in the attached file) 1) Operational excellency. 2) Time delievery 3) Time of sales 4) Volume of sales 5) Strategic Delieverables 6) Cash Flow (expenses, returns, net profits) 7) income statemetn 8)expenditure statement 9) ....etc. monthly log, bi-monthly, every quarter, every six months, every year.
More details will be shared with the preferred freelancer only experts can bid . Please don't time waster's bid on it
Oracle SQL Tuning, Tuning 4 oracle Exadata queries that's taking 3-4 minutes to run to make it to run in less than 30 seconds.
I am looking for an experienced Data Warehouse Consultant with banking knowledge and experience to provide Ongoing Support for a project I am working on. I have selected the SQL Server platform but it is not absolutely necessary should you have other options that can serve my needs better. I am aware that regulation in the banking industry may be an issue, but for this particular project, no specific regulations are necessary. This is an ongoing support role and looking for someone who can provide expertise and insight into the design, development and maintenance of the data warehouse.
I want to create for this project a chatbot using rasa, do you have experience in AI chatbots
I am in need of a freelancer to help me with a project of migrating from my existing OpenProject Bitnami to OpenProject on Ubuntu. I am using Ubuntu 20.04 and will require help in setting up the new OpenProject installation. The successful freelancer will need to be knowledgeable in OpenProject and proficient in database migration for this project. I am looking for an experienced, reliable, and self-motivated individual who is able to provide quality work that meets my expectations. If you think you have the necessary experience to complete this project successfully, then I look forward to hearing from you. Thank you!
I need an experienced database professional to help me optimize the speed of my queries and configure a high availability setup on a MySQL database. The optimization will focus on the queries being used by default. The high availability setup should cover all aspects of disaster recovery and data protection, with appropriate failover protocols. The ideal candidate has extensive experience in database optimization as well as working with MySQL databases to ensure a successful outcome. If you have experience creating or working with databases using other technologies (NoSQL, for example), that could be beneficial too. The expected result of this project is a database that can run quickly and reliably, providing maximum uptime and eliminating costly downtime from system outages. The perform...
Upgrade Primavera PPM and database to 19c.
My project requires assistance in converting my existing Microsoft Access database to a MySQL database which will be used in our new Word Press Web Sites.. We would like to update the database on our local machine and after updating, the files would be uploaded to the Word Press Web Server. The resulting MySQL database needs to be hosted on a local server, and I would like an interface to interact with the MySQL database. The Microsoft Access database contains both text and numerical data. My project requires someone who can efficiently transfer the data from the Access database and correctly incorporate it into a new MySQL-based system.
I have an sql server which i pull service-related data from in power bi. its all organized in tables now. im looking for a person who can zoom call IMMEDIATELY right now for maybe an hour or two. Open to pay negotiations if you can REALLY help me. must know at least dax.
Our company is currently seeking a skilled Tableau Developer and Power BI Expert to join our team. As a data visualization specialist, you will be responsible for developing and implementing visualizations, reports, and dashboards to help us gain valuable insights into our data. Responsibilities: Design and develop data visualizations using Tableau and Power BI Create and customize dashboards to meet business requirements Generate reports and automate report generation processes Analyze data, create data models and integrate and transform data from multiple sources Optimize performance and troubleshoot issues Collaborate with stakeholders to identify business needs and design solutions Requirements: Proven experience in developing visualizations using Tableau and Power BI Strong knowled...
Need in about 3 hours. Urgent 2 minutes meeting . Malaysian only . Payment Rm100.00
Here's a simple flow leading form a mobile base in website.i have sample.i need database also.
Database Administration, proficient knowledge of Django create for this project a chatbot using rasa
Rasa Chat bot to GPT4 AI chatbots, for customer be an expert on python
Hello I would like someone to build me a bridge between My Odoo PostgresSQL database to an old in house oracle based database I want my sales orders that I do on Odoo to be posted on the oracle as sales orders also
I'm looking for an expert DBA to help with a project related to moving data from an existing MySQL-based database to a new database system. Both database have different structure, table and datatype. I'm looking for someone with experience and expertise in MySQL, as well as a strong knowledge of best practices when it comes to data migration. Ideally, the candidate should have experience working on project-based tasks and be able to provide clear timelines for completion of the project. If you think you would make a great fit for this project, please don't hesitate to apply!
I am looking for someone to help me with a project involving sql (Structured Query Language). I don't need help writing a query, but I don't have an existing database nor do I have the structure set up. I also do not need help creating stored procedures. The project does not involve any of these tasks. I simply need somebody to help me with sql for a particular project.
I am looking for an experienced administrator for regular support for a real estate team. The successful candidate should have a strong background in working with real estate agents by offering assistance with admin tasks, email inbox management, agent outreach, phone calls and more. Someone who is meticulous and has excellent attention to detail and reliable organizational skills is necessary. Experience in a similar role would be preferable. The ideal person should be self-motivated and a team player. If you feel that you have the skills and experience to work in this position, please apply now.
We are looking for people who rant to work for two months project in order to create a Business intelligence program based on Power BI.
This server suffered HDD failure or HDD COntroller failure. Dell support has been less than useless in helping with this. The server had 8 VMs running, using VMWare. Will need someone local to our Area, Windsor - London - Sarnia, Ontario, Canada I'm looking to restore my existing server using VMware virtualization software. The business I am representing has been established for a while now, and is in need of a reliable server to store and manage our data. We require a knowledgeable individual who has experience working with Dell servers as well as VMWare for restoring our current system. If you think you are the right person to complete this task, please contact me so that we can discuss the details further. Thanks for your time.
I'm looking to hire a freelancer who can help me with Oracle SQL Query Tuning and improve Oracle Performance. I will be using Oracle Exadata Database and therefore the successful freelancer should have prior experience working with these versions. The specific work required is Ad-hoc Query Tuning so the applicant should include relevant past work and experiences as part of their application. Detailed project proposals are also appreciated. Scenario: 4 Oracle SQL Queries that we have taking time anywhere from 3-7 minutes and wanted these to be running in less than 30 seconds. So require some one with Oracle SQL Performance Tuning Expertise to rewrite the query or Add any DB Configuration or Indexes or other Performance enhancement tips to cut that runtime down to 30 seconds or less. ...
Drawing B+ and B- trees and knowledge on hash table buckets can be really helpful.
We are looking for a database developer/compiler who can help us develop and maintain our databases. The ideal candidate will have experience with both SQL and NoSQL databases, and will be able to write efficient and reliable code. They will also be able to work with our team to ensure that our databases are up-to-date and meet our needs.