Pentadbiran Pangkalan Data Jobs

Requireeld to export few excel sheets in mySql database on a linux server

We want to implement MySQL HA in two node windows cluster.

1. Provision MySQL (v5.7 or higher versions) instances, both in clustered and non-clustered configurations 2. Experience with replication configuration in MySQL 3. Ensure performance, security, and availability of databases 4. Handle common database procedures, such as upgrade, backup, recovery, migration, etc. 5. Profile server resource usage, optimize and tweak as necessary 6. Proficient in writing and optimizing SQL statements 7. Knowledge of MySQL features, such as its event scheduler 8. Ability to plan resource requirements from high level specifications 9. Collaborate with other team members and stakeholders 10. Good to have: Hands on experience in Tungsten Cluster and Tungsten Replicator

Blue Clean is a cleaning company based in Sydney - Australia since 2013, specialised in Residential, Commercial and Accommodation Cleaning for short term rentals. As the business continues to expand, we are currently looking for 2 Bilingual Virtual Assistants (English and Spanish) A Virtual Assistant is required to provide sales, customer service and team support with taking and scheduling customers’ bookings and assigning jobs to cleaning contractors. You will build strong relationships with our customers and teams and will enjoy being part of a team and learn from the process. You will speak Spanish and English as most of our contractors speak Spanish and all our customers speak English. You will be the main point of contact to liase between the two to get the job done. Duties...

I am new to oracle and I need help to create cron tab jobs that will query the oracle database and upload the result to the SFTP site every month.

Chinook Database Introduction In this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows. All of the below instructions are discussed in detail as you work through this lesson on your way to completing this project. The below serves as a quick reference of what you will be doing as you progress through the completion of this project. Instructions You will need to follow the instructions on the next three concepts to ge...

Hi, THIS PROJECT IS FOR MYSQL DATABASE EXPERTS NOT FOR WP DEVELOPERS. A few months ago I have changed my WordPress hosting and that host converts my WordPress database into latin1 while migration of my site. Now I have changed my host but due to latin1 few features (e.g. WordPress multisite) of WordPress are not working. When I changed following line in wp-config from define('DB_CHARSET', 'latin1'); to define('DB_CHARSET', 'utf8mb4'); My whole text matter (Hindi and Marathi) getting messed up, can you please fix and cover my database smoothly. see the URL all Unicode text got messed up Here is the WordPress manual Here is one more person who faced an issue like me First, you need to fix the issue on the staging site and then you can work...

Need some help with SQL Server Agent not starting.

You must be an experienced (7 years or more) SQL Server Programmer who can write (1) Optimized Queries (2) Clean up our existing stored procedures (3) Introduce transaction handling in the existing procedures (4) Introduce exception handling in existing stored procedures. The highlight of your eligibility for this requirement is your expertise and experience in writing clean and optimized stored procedures. Any experience in ECommerce and Fintech domain would be a great advantage. You will be required to spend around 25-30 hours a week initially abd You must be a person of high integrity , whom we can depend on for long term projects. Some of the consultants working for us have stayed with us for more than 4 years.

We are workinf with a client in migrating thier custom developed ERP to Odoo 14. We need all transactional data such as invoices, PO's, GL entries to be extracted from their ms sql database to csv so we can import to odoo

There are more than 10k sql records and some records are duplicated i want to learn which records duplicated regarding below conditions Conditions If = and = and = and – <= 95 days and <= 1,5 TABLE Column1 | column2 | column3 | column4 | column5 Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5 Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5 Row 3 |8800 | pencil | 1234 | 2021-04-05 | -650 RESULT Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5 Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5

I need the help of someone who could assist with some small scripts with SQl Programming Urgently...tif you can finish it in less than 2-3hrs hanks

- cpanel admin db need to configure - run overall code

I need explanation of architecture diagram related to database oracle PLSQL and Json

I need help putting together a project proposal in technical paper format. The topic covers Data Warehousing. More details are attached in the document and an paper outline that needs to be covered.

I was looking for who is expert in adf with strong data modeling concepts

Need a trustable Power BI Developer, to co-work with us remotly. Tools and Terminologies: SQL Server Power BI TimeZone: Need to work at US PST Time Zone. Preferred 3 to 5 years experience candidate

