Sql database configurationdela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include a diver...

...interruptions gracefully and attempts to reconnect as needed. - Security: - Ensure secure communication between the app and the WebSocket server. - Implement necessary security measures to protect the data being transmitted. Deliverables: 1. Fully functional PhoneGap/Cordova plugin for Android and iOS. 2. Source code with clear and concise comments. 3. Documentation on installation, configuration, and usage. 4. Example project demonstrating the plugin in action. 5. Support for initial setup and troubleshooting if needed. Additional Requirements: - The plugin must be developed in accordance with the best practices for PhoneGap/Cordova plugin development. - The plugin must not cause significant battery drain or performance issues on the device. - Clear communication and r...

...be properly configured. - The system must be set up for 1-10 users to access on our intranet. Customizations and integrations: - We may require custom reports or dashboards, although the specifics for these are not yet entirely defined. - There may be other custom integrations needed as the project progresses. Ideal Skills and Experience: - Proficient in Dolibarr installation and configuration - Previous experience in setting up Dolibarr for small businesses - Strong understanding of inventory management and HRM - Able to propose and implement customizations as they are defined - Good communication skills to keep the project on track. "Description: It involves installing and configuring Dolibarr on two servers, one for testing and demo, the other producti...

We are seeking an experienced Flutter developer to integrate 's video and call streaming services along with Firebase database into our existing Flutter application. The primary tasks include implementing 's features for seamless video streaming and call functionality, as well as utilizing Firebase database for efficient data storage and retrieval. The ideal candidate should have prior experience with SDK and Firebase integration. Additionally, the developer will be responsible for updating the app to meet the requirements for submission to both Apple Store and Android Store. If you have the necessary skills and expertise in Flutter development, we'd love to hear from you.

I am in need of an experienced Django developer to debug and...my existing Django project. Specifically, I have been encountering issues with the nginx server. Key Responsibilities: - Debug and troubleshoot existing Django project - Resolve issues related to the nginx server Ideal Skills and Experience: - Proficient in Django web framework - Expertise in troubleshooting and debugging Django projects - Experience with nginx configuration and troubleshooting - Strong understanding of database models, views, and templates in Django - Ability to efficiently integrate third-party libraries if necessary Please note that this project is primarily focused on fixing issues within an existing project rather than creating new features. Your ability to quickly identify and resolve pro...

I'm looking for a professional Magento developer who can upload and configure a Magento theme for my new e-commerce website. The website is currently hosted with a provider and runs on Magento 2. We will provide the theme, so there's n...runs on Magento 2. We will provide the theme, so there's no need for customizations. Key Responsibilities: - Installing the Magento theme onto our server - Configuring the theme to ensure it works smoothly on our website - Ensuring the website looks consistent with the theme's design Ideal Skills and Experience: - Proven experience working with Magento - Expertise in theme installation and configuration - Good understanding of e-commerce website design - Ability to work with minimal supervision - Strong attention to detail and ...

I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websit...

am seeking an experienced DevOps engineer to scale down my Red Hat OpenShift configuration currently running on AWS. The primary tasks involve reducing: - Application instances: Currently, I have 1-5 instances running, and I need to scale it down to a single instance. - Compute resources: The reduction should align proportionately with the decrease in application instances. This is an IBM Maximo Application Suite installation that was done with an AWS Marketplace Template "IBM Maximo Application Suite (BYOL)". The template built all the instances (9 including 3 masters, 3 workers, and 3 workers (using m5.2Xlarge and m5.4xlarge) along with a boot node and bastion host) and the volumes (26 of them with 6.23 TB of storage being used) and it is way overkill for just using as...

I'm looking for an Electrical Engineer who is experienced with Raycus Laser systems and its associated components such as Raytools BM110 Auto Focus, Raytools Software, and leadshine servo drives. The main role involves configuring these elements to integrate seamlessly. Key Requirements: - Proficiency ...configuring these elements to integrate seamlessly. Key Requirements: - Proficiency in configuring Raycus Laser hardware, Raytools BM110 Auto Focus, Raytools Software, and leadshine servo drives. - Experience with CNC Gantry Function Software. The ideal freelancer should: - Have demonstrated experience in machinery and software configuration. - Be located near Reno, NV for potential onsite work. - Prioritize accuracy in their work, as ensuring the correct configuration...

I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the cu...

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...focused on assessing and enhancing our client's DDoS protection mechanisms, incident response processes and overall security posture. Budget: ~$7000 Location: Riyadh (Onsite) 60 Days Responsibilities: - Review and assess the configuration and setup of DDoS protection systems, including network and application layer defense mechanisms - Evaluate the effectiveness of existing cybersecurity incident management processes, procedures, and playbooks - Assess DDoS detective and preventive controls from a technology infrastructure and security perspective - Audit the configuration and setup of network appliances (routers, switches, firewalls) for security best practices - Review and optimize the SIEM (Security Information and Event Management) solution's use cases for ...

