Ujenzi wa Database Jobs

Write SQL statements (MySQL/MariaDB SQL) to: Create a relational database named ‘GourmetHub’ using MySQL/MariaDB SQL (write also the statement to use it). Create the following table: RESTAURANT (CODE, name, location) with the following restrictions: CODE is the primary key. It is an alphanumeric code designating each unique restaurant. The code can have 1 to 5 characters. NAME is an alphanumeric sequence, it is required, and it is unique. LOCATION is an alphanumeric sequence, indicating the address or area of the restaurant, and it is required. Create the following table: DISHES (CODE, name, type, price) with the following restrictions: CODE is the primary key. It is a four-character alphanumeric code designating each unique dish. NAME is an alphanumeric sequence, it is requir...

Description: We are looking for a skilled freelance developer to create an intuitive and robust time-tracking system for educational courses. This project has two potential versions, and we need a price quote for each. Version 1 Requirements: - A system for tracking and managing working hours for specific courses. - Users: Admins and Teachers. - Admin Features: - Secure sign-in. - Full control over the system. - Ability to create and edit course details, including required hours. - Assign teachers to courses. - Teacher Features: - Secure sign-in. - Log teaching hours for assigned courses. - View total and remaining hours for each course. - Access a dashboard with aggregate data (total required hours, total worked hours, etc.). - Main Page: - ...

I am looking for an experienced Android app developer to modify my existing wallpapers app by creating a database mysql with admin panel instead of firebase database. Skills and Experience Needed: - Proficiency in Android app development - Ability to implement new features efficiently and effectively - Attention to detail and ability to follow specific instructions - Problem-solving skills to troubleshoot any issues that may arise during the modification process The developer will not be responsible for uploading the modified app to the Google Play Store, as I will handle that aspect myself.

I am looking for a freelancer who can assist me with database design using ERD and SQL. Purpose: - The main purpose of this project is database design. Specific Entities and Relationships: - I have a detailed list of specific entities and relationships that must be included in the ERD. Scale: - The scale of the database is small, with less than 50 records. Ideal Skills and Experience: - Strong knowledge and experience in ERD and SQL - Proficiency in database design - Attention to detail in following specific requirements - Ability to handle small-scale databases efficiently

I am looking for a skilled SQL query writer who is experienced with big query. The ideal candidate should have expertise in writing complex queries. Requirements: - Proficiency in MySQL, Oracle, or SQL Server - Ability to understand and execute complex query requirements - Strong problem-solving skills to optimize query performance - Experience in working with large datasets and handling complex data structures Responsibilities: - Collaborate with our team to understand the specific query requirements - Write complex SQL queries to extract and manipulate data from our big query database - Optimize query performance for efficient data retrieval - Troubleshoot and resolve any issues related to query execution Skills and Experience: - Strong knowledge of SQL and different database systems...

Project Description: Barcode Developing Software Operating System Compatibility: - The software should be compatible with both Windows and Mac operating systems. Barcode Generation: - The software should have the capability to generate both 1D barcodes and 2D barcodes. Speed of Barcode Generation: - The speed of barcode generation is somewhat important to the client. Ideal Skills and Experience: - Proficiency in software development for both Windows and Mac platforms. - Experience in barcode generation and encoding. - Knowledge of 1D and 2D barcode formats and standards. - Ability to optimize barcode generation algorithms for efficient performance. Note: Please provide examples of previous work or relevant experience in barcode development when submitting proposals for this project. ...

Project Title: O365 SQL DBA I am seeking assistance with database administration tasks as an O365 SQL DBA. Specifically, I need help with the following: - Database administration - Performance tuning - Backup and recovery I require this service on a regular basis and my expected timeline for this project is within 1 year. Ideal skills and experience for the job include: - Strong knowledge and experience in O365 SQL DBA - Proficiency in database administration, performance tuning, and backup and recovery - Ability to work on a regular basis and meet project deadlines

