Адміністрування баз даних Jobs

Integrate SQL Server monitoring solution at and and have it monitor multiple servers and send email notifications The integration should also be able to use PowerBI to publish the findings and show dashboards. these tools exist today, but I need them to work as one and have a simple deployment. Also they need to work with future updates to the open-source projects DATABASE ADMIN, SQL SERVER, POWERSHELL & POWERBI SKILLS ARE IMPORTANT, PLS SHARE YOUR PORTFILIO OF SIMILAR PROJECTS

Design, develop and maintain BI Solution using Redshift, Tableau & Alteryx  Optimize Redshift Data warehouse by implementing workload management, sort keys & distribution keys  Required Skills:  4+ years of experience using databases such as Oracle, MS SQL Server  1+ Must have hands on experience of Amazon Redshift Architecture.  1+ AWS Pipeline knowledge to develop ETL preferably using AWS Glue for data movement to Redshift  Strong knowledge on AWS environment and Service knowledge with S3 storage understanding  Strong knowledge multiple cloud technologies including VPC, EC2, S3, Amazon API Gateway, DynamoDB, SimpleDB, AWS Route 53  Should understand nuances of moving data from RDBMS sources to Columnar DB (Redshift)  Hands on experience in Data Warehouse (DW) and BI tool...

Need database of students appearing for cuet exam for UG & PG programs

Looking to switch from using a local shared access file to an online version that can be accessed from anywhere with access control. Questions to be answered: • Would you be able to install a SQL database in something like MySQL on a Windows computer? Or would it require an actual SQL Server? • Approximately how long would it take for the database to be built? • How much would it cost to build it? • Will you support the database if we needed support?

I have a new role as Global Strategic Partner manager, there are (10-20) people I rely on to accomplish tasks. I believe a RACI model can help to clarify/ define who is responsible for what. My data is similar to but not identical the one I attached. would be great to accomplish this in the next 2 weeks.

Build data base or basic program for CRUD

Hi, developers. I need help for Multi layer BOM Selection in SQL. I have a project related to multi-layer BOM. Each BOM has multiple levels (layers). The columns in the BOM table include final product id, component id, quantity, level, and location id, component category, progress. I'll provide table detail, and rules once you take this project, thank you.

Backup received from kinstar server. And I have uploaded all FTP files to the vultr server. I'm looking for someone to connect with the database. 나는 오랫동안 함께 할 사람을 찾고 있다.

Need an sql developer to support my job in error and bug fixing sometimes creating views,procedures and queries as well

We are currently looking for someone that can help us design actionable reporting and dashboards for our subscription-based e-commerce company. Responsibilities will include: Write SQL queries and stored routines to return and manipulate data per business needs Debugging and troubleshooting queries, stored procedures, and data integration solutions Optimize query performance tuning Develop and build analytic reports from conception to publication Connecting our SQL data source to reporting applications such as Power BI to create visual reports that can show us KPIs and Business Drivers, Customer Analytics, and more that effectively communicate trends, patterns, and predictions using relevant data. Collaborating with programmers and organizational leaders to identify opportunities for ...

We need implement automation to the process of developing / mantaining database objects with repository, versioning, CI/CD, etc.

consultation for Amazon RDS project /Data Warehousing

I have a mysql databse but i need the data mapped as they are not represented with the same column name

