Database Administration Jobs

I'm seeking to be a full-time data analyst in the tech industry. Key Responsibilities: - Analyzing complex data sets, interpreting trends, and providing insights for decision-making. - Developing and maintaining data models, databases, and dashboards. - Identifying opportunities to enhance reporting processes and data accuracy. Ideal Candidate: - Strong background in data analysis, with experience in a tech-related field preferred. - Proficiency in data visualization tools like Tableau, Power BI, or similar. - Ability to communicate complex data findings to non-technical stakeholders. - Solid understanding of database management and data warehousing. - Familiarity with statistical tools and techniques for predictive modeling. If you've got the right experience and skills, I&#...

I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

We are looking for an expert in MongoDB + ElasticSearch infrastructure. We are looking to build from the ground up, in the cloud (AWS), a very complex infra with 500M Person object, 50M Company, and dozens more challenges. The dataset will be always evoling, with hundreds of thousands of updates a day on every object etc. Please see the screenshot that explain the technical setup wanted: []() The final goal is to have a full blown searchable database, with list feature, and respond time always staying below a clean 100ms. The main DB will be Mongo, that needs to be optimized (shard, cluster config, index...) properly. On top of that DB will live Elastisearch, which will require a near real-time and bulletproof syncing between the two. The server budget expenses is 5-10k$ which should b...

I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change database values, as a proof of concept. T...

I need an expert with in-depth experience in ZFS pool management on a Linux operating system. The data lost from the corrupted pool wasn't critical to our operations, but we primarily stored databases, and the loss was still a hassle. Your main responsibilities would be to: - Investigate the root cause of the pool corruption and provide a detailed report on your findings. - Suggest and potentially implement steps to prevent such incidents from happening again. Ideal skills and qualifications: - Extensive experience with ZFS and Linux systems. - A history of troubleshooting and resolving data corruption issues. - Prior experience with database storage and recovery. - Strong problem-solving capabilities. - Excellent communication skills to explain complex technical concepts in layman...

I'm in need of an experienced Tableau Developer/Analyst/Designer to help me enhance an existing dashboard, and improve its performance and functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professi...

We are in need of an Oracle Database Administrator (DBA) who can provide coverage from ~8pm to ~4am PDT for one or two weeks starting May 27th, while a current employee is on vacation. Those hours are somewhat flexible. Ideal candidates should have the following skills and experience: - Proficiency in Oracle database administration for versions 11 through 19 - Must be proficient from the Linux command line - there is *no* OEM for these databases - Will respond to emails & alerts for end-clients - Will Investigate any reported problems during that shift - Must be completely fluent in English It is possible there will be nothing to do during the shifts, but if something comes up, rapid response is required. There may also be a need for weekend coverage, and possible future work.

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-driven - C...

As an organization, we've successfully implemented both Intapp and Boomi platforms within our workflow. However, the abundance of possible improvements we could make has led to the need for an experienced specialist to help us maximize usage. The tasks waiting for you will include, but are not limited to: - Automation of existing manual processes within our systems - Integration between various applications, primarily iManage and Elite 3E The ideal freelancer for this project will not only have substantial experience with the Intapp and Boomi platforms, but also a deep understanding of iManage and Elite 3E. We're excited about the potential improvements in efficiency and effectiveness these automated and integrated processes will bring to our organization.

I am currently in need of a part-time assistant skilled in data entry. The main task will require you to input customer records into databases. Key Responsibilities: - Accurate Input of client records into the database - Ensuring that data entries are correct and up-to-date Ideal Skills: - Previous experience in data entry - Meticulous attention to detail - Familiarity with digital databases Looking forward to connecting with detail-oriented and reliable bidders.

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

I'm in need of a reliable and experienced freelancer who can provide ongoing virtual assistance for tasks that include managing Airbnb, booking personal appointments, travel arrangements, and finding a handyman when needed. Key responsibilities include: - Coordinating Airbnb operations: managing bookings, coordinating with guests, and handling any issues that may arise. - Arranging personal appointments using online platforms or over the phone. - Coordinating travel itineraries: booking flights, accommodations, and transportation. - Finding suitable handyman services as needed. For a successful application, please include details of your previous experience in similar roles. Ideal candidates must demonstrate the ability to work remotely and must be well-organized, proac...

