Database Administration 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.
From 186,596 reviews, clients rate our Database Administrators 4.86 out of 5 stars.Hire Database Administrators
¿QUÉ BUSCAMOS? Muy fácil, actualmente estamos buscando 1 DBA de Oracle, para formar parte de un proyecto en uno de nuestros mejores clientes (empresa del sector de las telecomunicaciones). El proyecto tiene una duración estimada de 5-6 meses con posibilidades de alargarse. A continuación detallamos los conocimientos y experiencia que deseamos que tenga: - Experiencia de al menos 3 años como Administrador de BD Oracle en entornos de producción 24x7 sobre sistemas unix/linux, preferiblemente en versión 19c o como mínimo en 12c. - Conocimientos de backup&recovery con RMAN y de OEM. - Valorable: .- optimización de SQL .- Conocimiento de Shell scripts .- Conocimientos en Dataguard, RAC, ASM y particionamiento .- Shell s...
I am in need of an SQL performance and optimization expert to address high CPU usage in my SQL Server database, which is of large size (more than 10GB). Skills and experience required: - Strong expertise in SQL performance tuning and optimization techniques - Proficiency in working with SQL Server databases - In-depth knowledge of query execution plans and indexing strategies - Experience in analyzing and resolving high CPU usage issues in large databases -Trace deadlocks, root cause and implement solutions to stop them Responsibilities: - Identify and analyze the root cause of the high CPU/Memory usage problem - Optimize SQL queries and database structures to improve performance - Implement indexing strategies and query optimization techniques - Monitor and fine-tune the database for o...
SQL Training for 4-5 Students I am looking for a trainer who can provide SQL training to a group of 5 students. The students have beginner-level experience in SQL. Main Focus of Training: Understand DB Function, Administration - The main focus of the training should be on understanding DB Functions, Administration, and analysis in SQL. Training Session Duration: 30 Hrs to 42 Hrs. - Each training session should be 1-2 hours long. - Strong knowledge and experience in SQL - Ability to effectively teach and explain complex SQL concepts to beginners - Experience in Data Base Administration and analysis using SQL - Excellent communication and presentation skills.
I need someone to link a database 1 hour of works
I have by mistake deleted a foreign key from my mysql table. i want u to help me create it using anydesk.
I am in need of a real PHP MySQL expert who can assist me in setting up a query to replicate my database tables. The project requires the following: Size of the database: Small (under 1GB) - The expert should be experienced in handling small-sized databases efficiently. Type of data in the database: Business Data - The ideal candidate should have prior experience working with business-related data. Preferred method of replication: Master-Slave - The expert should have a strong understanding of Master-Slave replication and be able to set it up effectively. Skills and experience required: - Strong expertise in PHP and MySQL - Experience with replicating small-sized databases - Knowledge of handling business data in a database - Proficiency in setting up Master-Slave replication If you a...
Compile a database of travel companies from Cairo and Alexandria. You need to work through the information and find a list of 50 companies from Cairo and Alexandria. Companies must engage in outbound tourism from Egypt. That is, not companies that deal with tours to seaside resorts in Egypt, but companies that sell tours for Egyptians abroad. You can write to companies that deal with sightseeing tours, companies that deal with business and educational tourism. You need to create a table in Excel: Company name, website, mail, phone, address
Hello Everyone, we are looking for a trainer who can deliver training on Oracle Time and Labor(OTL) Training: Oracle Time and Labor(OTL) Mode : Online Pax : 15 TOC : Available
I am looking for a relatively simple database to track attendance for around 300 employees. The data entry point must only accommodate a few users, and be able to calculate points and occurrences based off of the entered data. This database will need to provide reports and allow us to export it to a prebuilt forum. We specifically want our database to be of the SQL variety, as opposed to NoSQL or some other format. Furthermore, we do not need this database to be accessible online - it can be locally hosted. The primary reports that we need this database to generate are attendance reports. We would like it to be able to generate performance reports and custom reports, but attendance reports are our main focus. The ability to export the data to a spreadsheets or some other forum is a prior...
I am looking for a freelancer to develop an automatic attendance system using face recognition technology. The purpose of this system is to monitor student attendance. Key requirements for this project include: - Integration with an access control feature to restrict unauthorized access - The system should be able to handle a maximum of up to 100 users
Looking for someone who knows how to design a Database schema and can help with me refining the same. We are a startup and i am the CTO. I created DB tables (mostly around 2 years ago); i am in the process of making sure that these adhere to the best practices of Database schema design. I need someone to answer my questions on why one design is better than the other. And if there is any alternate (and better) way to get the same results. I expect the call to take not more than 10-15 mins. I will pay for each call as if it is for 30 mins.
Data Warehousing Architect with experience in Hybrid solutions, specifically using Amazon Web Services and Microsoft SQL Server. The project requires the architect to design and implement a data warehousing solution that combines both on-premise and cloud-based infrastructure. Ideal Skills and Experience: - Strong knowledge and experience in data warehousing architecture and design - Expertise in implementing Hybrid data warehousing solutions - Proficiency in using Amazon Web Services (AWS) for cloud-based infrastructure - Strong knowledge and experience in MSSQL Server, data warehousing architecture and design - Familiarity with on-premise data storage technologies - Ability to analyze and understand data volume requirements - Experience in designing and optimizing data storage for volu...
Hello Everyone !! We are looking for a trainer who can deliver training on ADABAD Admin ... Training : ADABAS Mode : Online Pax : 15 Training duration: 4hrs/day Date : Asap Need : Trainer + courseware+ labs. Budget -Open
I am looking for a skilled developer to integrate Shiprocket into my MERN project. The project requires the integration of specific functionalities, including inventory management, order tracking, shipping rates, and labels. I have a preferred timeline of completing the integration within 2 week. Ideal skills and experience for this job include: - Proficiency in MERN stack development - Experience with integrating third-party APIs - Knowledge of inventory management and order tracking systems - Familiarity with shipping and logistics processes.
The project needs a PostgreSQL Admin who can help with the migrating an existing database to another database. The database in currently hosted on AWS. The current RDS instance hosts 3 databases (Dev, test & PROD). The requirement is to divide the databases into 2 separate RDS instances (PROD in one and DEV and TEST in another). More details: What is the current database size? Large (more than 10GB) Do you require data cleansing during the migration process? No Are there any specific configurations or customizations needed after migration? Yes
BUENAS TENGO UN REPORTE QUE ESTA FUNCIONANDO, PERO NECESITO AGREGAR UNA TABLA ADICIONAL QUE CUANDO LO REALIZO ME DUPLICA LOS REGISTROS. EL REPORTE INICIA ASI: --REPORTE DE VENTAS DECLARE @FECHA_I DATETIME = '2019-12-02'; --:FECHA_INICIO DECLARE @FECHA_F DATETIME = '2019-12-02'; --:FECHA_FIN DECLARE @FECHA_INICIO VARCHAR(10) DECLARE @FECHA_FIN VARCHAR(10) SET @FECHA_INICIO = CONVERT(VARCHAR(10), @FECHA_I, 105) SET @FECHA_FIN = CONVERT(VARCHAR(10), @FECHA_F, 105) SELECT DENSE_RANK() OVER (PARTITION BY , , FV.N ORDER BY FECHA_ASIGNADA) AS DIA, TABLA.Z, , TABLA.[RAZON SOCIAL], ... Y CONTINUA...
run two or more mysql queries inside transaction in goland
Title: MySQL Database Schema Creation - Existing Data Integration - Urgent I am in need of a skilled freelancer who can assist me in creating a database schema for a MySQL database. The ideal candidate should possess the following skills and experience: - Proficient in creating database schemas for MySQL - Familiarity with database design principles and best practices - Experience in integrating existing data into a new schema - Ability to efficiently transfer and map data from the current database to the new schema - Strong attention to detail to ensure data integrity and accuracy Key Requirements: 1. Database Schema Creation: The freelancer should be able to design and create a well-structured and efficient database schema for a MySQL database. 2. Integration of Existing Data: The f...
I am looking for someone who can teach me about all the functions and capabilities of Snowflake software. I am a beginner and I want to learn everything about it, including what it can do and how to use it. Preferred Method of Learning: - Video tutorials Specific Areas of Interest: - Data Warehousing - Data Engineering - Data Science Ideal Skills and Experience: - Extensive knowledge and experience with Snowflake software - Ability to explain complex concepts in a clear and concise manner - Experience creating video tutorials or teaching materials - Strong understanding of data warehousing, data engineering, and data science concepts
Project Description: Objective: Implement MySQL replication for data synchronization between 1-3 databases using Master-Slave replication method. Skills and Experience: - Expertise in MySQL database management and administration - Proficient in configuring and setting up MySQL replication - Strong understanding of Master-Slave replication method - Ability to troubleshoot and resolve replication issues - Knowledge of backup and recovery strategies for MySQL databases - Familiarity with database scaling and load balancing techniques
A database of a Saudi supermarket with pictures to upload to my store
I am looking for an ER Diagram expert who can assist me with creating a Physical ER Diagram for my project. The level of complexity for the diagram is basic, and it involves 5-10 entities and relationships. Skills and Experience: - Proficient in creating Physical ER Diagrams - Strong understanding of database design and entity relationship modeling - Experience working with 5-10 entities and relationships in ER diagrams - Ability to translate complex business requirements into clear and concise diagrams - Attention to detail and ability to ensure the accuracy and integrity of the diagram - Knowledge of database management systems and SQL is a plus
I am looking for an experienced professional who can develop an email database for my business. The email database should be tailored to the healthcare industry and should cover a national geographic region. I am specifically looking for a B2B (business to business) database, and not B2C (business to consumer) or a combination of both. The contractor should be able to provide a reliable and comprehensive database that meets all of my requirements. It should have relevant and up-to-date contact information, as well as any other pertinent data. Additionally, privacy and security are two of the top priorities for this project. All data must adhere to the applicable laws and regulations and remain confidential. If you have the experience and skills needed to produce an effective email datab...
We have a old Moodle. We want to install a fresh and clean Moodle and import all Data from the Old Moodle.
I am looking for a freelancer who can help me set up Dataverse for my tax business. The purpose of setting up Dataverse is for data storage, data analysis and reporting, and for interaction with other Microsoft apps. I have existing data that needs to be migrated into Dataverse, with the expected volume of data being significantly less than 1 TB. Ideal skills and experience for this job include: - Strong knowledge and experience in setting up and configuring Dataverse - Familiarity with data migration processes and tools - Expertise in data analysis and reporting - Ability to handle and manage data volumes of less than 1 TB I need recommendations on whether to use existing tables or to set up custom tables. Advice on how to separate data into tables would be welcome. The project will be...
I am looking for a skilled MySQL developer to create a new MySQL view for reporting purposes. The view will be used for data analysis and visualization. I have all the details regarding the specific tables and columns that should be included in the view. The ideal candidate should have experience in: - MySQL development - Creating views for reporting and data analysis - Data visualization techniques If you have the required skills and experience, please submit your proposal, see the attached doc for more details PLEASE: dont low bid only for get the interview, make your accurate bid for the quotation, warm regards
I am looking for someone to help me build the perfect database for me and my projects. I have a vision of how the database should look, but I need to find someone to take the ideas and make them into reality. The database I prefer to use is a Relational one and I have some ideas and thoughts on the interface design but could use some help in narrowing down what would be realistic to expect. My budget for this project is within the range of $500 to $1000 but I'm flexible. As far as an editable intrface - my best description is something like tiles or something i can put a picture on with a description to be a button to open that [project] page that has info on that item. I'd like those pages to be very interactive as well but that might be someplace where i need to be educated on...
I am looking for a skilled professional who can help me fix connection & performance issues with my MS Azure SQL DB. The performance is noticeably slow today, but I have received specific error messages. Ideal skills and experience for this job include: - Proficiency in MS Azure SQL DB - Experience in identifying and resolving connection& performance issues - Knowledge of troubleshooting techniques - Ability to optimize database performance - Strong problem-solving abilities - Excellent communication skills to effectively understand and address the issue please bid who knows todays issues with azure
I am looking for someone to help me organize my automobile spare parts catalogs. The data that needs to be organized includes text, numerical, and mixed data types - all in a volume of up to 1 GB. I am open to suggestions for the best method for organizing and managing the data. The ideal freelancer should have experience in data organization techniques and methods to ensure the best possible outcome. If using any software, I would like to have an understanding of these tools so I can access them in the future. If you think you are a suitable candidate for the job then I look forward to hearing from you.
I am looking for a freelancer who can convert an Oracle report from RDF format to AQL within a week. This project does not require any specific features or data to be included in the conversion, as everything can be converted as is. Skills and Experience: - Strong knowledge of Oracle reports and AQL - Experience in converting reports from RDF to AQL - Familiarity with Oracle database systems - Attention to detail and accuracy in data conversion must able to work remotely and this is for independent developer no third party must have following skill oracle pl/sql oracle report oracle forms oracle weblogic
Azure DBA for Cloud Migration I am looking for an Hands on experienced Sr Azure DBA to assist with the migration of our current SQL Server database to the Azure cloud platform. Skills and experience needed: - Expertise in Azure SQL Database and Azure SQL Managed Instance - Strong knowledge of SQL Server and its administration - Experience with database migration tools and techniques - Experience in online replication of databases - Ability to handle a database size of more than 5TB Responsibilities: - Collaborate with our team to plan and execute the migration of the SQL Server database to Azure - Ensure the successful transfer of data and functionality to the cloud environment - Optimize and tune the database performance in the Azure environment - Provide continuous maintenance and ...
## Objective: To develop a Business Intelligence (BI) dashboard that tracks key performance indicators (KPIs) for marketing campaigns. The dashboard will also include relevant databases and automated email functionalities based on the data. ## Key Performance Indicators (KPIs): 1. Number of requests sent vs target 2. Number of approved camps vs target 3. Number of camps conducted vs target 4. Secondary sales - total revenue generated 5. Number of boxes/month/conversion 6. Duration to conversion 7. Cost vs return ## Data Sources: 1. Sales Force Automation (SFA) 2. Zoho CRM 3. YouTube Analytics 4. Excel files ## Data Update Frequency: 1. Weekly Reports 2. Monthly Reports 3. Alternate day Reports (Every two days between the 10th and 15th of each month) ## Se...
I am looking for a skilled freelancer to help me migrate my WordPress website and database from Domain A to Domain B. Access to Original Files and Database: Yes - I have access to the original website files and database, which will be provided to the freelancer. Ideal Skills and Experience: - Strong experience in migrating WordPress websites and databases SQL. - Proficiency in handling domain transfers and ensuring a smooth transition. - Familiarity with troubleshooting and problem-solving during the migration process. - Attention to detail to ensure that all content and functionality are preserved accurately. If you have the necessary skills and experience, please reach out to discuss the project further.
I am looking for a freelancer who can create a report in Zoho Analytics for my business. The specific data or metrics that I want to include in the report are sales data. I have a preferred layout or design for the report and I can provide an example for reference. Additionally, I am open to any suggestions or ideas for the design. The report can be either interactive or static, and either option is fine for me. Ideal skills and experience for this job include: - Proficiency in Zoho Analytics - Experience in creating reports and visualizations - Ability to understand and analyze sales data - Strong attention to detail and ability to organize data effectively - Good communication skills to discuss requirements and provide updates throughout the project.
I am looking for an expert in blockchain and AI to help me with a project related to both topics. I have some technical knowledge, but it's not enough to be sure I am taking the best decision with my application. Therefore, I'm looking for someone who is an expert in blockchain DATA and AI, specifically LLM. It would be necessary for the person to have a deep understanding of the topics and the ability to tackle complex challenges and optimising the infrastructure. If you have a proven track record of success in this field, I'd love to hear from you.
You should have experience handling payroll procedures and provide effective administrative help if you are looking for a payroll assistant. With a thorough grasp of payroll laws and a sharp eye for detail, I need someone who can do the different payroll tasks—calculating employee wages, checking time-sheets, and processing payments and deductions—effectively in this position. I want to demonstrate my mastery of payroll software by producing payroll reports quickly, resolving issues, and maintaining correct client records. If you have this experience, I firmly believe you can operate in this organizational setting using your talents. I require an efficient assistant to manage the payroll assist post while also assuring correctness and confidentiality.
I am looking for a freelancer who can help me with automated backup scripts for my client's Pastel Evolution and other POS software using SQL Database. The ideal candidate should have experience in SQL Database and backup solutions. The project requirements are as follows: Backup Solution: - Currently, manual backups are being performed. However, I need automated backup scripts to ensure a more efficient and reliable backup process. Backup Schedule: - The preferred backup schedule is daily, ensuring that the database and log files are backed up regularly. Project Timeline: - There is no specific time limit for completing the project, allowing the freelancer to work at their own pace. Skills and Experience: - Proficiency in SQL Database and backup solutions. - Experience in creatin...
Project Title: Advanced SQL Query Optimization Description: I am looking for a skilled SQL developer who can assist me with an advanced SQL query in MySQL. Specific Database Management System: MySQL Complexity Level: Advanced Optimization: The need for optimization is uncertain at this stage. Requirements: - Strong proficiency in MySQL and database management systems - Expertise in writing complex SQL queries - Familiarity with query optimization techniques - Ability to analyze query performance and suggest improvements - Experience in troubleshooting and debugging SQL code - Attention to detail and ability to deliver accurate results Ideal Skills and Experience: - Proven track record of successfully handling complex SQL queries in MySQL - In-depth knowledge of database optimization...
I am in need of immediate support for troubleshooting with Oracle Database. I require a skilled professional who has experience in Oracle Database administration and can quickly identify and resolve any issues that may arise. Ideal Skills and Experience: - Strong knowledge and understanding of Oracle Database - Proven experience in troubleshooting and resolving database issues - Ability to work under pressure and deliver solutions in a timely manner - Excellent communication skills to effectively communicate with clients and team members - Familiarity with Oracle tools and technologies for efficient problem-solving If you have the expertise and availability to provide immediate support for troubleshooting with Oracle Database, please reach out to me with your qualifications and relevant...
I am looking for a skilled freelancer to help me migrate my WordPress website and database from Domain A to Domain B. Access to Original Files and Database: Yes - I have access to the original website files and database, which will be provided to the freelancer. Ideal Skills and Experience: - Strong experience in migrating WordPress websites and databases SQL. - Proficiency in handling domain transfers and ensuring a smooth transition. - Familiarity with troubleshooting and problem-solving during the migration process. - Attention to detail to ensure that all content and functionality are preserved accurately. If you have the necessary skills and experience, please reach out to discuss the project further.
Upgrade Server from CloudLinux v6 to AlmaLinux 9.2 I am looking for a skilled professional to upgrade my server from CloudLinux v6 to AlmaLinux 9.2. The ideal candidate should have experience and expertise in server upgrades and migrations. Backup: - I have a backup of my current server, ensuring that data loss is minimized during the upgrade process. Downtime: - No downtime is acceptable for my business during the upgrade. The candidate should be able to perform the upgrade seamlessly without causing any interruptions to the server's functionality. Applications: - My server is primarily used as a hosting server, running web-based applications, a database server, and a mail server. The candidate should be familiar with these types of applications and have experience working with t...
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.
¿QUÉ BUSCAMOS? Muy fácil, actualmente estamos buscando 1 DBA de Oracle, para formar parte de un proyecto en uno de nuestros mejores clientes (empresa del sector de las telecomunicaciones). El proyecto tiene una duración estimada de 5-6 meses con posibilidades de alargarse. A continuación detallamos los conocimientos y experiencia que deseamos que tenga: - Experiencia de al menos 3 años como Administrador de BD Oracle en entornos de producción 24x7 sobre sistemas unix/linux, preferiblemente en versión 19c o como mínimo en 12c. - Conocimientos de backup&recovery con RMAN y de OEM. - Valorable: .- optimización de SQL .- Conocimiento de Shell scripts .- Conocimientos en Dataguard, RAC, ASM y particionamient...
Mi occorre un software che sulla base di una serie di indirizzi postali li riassegni per zone di riferimento da disegnare su una cartina. Tali zone sono delle aree di intervento di specifiche filiali mentre gli indirizzi fisici sono relativi ai booking prenotati da prospect raccolti mediante campagne su internet
Buscamos a un programador muy especializado en el trabajo con startups experto en realizar plugins personalizados en wordpress experto en php. Lo buscamos para continuar nuestro mvp y que se quede con nosotros a largo plazo. Con conocimientos en desarrollo de apps híbridas con acoplamiento con wordpress. Se valoran conocimientos y trabajos con blockchain.