...specifically in setting up and running code in response to events. Ideal Candidate: - In-depth understanding of AWS Lambda functions and AWS Lex - Strong experience with running code in response to events - Should be able to guide me through the process effectively I want to be able to learn how to integrate my Lex bot with the Lamda function that I have created. I need someone to advise on the configuration of aliases and permissions and how to invoke the function in Lex. I have the pieces setup so don't think it will take too long for someone experienced to show me what I am missing. Initially all I want is the Lambda function to invoke my bot and play a Welcome without needing user input to start the conversation. This project is more of a tutoring task, therefore, yo...

I'm in need of an experienced professional to assist with setting up Apache for Cognos12 on Linux. Key Responsibilities: - Perform a comprehensive Apache configuration to ensure compatibility with Cognos12 Required Skills: - In-depth experience with Apache configuration - Proficiency with Linux operating system - Understanding of Cognos12 architecture Moreover, I would like to implement specific directory access restrictions as part of the setup to enhance security. Desired Skills: - Knowledge in implementing directory access restrictions - Awareness of best practices in security for Apache servers

We need the following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I'm seeking a professional who can configure my Kamailio SIP proxy and RTPengine. The main purpose of this project is to set up call routing and load balancing. Key Responsibilities: - Configure Kamailio SIP proxy for call routing - Implement load balancing features - Ensure compatibility with SIP over UDP Ideal Skills: - Proficient with ...Proficient with Kamailio SIP proxy and RTPengine - Strong understanding of call routing and load balancing - Familiarity with SIP over UDP I do not require integration with any specific external systems or services. The primary goal is to optimize my setup for efficient call routing and load balancing. Please share your relevant experience when applying. It should read from a text file, xml or database the list of servers it needs to sen...

I'm experiencing an issue with my IIS 8 server. Specifically, I'm unable to reflect image updates across the server. Key Requirements: - Troubleshoot IIS : You should be experienced with IIS and capable of identifying and resolving server-related issues. - Server Configuration: The problem may be related to server settings, so a deep understanding of IIS configuration and management is desirable. - File Management: The issue seems to be related to file update. You should have expertise in managing files on Windows servers and diagnosing related issues. - Image Handling: The problem specifically pertains to image updating. You should be well-versed in how servers handle image uploads and updates. Your task will involve: 1. Diagnosing the issue: Understand why new...

Hi Saira Arif M., as discussed this involves configuring Nginx on an AWS EC2 instance to properly serve a frontend React app under a custom domain while addressing SSL issues. Nginx configuration files need to be set up to ensure seamless access to the React site via the specified domain, resolving any SSL-related issues to ensure secure connections. my price is 10$ and I have one conditions: If you are happy we can do it right now

I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advanta...

I'm seeking a network engineer with expertise in using Cisco Packet Tracer for a small-scale ISP network project. - Tasks: The main responsibilities of the project will involve configuring and setting up the ...network is secure and troubleshooting any issues that may arise during the process. - Goal: The main aim of this project is to successfully build and simulate a small-scale ISP network using Cisco Packet Tracer. - Experience: The ideal candidate for this project should possess: - Proficiency in using Cisco Packet Tracer for network design and simulation. - Strong understanding of network configuration and security. - Proven experience in troubleshooting network issues. I'm looking for a reliable and skilled professional who can deliver quality work within the st...

...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 warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowl...

...Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-qu...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I'm seeking a network engineer with expertise in using Cisco Packet Tracer for a small-scale ISP network project. - Tasks: The main responsibilities of the project will involve configuring and setting ...network is secure and troubleshooting any issues that may arise during the process. - Goal: The main aim of this project is to successfully build and simulate a small-scale ISP network using Cisco Packet Tracer. - Experience: The ideal candidate for this project should possess: - Proficiency in using Cisco Packet Tracer for network design and simulation. - Strong understanding of network configuration and security. - Proven experience in troubleshooting network issues. I'm looking for a reliable and skilled professional who can deliver quality work within the st...

MY FACEBOOK ADS CAMPAIGN Here is my wordpress website URL: (please don’t email me direct) I have set up my Facebook campaign demographics and happy with this. But I now want to add the fb pixel to my website to track users who visit my ‘thank you’ page which shows up automatically after an application form is submitted via jotform. The main objective of my website and fb campaign is to get more people to fill out the form here: Please quote for the following work. 1. Set up appropriate fb pixel on my website. 2. Advise on better more affective add creative 3. Any other changes to improve objective Please only contact me with a quote if you have read this in full and confirm that you fully understand my requirements. Thank you.

I have 33x sets of product data in a spreadsheet. I need each product's specifications to be created in a standardized PDF format. The level of detail should include everything detailed on the spreadsheet. The data on the spreadsheet is broken down into the following sections, which must be reflected on the product specifications. - Production Information - Packaging - Pallet Configuration - Physical Data - Chemical & Microbiological Tolerances - Storage - Labeling You will be responsible for: - Creating individual product specifications from provided data. - Ensuring all specifications are formatted consistently in PDF format and include our company logo provided. - Include all the information provided in each product specification. Ideal skills and experience for this ...

