Database Administration Jobs

I am seeking a developer experienced in Apache NiFi to create a workflow pipeline. This will involve converting and integrating data into MySQL. Key Requirements: - Proficiency in Apache NiFi: You must have a solid understanding of the platform to develop efficient and reliable data conversion workflows. - MySQL Integration: Experience in integrating data with MySQL is essential. - Data Conversion: You will be responsible for converting the data - previous experience in this area is highly desirable. Please note the following: - The type and source of data to be converted is not yet defined. - The triggering mechanism and frequency of workflow runs are also pending. Ideal Skills: - Proficient in Apache NiFi - Strong MySQL Integration skills - Previous experience in data conversion Your...

I require the expertise of a proficient Odoo ERP freelancer to assist in migrating data from an old system to a new one. Key Requirements: - Expertise with Odoo version 15. Familiarity with the ins and outs of this system version is crucial to successfully migrate the data without loss or corruption. - Extensive experience is paramount. I'm eager to hear about the similar data migration projects you've handled in the past and the results you've achieved. - A deep understanding of the Accounting module which the data is primarily focused on. Ensure you are adept at dealing with figures, financial data, balance sheets and other financial reports. Best suited freelancers would be detail-oriented, meticulous, and possess a proven track record of handling similar tasks succe...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complexity level spec...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ commu...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Proven track record in ...

Software API de apuestas Betfair

HRM Modules: This application allows representing the relationships between employees, the groups they belong to, and the training they have attended. 1. "Employee": They are characterized by: name: The employee's last name. first_name: The employee's first name. date_of_birth: The employee's date of birth. position: The position held by the employee. establishment: The establishment where the employee works. hire_date: The date the employee was hired. contract_type: The type of contract. seniority: The seniority. 2. "Group": They are characterized by: group_name: The name of the group. group_selection_criteria: The selection criteria of the group. 3. "Training": Each training is characterized by: name: The name of the training. description: A...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousin...

I'm looking for a Power BI expert to create a dashboard primarily for our executive team. - The main goal of this project is to create a visually appealing and easy-to-understand dashboard. - The dashboard should be tailored to the needs of executives, providing them with the key information they require at a glance. - Database of 2,000 cases and 11,090 variables Ideal skills and experience for this job: - Proficiency in Power BI - Previous experience in creating dashboards for executives - Great data visualization skills - Ability to integrate data from databases The successful freelancer will have a good understanding of what makes a dashboard not only visually appealing but also functional for high-level decision-makers. Your experience in data integration and visualization...

I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MySQL: The ideal candidate shou...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

 We are seeking a highly skilled and experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I have to transfer data and tables from oracle to postgres.

I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.

I'm looking for a skilled freelancer who can automate our report generation process and build Power BI models for in-depth data analysis. Key Requirements: - Automating Report Generation: Our current process is manual and time-consuming. We need to automate it to save time and ensure accuracy. - Power BI Models: You should have experience in building Power BI models, specifically for data analysis purposes. Data Sources: - Excel Spreadsheets: The Power BI models will need to connect to our Excel sheets. - Dataverse Database: We also require the establishment of a Dataverse database as part of this project. Ideal Skills and Experience: - Proficiency in Power BI. - Proven experience in automating report generation. - Strong understanding of Excel and database management. - Previous...

I need an expert in data visualization to create a series of infographics based on survey results. The infographics must be tailored for a general audience, making complex data easy to understand and engaging. Key Requirements: - Proficient in Data Visualization: You should be well-versed in creating visually appealing infographics that effectively convey survey data. - Audience Understanding: The ability to simplify complex information for a general audience is crucial. - Survey Data Expertise: Experience with survey data interpretation and visualization is preferred. - Creative and Innovative: I'm looking for someone who can think outside the box and deliver unique, engaging designs. - Strong Communication Skills: Clear communication will be essential for understanding the survey d...

I'm in need of a reliable colleague who can assist me with data entry. The main task at hand is database creation. Key Responsibilities: - Data Entry: Your main responsibility will be to input data into a database. - Database Creation: You will be actively involved in the creation of a new database from scratch. Ideal Skills and Experience: - Proficiency in Data Entry: I need someone who is both fast and accurate in data entry. - Familiarity with Databases: Experience in creating and managing databases will be a great advantage. - Attention to Detail: The data involved in this project could potentially be complex, so attention to detail is crucial. I appreciate someone who is detail-oriented, reliable, and can work efficiently with minimal supervision. Looking forward to working ...

I'm looking for a skilled freelancer to help me in creating a database of entry-level IT working professionals. The database is intended for recruitment purposes and should focus on professionals within our country. Key responsibilities will include: - Identifying and collecting database of entry-level IT professionals. - Categorizing the database based on different IT fields like software development, cyber security, network engineering, etc. Ideal candidates for this project should have experience in: - Database creation and management - IT recruitment - Strong knowledge of the local IT job market Your work will be critical to our hiring processes and future IT recruitment strategies.

