Databasadministration Jobs

I need a professional to assist with a database migration project from PostgreSQL using Sequelize ORM. Key responsibilities: - Migrate data efficiently and accurately from PostgreSQL to a new application using Sequelize. - Ensure data integrity and consistency throughout the migration process. - Optimize the migration process for speed and efficiency. Ideal skills: - Extensive experience with PostgreSQL and Sequelize ORM. - Proven track record of successful database migrations. - Strong understanding of data integrity and consistency issues. - Excellent problem-solving skills. This project requires a freelancer who can work independently, is detail-oriented, and can deliver high-quality work within a set timeframe.

I am in need of a seasoned professional with extensive experience in Oracle Cloud Infrastructure (OCI) server setup. The project involves configuring several components including a load balancer, a firewall, an IP address, Redis, and a MySQL database. Key Tasks: - Setting up the Oracle Cloud Infrastructure Load Balancer - Configuring the Oracle Cloud Infrastructure Firewall - Reserving a new IP address - Configuring Redis - Setting up a MySQL database Ideal Skills: - Deep understanding of OCI server infrastructure - Experience with Oracle Cloud Infrastructure Load Balancer and Firewall - Proficiency in Redis and MySQL configuration - Network management skills for IP address reservation This project is crucial for our operations, and I am looking for someone who can deliver quality work ...

Our MySQL database on GCP is experiencing significant performance issues, leading to long wait times and system locks. While I have not undertaken any optimization efforts yet, it's clear that our database is struggling due to a range of factors, including complex queries with outer joins, high process concurrency, and large volumes of inserts. The ideal candidate for this project should have the following skills and experience: - Proficient in MySQL database performance optimization - Prior experience with Google Cloud Platform (GCP) databases - Skilled in handling complex SQL queries effectively - Ability to manage high process concurrency and large volume inserts Key Responsibilities: - Diagnose the root cause of long wait times and system locks - Optimize the database performan...

I am seeking an experienced professional who can guide me in synchronizing transaction data between two MySQL databases. The synchronization will need to be accomplished through database triggers on a Hostinger VPS with CloudPanel using phpmyadmin. Key Requirements: - I only need guidance on how to do it. I will handle the execution. - Assistance in writing INSERT statements to synchronize both databases, which have different tables and columns. - Ensuring the synchronization is real-time and bidirectional.

I am seeking an experienced professional who can guide me in synchronizing transaction data between two MySQL databases. The synchronization will need to be accomplished through database triggers on a Hostinger VPS with CloudPanel using phpmyadmin. Key Requirements: - I only need guidance on how to do it. I will handle the execution. - Assistance in writing INSERT statements to synchronize both databases, which have different tables and columns. - Ensuring the synchronization is real-time and bidirectional. Please note: Bids from freelancers who have not done this before will not be considered.

My project involves synchronizing transaction data between two different MySQL databases. The synchronization needs to be done through database triggers using phpmyadmin on a Hostinger VPS with CloudPanel. Key Requirements: - I just need sample triggers. Rest, I will take care myself. - Writing Insert statements to synchronize both databases, which have different tables and columns. - Ensuring the synchronization occurs in real-time. - Databases exist on different URLs Please note: - Bids from freelancers who have not done this before will not be considered.

I'm seeking a professional who can implement AES 256 encryption on specific columns within my MySQL database tables using openssl iv along with matching sql queries modified for aes on the php backbone Key Requirements: - MySQL database management system: The project is strictly centered around MySQL, hence, a thorough understanding and experience with it is mandatory. - AES 256 Encryption: I need the expert to use AES 256 encryption, a well-known and reliable encryption standard, to ensure the security of my data. - Openssl iv: The use of openssl iv is crucial for this project, therefore, familiarity and experience with this tool is necessary. - Targeting Specific Columns: The project does not require encrypting all data within the tables, but rather specific columns. Therefore, the...