Job Title: Database Developer with Snowflake and MDM Location: HYD/Remote Duration: Full Time Required Skills: • At least 7plus years of experience in Snowflake development which includes creating Stored Procedures, Tasks, Stages, Views and Tables. • Experience working with SQL Query optimization and Cost optimization of Snowflake resources. • implement security measures to protect sensitive data such as, Role-Based Access (RBAC), Data Encryption and Data Masking. • Proficiency in building ELT/ETL pipelines with focus on Change Data Capture (CDC), History Snapshots, Audit logging and other best practices. • Working experience with any of the ETL tools such Five trans, Informatica, etc., • Perf...

I want to be able to take a text string such as: "My name is Andrew Jackson and I am a website developer." Press a button and spin the text so its dynamic. "My {name,alias} is {Andrew Jackson,George Washington,Thomas Edison} and I am a {website developer, web designer, database programmer}. I am looking for a programmer that has built an article spinner in the past. I am looking for a data source to use to spin the context. Do not bid on creating the software. I must be 100% satisfied with the data provided to me. If it does not have almost every word in a thesaurus do not bother bidding. if you are an autobidder, do not bother bidding. Type #spinArticleGuru in your bid so I know you have read this description. In addition, in your bid, tell me whether 1) you have b...

membuat aplikasi untuk koperasi skala umkm, isinya data nasabah, pinjaman. sisa kredit, sisa kasbon dll dan hasilnya bisa didownload berupa file excel

Hello, i would like to hire a database administration but needs ti prepare for some exams before Please contact mee!!

Seeking an expert developer to create a dynamic medical research networking platform. The ideal candidate should have experience in PHP programming language and be able to implement collaboration and communication tools. Additionally, proficiency in MySQL for the backend is preferred. Key requirements for the platform include: - User Profiles: Allow users to create and manage their profiles, including personal information and research interests. - Collaboration/Communication Tools: Implement features such as messaging, forums, and file sharing to facilitate collaboration among researchers. - Data Analysis Tools: Develop tools for analyzing and visualizing research data, including statistical analysis and data visualization. Skills and experience required: - Proficiency in PHP pro...

I am looking for a freelancer to help me with a project to scrape global company data. The specific data that needs to be scraped includes company names, addresses, financial information, and employee data. Additionally, I need the data to be cleaned and formatted in an advanced manner. This includes removing any duplicates or inconsistencies in the data and ensuring that it is presented in a structured and organized format. Must be scraped to a data Base and allow re scrapes. To happen. I'm looking at capturing 5000 company data records across 15 industries. 1. **Technology and Communications** - Software Development - Hardware Manufacturing - Telecommunications - Internet Service Providers - Social Media Platforms - Cloud Computing Services 2. **Finance an...

We are seeking a highly skilled freelance developer with a passion for sports to lead the development of innovative app and website inspired by the remarkable This project offers an exciting opportunity to contribute to the creation of a dynamic platform that caters to the needs of sports fans worldwide. App and Website Development: Translate project requirements into efficient technical solutions. Implement an intuitive and responsive design to provide an exceptional user experience. Sports Data Integration: Integrate and dynamically update real-time sports data to ensure accurate and timely information. Advanced Features: Implement advanced features such as chat, detailed statistics, personalized notifications, and social interaction. Performance Optimization: Ensure continuous opti...

Trucking Management System (TMS) Purpose: - To replicate our trucking management system (TMS) built on Airtable & Softr and allow subscribers user access via a website interface and/or application. Features and functionalities: - The management system allows trucking companies to manage and streamline their operation and/or assign dispatchers. Design customization: - A custom design similar to our prototype theme for both the website and application Ideal skills and experience: - Proficiency in web and application development - Experience in creating interactive platforms, airtable and databases. - Strong expertise in custom design and user interface (UI) development

I am in need of a skilled backend developer with experience in C# and .NET Core to assist me with API development. Goal: For organizing a website that is used by a bank to provide information about its products and services to customers. It may also allow customers to perform transactions such as checking their account balances, transferring money, and paying bills. Our website should typically have a number of different sections, including: * A home page that provides an overview of the bank's products and services. * A section for customers to log in to their accounts. * A section for customers to view their account balances and transactions. * A section for customers to transfer money between accounts. * A section for customers to pay bills. * A section for customers to c...