I'm seeking assistance in incorporating 2D Data Matrix barcodes within both BI Publisher and Oracle EBS. The primary goal of this integration is to enhance our current inventory tracking systems by printing the Labels with 2D barcode and business users can scan the barcode by using the RF scanner in the inventory. This project should be relatively straightforward for someone who is proficient with BI Publisher, Oracle EBS, and barcode implementation technologies. Key requirements and considerations include: - Proficiency in both BI Publisher and Oracle EBS - Strong understanding of 2D Data Matrix barcodes - Proven experience in integrating barcodes into inventory management systems The successful candidate will be able to not only implement the barcode system but also provide us wit...

As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.

I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI

I'm seeking a skilled developer who can create a customized Grafana dashboard that will display real-time data on both water levels and contour land. This project is specifically aimed at monitoring water levels Key Responsibilities: - Develop a functional Grafana dashboard that can display both water level and contour land data. - Ensure the dashboard is updated in real-time, as this data will be used for flood monitoring and prevention. - Implement a user-friendly and intuitive design for easy data interpretation. Ideal Skills and Experience: - Proficiency in Grafana or similar data visualization tools. - Experience with real-time data visualization. - Proven track record of developing dashboards with a focus on monitoring and prevention. This project has the potential to signifi...

I'm in need of a composition diagram based on a provided ERD, but starting from either products or categories. Your deliverable should be in PNG format, keeping it black and white, and should include detailed notes for each constraint and enumeration listed. Key Deliverables: - Create a composition diagram based on the given ERD - Diagram starting from 'products' or 'categories' - Output format should be PNG - Keep the diagram black and white - Include detailed notes for each constraint and enumeration listed Ideal Skills: - Proficient in creating ERD diagrams - Experience with composition diagrams - Ability to clearly indicate datatypes and multiplicities - Familiar with check constraints and enumerations - Excellent attention to detail and communication skills...

I am in need of a professional QlikView developer capable of seamlessly integrating and modeling our substantial sales data. This project revolves around: - Data Integration and Modeling: Your primary task is manipulating our vast trove of sales records - more than 10,000 - for incorporation into QlikView. - Sales Data Expertise: A solid track record in handling sales data is crucial. Yours should include previous experience with large datasets. The success of this project hinges on your ability to model our data precisely, thereby facilitating informed decision-making on future sales strategies. Excellent knowledge of QlikView, along with a strong background in data integration, will prove invaluable.

I'm in need of an experienced Talend Studio developer to assist with a database migration project. Key Project Details: - **Data Sources**: The project entails integrating data from various databases. - **Primary Goal**: The primary focus of the project is to migrate the data accurately and efficiently. - **Data Processing**: The data migration will primarily be through batch processing, therefore real-time processing is not required. Desired Skills: - **Talend Studio Proficiency**: A strong understanding of Talend Studio and its capabilities is essential for successful project completion. - **Database Integration Skills**: Experience working with database integration is a must. - **Data Migration Experience**: Previous experience with data migration projects will be highly valued....

Our development team just wrapped up front end development for a large-scale website. At this critical juncture, we're seeking advice to ensure that our back-end databases - PostgreSQL and Cassandra - will be optimally performing and highly available. Key areas of consultation include: - Performance optimization strategies - Replication and high availability options - Ideal design of databases to accommodate the scale of our website Ideal professionals would bear extensive experience with both PostgreSQL and Cassandra databases, as well as a keen understanding of integrating front-ends to back-end databases. Your prior work with large-scale website infrastructures will greatly benefit our project. Database optimization and design aptitude is a crucial requirement for this task.

Please Sign Up or Login to see details.

I need a seasoned Java developer with a strong background in utilizing NetBeans 8.1 and Derby Database. The primary task would be to improve the performance of an existing Java application. Key Requirements: - Expertise in Java and NetBeans 8.1 is essential. - Familiarity with Derby Database and how to optimize its use. - Proven track record in enhancing application performance. - Ability to identify and address performance bottlenecks in the system. Performance Improvement: - The main area of improvement is managing data processing speed. - Analyze the application for possible performance improvements and suggest appropriate solutions. Please note, the client has not specified details about user interface responsiveness or server-side operations. Thus, the focus should primarily be o...

I need a system for an IoT-based project in which a WiFi module will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer w...

I'm in need of an expert in Machine Learning who can successfully build a Language Model for me. Train this LLM on data that I'll provide. The key specifics about the project involve: - Data Handling: My data currently lies in PDF format. Therefore, you need to be proficient in working with PDF data and possibly transforming it for the training process. - Database Knowledge: The data is stored in a MySQL database. You must have experience working with MySQL databases and effectively extracting data from them. - Document Types: This project solely revolves around PDF documents. I require somebody with a proven track record of handling and working with PDF data. Skills required: Machine Learning, MySQL, knowledge of handling PDF data and documents.

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'm looking for one have experience in data center, and I need your expertise for this project.

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.

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.

La tarea a realizar es bastante sencilla. Se requiere agilidad a la hora de procesar los datos. Tenemos una base de datos con productos y tenemos que corregir los siguientes datos: - Titulo - Categoria - Color - Tipo de producto - En caso de que sea necesario, reordenar las imágenes Es importante estar familiarizado con la nomenglatura de cada prenda en Castellano (España) Estamos contratando bloques de horas. La asignación de más o menos carga de trabajo dependerá de la eficiencia a la hora de editar estos datos. Al comenzar el trabajo debemos picar en una plataforma online, y hacerlo de nuevo cuando se pause la jornada.

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.