I'm looking for a professional to help configure my Linux server and upload my MySQL database. Key Tasks: - Initial setup and installation of the server - Upload and setup of my MySQL database - Performance tuning for optimal server efficiency Ideal candidates should have: - Extensive experience with Linux server configuration - Proficient in MySQL database management - Skills in performance tuning and server optimization

I have a corrupted MDF file from Microsoft SQL Server that needs urgent attention. I require a professional who can extract all structured database records from this file.

I'm currently facing connection errors with my Scylla database and need expert help. Key Responsibilities: - Troubleshoot and resolve configuration problems - Help with accessing the Scylla server - Ensure optimal connection settings to prevent future issues Ideal Skills and Experience: - Extensive experience with Scylla database - Proficiency in database configuration and troubleshooting - Strong understanding of server access protocols - Excellent problem-solving skills

Hello, I hope someone can teach me how to configure pgBackRest to back up my database on a VPS with PostgreSQL. The idea is to store those backups in Azure Storage and also have them explain how to restore the database in case it stops working.

I'm in need of a seasoned SQL database analyst with a specific focus on hybrid database design. The key aspects of this project will involve: - Designing a new hybrid SQL database to meet specific project requirements. - Ensuring the database is optimized for both relational and non-relational data, in line with hybrid design principles. Ideal candidates should have extensive experience with SQL and hybrid database design, demonstrating a strong understanding of both relational and dimensional design elements. Please include relevant examples of your work in your proposal.

I am looking for someone to mentor, train and provide project support on Talend and complex sql tasks. This is at least a 3-6 months arrangement. I would require a right person to give me a demo before we can start the project together. Confidently is an important part of the process.

I'm in need of an experienced Node.js developer who can create a server for a financial dashboard. The dashboard will connect to various APIs to source real-time stock prices. Key Requirements: - Create a Node.js server that can handle real-time data. - Ensure the server can connect to and retrieve data from multiple APIs. - Implement a system for displaying this data on a financial dashboard. Ideal Skills: - Proficient in Node.js, with a strong understanding of server creation. - Experience with financial data and stock market APIs. - Ability to implement real-time data updates.

We are looking for a skilled freelancer to assist in migrating our existing Appsheet applications from Google Sheets to a more robust database solution. This project involves analyzing current app functionalities, designing a suitable database structure, and ensuring a seamless transition without data loss. The ideal candidate should have experience with Appsheet, database management, and data migration processes. Your expertise will be vital in optimizing our app's performance post-migration. only contact me with previous matched exps. If not, I will not accept.

I need an Oracle Database Administrator who is also skilled in Linux system administration to help optimize and maintain my Oracle database environments. The project is short-term and budget-friendly. Key Tasks: - Database performance tuning, specifically addressing slow query responses. - General system maintenance ensuring the databases run smoothly. Skills Needed: - Proficient in Oracle Database Administration - Linux system administration expertise - Skilled in database performance tuning - Experience in identifying and resolving slow query responses I am looking for a professional who can deliver quality work within a limited budget. Please provide a proposal if you meet these qualifications.

I need a skilled Database Administrator (DBA) to analyse my existing database table and create a new one. The new table will be used for storing user data, specifically personal information like name and address. Key Tasks: - Analyse current database for efficiency and necessary modifications. - Create a new table to store user data, linked to the existing table. Ideal skills for this project include: - Strong SQL skills - Experience with data privacy and protection - Excellent problem solving abilities - Previous experience in creating and linking database tables. Please note, the new table will reference the existing one. Therefore, a thorough understanding of the current table's structure and data is crucial for this task.

I need a comprehensive web application for order management with a primary focus on order tracking. The application should be capable of catering to both internal staff and customers. Customers will scan the QR which will open the menu from which they can place the order. The admin (owner) will be able to view all the orders on the screen and update the status. Key Features: - Real-time updates: The system should provide real-time tracking of orders to users. - Order history: Users should be able to view the complete history of their orders. - Automated notifications: The system should automatically notify users about the status of their orders. Ideal Skills and Experience: - Proficiency in web application development. - Prior experience in creating order tracking systems is a plus. - Ex...

