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 174,560 reviews, clients rate our Database Administrators 4.88 out of 5 stars.Hire Database Administrators
I am looking for a skilled professional who can help me integrate my hybrid data storage solution with Microsoft Azure. My primary goal is to optimize data processing and analytics. Ideal Skills and Experience: - Experience with Microsoft Azure data lake integration - Knowledge of hybrid data storage solutions - Expertise in data processing and analytics - Strong understanding of data security and access control measures.
I am looking for a freelancer who can help me connect my postgres database to Microsoft SQL Server Analysis Services (SSAS). Specifically, I require assistance with data modeling and query optimization to ensure efficient data processing. The ideal candidate should have experience with both postgres and SSAS. There are no specific performance requirements or limitations, but I would appreciate someone who can provide recommendations for real-time or near real-time data processing.
change the data connection oracle DB to Postgrase DB and also Powershell syntax
I am in need of a Microsoft Dynamics AX expert who can help me resolve an error message I am receiving when I try to log in. The error message states "Error - you are not a recognized user of Microsoft Dynamics AX contact system admin." Ideal Skills and Experience: - Proficient in Microsoft Dynamics AX - Experience troubleshooting log in issues - Familiarity with resetting passwords - Excellent communication skills to guide me through the resolution process I am currently a user of Microsoft Dynamics AX and the error occurs when I try to log in. While I am unsure if resetting my password will resolve the issue, I am open to trying this solution. I am looking for someone who can assist me in a timely manner to ensure minimal disruption to my workflow.
Hi, I am looking for a freelancer to help me with my Microsoft Access database. Specifically, I need assistance with the structure of the database and intermediate level complexity. This project is to create reports from the database; managing customer data and tracking inventory are not part of this project. I am looking for someone who is experienced in working with Microsoft Access and is capable of creating a database that meets my goals. If this sounds like something you could help me with, please let me know. Thank you for your time.
I have a very large MySQL database that uses LVM on a normal Linux VPS on Linode. The database is now 200GB+ and some tables are 100GB+. The DB has a lot of inserts and updates at all times. After running the DB for a while, we can't do basic tasks like count(ID), sort by ID or order by DESC on timestamp columns. As a result, we can't make any changes to the table at all. We either need to optimize the DB or migrate it to another solution (i.e. AWS RDS, Linode Managed Databases). Right now it is impossible to scale our project because of this DB bottleneck. You will need to: 1. Review our current DB structure 2. Advise us whether it is better to restructure or migrate the DB 3. Implement whatever you suggest Important: The DB uses LVMs. If you aren't familiar/comfortable ...
Responsibilities: Database Administration: Perform all aspects of Oracle database administration, including installation, configuration, monitoring, tuning, backup and recovery, and troubleshooting. Performance Tuning: Analyze database performance using various tools and techniques, identify bottlenecks, and implement necessary optimizations to improve system performance. Security and Compliance: Implement and maintain database security measures, including user access control, data encryption, and database auditing. Ensure compliance with data protection regulations and industry best practices. Backup and Recovery: Develop and maintain database backup and recovery strategies, perform regular backups, and test the recovery process to ensure data integrity and availability. Database Monito...
i have a table with FullName, Primary Key Unique ID, Email id and Sponser Id of each euser... its tree struture and 1 user can have many childs.. every child have parent... now i want stored procedure that will give me all members in tree of a particular person like list of members at first level, at second level, at third level and soo on....
I am looking for a skilled developer to help me link my SQL Server 2022 to Oracle Database 12c for a data migration project. The ideal candidate should have experience in: - SQL Server administration - Oracle Database Administration - Set up Oracle ODBC connection The goal of this project is to create a link between sql server and oracle so I can select data from a oracle database in SQL Management Studio.
I am looking for someone with experience repairing collations in a Moodle database. Although I have not attempted to repair the collations yet, the initial error has been corrected and I am looking for preventative maintenance. Specifically, I am looking for someone who can check and maintain the collations annually. Ideal skills and experience: - Experience repairing collations in Moodle databases - Knowledge of preventative maintenance techniques for collations - Ability to check and maintain collations on an annual basis
I am looking for a SQL Server expert to create a stored procedure that will send emails with Excel attachments. The data included in the attachment will be in raw format. I do not have any specific formatting or styling requirements for the attachment. The frequency at which the emails should be sent will be on a custom schedule. Ideal skills and experience: - Strong proficiency in SQL Server and stored procedure creation - Experience with sending emails through SQL Server - Knowledge of Excel and attachment creation - Ability to create customizable schedules for email frequency
whm sql upgrade failed need to update or downgrade to old - only anydesk urgent
I am looking for a freelancer who can help me replicate a bar chart in SSRS Report Builder. The chart needs to be an exact replica of the original, which is currently sourced from a SQL Server Database. The ideal candidate will have experience with SSRS Report Builder and be able to replicate the chart with precision. Some additional details about the project include: I have attached images of the original chart and what the chart looks like currently in report builder. - Chart type: Bar Chart - Data source: SQL Server Database - Level of customization: Exact replication If you have experience with SSRS Report Builder and are confident in your ability to replicate this chart, please submit a proposal. Thank you!
1. Convert existing 100-120 table postgresql Db schema into Dgraph schema. There is no data, just the schema. 2. Decide on indexes, based on use case 3. Install on Dgraph hosted service
I am looking for someone to help me with the preparation of a timetable. It is for a university setting, specifically a department in that university. The duration of the timetable I require is for one semester. I need someone who is highly experienced with this type of project. They must have successfully completed timetables for university departments in the past. My requirements are quite specific and detailed. The timetable must meet the exacting standards set by the department while also taking into account any special circumstances or requests from faculty and students. The successful applicant should also be well-versed in time management so that the timetable is accurate and efficient. They must have a working knowledge of different types of software for preparing and managing ti...
I am looking for an AVEVA PI Systems Engineer to help with the support of our customers systems. We need support with various tasks related to the installation, configuration, customization, and maintenance of our PI system. The ideal candidate will have experience in all aspects of PI system work including new installs, upgrades, and ongoing support. We have specific requirements for the installation, and we need someone with experience in development, configuration, and maintenance to ensure the project is completed on-time and to our satisfaction. The timeline for this project is moderate, and we need it completed within one month.
My company is looking for a reliable Power BI Developer to help us create visually appealing data models to analyze our data and to create dynamic and customized Power BI dashboards. Our purpose for using Power BI is to visualize our data for data analysis and forecasting, so interactivity is key. We will be using SQL databases as our main source for data, so experience with these technologies is essential. For the report/dashboard, we are looking for an advanced level of interactivity, with features such as filtering and sorting, drill down and drill through, and customized interactions and animations. If you think you have the technical expertise, experience and interest, please apply for this project. We look forward to hearing from you!
We are a small start up consulting firm and we are launching a new website with following structure: Brief Structure of the Website 1. Homepage: Providing an overview our company, with following possible, sections: o About Us: A brief description of our company and its projects o Services: An overview of the different services offered o Partners: Information about main partners. Accessible to visitors, but with limited information available without having an account o Resources: having some resources, presentations, videos etc. – which can be freely used and can also contain short/preview version of the paid resources o Events: having information about the past and upcoming events, links for registration and links to pages for accessing resources from such events o Latest News: A...
Need someone who can audit SQL Server Databases and provide an audit report. Details: The Scope of work, requirements & deliverables from the Freelancer of Work: The freelancers will be responsible for the following tasks: a. Analyzing the database structure, including tables, indexes, and relationships. b. Reviewing and evaluating security settings, including user access permissions, roles, and authentication methods. c. Assessing the performance of the databases, identifying any bottlenecks or inefficiencies, and recommending improvements. d. Verifying compliance with SQL Server best practices, including naming conventions, data types, constraints, and indexing strategies. e. Identifying any potential data integrity issues or vulnerabilities. f. Reviewing storage including hard dis...
I am looking for a freelancer who can assist me with fixing the schema errors and running queries for my MySQL database. As I do not have an existing database schema, I need someone who can work with my rough idea and create a well-structured schema. Ideal skills and experience for this job would include proficiency in MySQL, strong understanding of database design and schema creation, and experience in database management systems. The goal of this project is to improve website performance by ensuring that the database is well-structured and optimized for efficient querying.
I need a expert excel date linearity
I am looking for a skilled database developer who can optimize my MySQL query or index the database to improve performance. The database is currently 1.3GB in size and is used for transactional processing. There are specific tables and queries causing performance issues that need to be addressed. The specific table is approx 200k rows. The query is fairly simple but taking 10 seconds to complete, and it needs to be closer to 1 second. I can provide the exact table structure and the query, but not actual data. The database is hosted on a normal windows machine. Ideal skills and experience for this project include: - Advanced knowledge of MySQL database optimization and indexing - Experience working with large databases - Ability to identify and troubleshoot specific tables and queri...
I am looking for a developer to create a WebApp that is mobile friendly and has a database backend. This project is for business use and will primarily be used for user point tracking. The database will store user information and logs. Would like the site to be in Wordpress and very easy to manage the backend to make future changes. Skills and experience needed: - Proficient in HTML, CSS, and JavaScript - Experience with database design and management - Familiarity with mobile app development - Ability to create a responsive and user-friendly design - Strong communication skills to ensure clear understanding of project requirements and updates. There will be about 8 pages and a database with about 5-6 tables. User login needed
A) Database design: Determine the structure of your database based on the information you want to store. Identify the necessary tables and the relationships between them. For example, you might have a table for suppliers, one for customers, one for documents (invoices, orders), one for products, and so on. Define the attributes of each table and the primary and foreign keys to establish the relationships between them. B) Database creation: Use a relational database management system (RDBMS) such as MySQL, PostgreSQL, or Microsoft SQL Server to create your database. Follow the specific instructions of the chosen RDBMS to create the tables, define the attributes and relationships. C) Data extraction: Use the information extraction techniques described earlier to extract the relevant data f...
More details: What is the purpose of the Power BI dashboard? Sales Analysis, financial Reporting, Operational performance, What data sources will be used for the Power BI dashboard? Excel,SQL databases,cloud based data sources Do you have a preferred visual style for the dashboard? This question was skipped
I am experiencing a data updating issue with my Sybase database and require assistance from a skilled freelancer. The issue pertains to the entire database and not a specific table. The frontend programming language is unspecified, and I need someone with knowledge and expertise in resolving Sybase database issues, familiar with the following: - Sybase database management - .NET framework - Troubleshooting data updating issues Specifics: Eaglesoft is a software application for dental offices that uses SQL Anywhere. I created another application which retrieves and updates data in Eaglesoft database which is Sybase. In my application I modify appointment records in the DB to set them as confirmed by the patient. I can do "select * from table" and I can see that the change ha...
I'm looking for a freelancer to help me with database marketing. I currently have customer contacts stored in a database, and I need help with both data analysis and campaign execution. The desired outcome from this project is increased sales. I need someone with strong analytical skills and an understanding of marketing and customer relations. The freelancer should be able to create tailored campaigns, identify target groups through data analysis, and create reports quantifying results. They must be experienced in managing and curating a database, as that will be a major part of the process. This is an important project for me, as I'm looking to expand my reach to potential customers. I need somebody who is reliable, takes initiative, and can help me make the most out of my d...
I am looking for tutor who is Microsoft product expert, like azure, SSIS, data factory etc.
Hi I need support oracle database for my consultant like Indian time 8:30 pm to 10 pm 11$/hourly. Payment every Friday. This support will be on zoom meeting which we will provide you and you will connect with my consultant and support him.
Job Description: Database Engineer (Informatica/ETL) We are seeking a highly skilled and motivated Database Engineer with expertise in Informatica and ETL (Extract, Transform, Load) processes to join our dynamic team. As a Database Engineer, you will play a crucial role in designing, implementing, and managing our complex database systems, ensuring optimal data integrity, performance, and security. You will collaborate closely with cross-functional teams to deliver scalable solutions and contribute to the success of our organization. Responsibilities: • Design, develop, and implement efficient and scalable database solutions using Informatica PowerCenter and other ETL tools. • Perform data extraction, transformation, and loading (ETL) processes, ensuring the accuracy and integrit...
Senior Python Developer at , a Generative AI Research and Production Lab Prior to applying please review our github is a cutting-edge Generative AI Research and Development company focused on collaborating AI Agents. We are building towards the new world where AI Agents collaborate with each other and with humans to reach peak ingenuity. The opportunities are endless. Our philosophy is to democratize success through generative AI. Our core tenets include Reliability, Accessibility, and Human Driven technology. We believe in open source and the power of collaboration and community driving our projects forward. Please check out our GitHub () Our flagship product is GenWorlds, (public announcement coming soon) a Generative World-as-a-Service Platform for Collaborating AI Agents. The...
I am in need of an experienced Oracle DBA with expertise in Golden Gate configuration. I have an existing Oracle database that requires Golden Gate configuration. The task is of medium priority and needs to be completed within a reasonable timeframe. The ideal candidate should have experience in Oracle Enterprise Manager (OEM) setup and be proficient in Oracle database administration. Key requirements for this project include: - Oracle DBA with experience in Golden Gate configuration - Familiarity with Oracle Enterprise Manager (OEM) setup - Strong knowledge of Oracle database administration - Ability to work within a medium priority timeframe
I am looking for a database developer who can create a database that will primarily be used for analyzing data. The database should have basic security measures in place to protect the data. Skills and experience required for this project include: - Experience with database development - Knowledge of data analysis techniques - Understanding of basic security measures for databases
I am in urgent need of a PHP expert who can help me create a custom PHP script within the next 2 hours. I already have a complete outline of the project, so I need someone who can jump right in and get to work. The ideal candidate for this job should have: - Extensive experience with PHP development and custom scripting - Strong problem-solving skills for addressing any issues that may arise during the project - Excellent communication skills to ensure that the project is completed accurately and on time. If you think you have the necessary skills and experience to help me with this project, please reach out to me as soon as possible.
We are looking for PBI experts to work on a high-impact project which would include implementing on new initiatives such as Dashboarding, Sales Pipeline management, QnA bot, etc. More details: What data sources do you need integrated into the Power BI report? Excel, SQL databases Do you require data visualization or just data consolidation? Both What key performance indicators (KPIs) do you want to track in the Power BI report? We want to implement sales pipeline management via Power BI
I need a developer who is better than I am to develop 2 forms with their databases. One form is primarily to access dozens of Videos (specifically music videos) that will come in from (because emails simply do not allow bigger files); AND, the other form and database is to access mostly pictures (.pngs / .gifs / .jpgs) with maybe a couple of videos as well. Because most major websites, such as Facebook, Yahoo, Google, Twitter, Linked In, Capital One, cannot keep hackers out, what chance do I have! So I am against forms and databases now. I have developed a way around forms and databases, a great way that probably makes my website, , the most secure website on earth!!! If any hacker gets into my website they won't get any financial information, etc. BUT, even though I have a wonder...
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.
Queries implementadas na linguagem SQL aplicadas no SGBDR Oracle, apoiadas no SqlDeveloper. Utilizar o MER Físico e BD Pedido disponibilizado para treinamento da disciplina de Banco de Dados.
Potrzebny parser który bÄ™dzie przetwarzaÅ‚ faktury elektroniczne od różnych dostawców (formaty EDI XML, csv i inne) na format txt o podanej architekturze, który da siÄ™ zaimportować do programu magazynowego Magres.