I have a MySQL database with some tables and data. I need to add some additional fields to my main table and then have a update routine that that can read the record in the table , get matching data from other tables and update the main table with calculations and the results to be written in the database table. We can connect and share my screen to discuss further, I need this done immediately so must be done today. If you cannot do it today please do not reply and waste time

We're looking for a certified MySQL DBA who has an exceptional experience in DB performance optimization. You will join our engineering team and help client's project for more than 3 months. We're in middle of implementing archiving strategy so your initial project would be to carry out those archiving scripts and update them with ongoing basis. Project stack: MySQL, .NET Web APIs, Entity Framework, GCP Cloud SQL Requirements: • MySQL DBA certification • Fluent in spoken and written English You'll need to be available during the US business hours.

I am a quality and patent safety director , i am responsible for 14 hospitals , 61 primary health care centers I have alot of data , i hope to give me a professional work analysis and analytics to introduce these data to my boss Time i hope to finish work 4 days

Looking for an individual to upgrade Oracle database from 12c to 19c Required experience in upgrading Oracle databases Ability to define clear upgrade path and estimate effort

Modyfikacja istniejących procedur MS SQL Server (500 do 1000 linii), ok. 200 tabel, dodawanie endpointów. Jezyk Polski wymagany. Pełen wymiar czasu. 6 tygodni. Od zaraz. Praca zdalna.

Virtual Administration Assistant

I need to build a search/query engine where a user will type a query in english which will be mapped to a correct or relevant sql query. Post a trigger, sql query will fetch the details and display some insights, graphs and visualisations.

i want to transfer sql data to other sql databse using static ip

I am using Perfex CRM and a MySQL database. I need a loop routine that must select my data within a date range read the record find the correct price do a calculation and update the same record in the table and then move to the next till all us done. I require this as a option on the menu that we can reuse at any time. Must be able to work live online on my server as we will not be sharing the application or database to any outside person

Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10 - need to install and config user only

Field people's doctor and retailer visit detail will be tracked through this report.

Hello. Guys I need developer who can convert MS SQL database to SQL database file. If you are available for this role contact me

I need to cerate a report and help setting and moving MS Reprointg server to 2019 from 2012

Installing new server to small established network of 5 computers, database exceeded 10 gb so we have to upgrade to sql standard from sql express. Small optometric office we run office mate ’ll be able to call office mate for help in transition to new server.

Install the required software and restore the Oracle 11g database backup. Make a connection with the application.

Client interview support and job support for 6 months in Big data engineer Python,hive,haddop,sql

I would like a directory database that is simple to use. I would like a search filter option so that shippers can search for a truck and find matches based on the information provided by my carriers.

Connection failed: User "someting" has exceeded the 'max_user_connections' resource (current value: 50)

We are looking tech panelist for technical interview for several skills related to infra like Network Security L3, Server L3, cloud AWS, AZure L2 and L3, DBA, Data storage, service desk Lead etc.

Need an online person to work with me in parallel for this view creation for report. Only remote online person is required

We develop cloud applications for which we are in need of creating Technical and user documents starting from the beginning of the project

busco crear un base de datos para poder registrar a mis clientes (alumnos y padres) y poder lleva run mejor control de estos alumnos, un base de datos que cuente con lo básico (nombres, apellidos, teléfonos, direcciones, etc.) y agregarle campos adicionales.

We have an existing system built on top of MySQL. The system uses a lot of various filters / queries and is very slow. It was built and modified as the needs changed so it is a bit of a “Frankenstein” creation. Our immediate need is to: (1) review the DB structure and suitability for our use cases, (2) optimize tables and queries/filters, and (3) determine if – long term - we should stay with MySQL or switch to something like PostgreSQL.

We are looking for an experienced SQL Developer to join our existing team of web-based enterprise application developers. The primary responsibility of the candidate is to develop Stored Procedures and Functions that perform the applications business logic. The candidate should demonstrate strong logical, analytical, coding and debugging skills. Ability to write medium to complex Stored Procedures & Packages, T-SQL queries (DML, DDL statements, etc.), Functions, Transactions, Triggers, Database designing, Indexes, Query optimization, Troubleshooting Desired Candidate Profile - Desired candidate should have excellent knowledge of T-SQL - Good understanding of query optimization and indexing - Good database designing skills - Knowledge of various packages like SSIS, SSRS, SSAS would b...