-Data Modelling and Database Design Create database designs by performing needs / requirement analysis, creating a logical mode, and then implementing the physical model. -Backup and Recovery Making periodic backups of data and keeping it safe from accidental or intentional destruction. Testing recovery plans so that when problems do arise, data can be restored quickly. -Capacity Planning Watch data growth, and plan how best to deal with it. This may include archiving it, increasing the size of current hardware, or adding new hardware. -Change Management Server configurations, database schema change over time. Perform impact analysis before changes are made, implement changes, test changes, and document them. -High Availability Ensure high availability, including use of log shipping, clustering, database mirroring, and other technologies. -Monitoring Monitoring performance, monitoring server disk space, monitoring logs, ensuring jobs have run successfully, checking for errors, and so on. -Needs/Requirements Analysis Perform needs/requirements analysis. Talking to users, finding out their needs and requirements, and determining the best way to meet them. -Performance Tuning Monitor performance to determine ways to optimize database performance. -Report Writing Writing reports against databases in transact-SQL code to extract the data, or creation and formatting physical reports. -Security Control who can access data and what they can do with it. Creating SQL Server login IDs, database IDs, assigning permissions, moving security between servers. -Testing Testing servers, testing databases, testing applications, testing management tools, and so on. Ensure that data integrity and high availability, is maintained at all times. -Training Users Sharing knowledge with other DBAs, developers, or end-users. -Working with colleagues Interacting with other DBAs, developers, end users, product-knowledge specialists, vendors, accountants, hardware experts, and networking experts.
Get Your MySQL Project Started Today!
Hire a freelance MySQL developer for expert database development. Search our database of MySQL consultants to get your MySQL database developed on demand.
MySQL is an open-source relational database management system which is commonly used by free software projects, such as WordPress, Google and Facebook. On oDesk, the world’s largest online workplace, companies hire MySQL Administrators to successfully complete jobs including database management, gallery integration, and migration.
MySQL Administration Job Cost Overview
Typical total cost of oDesk MySQL Administration projects based on completed and fixed-price jobs.
oDesk MySQL Administration Jobs Completed Quarterly
On average, 2,261 MySQL Administration projects are completed every quarter on oDesk.
Time to Complete oDesk MySQL Administration Jobs
Time needed to complete a MySQL Administration project on oDesk.
Average MySQL Administration Freelancer Feedback Score
MySQL Administration oDesk freelancers typically receive a client rating of 4.65.
Mohammad A. Agency Contractor
Michael A. Agency Contractor
Linux System Admin and Devops. Administration and configuration of Fedora and Debian based platforms. Apache & NGINX maintenance and configuration. Security and network-penetration expert, negating vulnerabilities and reducing attack vectors. Able to proficiently write, support and maintain Perl, Python, Bash, PHP, Rust, Go and C.
TOP RATED, 100% JOB SUCCESS RECORD & AMONG ODESK'S TOP 5% SUCCESSFUL FREELANCERS! Since 2004, I have been working as a Freelance Responsive CMS Website Designer, SEO Specialist & PHP Web Applications Developer. I have designed and developed more than 75 websites and web applications and have a proven track record in SEO. My strengths are in Project Management, Responsive CMS Website Designing, PHP/ColdFusion Web Apps Development, as well as SEO (Search Engine Optimization), SERP (Search Engine Result Pages), SEM (Search Engine Marketing), SMM (Social Media Marketing) also I have much copywriting experience. Along with that, I have a niche for writing articles on different topics and children stories containing social & moral values of life. Apart from that, I have been working as a PHP Project Manager & eCommerce/SEO Specialist at Unik Impact Co. I am seeking opportunities to complete all your website related work including its planning, designing, content creation, and search engine optimization/marketing even on urgent basis. I also have experience in the following areas: Custom Responsive Theme Designing, Linux Web Server Administration, Web Content Uploading & Management and Mobile Applications Development. I have expertise in: WordPress, Joomla & Drupal CMS (Responsive Website, eCommerce Store Development & Custom Theme Designing) Custom PHP & MySQL Development (Websites & Web Applications) Magento, PrestaShop, BigCommerce, OpenCart, osCommerce, Zen Cart & X-Cart eCommerce Platforms (eCommerce Store Development & Custom Theme Designing) Search Engine Optimization (SEO & SERP) HTML5/CSS3 Website, Mobile Site & Mobile APP UI Designing SEM (Google Adwords / Microsoft Bing Ads) Social Media Marketing (SMM) E-Learning Management System Development (eLMS) jQuery, HTML5 BP, Modernizr, Normalize.css ColdFusion MX 7 & 8 Flex/Flash/XML Content Writing Copy-writing Link Building Graphics Designing
Over the last 10 years, I have developed a wide range of websites using Adobe Business Catalyst, Magento, Volusion, WordPress, HMTL, PHP and MySQL, including sites for startup companies and small businesses. My core competency lies in complete end-end management of a new website development project, and I am seeking opportunities to build websites from the ground up for you or your business. I spent 5 years in website promotion via SEO, SEM, LB & SMM using white hat techniques. I also got exposure in 3rd party off the shelf tools like Prestashop, 3dcart, OpenCart, Shopify, and Joomla. I also have some experience in the following areas: Ajax, JQuery, XHTML, Responsive Design, software design and testing.
I am currently freelancing RoR projects across the universe, fullstack rails coder for your duty. I have been doing this for the last 9 years now and I was employed as CTO & Ruby On Rails Senior developer, and my projects include wide usage RoR(1,2,3,4), I love new technologies and I can learn to use them very fast! I can develop anything starting from tech plan/mockup, through creating rails application (agile method) till full setup of VPS/dedicated server (or even cloud), then I can maintain and administrate this project. I work with cloud platforms like AWS, Heroku, EngineYard. I have ZERO unsatisfied clients. Knowledgeable in CI like Jenkins, and various management systems like Trello, Lighthouse, Jira, Redmine (You can have a tracking project with my private Redmine installation for no cost) and some others All small things around webdev; AJAX, HTML, CSS, JS, RSS, XML, JSON. SVN, GIT(preferred), Capistrano/Chef/Rubber for multistage deployment for test/production projects, SASS, SCSS, HAML, CoffeScript, REDIS, various types of caching. Capable to work in Linux/OSX/Windows environments. Having proven Berkley certification for SAAS: https://verify.edx.org/cert/7bd82e53af154feaa706ac8b3db01561 Full stuff you can find on my Linkedin profile: http://lnkd.in/XQ5hgJ Github page: https://github.com/alexey