I am in need of a talented developer who can create a robust test management tool that can be used across Windows and Mac platforms. Key Requirements: - The software should support more than 50 users, so it needs to be scalable and have a user-friendly interface. - It should have the capability for test case creation and management to help us organize and track our testing efforts effectively. - Real-time reporting and analytics features are crucial for us to understand our test results promptly and act upon them swiftly. Ideal Skills: - Proficient in cross-platform software development, with a focus on Windows and Mac. - Prior experience in developing test management software is highly desired. - Strong understanding of real-time reporting and analytics tools. - UI/UX design experience...

I'm seeking a talented Copy Writer with a knack for enhancing product listings in the beauty field. Knowledge about using Lazada/Shopee Websites is essential. The task at hand is optimizing existing descriptions for beauty products on these online platforms. You'll focus on making them more attractive, and conversion-friendly. Ideal Skills and Experience: - Experience with Lazada/Shopee product optimization - Proficient in writing engaging product descriptions - Familiarity with beauty products - Ability to work creatively, enhancing existing content Your task will be all about making the product descriptions shine while keeping the core information intact. If you're someone who can blend creativity with the actionable intent in product descriptions, this project is for y...

I'm seeking a skilled data analyst to work with food quantity data to improve our decision-making processes. Key Responsibilities: - Analyze our food quantity data set to provide prescriptive insights - Offer strategies that will enable us to make better decisions - Collaborate with our team to implement and test these strategies Ideal Skills and Background: - Proven experience in prescriptive data analysis - Strong understanding of food quantity data - Excellent communication and collaboration skills - Previous experience in the food industry would be advantageous, but not essential The successful candidate will provide actionable recommendations that can directly enhance our decision-making process. They should be able to distill complex data into clear, understandable insights ...

I'm looking to test the scalability of my web application. The goal is to assess how the application performs when subjected to a significant load and to identify any potential bottlenecks. Specifically, I'm probing: - User interface functionalities - Database interactions For these tests, we'll simulate the activity of 100-500 concurrent users. This task would be best suited to a professional experienced in using JMeter for load testing web applications. Skills in web development would be advantageous, to help understand functionality and potential errors. Your deliverable is a detailed report with insights and recommendations on where and how the web application can be upgraded for scalability. Work location - North Bengaluru (North Bangalore). Remote working...

I am seeking a talented freelancer to conduct an audit of our company's data and create an availability map. - **Data Audit**: Your primary task will be to delve into our data sources and types, understanding what we have and how they're stored. - **Data Availability Mapping**: Based on your audit, you'll then create a clear, comprehensive map of where our data is and how it can be accessed. Ideal candidates for this job should have a solid understanding of data management, analysis, and storage. Experience in data auditing and creating data maps would be a significant advantage. A meticulous eye for detail is crucial, as we need a thorough and accurate representation of our company's data landscape. A data audit refers to the examination of data to assess its quali...

I'm in need of a proficient developer capable of integrating an API that reflects financial statistics onto a visual dashboard. Key components of this task include: - Integration of an API that conveys financial figures. - Representation of Investment performance stats in a table format. - Visualization of portfolio return via a line chart along with portfolio assets and diversification. Experience and skills ideal for this task are: - API integration knowledge - Experience in financial data representation - Advanced proficiency in creating visual dashboards A ready-made template will be used so as not to have to develop the visual part.

As a MongoDB Expert, my primary need is to work with someone who can assist with two key areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailo...

I am seeking a developer experienced in AspDotNetStorefront and email server settings. I am currently experiencing email-related issues with my AspDotNet storefront. I have checked the admin panel email settings and are correct and temperamental. They sometimes work, then completely stop. The project involves: • Identifying and resolving email issues, as neither sending nor receiving emails is functioning properly. • Assisting in effective troubleshooting without error messages or codes. Ideal skills and experience for this task include: • Knowledge and experience with AspDotNetStorefront. • Ability to troubleshoot and resolve email dysfunction issues. • Excellent problem-solving skills with minimal available data. • Experience in working with email serv...

