Sql server 2008 database administration jobs

...handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that supports efficient data aggregation and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing analytics requirements. - Efficient ...

I need a proficient Linux developer with a solid understanding of networking and security, and expertise in scripting languages like Bash or Python. The primary task will be troubleshooting and optimizing existing Linux systems. Also, superior skills in server administration and deployment are a requisite for this role. As the project unfolds, communication is critical, but I haven't decided on a reporting frequency at this point. Please provide suggestions on what you've found effective in your experience.

Hello! I'm looking for an experienced Person who can build the mobile device management (MDM) Server for iPhone device. Specifically, I need someone with expertise who can create a custom MDM solution. This solution must be capable of advanced user access control, including full control of devices, remote wipe capabilities, and more. The MDM functionality I need is for iPhone device enrollment and management. I do not have an existing solution that needs to be integrated, so will require a new solution to be built from scratch. Before showing interest on this job, Please read the below link and then you can bid for this job FYI: The ideal candidate has extensive experience developing mobile device management

I'm currently experiencing a peculiar issue on my CentOS server. The process /usr/sbin/mariadbd is showing 109% CPU usage in the WHM task manager, although the server load is stable and I haven't made any recent changes. Your primary task would be to diagnose and resolve this problem. No error messages or warning signs have appeared, making the source of the issue somewhat inscrutable. Access will be provided via AnyDesk or a remote desktop connection for swift and efficient troubleshooting. Your expertise in the following areas would be invaluable: - Proficiency in CentOS server administration - Expertise in WHM and server task management - Experience in identifying and resolving high CPU usage issues - Strong communication skills to work...

I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.

I need a VA with Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating pro...

I'm seeking an exam invigilator assist for an on-site exam in La Ceiba. We provide test administration services to test-takers worldwide. For this purpose, we look for professionals who we contact on an "as-needed" basis work at professional centers administering certifications. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have an assignment coming up where a test taker has been approved to have the exam read outloud to them. For this assignment, you are required to be present on-site, and read the exam content aloud to the test taker. The exam is taking place at a professional testing center in Ceiba, Costa Rica. Date: Wednesday, 24 April, 2024 Time: 7:30 am to 12:45 pm We provide full t...

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I'm looking for a skilled individual who has a good understanding of Mechanical Engineering and Data Science to help me set up a database that records the live feed of on-board sensors in a car. Key Responsibilities: - Utilizing an On-Board Diagnostic Tool and an app to record the data - Implementing a database to store the collected sensor data - Analyzing the data primarily for predictive maintenance using statistical analysis Ideal Skills: - Mechanical Engineering background - Proficiency in working with On-Board Diagnostic Tools - Strong experience in statistical analysis - Knowledge of database management systems and data analysis tools - Experience in predictive maintenance is a plus This project requires attention to detail, analytical thinking, and the...

I am searching for a Product Analyst who can apply their knowledge towards data analysis, market research, and performance monitoring. Its a small assignment This assignment involves diving into a snowflake database to explore how customers behave. The goal is to find useful information that can help the Product team make decisions to make the business grow. After you uncover insights, you'll suggest changes to the product, like adding new features, making current features better, or even getting rid of features that aren't working well. You need to do the analysis, create graphs to show your findings, share all the code you used, and also come up with a plan for an A/B test to try out one of your suggested changes. Note: Its a short assignment, not spend more than tw...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I'm looking for an experienced server administrator to optimize my dedicated server running Almalinux 9.3 + Plesk. The server is currently performing poorly with slow website loading times and database slowdowns, which is unacceptable as I regularly have more than 500 concurrent visitors. The primary focus of this project will be optimizing the server's Plesk settings, Postgres and MariaDB databases, and PHP 8.2 configuration. Key tasks will include, but are not limited to: - Configuring Plesk for optimal performance, including adjusting server pool size - Identifying and implementing improvements to Postgres and MariaDB settings to reduce slowdowns - Tuning PHP 8.2 to enhance website speed and performance Ideal candidates for this project ...

I am seeking a detail-oriented freelancer who can expertly transfer text data from PDF files into a database. The ideal candidate should possess the following skills and experience: - Proficiency in working with PDF files - Expertise in data entry tasks - Experience in formatting and structuring databases - Excellent attention to detail Suitable candidates need to handle copious amounts of text data, accurately convert the text-containing PDF files into a structured and organized database. This includes careful validation to ensure no data is lost or misrepresented during the data entry process.

Hi Ashish, this is for the tasks I emailed about.

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

I was utilizing a server running Alamlinux9.3 with Virtualizor for my virtualization needs. However, after a recent reboot, the server failed to start up properly. Despite troubleshooting attempts, the system remains inaccessible. The datacenter has provided access to the server via sysrcd (SystemRescueCd), but I lack the expertise to efficiently recover the system and get it operational again. I am seeking assistance from experienced system administrators or IT professionals who have expertise in Alamlinux, Virtualizor, and system recovery. The goal is to diagnose the issue, recover the system, and ensure it is functioning correctly. Tasks: Diagnose the cause of the server failure after reboot. Implement necessary steps to recover the Alamlinux9.3 system. E...

