Information Technology Managed Service Provider looking for a Database Administrator (DBA) to provide ongoing database consulting services on an ad hoc basis. Contractor will receive work via emails on customer database-related incidents or change requests requiring DBA skills. Technologies used are Microsoft SQL Server in Windows environment, as well as skills for Data in Microsoft Azure environment (Azure MI, SQL as a Service, ADF). Occasional support for MySQL/Postgres in Linux/BSD environment. Consulting services required are the following: manage and monitor Microsoft SQL Server environments; provide SQL server maintenance and tuning; review customer SQL environments for recommendations; design database schemas for projects; troubleshoot database and data issues; create T-SQL scripts for automation or job processing; design queries and reports as needed; develop SSIS loaders for ATL; assist customers with moving/architecting for Microsoft Azure environments. Flexible schedule and remote (work from home) consulting.

I will have remote access to a client's server. I need to install PostgreSQL and also an application developed in Node (backend) and Vue (front end). I need remote assistance with an expert who can walk me through the paces, as I have never done this before. You will not have access to their system. You will have to guide me. It would be like a novice trying to fly a 747 with an expert pilot on the ground talking him through the motions.

Database connection and automation between related but disparate sales tools. Pulling in all data into a core database then exporting to a CRM. Solid framework for the project and it is 60% there, looking for someone who can help us get over the finish line, and likely help us with ongoing maintenance. Currently exporting to ZohoPrep/Zoho Analytics then to Zoho Books and Zoho CRM. Some Joining SQL required and FTP experience a must.

iDENTIFY is burgeoning and looking for another intrepid Data Engineer and Dashboard Developer to join our Data Team. We address the lifecycle of multiple clients’ data projects; where we not only build data warehouses in Snowflake for banks, but also design and implement their dashboards in Power BI, Tableau, and Sigma. We are looking for someone within the US who can: - Design data pipelines and ETL processes for all data from staging to the unified schema for use-cases in BI - Develop dashboards based on use-cases provided by the Bank - Measure the quality of customers' data through deep audits and fix data quality issues - Participate in the discovery phase with new clients and help develop a scope of work for projects “You’re hired!” will be the next message you receive if you have the: - Ability to take ownership of problems and solve them - Strong attention to detail - Solid experience as a data engineer and dashboard developer - Experience with as many of these as possible: Cloud data platforms (Snowflake, Azure, and AWS), Power BI, Tableau, Sigma Computing - Strong SQL experience - Financial/Banking background is a huge plus As a budding organization, we all work directly with our clients, wear many hats, and tackle problems wherever they emerge. Expertise isn't as important as the willingness to dive in and the determination to learn. Though this is a long-term position, the hours may start slow. Ramping up to 40 hours is the convention. Being open to full-time work and phasing out any other contracts is a must. Please do NOT apply if you are working with an agency or working on multiple projects on UpWork (it is visible). Thank you for your consideration and we’re looking forward to hearing from you!!!

We are currently seeking a highly skilled and motivated app developer to join our team. As an app developer, you will be responsible for building an innovative app that will revolutionize our sports marketplace platform and software management needs. This is an exciting opportunity to showcase your valuable expertise and contribute to the growth of our startup company. In this role, you will be tasked with developing an app with a user-friendly interface that seamlessly integrates with our existing platform. The app will be the cornerstone of our marketplace, providing our users with an enhanced and streamlined experience. Your main focus will be on creating a robust app that incorporates essential features such as product listing and search, secure payment processing, software management, user progress / session tracking, calendar management, etc. We also are looking to integrate AI/adaptive AI at a later stage in the development. In addition to these core features, we also envision the app to a marketplace for both sides to meet, as well as the ability to support multiple languages to cater to our diverse user base. Your expertise in app development, UI/UX design, and API integration will be crucial in bringing these features to life. To excel in this role, attention to detail is key. You must possess strong problem-solving skills and have the ability to think critically/creatively to overcome any obstacles that may arise during the development process. Additionally, you should be able to work effectively within deadlines, delivering high-quality work without compromising on efficiency. We are also potentially looking for a long-term partner who is willing to join the team and help iterate as we begin to test the product with an initial market subset. As a member of our team, you will have the opportunity to collaborate with a diverse group of professionals who are passionate about what they do and are eager to disrupt the industry. This collaborative environment will allow you to learn from others, share your knowledge, and contribute to the overall success of our app development efforts. Qualifications: - Proven experience in app development, with a strong portfolio showcasing successful projects - Proficiency in programming languages such as Java, Swift, Katlin, etc. - Experience in UI/UX design, with a keen eye for aesthetics and user experience - Familiarity with API integration and working with third-party libraries - Strong problem-solving skills and attention to detail - Creativity and willingness to share new ideas - Familiarity with AI/Adaptive AI - Passion for software development and building products/startups - Ability to work effectively within deadlines If you are a talented and driven app developer looking for a challenging and rewarding opportunity, we encourage you to apply. Join our team and be a part of creating an innovative app that will shape the future of our sports marketplace platform and software management needs. We look forward to reviewing your application and discussing how you can contribute to our success.

Need a database utilizing the Google Suite (I think using AppSheets?) to capture all components of a Total Quality Management (TQM) system using the Plan-Do-Check-Act (PDCA) methodology. I should included the fields that facilitate the comprehensive data collection, analysis, and action planning in addition to general fields like Organization/department, Project/Initiative, Process or Tool, Status, Comments/Notes, results/outcomes, documentation, results/outcomes, timeline/status, reporting and analysis, etc. As with any db, we need the ability to export the data into nice reports. I've attached a word doc that spells it out in more detail in 3 various ways to ensure I don't miss anything. :-)

I need some help troubleshooting 2 storage related issues with a Redshift database. The storage capacity is 320gb and the AWS cloud console shows that I am using ~90% of that (295gb). 1) When I look at the sum of the storage of all my tables in the redshift DB, the total is only about 220gb. So there is an unexplained 75gb that I would like to figure out. 2) There was also an unexplained 45gb spike in storage used several days ago that I would like to figure out. While these 2 issues are my top priority at the moment, there may be an opportunity for more work in this area.

We need an IT tech/software technician that can program and set up web type technology similar to APIs to a server that's using some type of recovery server. Must understand how to work with SQL and PHP because a lot of this stuff does not have front ends, so you'll have to understand how to add and understand scripting within the network, pretty much basic communication between devices and pull from SQL so it communicates through a controller and takes that information from the server, the actual physical stuff that it's doing the main thing. Must understand IP addresses, not fix IP addresses, within a network to communicate with fixed devices. It is important to know pretty much anybody that's an IT person has at least three to four years trouble shooting, somebody that understands the network. This is just a Wi-Fi enabled Intranet Internet with hidden addresses inside a workstation and controllers and Wi-Fi routers not connected to the Internet. Everything is internal so must work with devices very similar to routers and a GUI that have vision files on Sim cards. Must understand the right configuration files. Skills required: - MySQL - Database management - SQL - Troubleshooting - Web development - PHP - JavaScript

We are seeking a dedicated professional to take over the maintenance and development of our Microsoft Access program. The ideal candidate should have a solid background in Excel and relevant experience in the construction industry. We use Sage Accounting and Estimating Software, which integrates with the Access Database Application. This role involves troubleshooting, enhancing existing features, and implementing new functionalities based on user requirements. The successful candidate will collaborate closely with our team to ensure the program meets our evolving needs. If you have a keen eye for detail, excellent problem-solving skills, and a strong understanding of Access and Excel, we'd love to hear from you. Skills required: - Microsoft Access - Excel - Construction industry knowledge - Microsoft SQL - ASP Net

I need to now you project plan with all of it's goals where I can ask questions before starting the work. I excel in the data layer and am excited to help businesses.