Microsoft Sql Server Administration Projects
Looking for freelance Microsoft Sql Server Administration jobs and project work? PeoplePerHour has you covered.
PHP Developer familiar with LEMP (Linux, Nginx, MySQL and PHP).
I am looking for monthly support: To locate a new development outlet here are some suggestions: - You will need to find someone that is a PHP Developer and familiar with LEMP (Linux, Nginx, MySQL and PHP). Ideally someone also versed with DigitalOcean, server administration etc. This can be an agency or individual and remains your choice. - They will be able to access your server with the details below (be very careful in sharing them as they are sensitive). The root password for the server is not shared below but can be obtained within your DigitalOcean control panel by resetting it and receiving a new password via email. - You will need to add any new development company / outlet to your DigitalOcean team via the DigitalOcean control panel to allow backend access - we cannot do this for you. Once you have done that they will be able to access your server, change the root password and gain access. Please be aware you must implicitly trust any development outlet you add to your account. Once they gain access to your account they can assume full control of both your account and your server / data. - Be mindful that any incoming development outlet needs to understand that any data / code / files stored or your system may be sensitive and we recommend you put in place any agreements to control this data / code / files before providing any access or agreeing to any new services. This remains your responsibility as the data owner and controller. - You may wish to provide a new developer with access to the front end of your system to use the system as you do day to day. This is down to you and requires you to trust them in accessing your data. We would recommend you do this BEFORE you provide any SSH / backend access below and that you only provide backend access below to someone who you have evaluated and decided to be a good fit to work with. We also recommend you put in place any agreements to control this data before providing any access or agreeing to any new services. This remains your responsibility as the data owner and controller. Finally: I have included a sample code file from your system that show the backend typical example of code that your new development outlet could expect to find behind the scenes. This is by no means a subjective example and the code varies hugely - but it does show someone what the typical codebase looks like. You can share this file with any new development outlet - the necessary sensitive parts are redacted.
2 days ago50 proposalsRemoteopportunity
Read/write data via GraphQL API to MS Access/Sql Server
"read/write data via GraphQL API to MS Access/Sql Server" We're a children's nursery, in the process of moving to a Nursery management service hosted on web We are a childrens' nursery using a web-based nursery management software called Famly. They use GraphQL for their api. We currently use MS Access DB but planning to move to SQL Server or similar. I need a set up for me to pull various sets of data via their api provided as e.g. row/column data to write/update our database. I also want functionality to write key information to Famly via their API by providing row/column data etc. The work would consist of configuring API access to our data in Famly with functionality to read and write data to/from Famly from our database.
a month ago27 proposalsRemoteCanva Xibo AWS Integration
I have an existing Canva account and am looking to seamlessly integrate it with my Xibo digital signage system. My primary goal is to have the Canva designs automatically update in Xibo, ensuring that the latest content is consistently displayed on the screens. Key requirements: - Integration between Canva and Xibo: The freelancer should be able to connect Canva with Xibo, allowing for an automated update process. - AWS and Linux server management: Experience in managing AWS and Linux servers is a plus, as the Xibo system is self-hosted on an AWS Ubuntu server. We are getting this error when try to integrate: {“error”:0,“message”:“API configuration problem, consult your administrator”} We need the solution to be documanted and step by step to resovle it in future. Ideal skills and experience: - Proficiency in Canva and Xibo: The freelancer should have a deep understanding of both platforms to facilitate a smooth integration. - Experience in API integration: Knowledge of APIs is crucial for creating a connection between Canva and Xibo, allowing for real-time updates. - AWS and Linux server management: While not mentioned in the initial questionnaire, experience in managing AWS and Linux servers will be beneficial for ensuring the integration runs smoothly. The project entails creating a robust connection between two platforms and ensuring that the integration is set up for automated updates. A freelancer with a keen eye for design, strong technical skills, and experience in API integration would be ideal for this project.
4 days ago13 proposalsRemoteWeb Application Deployment in the Azure Cloud
(Microsoft Azure) Web application deployment in the Azure cloud using different service (IaaS, PaaS and FaaS) models 1.1 IaaS service model: Deploying an ASP.NET web application on Azure virtual machines. 1.2 PaaS Service Model: Deploying an ASP.NET web application to Azure App Service using Azure SQL Database. 1.3 FaaS Service Model: Deploy serverless APIs with Azure Functions, Logic Apps, and Azure SQL Database Objective: To test and compare the implementation of a web application in the Azure cloud using IaaS and PaaS service models.
22 days ago5 proposalsRemoteOnline Administrative Assistant
We seek an experienced online administrative professional to seamlessly support our virtual business operations. Remote collaboration and multitasking acumen are necessities for managing communications across channels, compiling research, entering financial data, creating presentations and spreadsheets, scheduling conferences, assisting customers, and performing general tasks as assigned. An organized self-starter proficient in Microsoft and Google Suites who reliably meets deadlines is ideal. Applicants should demonstrate proven experience in virtual roles with strong communications and organization/time management capabilities. Bachelor's degree or comparable experience preferred. Prioritization of client service and digital literacy are highly valued.
10 days ago39 proposalsRemoteopportunity
Need a specialist in Kartris, WordPress and Microsoft Access
I have a website with an intranet where customer can order their goods. The website is currently moved and change to a WordPress website (website already done). When moved, I need to copy/move the Kartris ecommerce into the WordPress platform (no payment required). kartris ecommerce synchronise every night with Microsoft access database, and this database is on a physical server in my office. I am trying to put everything back onto a WordPress website so i need a specialist in all these area or I need someone with a solution I expect to do it step by step to keep the service running at all time. Please come back to me with some solution Also I want to work with the person on PPH don't sub contract this work
15 days ago24 proposalsRemoteEducation Admin support
We are a small team of Healthcare Professionals offering a 1-yr Certificate Programme in Psychedelic Practice. This is aimed at Healthcare Professionals worldwide. We will likely be expanding to offer other courses over the coming years(s) Website: https://www.psyedu.co.uk/ Our current Education Admin Lead is leaving in May. We need someone to work flexibly around 3-6 hrs a week (10-20hrs per month) doing basic administrative tasks for our Education Organisation. It will be very busy between June and September (more like 6hrs per week) then will calm down a bit at other times in the year. We are a small start-up in our second year, just beginning to settle into our rhythm and we now need reliable low-level input which will likely slowly increase in workload over the next 3-5yrs. Job Description Skills/knowledge: MUST HAVE: Excellent written and spoken English, Organisational Skills +++, Microsoft office, excellent written and spoken communication skills, an understanding of the course we offer or a willingness to learn about it DESIRABLE: some knowledge of healthcare and how psychedelic practice is starting to be used in healthcare Qualities: flexibility Experience: any role which demonstrates the capacities outlined below Hours: 10-20hrs per month, ideally 1-2hrs on Mon, Wed and Fri each week Job Description: Key Responsibilities: 1. Communication Management: o Serve as a primary point of contact for internal and external communications. o Handle incoming emails, and redirect them as appropriate. o Draft and distribute notices, tutorials, open events and announcements. 2. Administrative Support: o Assist in scheduling appointments, and meetings for management and staff. o Maintain and update company databases, records, and filing systems. o Prepare and distribute documents as required. o Liaising with different organisations 3. Documentation and Recordkeeping: o Ensure accuracy and completeness of documents, contracts, and agreements. o Maintain confidentiality of sensitive information and handle it with discretion. o Organize and archive records in accordance with company policies and regulatory requirements. 4. Team Collaboration: o Collaborate with colleagues and departments to support cross-functional projects and initiatives. o Provide administrative assistance to various teams as needed. o Foster a positive and cooperative work environment through effective communication and teamwork. o Attending meetings once every two weeks 5. Problem Solving and Decision Making: o Identify issues or challenges in administrative processes and propose solutions for improvement. o Prioritize tasks and manage time effectively to meet deadlines and goals. Qualifications and Skills: · Proven experience as an Administrator or similar role. · Proficiency in office software applications, including word processing, spreadsheets, and presentation software. · Strong organizational and multitasking skills with attention to detail. · Excellent verbal and written communication abilities. · Ability to work independently and collaboratively in a fast-paced environment. · Discretion and professionalism when handling confidential information. · Problem-solving and decision-making skills. · Flexibility and adaptability to changing priorities and tasks.
16 days ago40 proposalsRemoteADMIN ASSISTANT REQUIRED IN LONDON
Job Description: As the Admin Assistant, you will be responsible for coordinating and managing some aspects of the leasing process for our properties. This includes advertising available units, conducting property tours, screening potential tenants, and managing move-in and move-out processes. Key Responsibilities: Conduct property tours for potential tenants and provide information on the property and its amenities Communicate with tenants to address any questions or concerns they may have during the leasing process Screen potential tenants by conducting background and credit checks Ensure all necessary documents are completed accurately and in a timely manner Coordinate move-in and move-out processes, including conducting unit inspections and managing security deposits Maintain accurate and up-to-date records of all leasing activities Advertise available units through various channels, such as online listings and local publications Stay up-to-date on local rental market trends and adjust rental rates accordingly Assist with other administrative tasks as needed Requirements: Previous experience in leasing or property management is highly desirable Strong organizational and time-management skills Excellent communication and interpersonal skills Proficiency in Microsoft Office and property management software Ability to work independently and as part of a team Knowledge of local rental market Attention to detail and ability to multitask in a fast-paced environment. P.S. Only Freelancers within the UK should apply
13 days ago7 proposalsRemotePower BI Developer
Key Responsibilities: Develop functional & operational reports & dashboards. Build automated reports and dashboards with the help of Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX Be able to quickly shape data into meaningful reports and analytics solutions. Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more. Analyse data sources and ensure data quality and integrity. Design and develop efficient data models in Power BI, ensuring optimal performance and scalability. Transform raw data into meaningful insights by implementing appropriate data transformations. Develop visually appealing and user-friendly dashboards, reports, and interactive visualizations in Power BI. Implement complex calculations and custom measures to meet business requirements. Leverage DAX (Data Analysis Expressions) to create advanced calculations. Integrate data from various sources into Power BI, ensuring seamless connectivity and data refresh. Utilize Power Query to clean, transform, and shape data for reporting purposes. Collaborate with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment with overall business goals. Conduct regular stakeholder meetings to gather feedback and make necessary adjustments to BI solutions. Provide training and documentation for end-users to ensure effective use of Power BI reports and dashboards. Monitor and optimize the performance of Power BI reports and dashboards. Ability of learning new tools to enhance the data quality and visualizations. Qualifications and Skills: Bachelor’s degree in computer science, Information Systems, or a related field. Proven experience as a Power BI Developer or similar role. Strong knowledge on Azure Data Lake, Data Factory and other data services Strong proficiency in Power BI, including data modelling, DAX, and Power Query. Solid understanding of relational databases and SQL. Experience in ETL processes and data integration. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Ability to work independently and as part of a team. Preferred Qualifications: Microsoft Power BI certification. Experience with other BI tools (Tableau, QlikView, etc.). Knowledge of data warehousing concepts. Familiarity with cloud platforms (Azure, AWS) for BI solutions.
5 days ago17 proposalsRemoteWebsite Testing
Comprehensive Website Testing Services 1. Introduction: We are seeking proposals from qualified vendors to conduct comprehensive testing of our website. The purpose of this testing is to ensure the functionality, usability, compatibility, security, performance, and content accuracy of the website. The selected vendor will be responsible for executing various testing types and providing detailed reports with findings and recommendations. 2. Scope of Work: The scope of this project includes conducting comprehensive testing of the Medha Immigration Consultants website to assess its functionality, usability, compatibility, security, and performance. The testing should cover all aspects of the website, including but not limited to: Functionality testing to verify links, forms, navigation menus, search functionality, interactive elements, and dynamic content. Usability testing to evaluate ease of navigation, layout, design consistency, readability, accessibility, and responsiveness across different devices and screen sizes. Compatibility testing to ensure compatibility with various browsers, operating systems, screen resolutions, and assistive technologies. Security testing to identify and address potential vulnerabilities such as SQL injection, XSS, authentication, authorization, SSL certificate installation, secure transmission of data, error handling, and logging mechanisms. Performance testing to determine website capacity, response times under heavy load conditions, server and database performance, image and media optimization, caching mechanisms, and monitoring of performance metrics. 3. Deliverables: The testing service provider is expected to deliver the following: Detailed test plan outlining the testing approach, methodologies, tools, and schedule. Test cases and scenarios covering all aspects of the website. Test reports with findings, recommendations, and prioritized action items. Documentation of identified issues, including severity levels and sugge
15 days ago25 proposalsRemoteAmazon Account Manager (WORK EXPERIENCE WITH AMAZON REQUIRED)
Company Overview ChannelClan is a dynamic and rapidly growing e-commerce company specializing in Amazon sales. We pride ourselves on delivering high-quality products and exceptional customer service to our clients. As we continue to expand our online presence, we are seeking a dedicated and experienced Amazon Account Manager to join our team. Job Description The Amazon Account Manager will be responsible for overseeing and optimizing our presence on the Amazon platform. This individual will play a critical role in driving sales, managing inventory, and enhancing our brand visibility on Amazon. The ideal candidate will have a strong understanding of e-commerce best practices, excellent communication skills, and a proven track record of success in managing Amazon accounts. Key Responsibilities - Manage all aspects of our Amazon seller account, including product listings, inventory management, pricing strategies, and promotions. - Monitor and analyze sales performance, traffic metrics, and customer feedback to identify opportunities for growth and improvement. - Keen eye for administrative processes, e.g., inventory management and reimbursement management of lost and damaged FBA stock. - Co-develop and implement strategies to increase product visibility, drive traffic, and improve conversion rates on Amazon. - Assist optimizing product listings with compelling copy, high-quality images, and relevant keywords to enhance search visibility and attract customers. - Stay up-to-date on Amazon’s policies, guidelines, and algorithms to ensure compliance and maximize performance. - Collaborate with cross-functional teams, including marketing, sales, and operations, to align Amazon strategies with overall business objectives. - Respond promptly to customer inquiries, feedback, and reviews on Amazon to maintain a positive brand image and customer satisfaction. - Conduct competitive analysis and market research to identify trends, opportunities, and potential threats in the e-commerce landscape. - Work closely with third-party vendors, suppliers, and logistics partners to ensure smooth operations and timely fulfillment of orders. - Generate regular reports and insights on Amazon performance, including sales trends, inventory levels, and key metrics, to senior management. Qualifications - Bachelor’s degree in business, marketing, e-commerce, or related field. - Proven experience managing Amazon seller accounts and driving sales growth in an e-commerce environment. - Strong analytical skills with the ability to interpret data, identify trends, and make data-driven decisions. - Excellent written and verbal communication skills, with the ability to effectively communicate with internal teams and external partners. - Detail-oriented with strong organizational and project management skills. - Proficiency in Microsoft Excel and other data analysis tools. - Knowledge of Amazon Seller Central and e-commerce analytics tools (e.g., Helium10) is required. - Knowledge of Amazon Vendor Central is a plus, or willingness to learn to use this platform. - Ability to thrive in a fast-paced, entrepreneurial environment and adapt to changing priorities.
17 days ago23 proposalsRemote
Past "Microsoft-sql-server-administration" Projects
SQL Server Database Migration
I'm in need of an experienced professional who can assist me in transferring a large-scale database. Key requirements include: - Proficiency in handling and transferring databases, specifically SQL Server. - Experience in migrating large databases, in this case, exceeding 10GB. - Demonstrated knowledge in handling data and ensuring its integrity. - Ability to ensure smooth transfer with minimal downtime. Your role will involve transferring selected data safely, efficiently and without data loss. Prior experience with similar projects is highly advantageous.
Website migration and updates
This project involves migrating an existing website from its current hosting platform to a new host, Web Central. The site transfer will require uploading all website files to the new host's server. Once transferred, the main navigation menu will need to be updated to reflect any structural or page changes. Additionally, an online booking module must be developed and integrated onto the site to allow customers to make reservations directly through the website. It seems the current host may have been compromised, redirecting visitors to an incorrect domain. Therefore, the secure and stable hosting provided by Web Central will resolve this issue. Familiarity with server administration, common web programming languages like HTML, CSS, PHP, and databases like MySQL is preferable to complete this project smoothly. The goal is to have the new site launched on the new host within two weeks with the updated menu and functional booking system in place.
Wordpress Plugin Errors
I recently upgraded the PHP on my server and now a couple of plugins have errors. I'm looking for someone with experience working with Wordpress plugins, PHP, sql and databases.
opportunity
Datatables.net (server-side), ASP.NET, VB, MS SQL
I have a requirement for a "simplified" version of an ASP.NET in VB page (default.aspx, default.vb) that: 1. Uses DATATABLES.NET with a repeater as the container for the data 2. Uses SERVER-SIDE processing in datatables.net with pagination, search, and sorting 3. Uses SQL Server to store the data (can use Northwind data as sample) 4. Uses (assuming) an .ashx Handler to manage/call/retrieve data from SQL in JSON
opportunity
Android TO-DO LIST working on LAN (REACT NATIVE / MS SQL SERVER)
I want to create an Android smartphone application that is a to-do list. The application will be installed on my smartphone and on my technicians' smartphone. I, who am the administrator, want to insert a job to be done into the application, for example "the printer in the technical office doesn't work, it needs to be repaired". I also need to be able to insert if it is an urgent job. Technicians who have the application, but are not administrators, should see the note and the time it was published. When each technician opens the note to see it, I have to see at what time they read the note. When a technician starts the job, he must tick it in the application and the start date and time must be recorded. When the technician has finished the work, he must report it in the application and the finishing date and time must be recorded. Only the administrator should be able to insert a job, modify it, or delete it. Technicians can only read the job, and report that they have started it and that they have finished it. The database that holds the application data will need to be on the company's MS SQL server. The application must only work on Android smartphones connected to the company's wireless LAN. No cloud data. The application will have to be developed with React Native. The backend will be developed with NODE.JS I attach a first draft of the screens
opportunity
Move web site from current hosting service to Contabo servers
This project involves migrating two similar yet independently operating websites from their current hosting service to Contabo servers. The websites, www.ezeparking.co.uk and www.wepark4u.co.uk, both update the same database for bookings administration. All files need to be received from the existing host and setup on the new Contabo hosting platform, with the websites' functionalities and data transfer preserved. One site, www.ezeparking.co.uk, will undergo several updates including having all references changed to 365parking and implementing a new logo that will be provided. The other site, www.wepark4u.co.uk, will maintain its existing content and branding but similarly be transferred to the Contabo environment. An additional small amendment involves changing the payment processing system from Nochex to Stripe on both properties. Familiarity with web hosting platforms, migrating sites, and payment integrations is beneficial for this project. Interested freelancers should have proven experience completing similar tasks efficiently and ensuring continued usability and security of information.
opportunity
Godaddy microsoft 365 migration to google space
"I need assistance migrating email accounts from a GoDaddy hosted Microsoft 365 environment to Google Workspace. There are approximately 20 emailboxes that need to be migrated over while preserving all existing email messages, contacts, calendars and other associated account data. The migration requires transferring all email content, configuration settings and subfolders from Exchange Online to Gmail without any data loss. The freelancer selected for this project will need experience performing email migrations between different platforms and services. They should be proficient in configuring both Microsoft 365 and Google Workspace administrative consoles. The work also includes testing accounts to ensure a seamless transition and that users can send/receive emails as expected in their new Google Workspace email inboxes. Assistance with password resets or reconfiguring any integration may also be required. The goal is for this migration to be completed within a 2 week timeframe while minimizing any disruptions to email use."
C# Developer
We are developing a LIMS platform using ABP.io in C#. We are seeking software developers to join our team and help develop new features. Requirements: - Excellent C# knowledge - Able to create high performing and clean code - Can take part in code reviews - Produce a full suite of tests for each new function - Microsoft SQL server - Working knowledge of Jira - Work within a remote team - Able to join regularly scheduled standups - Excellent knoweldge of working with Angular and writing front-end tests - UK Based. Nice to haves: - Experience working with abp.io framework Please apply with your experience, availability and location.
opportunity
Mobile App with React Native / Expo / CSV file (or SQL Server)
I need a Mobile App working on an Android Phone that reads barcodes and stores them inside the cell phone (connected to a LAN) After the operator has read each barcode, he must be able to enter a quantity. When the operator has finished reading the barcodes, he must press a button and the App must send the barcodes and the quantity in a CSV file to a shared folder on a computer on the LAN (or, if it is easier, write the data on a SQL Server table, in this case, I need also the code for the server if needed) The App must be developed with React Native / Expo