I am looking for a skilled professional to assist with migrating a small MSSQL database to Oracle. The database size is less than 1GB. Around 350 tables , 100 views, 300 scalar functions, 100 table valued functions,350 sps to be migrated The project requires special attention to any specific data types or structures in the database during the migration, although I am not sure if there are any. The timeline for this project is long term, with more than 1 week for completion. Need a person from bangalore , as I would like to work with the person offline Ideal Skills and Experience: - Experience with MSSQL to Oracle migration - Strong understanding of database structures and data types - Attention to detail in ensuring a smooth and accurate migration process

I have AWS RDS MySQL database that is of 1TB (1000GB) size. I'm looking for freelancer to migrate it to AWS Redshift. I have ~10 MySQL queries that I want to be re-written for Redshift. I will share all the details. Start your proposal with "Redshift" keyword to be considered.

Pervasive PSQL database has crashed and I need a DBA to import a table into Pervasive and export data to .xlsx DBA must use their own software as the PSQL is no more available to us

Custom Product Catalog Management I am looking for a freelancer to help me with my project on managing a custom product catalog for my digital products. Ideal Skills and Experience: - Experience in developing and designing custom-built platforms for managing product catalogs - Proficiency in database management and integration - Knowledge of digital product management and e-commerce platforms - Strong attention to detail and organization skills - Laravel / Codeigniter4 - Mysql Project Requirements: 1. Custom-built Platform: The freelancer should have experience in developing and designing a custom-built platform for managing a product catalog. The platform should be able to handle a large number of digital products efficiently. 2. Database Management: The freelancer should have exper...

I am looking for a skilled Database Administrator to assist me with creating a new PostgreSQL database for my medium-sized ongoing project. The ideal candidate should have experience in database creation and management, specifically with PostgreSQL. Skills and Experience: - Proficient in PostgreSQL database administration - Experience in creating and managing databases for medium-sized ongoing projects - Knowledge of SQL and database design principles - Strong problem-solving and troubleshooting skills - Ability to optimize database performance and ensure data integrity - Familiarity with relevant database tools and technologies - Excellent communication and collaboration skills Responsibilities: - Collaborate with project stakeholders to understand database requirements - Design and cr...

I am looking for a freelancer who can assist me in preparing a solution design and writing procedures in Oracle SQL database. I already have an established database structure, but I need help with queries and procedures. The level of complexity for the queries and procedures is intermediate. Ideal Skills and Experience: - Strong proficiency in Oracle SQL database - Experience in designing and implementing queries and procedures - Knowledge of intermediate level SQL concepts and techniques - Familiarity with Oracle database structure and best practices

Se desea realizar un desarrollo que me permita conectar con el sistema TICA del ministerio de hacienda con el fin de poder obtener de manera automatizada los DUAS (Documento Único Administrativo), el cual es una declaración de importación o exportación que se presenta ante las autoridades aduaneras, que además proporciona información sobre el producto y sirve de base para la correspondiente declaración tributaria, del mismo modo automatizar el almacenaje del DUA correspondiente a la Orden de compra en el centro de documentación de la empresa. El tiempo de entrega del proyecto será de 4 días, a partir de cuando se inicia a trabajarlo.

Cassandra DBA - Ideal Skills and Experience: - Strong expertise in managing Cassandra databases - Extensive experience with version 3.x of Cassandra - Proficient in database management tasks and best practices - Familiarity with performance tuning techniques for Cassandra - Knowledge of migration processes for Cassandra databases - Project Requirements: - Assistance with database management for Cassandra - Ensure smooth operation and optimal performance of the Cassandra database - Implement best practices for data management and maintenance - Address any issues or challenges encountered during database operations - Ongoing Support: - The client is not sure yet about the need for ongoing support - Further discussions and agreements can be made regarding ongoing supp...

Power bi coder for multiple jobs.

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.