I'm in need of an Oracle expert with extensive knowledge in Exadata infrastructure. Coming into this project without any experience in the field, I am eagerly searching for someone who can guide me and transfer their knowledge, so I can gain a deeper understanding. - SKILLS REQUIRED: Extensive experience in Oracle Exadata Infrastructure, excellent communication skills, teaching/mentoring experience would be a bonus. - EXPECTED OUTCOMES: Teaching me the technicalities of Oracle Exadata Infrastructure, and making me feel at ease with managing and understanding this field. Specific topics to be covered would be discussed in further detail with the chosen freelancer. Ideally, these would cover resource management, operational tasks and data warehousing, but I am open to learning abou...

I'm in need of a customized Point of Sale (POS) system that caters to the needs of my business which operates across 7 or more physical stores. The system should be developed to efficiently manage Inventory, generate Sales Reports, and facilitate a comprehensive Customer Database. Key Features Required: - **Inventory Management**: The system should track stock levels, reorder points, and provide notifications when stocks run low. It should also allow for easy categorization and organization of products. - **Sales Reporting**: I need a robust reporting functionality that can provide insights into sales trends, popular products, and overall store performance. - **Customer Database**: The system needs to be able to store customer data, such as purchase history and contact information....

We are currently facing an urgent requirement for the implementation of Oracle SCM/demand planning modules. We are in search of SCP experts or IT consultancy partner companies with proven experience in SCM/demand planning module implementation in Oracle EBS R12. The scope of work will cover the following aspects within Oracle SCM EB R12: Predictive Analysis based on MRP Demand forecasting for peak and off seasons Demand Sensing Multi-Dimensional Analysis: Analyze demand by product, customer, region, channel, and other relevant dimensions for deeper insights and better decision-making Supply chain integration Forecast accuracy tracking Reporting and Analytics

I'm looking for a skilled professional to assist me with various customer support, operation, and management tasks. - Handling Customer Inquiries: Please be prepared to manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database plat...

I am currently experiencing issues with my Moodle server database. Specifically, I'm encountering a persistent Cloudways error 524 and server timeouts. I am therefore looking for an expert with: - Deep knowledge in Moodle server databases who can troubleshoot and fix the error - Proficiency in server optimization to prevent future error occurrences and ensure seamless server performance - Familiarity with Cloudways would be a great plus, as I plan on reaching out to their support soon DO NOT put a Placeholder BID. Your role will involve diagnosing the issue, implementing a solution, and possibly optimizing the server to prevent this from reoccurring. Please confirm your relevant experience when bidding.

I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

I'm looking for a proficient data entry freelancer to assist me with an online data migration project. Key Tasks: - The primary task will involve accurately and efficiently transferring data from Excel/CSV files into an online database. - Ensure data integrity and make necessary corrections where needed. Ideal Candidate: - Proficiency in working with online databases and Excel/CSV files. - Attention to detail and accuracy is crucial. - Prior experience handling data migration tasks, preferably in a similar context. - Familiarity with data verification practices. The end goal of this project is to successfully migrate all the data from the provided Excel/CSV files into the online database without any loss or corruption. A successful freelancer will have the ability to work indepen...

I'm eager to find an accomplished Power BI and DAX expert who can help me develop a comprehensive dashboard for data analysis. Key Responsibilities: - Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated manually, so a part of this...

I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen understanding of these laws...

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational sk...

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.

Se tiene una plataforma creada en Retool y es necesario crear un mecanismo que integre vía API a MercadoLibre y así extraer los datos a una Base de Datos en PostgreSQL. Storytelling: Un usuario entra a nuestra plataforma, encontrará un botón que indique "Vincular cuenta de MercadoLibre" al dar click deberá de ingresar a su cuenta de MercadoLibre y mostrará una página pidiendo autorización para la integración. Una ves aceptada, se tendrá un proceso de descarga de datos a una base de datos y la plataforma mostrará una serie de reportes basados en dichos datos.

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU