Database Administration Jobs

I'm looking for an experienced Power BI and Microsoft SQL Server professional who can help me visualize data through charts, graphs, tables and matrices. Key Responsibilities: - Connect Microsoft SQL Server database to Power BI. - Create and implement interactive visualizations using charts, graphs, tables and matrices. - Ensure accurate representation and interpretation of data in visualizations. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server and Power BI. - Strong analytical skills with attention to detail. - Experience in data visualization and creating interactive dashboards. - Excellent communication skills to explain visualizations and insights. Filter certain data thru This is goings to be an intensive work please rea

Job Title: Power BI Freelancer Needed for Data Visualization and Reporting Job Description: We are looking for a skilled Power BI freelancer to assist with creating interactive dashboards, reports, and data visualizations. The ideal candidate will have a strong understanding of Power BI, data modeling, and business intelligence tools, with the ability to turn complex data into clear insights. Key Responsibilities: Design and develop Power BI dashboards and reports. Connect to various data sources (SQL, Excel, cloud databases, etc.) and transform data for reporting purposes. Implement DAX queries and functions for calculated measures and columns. Ensure data accuracy and troubleshoot issues within the data model. Optimize dashboards for performance and user experience. Collaborate with st...

I'm seeking a professional service to conduct employment verification for potential hires in Glendale, Arizona. Key Requirements: - Conduct thorough checks on candidates' previous workplaces to confirm their job titles, duration of employment, and salary (though salary verification is not mandatory). - The service should be able to verify information from more than 5 previous employers. - The ideal freelancer will have experience in conducting pre-employment vetting and a good understanding of employment verification processes. - A keen attention to detail is crucial to ensure all information is accurately verified. - Excellent communication skills are necessary to keep me updated throughout the process. Please provide examples of similar projects you've completed, alon...

We are looking for a professional who can assist with the maintenance of our Terra platform including integration of both real-time and historical data through the Terra APIs. This project primarily focuses on data integration from various sources including databases, APIs, and wearables. Key Requirements: - Experience with data integration and APIs - Familiarity with handling both real-time and historical data - Proficiency in working with databases and wearables - Excellent problem-solving skills and attention to detail Ideal Skills and Experience: - Previous projects involving Terra APIs or similar - Strong programming background - Expertise in data analytics and visualization - Ability to work under tight deadlines and deliver quality results

I'm seeking a competent professional to create a comprehensive database for my cargo service. This database should be accessible from tablets, desktops, and mobile phones. It needs to capture sender and receiver details, items, charged amounts, terms and conditions, and provide the option for customer signatures. just we required to replace the paper receipts and manual entries Key Features: - Fully functional database capable of handling all cargo service details - Accessible from tablets, desktops, and mobile phones - Option for customer signatures - Secure with Two-factor authentication I'm not certain about the best type of Database Management System to use, so I would appreciate your recommendations. Skills in SQL-based systems like MySQL or PostgreSQL, or NoSQL-based sys...

I'm seeking assistance to improve my software development skills for personal reasons. Scope of Work: - I need a clear summary of the project's purpose. - It is important to define the specific goals I wish to achieve with this project. - You will need to list the tasks to be performed in order to improve my software development skills. Key Requirements: - I’m looking for a skilled professional with experience in software development. - Ideally, you should be able to provide a personalized learning experience. Deliverables: - I expect a detailed outline of the steps we will take to improve my software development skills. - A comprehensive guide on how to keep my skills sharp post-project. Timeline: - I'm hoping for a reasonable timeline for this project, but ...

I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process

I'm experiencing logical errors in the business logic of my SQL Server stored procedure. These errors occur during specific queries. I need an expert to diagnose and fix the issue.

I'm facing some database errors with my MySQL. I suspect it may be related to security settings, as I've noticed potential SQL injection attempts. I'm in need of a Linux specialist or system administrator to diagnose this issue. Key Responsibilities: - Diagnose and troubleshoot the MySQL database errors - Review and adjust security settings as necessary - Identify any potential threats or vulnerabilities - Recommend and implement necessary solutions Ideal Skills and Experience: - Extensive experience with MySQL and Linux - Strong background in system administration - Proficient in database security and troubleshooting - Prior experience handling SQL injection issues - Excellent problem-solving skills

I need a skilled professional to set up a two-node Oracle 19c RAC database on Oracle VirtualBox 7.14 for a test environment. Key Requirements: - Host System: Windows 11 powered by Intel i5 12th Gen with 64 GB RAM - Install Oracle Linux Server 8.8 on both cluster nodes, assigning 12 GB RAM to each - Configuration of ASM with specified disk groups: - OCR: 3 GB - DATA: 30 GB - RECO 20 GB - Installation of Oracle 19c Grid software - DNS setup can be ignored - Use of Automatic Storage Management (ASM) for disk groups I have the Oracle Linux Server 8.8 ISO ready, and no special network settings are needed for the cluster nodes. The ideal freelancer for this project should have extensive experience with Oracle databases, VirtualBox, and Linux systems. Please be prepared to demonstrate ...

I'm seeking a skilled professional to assist me in setting up Tomcat 9, APEX, ORDS, and an SSL certificate on my Oracle Linux 19c DB. Key Tasks: - Install Tomcat 9, APEX, and ORDS - Configure SSL Certificate About the Environment: - The operating system is Oracle Linux 9 The required software packages for Tomcat, APEX, and ORDS are already available. Your expertise in installation and configuration will ensure a successful setup. Please reach out if you need further details.

I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process

I'm seeking an experienced assistant to help me prepare for an interview for an AWS Cloud PostgreSQL DBA role. The training will specifically focus on Postgres-centric DBA tasks, with an emphasis on database performance tuning. Key Areas of Focus: - Database Performance Tuning: This is a critical aspect of the training. I need to understand how to fine-tune the database for optimal performance. - Query Optimization: I would like to delve into the intricacies of making queries run as efficiently as possible. - Index Management: Understanding how to manage indexes effectively will be a key part of our sessions. - Monitoring and Diagnostics: I need to learn how to monitor the database and diagnose any potential issues. Ideal Candidate: The ideal trainer will be someone with extensive e...

I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process

I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process

I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data retrieval tasks.

I need a Tableau project that visualizes an organizational hierarchy. Requirements: - Create a comprehensive 'top office' table that includes the Manager, Supervisor, and CIO roles, detailing their responsibilities. - Design a three-level structure where the top office can see under their Supervisor and Manager, while the Supervisor and Manager can see under their employee ID and Name. - Ensure that the Supervisor and Manager are also recognized as employees under the top office. - All employees should see who their direct boss is. Ideal Skills: - Proficient in Tableau with prior experience in creating hierarchical visualizations. - Strong attention to detail to ensure accurate representation of the organizational structure. - Ability to understand and represent complex respon...

I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process

I need help with explore an Oracle database on my Windows 11 machine, this project will be conducted remotely for security purposes. Please note, this project will be conducted remotely for security purposes, so a reliable and secure remote connection is essential. Your understanding and expertise in these areas will ensure the successful completion of this project.

I'm seeking a professional who can help design a structured questionnaire consisting of 16 multiple-choice questions, with one correct answer per question. Key Requirements: - Each question should be presented on a separate page, enhancing user focus and engagement. - Users should navigate through the questionnaire using both 'Next' and 'Previous' buttons, allowing for flexible pacing. Ideal Skills: - Experience with questionnaire design and user interface (UI) principles - Proficiency in relevant software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the per...

I need a freelancer to set up a daily backup of my Microsoft SQL Server database from a dedicated Windows server to S3 AWS Storage. The backup files need to be compressed. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server - Experience with AWS S3 - Knowledge of Windows Server - SQL database management - Data compression techniques

I'm looking for a skilled Snowflake developer with extensive experience in data warehousing. The project involves integrating various data sources, primarily AWS S3 and SQL databases, with Snowflake. Key Responsibilities: - Data Warehousing: You'll be primarily focusing on the data warehousing aspect of Snowflake. - Data Integration: Integrating AWS S3, SQL databases, DBT, and Snowpark with Snowflake. - Data Transformation: Your main use of dbt will be for data transformation. Ideal Skills: - Proficient in Snowflake, dbt, and AWS. - Experience with data warehousing and integration. - Hands-on experience with live projects using these technologies. - Strong understanding of data transformation processes. Successful candidates will have previous experience working on live proje...

I need assistance with manual data entry into an SQL database. The project involves working with database entries, so experience with SQL and data handling is essential. Ideal Skills: - Proficient in SQL - Manual data entry experience - Attention to detail - Data handling skills - Able to work independently and meet deadlines

I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process

I need a Progressive Web App (PWA) that serves as an informational platform for my company. Specifics: - The PWA should provide comprehensive information about my company and the services we offer. - The app's primary purpose is to relay company information and services to our customers. Ideal Skills: - Proficiency in JavaScript, HTML, and CSS - Experience in developing PWA - Good understanding of creating informational platforms - Previous experience with creating company service apps is a plus.

We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.

We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing a project like this. Thanks!

I'm looking for a seasoned professional with advanced knowledge in SQL database architecture. The primary task will be designing a new database. Ideal Skills and Experience: - Extensive experience with SQL - Proven track record in database design - Ability to understand and meet project-specific requirements - Strong problem-solving skills - Excellent attention to detail

I'm looking for an experienced SQL Server professional to set up log shipping for disaster recovery purposes. This will primarily involve transactional data, and log backups need to be taken and shipped every 5 minutes. Ideal skills and experience: - Extensive knowledge of SQL Server - Proven experience with log shipping - Strong understanding of disaster recovery strategies - Familiarity with handling transactional data - Ability to set up frequent log backups (every 5 minutes)

I need an experienced professional to download and install a specific older version of JasperReports, version 7.5, on my Oracle Linux system. Ideal candidates should: - Have deep knowledge of Oracle Linux - Be skilled in software installations on Linux systems - Be able to download and install JasperReports version 7.5 Please provide evidence of similar projects you've completed in your bid.

We are migrating data from our current ERP system (that is stored in an SQL database) to Microsoft Dynamics Business Central Cloud. The source database structures is different than Business Central. We have been able to reverse engineer both the databases and create ERD models and DDL scripts. Also we know how to create Dynamics APIs and use AL to interact with Dynamics. We are looking some consulting advice on how best migrate the data into dynamics. For example looking for ideas how to best table and field match, what software tools to use, best proccess etc for this ETL project. Please describe any experience you have with ETL/migrating data between different systems. Please add the word DYMANICS123 to the start of your proposal so we can weed out automated responses. Thanks!

I'm looking for a professional pre-employment vetting service in Utrecht, Netherlands, specializing in education verification. Key aspects of the project: - Conduct thorough checks to confirm the accuracy of claimed educational credentials. Ideal candidates should have: - Experience in conducting pre-employment checks, specifically education verification - A network of contacts with educational institutions or access to official verification services - Strong attention to detail and commitment to accuracy - Excellent communication and report-writing skills. Please provide your relevant experience and methods you would utilize for this project.

I am looking for an experienced freelancer with in-depth knowledge of OpenApply to support our school’s admissions and re-enrollment processes. The ideal candidate will have either worked directly at OpenApply or at a school/schools that use OpenApply extensively. The scope of this project includes: • Customizing the admissions process to suit our school’s unique needs. • Enhancing communications and setting up custom notifications throughout the admissions flow. • Designing and improving forms, including application and re-enrollment forms. • Optimizing the use of OpenApply for more efficient workflows and better functionality. • Configuring API integration to PowerBI, PowerAutomate, SharePoint. • Configuring API integration to iSAMS. &bu...

I am in need of a professional who can assist in registering my already established business and setting up a comprehensive database for global news distribution. Key Responsibilities: - Register my business with relevant authorities. - Create a database that caters for news distribution, both in the USA and globally. Ideal Skills: - Experience with business registration processes. - Proficiency in various types of databases, including SQL-based, NoSQL-based, and Cloud-based. - Prior involvement in setting up a news distribution system.

I need an expert to help me troubleshoot my PostgreSQL database on a Linux system - Specific on Openproject (Live environment) https://www.openproject.org. The application is hosted on Ubuntu server with multiple applications. Tasks: - Backup application and make sure no damage is done to any other applications running oh the machine - troubleshoot database (OpenProject is not displaying hours spend on projects/tasks) - upgrade OpenProject to latest version (community) Ideal Skills and Experience: - Proficiency in PostgreSQL - Extensive experience working with Linux systems - Ubuntu Server - Strong troubleshooting skills - Ability to diagnose and resolve database issues efficiently

need to update a custom MySql CRM , with fixes at contact dashboard and create a new Pipeline Dashboard using database contacts. please check carefully the doc attached. regards

we need a Data architect with following requirements for 2-3 months assignment( 1 position ) Required Skills & Experience Required Profile 7+ years of experience on Database warehouse / lake house programming Experience in implementing at least 2 end-to-end data warehouse / data lake projects Experience in implementing at least 1 Azure Data warehouse / lake house project end-to-end Converted business requirements to concept / technical specification Worked along with source system experts in finalizing ETL and analytics design Support data modeler developer in design and development of ETLs Creation of activity plan as per the agreed concept with timelines Technical Expertise: Strong experience with Microsoft Azure components, including Azure Data Factory, Azure Synapse, Azure SQL Da...

Im looking to update a MySql database used for CRM I need to fix some funytions on what I have and add a new PIPELINE dashboard please chec documentation, is very clear

I am looking for an expert in Elastic Search or TypeSense to improve the search functionality within my database. The primary goal of this project is to enhance the way we search through our database records. Key Requirements: - Deep knowledge and experience with Elastic Search or TypeSense. - Proven track record of improving search functionality within databases. - Ability to understand and work with database records. - Strong problem-solving skills and attention to detail. Ideal Skills: - Elastic Search - TypeSense - SQL - Database Management - Search Functionality Improvement Your expertise will play a key role in making our database search more efficient and effective. Looking forward to your insightful proposals.

I'm seeking a skilled SQL developer with a deep understanding of manufacturing business logic, specifically in production scheduling within the chip industry. Your role will involve: - Assisting in the creation of a production scheduling system aimed at optimizing resource usage, primarily raw materials and machinery. - Providing guidance based on your knowledge of the chip manufacturing business. Ideal candidates will have substantial experience in SQL development and a strong background in the manufacturing sector, particularly with chip production. Your expertise will be pivotal in enhancing the efficiency of our operations.

I'm in need of a seasoned SQL DBA to help with my MySQL database. The primary focus will be on optimizing the database for efficient queries, ensuring top-notch security measures are in place, and overseeing data backup and restoration processes. Ideal Skills: - Extensive experience with MySQL - Strong understanding of database optimization techniques - Expertise in database security protocols - Proficiency in data backup and restoration procedures - Excellent skills in query optimization

I'm looking for an expert in Microsoft Access who can create a tailored database for managing customer information. The primary focus of this database is capturing and organizing individual customer contact details and their service history. Key Requirements: - Create a user-friendly Microsoft Access database - Capture individual customer contact details - Track and manage customer service history Skills & Experience: - Proficient in Microsoft Access - Experienced in database design and development - Knowledge in customer information management systems - Attention to detail and strong organizational skills

I am in need of a large scale database primarily storing financial records. The database should incorporate role-based access control to ensure security and proper data management. Key Requirements: - Design and implement a large scale database. - Primarily focused on storing and managing financial records. - Incorporate role-based access control into the database. Ideal Skills and Experience: - Extensive experience in database design and management, particularly with financial records. - Expertise in implementing robust access control systems. - Proven track record of creating large scale databases.

I'm in need of a database. Specifics have not been finalized, and I'm open to suggestions. Your expertise in the field will be invaluable in determining the best approach. Skills and Experience Required: - Proficient in various database management systems (DBMS) - Strong understanding of both relational (SQL) and NoSQL databases - Experience in creating databases for diverse applications - Excellent problem-solving skills to determine optimal database structure - Able to communicate complex technical concepts in simple terms

I'm seeking a seasoned Power BI professional to craft a thorough sales performance report. Key Responsibilities: - Extract data from SQL databases to analyze sales performance - Create a variety of visual representations of the sales data - Compile detailed tables for in-depth data breakdowns Ideal Candidate: - Proficient in Power BI and SQL - Skilled in creating comprehensive and insightful reports - Strong background in data analysis and visualization, particularly in sales Please note, specific sales metrics and types of visualizations will be discussed in detail with the selected freelancer. The frequency of report updates will also be determined at that time.

I'm looking for an expert in osTicket to assist with some database/ticket issues. osTicket is latest version and hosted on Hostgator.com. Tasks: - change dates/response person of existing tickets - provide documentation on making changes to tickets in Database (backend) Requirements: - osTicket experience - hostgator (shared environment) experience and manage osTicket there

I require assistance downloading all files from my Ubuntu server along with the complete MariaDB database. - Current Access: I currently connect to my Ubuntu server via Navicat. - FTP Setup: I need help setting up the FTP connection to facilitate this process. - Data Scope: The task involves downloading all server files and databases, not just specific directories or databases. The ideal freelancer for this project should have: - Extensive experience with Ubuntu servers. - Proficiency in working with MariaDB. - Skills in FTP connection setup. - Ability to handle comprehensive data downloads efficiently.

Project Description: We are looking for an experienced system administrator or database specialist to assist with the installation and configuration of PostgreSQL on two new servers. The goal is to establish a replication setup where one server acts as the primary (master) and the other as a replica (slave), ensuring automatic synchronization and real-time backup of the primary server’s data. The setup should also allow secure connections to the PostgreSQL database from a third server, which will be used for accessing the database remotely. Key Requirements: PostgreSQL Installation: - Install the latest stable version of PostgreSQL on both servers. - Configure PostgreSQL to run as a service on both servers, ensuring automatic startup on reboot. Master-Replica Configuration: - Set...

I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.

I need a comprehensive retrieval of all my chats from Instagram and Messenger. This includes both active and deleted conversations. I want to have a full overview of my chats from both platforms.