Sql server 2017 certification jobs

We have a project which needs an expert who is experienced with either Haraka or Postal. The project requires understanding, building and managing SMTP infrastructure on a deep technical/engineering level. To simplify the project it revolves around receiving email, modifying some of the headers and then sending it on for delivery. We expect there to be some development involved to achieve the final desired outcome. The full details will be explained in further discussions. We will need the installation and testing of the solution and ongoing support and consulting after implementation. Please note, we are specifically looking for a technical expert in handling Haraka/Postal/SMTP. This is NOT a project focused on email delivery as it is applied to marketing type emails and reputation man...

...specialist in server maintenance and troubleshooting, particularly for my Dedicated Linux Server Level 2 Strato. The key tasks required are: - Recovery: I need help with server recovery, the ability to troubleshoot and restore the server in case of failure. - Update: Keeping the server software up-to-date is crucial for security and compatibility. I need a specialist to handle the server updates effectively. Ideal skills for this job include: - Strong expertise in Linux server administration and management. - Proven experience with server recovery procedures. - Proficiency in updating server software without causing disruptions. - Strato dedicated server recovery - Operating system Ubuntu 16.04 LTS 64bit + Plesk On...

...experienced PHP backend developer who can assist me with urgent server configuration and API integration tasks. Specifically, I would require the following: - Server Configuration: I need someone who is well-versed in server setup and configuration, ensuring a smooth and efficient back-end infrastructure. The ideal candidate should be able to ensure optimal performance and security. - API Integration: There is a need for the integration of an 'informative application' API. This task requires someone with prior experience in integrating custom APIs and a strong understanding of how to effectively connect APIs for seamless functionality. Ideal Skills and Experience: - Proficient in PHP for backend development. - Strong background in server configur...

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quick...the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

I am looking for an expert who can help me set up a SIP trunk server using Twilio as the SIP provider. This server will be used for both voice calling and SMS messaging. Key Responsibilities: - Establishing a SIP trunk server with configurations optimized for Twilio - Implementing call management features like Call Recording, Call Forwarding, and Interactive Voice Response (IVR) - Ensuring seamless integration of both voice and SMS capabilities - Providing recommendations for server security and performance optimization Ideal Candidate: - Extensive experience with SIP trunking, particularly with Twilio - Proficiency in configuring and customizing SIP trunk servers - Proven track record in implementing call management features such as Call Recording, Call Forw...

I'm in need of an Agile Scrum Master to guide my small team through the development stage of our project. Key Responsibilities: - Facilitating and supporting the implementation of agile methodologies - Coaching and guiding the team on Agile and Scrum principles - Ensuring the team adheres to Scrum practices and values - Collaborating with Product Owners and ...practices Ideal Candidate: - Proven experience as a Scrum Master in a software development environment - Strong understanding and practical application of Agile and Scrum principles - Excellent communication, facilitation, and coaching skills - Ability to work effectively with small teams - Adept at fostering a collaborative and empowered team culture - Certified Scrum Master (CSM) or similar certification is a plus, bu...

I'm in need of an expert who can help me with the following tasks on my existing server: - **Server Configuration:** Fine-tuning and optimizing my server settings to ensure it's running at its best. - **DNS Management:** Managing and configuring my domain's DNS settings to ensure proper functionality. - **Email Setup:** Setting up email services on the server for my domain. I will provide you with root access to the server, so you should be well-versed in security practices and able to handle the responsibilities that come with that level of access. Ideal candidates should have: - Extensive experience in managing Cpanel and WHM - Strong knowledge of DNS configuration and management - Proficiency in setting up email services - The abil...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine

I'm in urgent need of an engineer with experience in designing elevated platforms for competitive purposes. The final design should adhere to Australian certification standards. Key Project Requirements: - Design of Elevated Platforms: The primary feature I need is elevated platforms, designed specifically to facilitate competitions. These should be durable, safe, and suitable for intense physical activity. - Material: I prefer the construction to be based on metal. Please consider this preference in your design and material suggestions. - Detailed CAD Drawings: The stage needs to be certified, so detailed CAD drawings are crucial. These will also be used for the construction and assembly of the stage. - Time Sensitivity: I need this project completed ASAP. Your ability to wo...

...skilled developer to implement DTLS in C for secure communication within a tight deadline of two weeks. Key project requirements: - Implement DTLS in C: The primary goal of this project is to introduce DTLS to an existing system for secure communication. - Tight deadline: This project needs to be completed within two weeks. Timeliness and reliability are crucial. I need the data coming from the server to the client over UDP socket to be encrypted with DTLS, and it should appear as DTLS in the protocol section of Wireshark. In addition, the code should be able to handle streaming video or live feed over the socket accordingly. This code should work in linux and windows. Ideal Skills and Experience: - Proficiency in C: Extensive experience with C language is a must. - DTLS Kno...

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere else to b...

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