We have a website where the homepage currently loads slowly due to multiple API calls. Despite implementing asynchronous API calls, the page load time is still not meeting our target. We are looking for a skilled developer to optimize the homepage to load within 1 second. we need some one who can : Optimized homepage that loads within 1 second. Cron job implementation for fetching and updating api data of tokens price/5%/24%//etc basically - i want to load data everything from DB only , rather than multiple api calls. thakns

I am looking for...Oracle DBA with experience in both Oracle RAC (Real Application Clusters) and standalone Oracle databases. The primary goal of this project is performance tuning. Ideal Skills and Experience: - Proven experience with Oracle RAC - Proven experience with standalone Oracle databases - Specialization in performance tuning - Familiarity with Oracle Database 19c Key Responsibilities: - Implementing performance tuning strategies - Monitoring and optimizing database performance - Troubleshooting issues related to performance - Ensuring the smooth operation of both RAC and standalone Oracle databases The ideal candidate should have a deep understanding of Oracle databases and be able to provide tailored solutions for enhancing performance on both Oracle RAC and s...

...skilled developer who can build a customized matchmaking database for my internal use. The database will primarily focus on matching investors to investment opportunities. Key Features: - Storing Match Preferences: The database should be able to store various match preferences including minimum/maximum investment, minimum/maximum funding amount, geographical preference, and the type of funding. - User Authentication: As this database will be for internal use only, the user authentication should be secure and limited to specific staff members. No external user authentication is required. - Search Criteria: The database should have search functionality based on the geographic location. Ideal Skills: - Proficiency in database management ...

I have an unfinished Flutter app that requires a skilled individual to handle its database connection. The app is designed and now, I need help connecting it to a MySQL database using an API. Key Responsibilities: - Complete the database connection for my Flutter app - Utilize MySQL to store the following data types: user profiles and authentication, transactional records, content and multimedia files Ideal candidate: - Proficient in Flutter and experienced in developing Flutter apps - Skilled in MySQL and API integration - Familiar with handling user data and transaction records securely - Strong background in data storage and retrieval for content and multimedia files This project is not for a business, but rather a personal venture. Your expertise will help me b...

I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Bertrange, Luxembourg. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for a Reader and input assistance. For this assignment, you are required to be present on-site, sit with the test taker, and read the exam ...

I am seeking an expert in AWS servers, particularly in the problem-solving aspect of EC2 instances. Key tasks to be performed: - Diagnose the specific issues of the server - Suggest and implement suitable solutions to rectify the problems - Maintain and improve server performance Ideal Expertise and Skills: - Strong technical skills and deep understanding of AWS, specifically EC2 instances - Proven track record in handling server emergencies and solving server issues - Competence in developing and maintaining customer-focused, high-performance AWS infrastructure - Proficient with best practices in ensuring server security

I urgently need an expert in Linux and Nginx who can help me: - Configure my Nginx server - Optimize server The ideal candidate should have: - Extensive experience with Nginx and Linux - Excellent troubleshooting and problem-solving Time is of the essence, so please get in touch if you can jump straight into action. Ubuntu Nginx

I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!

...fine tuned for improved responsiveness, and a better customer experience. - Soften existing UI found within Communications: Modify the content being sent within email communications, with consistent interface populated with the appropriate details drawn from the App. - Admin Dashboard - surface additional details in the existing dashboard, that are already captured in the App, for better administration. The App does not have any e-commerce, it aligns customers with individuals within a geolocation to preform the task The ideal candidate should have significant experience in cross-platform app development, a strong grasp of Ul/UX design, and a proven track record in enhancing app performance. Please share examples of previous work and outline your approach to this project...

...with a user-friendly panel. - The application should have a user-friendly interface that is easy to navigate. - It should support live streaming capabilities in high quality. - A Video-on-demand library should be integrated to provide a variety of content for viewers. The panel should come with the following functionalities for user management: - User subscriptions management: allowing the administration of user accounts and subscriptions. - Multi-user access control: enabling different levels of access for various users. - User activity tracking: to monitor and analyze user engagement with the platform. Ideal candidates for this project should have experience in: - Developing Android applications, particularly in the field of IPTV. - Building user-friendly interfaces and ensu...

The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate

...VPN/Internet gateway solution. This project involves building server software capable of authenticating client connections and providing access to the internet. Requirements: Master's degree or PhD in Computer Science, Cybersecurity, or a related field Extensive experience in internet security, privacy, and VPN technologies Strong proficiency in server-side software development Familiarity with OpenWrt and router firmware development (preferred) Passion for internet security and privacy Responsibilities: Develop robust Wireguard exit nodes and VPN server software Ensure seamless integration with existing client software and VPN router firmware Implement secure authentication mechanisms for client connections Design scalable server architecture for hos...

We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.

We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

...with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, particularly VPS/Dedicated hosting - Expertise in database management and optimization - ...

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Se...

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35

...js application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vulnerabilities, in particular server banner disclosure and CORS misconfig...

