Database Administration Jobs

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.

modifying store procedure on sql server

I have several realestate documents of realestate pin numbers and lot number owned by several owners. We are looking for someone to transpose from the paper print outs and list the owner names, the pin number and the lot numbers associated by owner. In other words, we are looking for the number of lots owned by each named owner. What owner names are associated to lots and pin numbers.

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.