CREATE TABLE [dbo].[TRANSPORTSERIALTRACKING]( [PREFIX] [nvarchar](10) NOT NULL, [SERIALNUMBER] [nvarchar](30) NOT NULL, [DENOMID] [int] NOT NULL, [CURRENCYCODE] [nvarchar](30) NOT NULL, [DENOMINATION] [nvarchar](30) NOT NULL, [SERIES] [nvarchar](30) NOT NULL, [NUMERICSERIALNUMBER] [bigint] NULL, [SUFFIX] [nvarchar](10) NULL, [LASTINCASHCENTERID] [int] NOT NULL, [DATEFIRSTIN] [date] NULL, [DATEFIRSTOUT] [date] NULL, [COUNTRETURNS] [int] NOT NULL, [DATELASTIN] [date] NULL, [DATEDESTROYED] [date] NULL, [SORTINGDATEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGSITEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGQUALITYINSEQUENCE] [nvarchar](2000) NULL, [SORTINGMACHINEINSEQUENCE] [nvarchar](2000) NULL, [TRANSPORTFILEIDINSEQUENCE] [nvarchar](2000) NULL, [HEADERCARDINSEQUENCE] [nvarch...

Hi, I need very urgently a talend expert to help me in the mission mentioned bellow. Mission, Understand 7 jobs of web service that consist on reading data from client and inserting them into data base. The insert can be in diffrent table and could have inner joins and data transformation I want some one to explain me the details of the jobs and document them in word/excel (data, mapping, transformation) and mention the database tables in which data is created

I have a new ERP platform based on Odoo which needs management to enter data of primarily new product, but also ensure system is running smoothly and data is updated as required. Previous experience with Odoo is certainly beneficial. Data entry is primarily from our suppliers websites or pricelists. Potentially options for other roles as a virtual assistant. This position is for 40 hours per week, working primarily 9am - 5:00pm GMT+10 (Australia Time)

Food delivery using phone and mysql Xampp local host offline project I have a project just need to edit it

We are looking to build website like

The ideal candidate is a database expert who is, at the same time, able to translate business needs into guidance for data structure, harmonization and data governance processes. Responsibilities • Data managing (cross information to extract data) • Data modeling • Variable creation • Expertise in dashboards and data visualization Qualifications •Programs: SPSS, Power BI, programing languages R, Python, SQL, (desirable). •Experience in managing marketing research data bases, business intelligence and consumer insights. •(Excel gurus who’ve also got all qualifications above preferred). Timming Per project. This project will last 2 months with the possibility to extend it one or two months more (remote).

We have a website with 250 000+ static pages, which are exported into DB. We'd like these pages imported into Wordpress. We have field like page name, meta description, URL and we need these fields to be mapped and create the exact same pages in Wordpress. Exported files by the client are extremely large - 250-270MB each CSV and total is more than 2.5GB database. We have 10x250MB CSV files which need to be imported into Wordpress. The client has provided names for each column, but I can't really open and confirm. So you really should know how to work with large databases. We will provide our own Wordpress where we need the DB to be imported.

Hi, I am looking for a form based system where we can custom build forms for specific tasks for companies. Ideally this need to be created with a mapping tool. So when user inputs information they can also add location data to the map with a polygon, point or line functionality in 2D format. The form will require a database initially small but then can be built out big. If succesful there will be lot more work to come out of this.

To install SQL Server 2016 in linux VMs Installation in a Private cloud. Installation on NVME drives wil logs and data on separate location Database LB and HA environment essential. Add existing databases to the new instance Good Knowledge on Database replication, Indexing and Log Truncation

I have a MS Access file for more than 100 users. Front end kept in the folder1 and Back end kept in folder2. ISSUE IS TO PROTECT COPYING THE FILE FROM FOLDER2 i.e. back end file. Front end file is created following user credentials - user name and password. Only the user can see their own data only using user name and pass. If I protect folder2 user cannot copy back end file from the folder but - If I protect folder2 from the properties (see attachment - 'allow' or 'deny') option - users do not have access their data. User credentials are not working. User cannot retrieve their data in front end. Do you have any solution? If you can solve it you will be awarded.

--send order ( predefined products, custom products) --check status of earlier orders Web based admin panel:: --list of products --list of custom products --list of retailers and their login --list of incoming orders --assign status to orders Android App UI is ready

Friends of Tenwek is a 501(c)3 that builds resources and relationships for a mission hospital in rural Kenya. We want to continue supporting this life-changing work at Tenwek Hospital as effectively as possible - and would like to make sure that our database is optimized to best do that. With 1,600 donors in our database, we are looking for a database consultant who is well-versed in DonorPerfect to assess our database and give recommendations on how to best optimize our data. Additionally, we are interested in hiring ongoing support to help us 1-2 hours/week with running internal reports, creating basic data graphics for board members, receipting donors, streamlining our data entry and other misc DonorPerfect tasks - paid hourly as-needed basis.

Need a Database expert who has great experience in database administration and available for 5 to 6 hours in a day with minimum experience of 5+ year in same domain You'll ensure that: 1. Data remains consistent across the database 2. Data is clearly defined 3. Users access data concurrently, in a form that suits their needs 4. There is provision for data security and recovery control (ensuring all data is retrievable in an emergency). As a database administrator, you'll Responsibilities to: 1. Establish the needs of users and monitor user access and security 2. Monitor performance and manage parameters to provide fast responses to front-end users 3. Consider both back-end organisation of data and front-end accessibility for end-users 4. Refine the logical design so that it c...

Need a Database expert who has great experience in database administration and available for 5 to 6 hours in a day with minimum experience of 5+ year in same domain You'll ensure that: 1. Data remains consistent across the database 2. Data is clearly defined 3. Users access data concurrently, in a form that suits their needs 4. There is provision for data security and recovery control (ensuring all data is retrievable in an emergency). As a database administrator, you'll Responsibilities to: 1. Establish the needs of users and monitor user access and security 2. Monitor performance and manage parameters to provide fast responses to front-end users 3. Consider both back-end organisation of data and front-end accessibility for end-users 4. Refine the logical design so that it c...

Project Requirements: You are asked to design and implement a Database for a new University called MTUC as follows: MTUC has Academic staff, general staff and students who are working or attending this new University. Each person is either academic staff, or a general staff, or a student. A person is uniquely identified by a PerId (person's ID), and has a Name, and an Address. An Address is composed of HouseNo, Street, and City. A characteristic property of a student is that she/he has 1 course and 12 modules for this course in one year. An academic staff has a Position (Head of Department, Lecturer, Assistant Lecturer) and an academic qualification. A general staff has a job title. An academic staff teaches at most one course, whereas a student takes at one course wit...

Thank you for taking the time to look at our post. We will be producing a number of Telegram System Bots, we are now looking for an experienced and highly motivated back-end developer to help with developing, deploying and maintaining these ongoing projects. Skills - Be a talented Core / Pure PHP & mySQL developer with enough experience to hit the ground running. - Minimum 1 year of professional / active development experience with proven track record of successful customer deliveries - Experience building and working with REST APIs - Good knowledge of MySQL and ability to write SQL queries and views - Ability to understand and debug code - Knowledge and experience of software versioning techniques and tools (Git) - Good level of spoken and written English to communicate in a...

Hi, I am looking for deals to expand business and need help with organization and making calls.

Looking for database of international shops and contacts form one industry.

See Spec Document attached for processing

Hi I have a file (csv file size 80000kb, SQL see pic) and I would like to make it searchable. I would like to allow access for clients on a pass word basis (subscription style no online payment method required) I would like to monitor usage to avaoid abuse and possibly a API for bigger users (1000/5000 lookups per month) There are reports I would like to run in time: Number of lookups total Number of lookups per user View historic lookups View data by a specific field etc. I would ideally want access via my website Can anyone help?

· Experience in a similar Data Engineering role, who has attained a Graduate degree or above in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. · Experience designing big data real-time processing solutions · Building and implementing Big Data solutions using Microsoft Data Platform and Azure Data Services; including Data Factory, Azure Functions, Data Warehouse, Data Lake, Data Lake Analytics, Data Bricks and U-SQL · Working with both traditional and modern data architecture and processing concepts such as relational SQL and NoSQL databases · Designing data pipelines to support machine-learning solutions. · The right candidate must also be able to support ...

Mysql connection always got disconnect and connect and no reports showing .

Contact Center is a very important touch point for customer service. Customers interact with the contact center for a variety of services fulfillment, information about products and services, complaints, feedback, and interactions. For enhancing the contact center service levels, the customer interactions need to be analyzed and need to be mapped with customer satisfaction. Banks want to automate the process with use of AI based techniques to measure and monitor various KPIs such as call data quality, customer sentiment, Call Hygiene, customer satisfaction etc. Solution Expected Convert speech recordings into text for various Indian Languages Call recordings with mixed languages such as Hindi + English, English + Marathi, etc. Provide sentiment analysis from the call center recordings...

I need an observium specialist to do custom dashboard for: 1. Port Status Monitoring for servers 2. Monitor database health (MariaDB, MongoDB, Hadoop) 3. Server up and down status 4. Memory, hard disk, and resource utilisation

In fact, I can start by explaining the concept to you and it will help you understand the importance of an inventory system. First, our packaging is reusable packaging for online orders. So, when the consumer orders on a website, he can choose the reusable packaging option to receive his package. When they receive their order at home, they mail back their received packaging. Then, all the packages come back to my warehouse to check their condition. When their condition is approved for another shipment, I return them to the store so that they can reuse the packaging for their next online order. This way, I can know where my packages are: at my warehouse, at my customer's location or sent to my customer. For this, all my packaging is identified with a barcode. As an indication, I will...

Docker swarm MySQL master slave replication setup