NextGen is seeking an experienced IT professional or team to deploy a private email server on our internal infrastructure. The goal is to enhance security, ensure data privacy, reduce dependency on third-party email services, and customize the email system to meet our specific needs. The project will involve setting up the server, configuring DNS records, installing and configuring necessary software, securing the server, and ensuring seamless email access for all users. Key Deliverables: Infrastructure Setup: Set up a dedicated server or VPS with a static IP address. Configure necessary storage and network resources. DNS Configuration: Configure MX, SPF, DKIM, and DMARC records to direct email traffic to the server. Software Installation and Configur...

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. ...

I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals

...of private jets. With your expertise, we aim to ensure the utmost safety and satisfaction for our esteemed clientele. Key duties and requirements: - Pilot private jets (Type ratings for specific aircraft will be needed) - Possess training and certification in Instrument Flight Rules (IFR) - Have a Multi-engine Aircraft Rating - Extensive flying experience is critical for this role Necessary Skills & Experience: - Proven experience as a pilot one a private jet - Strong knowledge of aircraft systems and operations - IFR certification, Multi-engine aircraft rating and type ratings for specific aircraft Your role will be paramount in maintaining our high-standard flights and services and ensuring client satisfaction. If you meet the above criteria, we wo...

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere else to b...

I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt attention to this ...

I'm in need of professionally engineered plans for my existing pergola. The ultimate goal is to certify it for compliance with local council regulations. Unfortunately, I don't have any existing blueprints or architectural...don't have any existing blueprints or architectural plan of the pergola. Ideal Skillset and Experience: - Expertise in creating accurate and detailed engineering plans - In-depth understanding of local council regulations regarding pergola constructions - Ability to work without existing plans or blueprints Your task will primarily involve creating a comprehensive plan to establish its certification for compliance. Please ensure that your design adheres strictly to local council regulations. Previous experience with similar projects require...

... Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Ability in RESTful API development and OAuth security practices. - Excellent problem-solving skills and ability to work effectively in a team environment. Education and Experience: - Bachelor’s or Master’s degree in Computer Science, Software Engineering, or related field. - At least 7 years of full-stack development experience, with a focus on complex cloud-based solut...

I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and React - on the server. Additionally, you'll need to install Flutter and React Native apps. The ideal candidate should have advanced understanding and practical experience in Linux system administration, server administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. --------------------------------------------------------------------------------------...

I'm on the lookout for an experienced supplier who can provide me wit...with premium, luxury-grade Egyptian cotton; specifically for clothing. In particular, the cotton must be certified organic. Key Requirements: - High-Quality Cotton: I'm in need of only the best, premium quality, luxury-grade Egyptian cotton. - Organic Certification: It's essential that the cotton is certified organic. Ideal Skills and Experience: - Proven experience in sourcing and supplying luxury-grade cotton for clothing. - Familiarity with Egyptian cotton, its grades, and qualities. - Able to provide proof of organic certification for the cotton. - Strong attention to detail to ensure the cotton meets the luxury standard. Looking forward to partnering with a professional who can ...

I'm in need of a talented developer who can help me with implementing server-side rendering for my website. Website not rendering html right now so need to do server-side rendering. You are good if you can do that through anydesk or teamviewer. Yes, i can work with new freelancers, Just send me github profile so i can check what you've done. Start your application with "SSR", all other will be ignored.

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ...features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations shoul...

I am looking for a freelancer who can help me set up iRedMail on my Linux server. - My server is running on Linux. - I have less than 10 email accounts that need to be set up. Due to my lack of technical expertise, I need someone who is familiar with iRedMail and Linux server administration. The ideal candidate should have experience in configuring mail servers and be able to provide a smooth and efficient setup.

I'm looking for a skilled professional who can help me secure my Linux server and SMTP setup. Key Requirements: - Deep experience with Linux server security measures and best practices. - Proficient in securing SMTP servers and ensuring authentication is managed effectively. - Capability to implement SSL/TLS encryption for enhanced security. Your application should focus on detailing your experience in this field. Please provide relevant examples of previous projects where you've successfully secured similar systems.

I am in need of an experienced Linux developer for a project that involves server configuration and also have knowledge of apache logs as well to fix some apache issue. Important : Job have to done Remotly.

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I need an experienced app developer to update my iPad app to fix a server connection issue. The app is currently unable to connect to the server, and this problem needs to be resolved. Once the update is complete, the app should be submitted to the Apple Store, and I require it to be compatible with iOS 12 and earlier. Key Requirements: - Fix the server connection issue preventing the app from connecting - Update the app to be compatible latest ios firmware - Submit the updated app to the Apple Store You should have: - Prior experience in iOS app development, particularly with server connection issues - Ability to navigate Apple's submission process and ensure the app meets their requirements - Proficiency in iOS 12 and earlier, and the ability to make ...

I am seeking an experienced online English teacher for children aged from 3 to 16. The ideal candidate should have a firm grasp of teaching Writing, Speaking, Listening, and Grammar. Your responsibility will involve: - Making engaging o...ideal candidate should have a firm grasp of teaching Writing, Speaking, Listening, and Grammar. Your responsibility will involve: - Making engaging online classes using online learning platforms - Adapting your teaching methods to effectively cater to a diverse age range - Being consistent in monitoring and reporting on student progress. Experience with online learning platforms is a must. Certification in TEFL, TESOL, or equivalent would be an asset. Your commitment to making learning enjoyable, relatable, and effective are key to success in ...

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...

