Database Administration is a professional service that allows organizations to create, maintain and secure their data architecture from the most basic structure to the most complex. Database Administrators (DBAs) typically have vast technical knowledge and specialize in installing and configuring database management systems, configuring access controls for secure data, improvement of data architecture and monitoring system health. A great Database Administrator can be an invaluable asset by helping clients increase efficiency and reduce redundancies in their databases.
Here's some projects that our expert Database Administrator made real:
- Constructing highly secure IT infrastructures - tailored systems that help boost overall security.
- Ensuring safe data transfers between different systems, such as from a previous cPanel installation.
- Building, maintaining and improving database systems for businesses ranging from websites to lead generation services.
- Efficient query tuning for SQL or MongoDB databases for businesses seeking optimized performance.
- Creation of database structures and processes catered to the needs of any business, such as an HACCP database.
- Deployment of various database structures, such as Azure websites with ABP framework support.
- Installation of SQL database solutions on Macbooks, maximizing performance with the help of a skilled professional.
Our Database Administrators are highly skilled professionals whose expertise can help any organization establish and maintain an effective database infrastructure that meets the requirements of their business. Freelancer.com is a great platform to hire a Database Administrator; you can find qualified professionals who can complete all types of database related tasks quickly and cost-effectively whatever your size or budget may be. Post your project now to take advantage of our amazing pool of talent, or browse existing projects on our platform if you are interested in learning more about what it’s like working with our professionals.Da 190,206 valutazioni, i clienti danno una valutazione ai nostri Database Administrators di 4.86 stelle su 5
Assumi Database Administrators
I am looking for an Advanced Postgress SQL Developer to work for 15 days on a man hour basis. Tasks: - The developer will be responsible for Database Design, Development work, ensuring efficient and effective data storage and retrieval. Communication: - The preferred mode of communication with the developer is through Email, direct messaging, whatsapp allowing for clear and documented communication throughout the project. Ideal Skills and Experience: - Advanced expertise in Postgress SQL - Strong experience in Database Design
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...
I am looking for a freelancer to provide support for my Odoo ERP system. Specific Areas of Support Needed: - Sales - Inventory - Accounting Goals and Outcomes: - I have specific goals in mind that I would like to achieve with the support of the freelancer. Preferred Mode of Communication: - Email Ideal Skills and Experience: - Strong knowledge and experience in Odoo ERP system - Expertise in sales, inventory, and accounting modules - Ability to understand and execute specific goals - Excellent communication skills via email.
I am looking for a freelancer to create a contact database specifically for business contacts in a specific industry or demographic. The database should be organized by role within the organization and relevant distribution lists. Ideal skills and experience for this job include: - Strong understanding of database management - Proficiency in organizing data by role and distribution lists
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 Title: MySql database recovery UPDATE: I've uploaded some sample files with both IBN and FRM files so you can have a look. And separately the entire data directory. Project Description: I need help to recover my MySql database ASAP. My hoster's server crashed and I managed to recover only the data directory with all the ibn and frm files. Nothing else. No log files at all. It might be useful to know that I tried to recover the DB using the mysqlfrm utility which throw out a character utf8 related error. I also tried to recover using Stellar Repair for MYSQL but without the log files there's no way the app can restore the DB. Current State of the Database: - The database has crashed and needs to be restored. Data Backup: - I have the full data directory with the...
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 have some frm and ibd files on my computer for a MYSQL database. I need to make a SQL file of certain tables or the whole database - and i need help with it it must be done via anydesk or help me via chat as i cannot give u the database files
Rebuild SharePoint SQL Connection After Active Directory Failure Project Overview: We are in need of a skilled professional who can help us rebuild the SQL connection for our SharePoint 2010 system after an active directory failure. Requirements: - Expertise in SharePoint 2010 and SQL connection troubleshooting - Familiarity with Active Directory integration in SharePoint - Ability to work with limited access to Active Directory data (no backup available) - Strong problem-solving skills to identify and resolve the issue - Experience with full administrative access to SharePoint server - Excellent communication skills to effectively collaborate with our team Deliverables: - Identify the cause of the SQL connection failure in SharePoint 2010 - Develop and implement a solution to rebuild ...
Note: This is a short deadline project. Only experts who can finish in 1 day respond. Others plz ignore I am looking for a skilled SQL developer who can create complex SQL queries to generate reports and dashboards on Databox. Database: SQL Server Report Format and Data Points: - I have specific requirements for the report format and the data points that need to be included. Deadline: - The deadline for this project is 1 day. Skills and Experience: - Strong SQL skills and experience in creating complex queries - Knowledge of Databox and its reporting capabilities - Ability to understand and interpret specific report requirements - Attention to detail to ensure accurate and reliable reports - Ability to work quickly and efficiently to meet the tight deadline
O365 developer with Migration Experience As an Office 365 Migration Engineer, you will be using cutting edge technologies to streamline services to our clients. Join our team of Data and Cloud professionals and accomplish what others only dream of. Ability to obtain a Q Clearance. This is a remote position. • Experience with Data Loss Prevention (DLP) and Azure Information Protection (AIP). • Experience with Office 365 Modern Workplace migrations and implementation • Ability to perform health checks and assessments of on-premises systems prior to migrations • Collaborate with members of the development team and project managers to deliver solutions that surpass client expectations • Implement AIS cloud infrastructure solution offerings based on public cloud, ...
I am in need of a bilingual English/Spanish Real Estate Transaction Coordinator & Admin Assistant to help with transaction coordination tasks. The ideal candidate must be fluent in both languages as it is a must for this role. I expect the assistant to work approximately 10-20 hours per week. Tasks include: - Document preparation - Client communication - Coordinating real estate transactions Skills and experience required: - Fluent in both English and Spanish - Strong organizational and communication skills - Knowledge of real estate transactions and processes - Attention to detail and ability to multitask - Proficient in Microsoft Office and other relevant software If you meet these requirements and are available to work the specified hours, please apply with your relevant experie...
I am looking for a skilled freelancer to create an order confirmation template in Excel with several dropdown menus. The template should include the following information: - Customer name - Customer address - approx 7 different products - Order details - delivery details - Payment information The complexity level of the dropdown menus needed is advanced. The order confirmation template should be delivered in Excel file format. Ideal skills and experience for this project include: - Advanced proficiency in Excel - Experience in creating complex dropdown menus - Attention to detail to ensure accurate inclusion of customer information and order details
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 seeking an AI/ML solution engineer to design the best solution for automating data analysis. The project involves collecting data as there is currently no existing data available. The preferred method for data collection is through Chat GPT. Ideal Skills and Experience: - Strong background in AI/ML - Proficiency in designing and implementing data analysis solutions - Experience in data collection through Chat GPT - Ability to work independently and deliver high-quality results
I can only access phpMyadmin through WHM when I have the following in my /etc/ file - [mysqld] skip-grant-tables But then I am not able to retrieve the data from mysql table in my webpages. However when I remove skip-grant-tables from , I an able to view the data in my webpages but phpMyAdmin stops working. I get the message - mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES) I am using AlmaLinux 8
I am looking for a Stimulsoft expert to help me with designing reports. Skills and experience needed: - Proficient in using Stimulsoft for designing reports - Knowledge of data visualization techniques and best practices - Ability to create visually appealing and user-friendly reports The client does not have a preferred data visualization style or format, so the expert will have the freedom to suggest and implement the most suitable style for the project. The client does not have a strict deadline for the completion of the task, providing flexibility for the expert to work at their own pace.
Cybersmith is looking to form a team of freelance professionals to collaborate on a series of upcoming projects involving Microsoft 365 products, with a primary focus on security and compliance solutions. These projects encompass various tasks and may involve competing priorities. Project Overview: Cybersmith is seeking experienced freelancers proficient in the Microsoft suite of developer technologies, including Power Pages, Power Apps, Flow, and Dataverse, to collaborate on creating innovative solutions. Projects will primarily center around Microsoft Power Pages and will leverage a combination of Microsoft Dynamics, Power Apps, and API capabilities. Key Responsibilities: Contribute to the design of solutions from the information provided in discovery and design workshops to architect ...
Engaged in DVB-C TV system operations, utilizing the Gospell-CAS management system for the administration of diverse TV channels and other functionalities within the software. Seeking an individual with expertise and experience in working for TV solution companies employing similar technology.
I am looking for someone to help me with the installation and usage of MySQL and PHP on my Linux operating system. I am currently experiencing an issue with the installation where I am getting the error message "Malformed line 2 in source list /etc/apt/ (type) E: The list of sources could not be read." Skills and Experience: -Use of Webmin to use linux in terminal - Strong knowledge and experience with Linux operating system - Expertise in installing and configuring MySQL and PHP - Ability to troubleshoot and resolve installation issues - Proficiency in creating and managing SQL tables - Experience with PHP programming for web development - Familiarity with completing projects for academic purposes The ultimate goal of my project is to complete a project for a class, which req...
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
Project Description: I am looking for a skilled MySQL and CodeIgniter developer who can help me fix a slow query in my CodeIgniter application. The current query that is running slow is a SELECT query. Preferred Method for Optimizing the Query: - I prefer server tuning as the method for optimizing the query. Expected Speed of the Query After Optimization: - I expect the query to run within 1-3 seconds after optimization. Skills and Experience Needed: - Strong proficiency in MySQL and CodeIgniter - Experience in optimizing and tuning slow queries - Knowledge of server tuning techniques - Ability to analyze and optimize database performance - Excellent problem-solving skills in identifying and resolving query performance issues
I need to develop a software can check the correct closing line odds of the bookmaker. The online sports gambling industry employs teams of data analysts to build forecast models that turn the odds at sports games in their favour. While several betting strategies have been proposed to beat bookmakers, from expert prediction models and arbitrage strategies to odds bias exploitation, their returns have been inconsistent and it remains to be shown that a betting strategy can outperform the online sports betting market. We designed a strategy to beat football bookmakers with their own numbers. What I need its have a software can detetect the correct odds and here I attach the info to make this project:
I am looking for a skilled professional who can assist with resolving an issue with my vCenter server which has crashed. You need to be in Dallas, Tx area and available now! You will have to be onsite in Irving. Skills and Experience: - Strong knowledge and experience with VMware vCenter Server - Expertise in troubleshooting and resolving server crashes - Proficient in database management and recovery - Familiarity with backup systems and their maintenance - Ability to assess the current state of the backup system and make necessary updates - Experience with vCenter versions, particularly version 7.0 If you have the required skills and experience, please reach out to discuss further details and provide a quote for this project. Thank you.
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 virtual assistant who can help me with setting up and managing my CRM system in odoo. The specific tasks that I need assistance with are data entry and organization. Here are the details of the project: Tasks: - Aiding in the set up of a multi company system within Odoo - Data entry and organization in the CRM system - Ensuring all customer information is accurate and up to date - Organizing and categorizing customer data for easy access and retrieval Training: - I prefer to provide written instructions for training the virtual assistant on these tasks but occasional phone or video conferences will be necessary. - Clear and detailed instructions will be provided to ensure a smooth transition Time commitment: - I anticipate needing assistance for less than 5 hours per...
Project Description: I am looking for a freelancer to deploy Supabase on the Azure hosting platform. Hosting Platform: - Azure Database Migration: - No existing database needs to be migrated to Supabase User Authentication and Security: - Basic level of user authentication and security is required Ideal Skills and Experience: - Experience with deploying Supabase on Azure - Knowledge of user authentication and security protocols - Familiarity with Azure hosting platform
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
Database fed by c.50 excel-based models. Database to aggregate data, and summarise a range of outputs
I am looking for a freelancer to help me estimate the process of moving 5 Navision accounting books to the cloud. The current version of Navision accounting software being used is Navision 2018. The accounting books are currently stored on a local server. I am looking to migrate to Navision cloud for the cloud service provider. Skills and Experience: - Experience with Navision 2018 - Proficiency in cloud migration and Navision cloud - Knowledge of Microsoft Azure for the migration process - Strong understanding of accounting systems and data migration
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.