...it. My main goal is to generate passive income through this method, but I'm also eager to learn more about the technology and support the network. I'm looking for a consultant who can guide me through the following aspects of crypto mining: • Mining hardware selection: I need assistance with understanding what kind of hardware is necessary for efficient mining. • Mining software setup and configuration: I require help setting up and configuring the mining software on my hardware. • Mining profitability analysis: I would like a detailed breakdown of the potential profitability of my mining operation, including the costs and potential returns. Ideal skills and experience for this job would include: • In-depth experience with crypto mining, particul...

...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system fe...

I'm seeking an experienced freelancer with strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong attention to d...

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

...take appropriate action in case of error conditions. Development and Implementation You will support in defining and implementing Kubernetes deployments and provide consultation in creating Kubernetes manifests for custom deployments. Software Audits and Disaster Recovery You are responsible for software updates, VM configurations, and the system's disaster recovery. • general VM updates and configuration through ours to be built IaC definitions (Terraform, Ansible and Kubernetes) • inspecting newer container images and software versions • planning and executing updates on infrastructure components (kubernetes, ceph, VMs, ...) and provided PaaS containers Platform Security and Scaling You ensure the platform's availability, respond to outages, and scale c...

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 in...

...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...

I'm seeking a skilled architect to design a contemporary architectural master plan for a picturesque development. At this stage, only a simple 2D landscape map of the project is required, similar to the image attached. The project involves the creation of: - 12 villa/vacation homes, each with a unique layout and design. - Villa Configuration: 4 x 1-bedroom, 6 x 2-bedroom, 2 x 3-bedroom integrated into a tropical island landscape and surrounded by coconut palms. - Common Area: A swimming pool and a mixed-use pavilion. The ideal candidate will have: - Proven experience in architectural design, particularly for vacation properties. - A flair for contemporary design that meshes with the natural environment. - Proficiency in using architectural design software. - The ability to...

I need an experienced developer to fix current issues with my ansible code. Facing two primary challenges: 1. Connectivity issues: My ansible code fails to establish a steady connection during its runtime. 2. CMDB Retrieval Issue: There's a problem retrieving data from the Configuration Management Database (CMDB). The data is being accessed directly from the CMDB rather than through any API. Ideal Skills - In-depth understanding of ansible code - Experience with CMDB - Knowledge in data retrieval procedures Please note there are no specific authentication or permissions involved. All the data access is being done using direct file access. Your task would be to streamline this process and solve the prevailing issues.

Need an web hosting an expert to update my DNS settings. This is essential to ensure a smooth and seamless transfer. Ideal Skills and Experience: - Proficiency in DNS settings and configuration - Experience with migrating websites between hosting providers - Expertise in Google Workspace, particularly in setting up domain emails - Good communication skills to keep me updated on the progress and potential issues.

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

I am looking for a skilled individual to set up ClickUp for my small team. We are less than 10 members and primarily need it for task management and team collaboration. Key Requirements: - Configuration of ClickUp for task management - Set up of collaboration tools to enhance team communication and efficiency - Integration with Email and Calendar for seamless workflow - Integration with our CRM software for better customer management - Linking with our file storage services for easy access to relevant documents Ideal Skills: - Proven experience in setting up ClickUp for small teams - Strong understanding of task management and team collaboration tools - Familiarity with Email and Calendar integration - Previous experience with CRM software integration - Knowledge of linking file s...

I'm in need of a proficient individual who can help me set up my NAS System running openSUSE, including the configuration of a Docker system. I already have the hardware for the NAS system, so the primary focus would be on the software setup. Key Requirements: - Installation and configuration of a NAS System on openSUSE - Setting up a Docker system on the NAS - Configuring the NAS to run Web applications, Database services and a Media server - Ensuring the system is capable of supporting connectivity for less than 10 devices Ideal Candidate: - Proficient in setting up NAS Systems on openSUSE - Experienced in Docker system setup and configuration - Knowledgeable in configuring NAS Systems to support various applications - Skilled in ensuring connectivity a...

I'm completely new to crypto mining and eager to start my own operation. I'm seeking an expert to guide me through the essentials. Key Project Deliverables: - Explanation of the crypto mining fundamentals - Recommendations on hardware selection - Assistance with software configuration - Tips on optimizing energy efficiency The ideal candidate should have: - Extensive experience with crypto mining - Proficiency in hardware and software selection - Knowledge of energy-efficient setups - Strong teaching and communication skills Ultimately, I'm looking for someone to mentor me through the process, ensuring I start my crypto mining operation on the right foot.

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 ac...

I am experiencing slow query processing and management issues with large ...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 d...