I'm looking for a creative writer who can craft a psychological horror story for my social media page on Facebook. The story should captivate my audience, keeping them on the edge of their seats and coming back for more. Key Requirements: - I need a story that can be delivered through radio-style content, so it's critical that the writer has experience in this type of storytelling. - The successful freelancer should have a strong background in crafting psychological horror narratives that are designed to deeply unsettle and provoke thought. Please include in your application: - A detailed project proposal showcasing your understanding of psychological horror and how you plan to engage my audience. - Past work or references that demonstrate your expertise in this genre. I'...

I'm seeking an expert in SAP SD (Sales and Distribution) to assist in a comprehensive project. The selected freelancer will focus on all aspects of the SAP SD module, with a particular emphasis on optimizing our current 'Pricing and Billing' if I get someone who is staying in US currently Key Responsibilities: - Overhaul and optimize our Pricing and Billing processes within SAP SD. - Assist with the implementation of a new SAP SD module. - Manage and oversee data migration and cleanup tasks. Ideal Skills and Experience: - Extensive experience with SAP SD, particularly in 'Pricing and Billing'. - Proven track record in process optimization. - Strong skills in data migration and cleanup. - Experience with implementing new SAP modules.

I need an experienced database expert to compare my ORIGINAL and NEW Microsoft SQL databases. The primary goal is to update the NEW database with missing fields. Key Responsibilities: - Compare both databases thoroughly using SQL Server Management Studio (SSMS). - After identifying discrepancies, we will discuss what is missing before updating the NEW database. - Specific tables to be compared will be decided post initial comparison. Ideal Skills and Experience: - Extensive experience with Microsoft SQL databases. - Proficient in using SQL Server Management Studio (SSMS). - Strong analytical skills to identify missing fields. - Good communication skills for discussing updates.

**Title:** GCP Compliance Engineer Needed for NERC CIP-Like POC Setup **Description:** We are seeking an experienced Google Cloud Platform (GCP) engineer to design and implement a small-scale Proof of Concept (POC) environment that demonstrates NERC CIP-like compliance controls. This POC won’t be for a specific client deployment yet, but will serve as an internal reference for future engagements. The ideal candidate has a deep understanding of GCP security, IAM, logging, monitoring, and compliance frameworks. **Responsibilities:** - Establish a dedicated GCP project and VPC network to mimic the isolation and segmentation required for NERC CIP compliance. - Configure IAM policies, roles, service accounts, and MFA enforcement to reflect least-privilege and secure access princip...

I'm looking for a developer to create a ChatGPT-like chatbot that can be deployed in a Docker container for use within my company. This will provide a secure, standalone network for our organization. Key Features: - The chatbot should be able to access our internal company database to fetch information. - It should be capable of answering general queries posed by employees. Data Interaction: - The data from our internal database is structured, primarily in SQL format. Therefore, experience with SQL databases and structured data is a must. - The chatbot should be able to interpret and pull relevant data from the database based on the queries received. Ideal Skills: - Experience developing chatbots or AI systems. - Proficient in Docker and SQL. - Ability to create user-friendly, effi...

I'm seeking an expert to assist with a Bugzilla migration. Key aspects of this project: - The migration involves transferring issues/bugs, user accounts, and attachments with comments from Bugzilla to Bugzilla. - The data size is medium, containing between 1,000 to 10,000 records. Ideal candidates should have: - Proven experience with Bugzilla migrations. - Technical proficiency in data migration and handling. - Ability to ensure data integrity throughout the process. - Ability to Install/Manage mysql

I'm seeking a knowledgeable SQL and Database instructor who can teach me the intricacies of both relational and NoSQL databases. This project is focused on comprehensive learning rather than a specific development task. Key Responsibilities: - Teach database design principles - Explain query optimization techniques - Elaborate on stored procedures and functions - Guide through the development of various types of databases Your role will be to help me understand the purpose and functionality of a database, with a focus on data storage and retrieval. Experience in teaching and a deep understanding of both SQL and NoSQL databases is crucial. The aim here is to improve my database comprehension and skills.