the project is about to create a Minecraft map that faithfully replicates a GTA RP server. GTA RP (Grand Theft Auto Roleplay) is a unique gaming style where players embody a character and immerse themselves in its persona, acting as if they were that character. Key Features of GTA RP: 1. **Roleplay Dynamics**: - Players assume the identity of a self-created character and live out their life within a fictional context alongside other players. - Interaction can be via text or, preferably, voice chat for enhanced realism. - Characters can be anything from a prominent businessperson to a foreigner unfamiliar with the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their own char...

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

I'm looking for an experienced Indonesian to English translator, specifically for legal documentation. The translated content must be certified by a sworn translator. Key Requirements: - Translate legal documents from Indonesian to English - Certification by a sworn translator Ideal skills and experience: - Proven experience in legal document translation - Sworn translator certification - Fluency in both Indonesian and English

As a contracting and maintenance company, we are looking to acquire ISO 9001 certification. Our aim is to enhance the quality of our services and boost our credibility in the industry. Key Requirements: - ISO 9001 Certification: We require a professional who can efficiently guide us through the ISO 9001 certification process.

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployme...

already we are running a page on server , on migration we are not able to up the apache and page on new server

...redesigned website onto a new server. Key Objectives: - Redesign to Improve Conversions: The primary aim of the redesign is to enhance user experience and bolster the site's conversion rates. Particularly, I'm interested in optimizing call to action buttons to boost user engagement and ultimately, conversions. - Server Deployment for Enhanced Performance: The new server deployment should prioritize faster loading times. A significant aspect of this project is to ensure that the website works seamlessly on the new server without any disruption to its functionality. Ideal Skills: - Proven experience in website redesign with a track record of increasing conversion rates. - Proficiency in UI/UX design and a strong understanding of user behavior. - T...

...Private Server. I want to redesign 2 of my website pages fully 100% 1-homepage 2- token page and other pages backgrounds and fonts. and make the site live in other server. thanks Key Requirements: - Redesign: I need the new website to have a modern and visually appealing design. This includes a seamless, user-friendly interface, engaging graphics, and intuitive navigation. - Deployment: After the redesign, you will be responsible for migrating the site to a Virtual Private Server. This requires a solid understanding of server configurations and best practices for deployment. Ideal Candidate: - Prior experience in web design and deployment, preferably for similar projects. - Proficiency in front-end technologies and design principles. - Familiarit...

...control, so the design needs to be both efficient and reliable. Key requirements: - The relay bank should be small in size, while still accommodating 6 triggers at 230 volts. - The design must include a dry switch rated at 13 Amps. - The PCB must be designed with the intention of obtaining CE certification. Ideal skills for this project include: - Proficiency in PCB design, particularly for high voltage applications. - Experience in designing for industrial control applications. - Knowledge of CE certification requirements for PCBs. It's crucial that the design be not only functional but also compliant with CE standards. I look forward to working with a professional who can bring these elements together in a reliable and efficient PCB design. The drawing attache...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

...limited to any particular brand; rather, I am seeking a comprehensive understanding on a broader scale. What You Are Expected To Deliver: - Compelling insights into overall production process of various liqueurs from a general perspective. - Suggestions, advice, or methods for improving production efficiency without compromising quality. As a qualified applicant, you should: - Hold a degree or certification in food sciences, chemistry, or related fields. - Have solid experience in the spirits industry, particularly in the production of liqueurs. - Show an understanding of scaling production processes. - Demonstrate adeptness at identifying and resolving production challenges effectively. Your expertise will greatly contribute to increasing both the efficiency and quality of ...

I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere else to b...

I'm in search of a skilled server administrator who can help me with setting up a new Contabo VPS server and migrating 3 websites from DigitalOcean to the new server. Tasks Include: - Setting up a new VPS server with Almalinux - Installing and configuring WHM/cPanel for server management - Installing and configuring Cloudlinux for server management - Installing and configuring LiteSpeed as the web server technology - Configuring DNS settings and ensuring proper hardening for security Migration Assistance: - Assisting in migrating a WordPress site and two Laravel applications from existing DigitalOcean droplets to the new server's cPanel Ideal Candidate: - Proficient in server setup and management - Experienced in ...

Hi there! For our project, we are seeking an experienced developer who can adeptly work with React 18. Your role would consist of assisting us with the installation of essential scripts on our server. To excel in this role, it would be a plus if you possess knowledge of: - Node.js - MongoDB - GraphQL Although these specific skills would be advantageous, they are not mandatory. On another note, our preferred server management system for deploying the React application is Shared Hosting. Thus, any experience you have with server management and deployment processes, particularity Shared Hosting, would greatly benefit your application. With your expertise, we trust that you can help us successfully manage this project. Looking forward to potentially working with you!

DotNet developers required for #Errors removal and Improvement work# in thenafter Host on server. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Errors removal and Improvement work which has to be done is explained in below link-