Адміністрування баз даних Jobs
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.
На підставі 194,049 відгуків клієнтів, рейтинг Database Administrators становить 4.88 із 5 зірочок.Найняти Database Administrators
I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help
I am in need of a skilled professional to develop software. We have all barcodes in EAN formats in excel (14-15 digits format) Everyday we sell products online. We would like to be able to find a certain barcode on a shelf as we have many EANS on the same shelf. We have bought a wireless handheld scanner. So we would like to be able to transfer those eans (EAN ) to use this wireless scanner to find a certain product on shelf. Or maybe not transfer but to export some batch of eans everyday in order to find them faster everyday ob the shelf.
Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering of info...
I require a Linux WHM expert to assist with a critical data recovery issue. Specifically. Suddenly our mysql stop working. We had a dump of data but we need to solve the mysql issue or reinstall it (we can provide WHM and root access), and upload the data dump. Key Responsibilities: - Troubleshoot and resolve the MySQL data recovery issue. - Ensure the retrieved data is accurate and complete. We would like to know why this happends, to avoid it happends in future, by checking server logs. Ideal Skills and Experience: - Extensive experience with Linux WHM. - Proven track record in MySQL data recovery. - Understanding of data security and privacy best practices. - Prompt and effective communicator.
I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server maintenance would be required. I am only looking for professionals who h...
My business, is in dire need of someone adept at simultaneous Mac and Microsoft system organization. Our setup and files are in disarray, and we’re longing for structure and order. Key tasks include: - Rectifying difficulty in locating files on our Mac systems - Troubleshooting software installation problems on the Macs - Solving networking problems with our Microsoft systems The ideal person for the job will have extensive experience with both Mac and Microsoft systems, with a particular focus on file management, software installation, and networking. A knack for problem-solving and a methodical approach to system organization are highly coveted. A solid understanding of business operations and third-party software would also be advantageous. This will be done in-office, SO MUST...
Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.
I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?
I need an adept Teams Administrator to set up and manage Powerbi report access and Share OneDrive accounts for the upper echelons of my company. The desired individual should ideally have experience handling Teams Administration for medium-sized groups (10-50). Details: • Allocate Powerbi report access: The task involves granting read-only access to Powerbi Reports for the Executive and Management teams in my organization. • Share OneDrive accounts: You will also need to set up Share OneDrive accounts specifically for these segments. Ideal Candidate: • The ideal candidate will have proven experience in Teams Administration. • Proficiency in managing and configuring Powerbi and OneDrive • Experience working with medium-sized teams of 10-50 peop...
I'm in need of an experienced SQL professional to assist me with data warehouse. The ideal candidate is someone who has: - Proven experience in designing data warehouses - Advanced SQL skills - Excellent understanding of data volumes and the implications for data warehousing If you are interested in this project, please provide details of your experience in similar projects. Thank you.
I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.
I am in need of an expert SharePoint consultant who can assist me in setting up a three-tier SharePoint 2019 server. I am migrating from a previous version and require professional guidance in choosing the best server configuration for my needs. Primary tasks include: - Set up a three-tier SharePoint 2019 server - Assist in migrating my current data - Optimise the server for document management Ideal Skills: - Expertise in SharePoint 2019 - Experience in server setup and data migration - Knowledge in document management systems - Excellent communication and consultancy skills Your responsibility would be to guide me throughout the process, ensuring a smooth transition while minimising data loss. Your expert advice will also aid me in optimising the new server for document management pur...
I'm looking for support with a typed data entry project that involves organizing the data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Experience: - Proficient in Da...
I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.
I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.
I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.
I am seeking an expert in SQL Server replication. The project involves replicating our business data to facilitate efficient data distribution. The replication has been set up. The snapshot working but Data not delivering to the subscriber. Log reader fails after 10 mins - Key Expertise Required: - Proficient with SQL Server - Extensive experience with data replication - Profound understanding of business data - Knowledge in data distribution strategies
Estoy construyendo informes en power BI, busco quien en sesiones en línea me guie en ir construyendo lo que entrego trabajo para desarrollar, debo hacerlo yo con la guía de un experto en power BI para entender bien las conexiones y poder editar el reporte. Debe tener paciencia y saber explicar.
I have a small FileMaker Pro 12 database that requires a conversion to an SQL-based database. The structure is to largely remain the same, but there are some minor issues that need rectification. Details: - The conversion task requires no major changes to the original data structure. - However, some calculation errors need fixing. Therefore, you'll need a keen eye for identifying and rectifying them. Skills & Experience Required: - Experience with FileMaker Pro 12 and SQL databases. - Understanding of database structures and functionalities. - Ability to identify and correct calculation errors. - Great attention to detail. Please ensure that during the conversion process, no data is lost, and the end product works seamlessly. The bid proposal should reflect your understandi...
I'm with a newly founded IT partnership company and we're in search of a skilled professional with expertise in data warehousing in Oil and Gas sector. We are going to use MongoDB. Key Requirements: - Data Integration: We need someone who can seamlessly blend data from various sources, ensuring accuracy and consistency. - Data Modeling: The ideal candidate should have a deep understanding of how to organize data in a way that supports business needs and decision-making. - ETL Processes: The selected freelancer will be responsible for the extraction, transformation, and loading of data into our warehouse. We are working with a medium-sized dataset (1-10 terabytes), so we need someone who is not only experienced in data warehousing but also with datasets of this size. Ideal Sk...
I am currently looking for an MS SQL trainer to help with physical training in chennai. - Expertise: While the selected trainer needs to have intermediate level skills in MS SQL, having advanced skills could be a bonus. However, the ability to explain complicated topics in a simplified manner is paramount. - Topics: Though a choice was not specifically provided, your comfort with a range of MS SQL subjects will be beneficial. From database administration, querying data to data integration, any and all skills are welcome. - Time frame: This is an immediate requirement. Hence, applicants who are available to start at the earliest will be preferred. Ideal candidates should have considerable experience in training others, a strong grasp of MS SQL, and the flexibility to start ASAP. Your abil...
I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.
I’m searching for a skilled developer to create a Scheduling Manager with specific features. My ideal candidate would have relevant experience in software development, specifically in scheduling and user profile management, along with a strong understanding of different form of notifications. Key Deliverables: • User Profiles: You will need to design user profiles including fields for name, email, and phone number. It should be user-friendly and easy to navigate. • Multi-Source Reminder System: The software must be capable of sending reminders through different platforms including email, SMS, and push notifications. Knowledge in setting up these systems is a must. Please include examples of similar projects in your proposal, especially if they involve scheduling or noti...
I need someone to help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categorize and label data as per our requirements. - Maintain data confidentiality and security. Ideal skills and experience for this job: - Proficiency in data entry. - Prior experience with database entry preferred. - Meticulous attention to detail. - Ability to work efficiently and maintain accuracy. - Understanding of data security and confidentiality measures.
I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should understand how to navigate...
I need someone to help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categorize and label data as per our requirements. - Maintain data confidentiality and security. Ideal skills and experience for this job: - Proficiency in data entry. - Prior experience with database entry preferred. - Meticulous attention to detail. - Ability to work efficiently and maintain accuracy. - Understanding of data security and confidentiality measures.
We have around 5 contact lists (approximately 1,000 contacts each list) that I need to be verified for accuracy. These contact lists include Email contacts, Phone contacts, Mailing addresses, Business Names, Best contact name, and Business Types. I need someone to go through the lists and ensure that the information provided is still correct and up to date. We use Go High Level (GHL) to manage contacts. You can use Excel or other software to manage the task. Key Responsibilities: - Cross-checking all Email contacts, Phone contacts, and Mailing addresses to confirm their validity - Verifying the Business Names, Best contact name, and Business Types for each entry - Removing any duplicate entries and outdated information - Providing a comprehensive report with the findings of the verifica...
I'm looking for a skilled data engineer to help me with the OMOP ETL process. Your main responsibilities will be: - Extracting and transforming data: You'll be working with me to extract data from a data warehouse and transform it into the OMOP CDM. - Loading data into a database: After transforming the data, it will need to be loaded into a PostgreSQL database. Experience with ETL processes and PostgreSQL is critical. You should also be familiar with data validation checks, as we need basic data type and range checks applied during this project. You must have experience loading data into the OMOP CDM.
requerimos de un sistema web para un colegio, con las siguientes funcionalidades: registrar o matricular estudiantes, docentes, materias, cursos permitir registrar estudiantes, docentes desde una lista de excel registro de pagos de mensualidades registrar asistencia e incidencias de estudiantes(al momento de registrar pueda enviar un mensaje via whatsapp al numero del padre de familia) Registro de notas por materias(4 a 5 actividades, que ademas se puedan añadir mas si fuera necesario) reportes de morosidad El registro de notas puede ser directo en el sistema o cargarse desde un excel generado por el mismo sistema. reporte de estadisticas de estudiantes por niveles y cursos Boletin de notas trimestral y anual reporte centralizador de notas con todas sus materias reporte de mejores ...
I am experiencing issues with my Microsoft Access database after moving the database file. After reconnecting the queries to the database, all but one tab of file updated okay. One tab is returning errors. The database is accessed through a desktop application. Key Requirements: - Resolve query errors in the database - Ensure the database functions properly within the desktop application - Investigate and fix any potential issues caused by moving the root file The ideal freelancer for this project should have: - Strong expertise in Microsoft Access - Proficiency in database management and query optimization - Experience in troubleshooting database errors - Ability to work with desktop applications Please include in your bid any relevant experience and your approach to troubleshooting...
I'm in need of a skilled Oracle consultant to provide ongoing maintenance and troubleshooting for our Oracle Payables, Oracle Receivables, Oracle General Ledger and Purchasing modules. Key Requirements: - Proficient in Oracle E-Business Suite R12 - Extensive experience with Oracle Payables, Receivables, General Ledger and Purchasing modules - Proven track record of providing ongoing maintenance and troubleshooting support Ideal Skills: - Oracle E-Business Suite R12 - Oracle Payables, Oracle Receivables, Oracle General Ledger, Purchasing modules - Troubleshooting and maintenance experience - Strong problem-solving skills
I have text data stored in a MySQL database that needs to be cleaned and formatted in Excel. Key Tasks: - Identify and correct errors in the data - Eliminate irrelevant information - Standardize data for consistency - Ensure data integrity and quality Key Skills: - Proficiency in MySQL database management - Strong experience in data cleaning and manipulation - Expertise in Excel for data formatting - Attention to detail for identifying anomalies and inconsistencies - Ability to ensure data quality and integrity We need a freelancer with a keen eye for detail and strong data management skills to take on this task. A background in data science or analysis would be highly beneficial. Please include examples of similar projects you have completed in your application.
I'm looking for a skilled professional to install and configure Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c on a Windows Server 2022. The primary purpose of this installation is managing databases, so the main focus should be on optimal database functionality. Key Tasks: - Installation of Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c - Configuring Oracle DB with a high availability setup and performance tuning - Setting Windows environment variables for Java files - Copying 3 applications and 3 URLs from another server running Windows Server 2012 Ideal Skills and Experience: - Proven experience with Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c - Strong background in managing databases, parti...
I am seeking an experienced database engineer who specializes in PostgreSQL. The migration from GCP to AWS has just been completed. I require an audit to validate the following aspects of the migration: - Data Integrity: Ensure all data was successfully migrated without loss or corruption. - Application Functionality: Verify the migrated database integrates seamlessly with the existing application. - Performance: Monitor the post-migration database performance, identifying and resolving any slow-down or instability. Ideal candidates should have in-depth experience with PostgreSQL 11 & 12, GCP, AWS, and migration projects. Proven skills in data integrity and performance testing are essential for this job. If you are an expert in resolving application functionality issues post-migratio...
I need a freelancer who can assist me with moving data from Excel to an Oracle database. Responsibilities: - Copy data accurately from Excel to the database - Ensure all data is consistent and properly formatted Ideal Skills and Experience: - Proficiency in Excel - Experience with Oracle databases - Detail-oriented - Proven track record handling data migration tasks
I'm currently working on a mini project that requires an SQL specialist to conduct descriptive analysis on our customer data. Your task will entail: - Understanding and interpreting the data set provided. - Writing SQL code that analyzes essential aspects of the data. - Providing valuable insights regarding customer behavior and trends. Ideal candidate would possess: - Proven experience in SQL and data analysis. - Ability to break down complex data into understandable format. - Strong knowledge in managing and analyzing customer data. Your input will guide our strategies moving forward and help improve our customer relations. Looking forward to working with someone who is detail-oriented, analytical, and able to meet tight deadlines.
I am currently using MySQL as my database management system which holds a small-sized database. I require an experienced and skilled freelancer to migrate this database to my new EC2 WordPress installation. Ideal Skills and Experience: - Expertise in MySQL and AWS EC2 - Proficiency in handling WordPress installations - Experience in migrating small-sized databases Please note that a backup of the current database is available and must be effectively utilized to perform this project. Expectations include high-quality work with no loss of database data and minimal interruption in service.
I'm in need of a skilled professional who can create a robust ticketing system in MS Access. This system should be designed keeping in mind the following requirements: - Ticket Creation and Management: The system should allow for the easy creation and management of tickets. - User Authentication and Access Control: It should include user authentication to ensure data security and access control to restrict certain functionalities based on user roles. - Reporting and Analytics: The system should be able to generate various reports and provide analytics for tracking and performance evaluation. This system will be used by a single user, hence the emphasis on simplicity and usability in the user interface. I would like the interface to be both modern and visually appealing, while also ...
I'm looking for an AWS Glue expert to handle my large MySQL database, over 10GB, and write it to S3. You will need to have: - A strong understanding and experience in handling large databases. - Proficiency in using AWS Glue for data ETL processes. - Knowledge in determining the best strategy to quickly load large amounts of data. - Experience working with Parquet output format. The database gets updated daily, so a fast and efficient process is required to ensure optimal performance. Please detail your experience with similar projects when making your bid.
I have an urgent requirement to create a DDL script and an ERD diagram for a large socio-economic dataset. The data is available in a Excel/CSV format, and I'll be able to provide the dataset to you. The ideal candidate should be able to: - Understand and analyze the given socio-economic data - Create a DDL script based on the data - Develop an ERD diagram to visually represent the data model - Deliver the work by tomorrow, without fail This is a time-sensitive project, so only bid if you're confident that you can complete this task on time. Your understanding of socio-economic data is crucial for this task.
I require assistance with Appian's Certified Lead Developer certification, specifically with sections related to Data Management, Process Modeling, and User Interface Design. Key Responsibilities: - Provide study material and conduct sessions to clarify confusions. - Guide me through data management, process modeling, and User Interface Design components of the certification. Ideal Candidate: - Experience with similar certification examinations. - Good communication skills and a knack for simplifying complex topics. Please detail your experience dealing with similar certification exams in your proposal.
General Project Requirements We are looking for software development engineer to develop user interface of a desktop software. This requirement can be turned into a long term basis for various application development if the work of the freelancer is good. We are looking for professional, sincere and dedicated team player who is willing to contribute to larger goals. Domain expertise: Unmanned Ariel Vehicle/ Drones Technical Expertise: Qt, C++, C, SQL Database Skills •A team player with willingness to contribute to larger goals •Eager to learn, research and improvise – problem solver •Want to invent and build to make things better, faster, easier and cost effective. •Effectively articulate technical challenges and solutions •Project Management •Produc...
I require a data expert to design and implement a comprehensive database system for my hospital. The project will include: - Patient Database: A system to manage patient registration, track medical history, and schedule appointments. - Medical Records Database: This should integrate with lab results, allow attachment of files such as test reports, and provide a robust search functionality. - Inventory Database: Tracking of medical supplies, equipment, and medicine inventory. The ideal freelancer should have a strong background in database design, preferably within healthcare environments. Knowledge in data privacy regulations in healthcare is essential. Exceptional attention to detail and a problem-solving mindset are also required.
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.