I'm looking for a professional skilled in Pyspark, SQL, and Python for a comprehensive data analysis project. The main focus will be interpreting and extracting insights from our datasets. Ideal Skills and Experience: - Proficient in Pyspark for large scale data processing. - Strong SQL skills for database management and queries. - Advanced Python capabilities, particularly in data analysis libraries such as Pandas and NumPy. - Experience with data visualization tools (e.g., Matplotlib, Seaborn) to present findings. - Prior work in data analysis is highly preferred.

I'm looking for a professional who can assist me with managing my website server. The task primarily involves deleting unnecessary database files to free up space for hosting images, videos, and documents. Ideal Skills: - Strong understanding of website server management - Experience with file deletion and data management - Knowledge of database file structures This project requires someone who is detail-oriented, efficient, and can handle potentially sensitive data with discretion.

I'm seeking a professional skilled in Pyspark and SQL to assist with data transformation tasks. Your primary role will be to modify and prepare data for analysis. This may involve cleaning, filtering, aggregating, summarizing or joining multiple datasets. Ideal candidates should have: - Proficiency in Pyspark and SQL - Experience in data transformation - Strong analytical skills - Ability to work independently and meet deadlines.

I'm in need of an experienced database designer and developer to create a relational SQL database primarily for storing customer data. Key Responsibilities: - Design and develop an efficient and scalable SQL database for customer data - Ensure the database is optimized for quick and easy data retrieval Ideal Skills and Experience: - Proven experience with SQL database design and development - Strong understanding of customer data management - Excellent problem-solving skills in database optimization Please note that while data security measures were not specifically outlined, a fundamental understanding and implementation of basic security measures such as encryption and access control are expected.

My Oracle database is currently non-operational due to an issue with a control file. I need an expert in database recovery to assist in restoring full functionality as soon as possible. Skills and experience needed: - Proven track record in Oracle Database recovery - Familiarity with control file issues - Quick and efficient problem-solving skills - Ability to work under pressure - Excellent communication skills - File name cannot access

I need an experienced database expert to compare my ORIGINAL and NEW Microsoft SQL databases. The primary goal is to update the NEW database with missing fields. Key Responsibilities: - Compare both databases thoroughly using SQL Server Management Studio (SSMS). - After identifying discrepancies, we will discuss what is missing before updating the NEW database. - Specific tables to be compared will be decided post initial comparison. Ideal Skills and Experience: - Extensive experience with Microsoft SQL databases. - Proficient in using SQL Server Management Studio (SSMS). - Strong analytical skills to identify missing fields. - Good communication skills for discussing updates.

I'm in need of a developer who can create a unified messaging platform that integrates primary chatting applications such as WhatsApp, Telegram, and Facebook Messenger. This platform will serve a key role in our customer support efforts. Key Features: - The platform should be capable of providing automated responses to customers. - It should also facilitate live chat to allow real-time communication with customers. - Lastly, it needs to incorporate analytics and reporting features, enabling us to track and assess our customer interactions. Ideal Skills: - Proficiency in software development and programming languages. - Experience with CRM software and customer support platforms. - Familiarity with integrating third-party applications. Experience: - Prior work on similar projects w...

I'm seeking a professional to migrate my Carbon Black EDR management server (version 7.3.0.18311) from an old CentOS 6.x system to a new operating system. After the migration, I would also need the EDR upgraded to the latest version. Key Tasks: - Migrate the Carbon Black EDR server to a new OS (OS choice will be discussed) - Upgrade the EDR to the latest version post-migration - Full testing of the server after migration and upgrade - Special attention to be given to database configurations during the migration Ideal Skills: - Extensive knowledge and experience with Carbon Black EDR - Proficiency in CentOS, Ubuntu, and Red Hat Enterprise Linux - Strong database management skills - Excellent server testing abilities Please note, the choice of the new OS will be discussed, as it hasn...

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.