Database Administration Jobs

Construct then Test SQL queries and reports

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.

Looking for sql expert to do development to use hadoop vm by following instrructions, i can share details with you , thank you, Looking for somone experience in Big cloud Data management.

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

Find partition from two tables and run alter command to change schema

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.

cloud database management class project using hadoop vm

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.

Virtual administration Assistant

We require fully experienced Microsoft SQL database administrator to optimise and support stored procedures. Our database already exists

I need a person to create Star Schema and break my columns into fact and dimensions.

I need someone to help me and guide me in Oracle data masking on oci 19

we are facing issue SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in

we are facing issue SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in

MIS expert required. Database expert required.. i need this small project today

I work as a DBA. I just need someone to answer few questions here and there and explain it to me why and how it’s done and some queries.

i need someone experienced with sql

I need a freelancer who has studied databases and sql to help me resolve these problems in the PDF which i have uploaded. As i have said it's about databases, sql, indexing and Cost optimization.

I need a freelancer who has studied databases and sql to help me resolve these problems in the PDF which i have uploaded. As i have said it's about databases, sql, indexing and Cost optimization.

Project on metrics, tracing and logging with opentelemetry and nosql database

I want a person who is expert in handling MySQL databases for my company.

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...

I want taxi driver data in west Bengal state

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

Looking for a guy who can fix checkout issues on laravel website.

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

Hello, am looking for help on a project - "Database Principles" for one project/study work that i have. Its around 3500 words. Can someone help?

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

l want to do strategic Queries and user Veiws

need to perform sql operations

I need an expert who help me Prepare a DOD SOW TEMPLATE FOR US Based on MIL-HDBK-245D

Need to generate a Account ledger and stock ledger from sql server database. we can show you the tables and the relationship structure from where the report is to be generated

Hi there, I need an SQL expert to create a few SQL queries based on the given example database and the requirements. Deadline is 2 hours MAX. Budget $50

We need to fix the query string with fast data fatch and configure mysql server in proper way All the report pages and admin link should open in proper way

Necesitamos tener un DBA freelance que nos ayude a tomar copias esporádicas o resolución de problemas eventuales en las bases de datos.

PEMASANGAN CCTV MAINTENCE KOMPUTER DAN SOFTWERE DAN PERBAIKAN JARINGAN

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...

Necesito un experto en mysql para recuperar datos de una base de datos, al parecer la instalacion de mysql esta rota