My WordPress site hosted on AWS is currently down due to a database connection issue. Key requirements: - **Database Connection Issue**: The site is throwing an 'Error establishing a database connection' message. I believe this is related to database connection details in the WordPress configuration file. If you are experienced with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have experience with both AWS and WordPress. Familiarity wi...

I need someone proficient in C# to help create a Remote Administration Tool (RAT). This tool will primarily offer remote desktop access. A user-friendly graphical user interface (GUI) is a must, with a clear and clean design that's simple to navigate. It should be tailored specifically for a Windows operating system. Ideal Skills: - Strong background in C# - Experience in creating GUI - Expertise in remote desktop functionalities Experience: - Developing RATs - Working with Windows OS - Designing intuitive GUIs

I am looking for an experienced developer that have worked on the signal messenger app to rebrand the app change icons and colours. We need installation on our amazon instance signal server and included all required backed services database etc. and publish application with custom icon colours and icons markets google and apple. you can look signal application

We are currently struggling with our WordPress site which is plagued by slow loading times, frequent server crashes and persistent error messages. Given the criticality of the platform, We need an expert who is adept in Internet Information Services (IIS) server management running WordPress environment and troubleshooting it at server level. To be successful in this role, you should demonstrate the following: - In-depth knowledge of IIS servers and WordPress operations - Proven experience in diagnosing and resolving server and website errors - Proficiency in optimizing WordPress sites for enhanced performance Please note, no recent changes or updates have been made to the website or server configuration that could be contributing to these issue. I...

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantag...

I'm in need of an expert who can fix my corrupted .FIC file in my HFSQL database. Key Project Requirements: - The file is currently not opening and is producing errors, so the main goal is to restore it to its original state and ensure it can be opened without any issues. Please note that I can provide the corrupted .FIC file for analysis. Ideal Skills and Experience: - Proficient in HFSQL database management. - Proven track record in repairing and recovering corrupted database files. - Strong problem-solving skills to identify and rectify the issues within the file. If you're confident in your ability to handle this task efficiently, please provide details of your relevant experience and how you plan to approach this project in your bid.

I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API integration and displaying data.

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.

... The user back office should provide easy access to personal data, token balance, transaction history, tasks performed, and direct referrals. Implementation of a personalized referral link for each user, allowing them to easily share the link to invite new users to the platform. 2. Backend e Lógica de Negócios: Development of a robust backend architecture to support the functionalities of administration and user back office. Implementation of business logic to calculate token appreciation based on survey responses and manage the referral and commissioning system. Payment management system to process transactions related to token purchases and referral commissions. 3. Integrações de Pagamento: Integration with APIs of conventional payment services to ...

...app development, and website development. - Excellent communication and negotiation skills. - Ability to work independently and manage multiple tasks effectively. - Proven track record of meeting and exceeding sales targets. - Self-motivated and result-oriented. - Flexibility to work on a commission-based or freelance basis. **Preferred Qualifications:** - Bachelor's degree in Business Administration, Marketing, or related field. - Experience with marketing department, sales department, web development. - Knowledge of different sales techniques and strategies. - Ability to adapt to a fast-paced and dynamic work environment. **Benefits:** - Flexible work schedule. - Opportunity for unlimited earning potential based on sales performance. - Chance to work with a...

...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...

I'm in need of an experienced professional who can help me with the writing and preparation of a Request for Quote (RFQ) to be submitted through the General Services Administration (GSA). Key Responsibilities: - Develop a comprehensive RFQ to solicit competitive quotes - Ensuring that the RFQ is tailored to select the most suitable supplier - Aligning the RFQ with GSA procurement regulations and guidelines - Creating a template for suppliers to provide an overview of capabilities and pricing The RFQ will be specifically for the procurement of Multiple Award Schedule (MAS) services including both technology solutions and professional services. It's crucial that the supplier I choose has the necessary expertise in government contracting and procurement, as well as a strong...

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

...software, app development, and website development. - Excellent communication and negotiation skills. - Ability to work independently and manage multiple tasks effectively. - Proven track record of meeting and exceeding sales targets. - Self-motivated and result-oriented. - Flexibility to work on a commission-based or freelance basis. **Preferred Qualifications:** - Bachelor's degree in Business Administration, Marketing, or related field. - Experience with CRM software for managing sales processes. - Knowledge of different sales techniques and strategies. - Ability to adapt to a fast-paced and dynamic work environment. **Benefits:** - Flexible work schedule. - Opportunity for unlimited earning potential based on sales performance. - Chance to work with a dynamic team and ...

...domain name Current website is very slow and couldn't take a back up using updraftplus plugin I need all files and Database copying to new server and testing that it function OK I am in need of a specialist with broad experience in WordPress platform to move my website from its current location to a Virtual Private Server (VPS). Requirements: - Comprehensive knowledge of WordPress site architecture and components. - Extensive experience in website server migration, particularly to VPS hosting. - Ability to ensure that no data is lost during the migration process. - Skilled in backup creation and restoration. - Familiarity with DNS and IP configurations for the new server. The task must be completed with minimal downtime and no loss of data/...