We have been working with databases for over 13 years, specifically with MYSQL. We can work with all flavors of MYSQL including Maria Db, Percona and Oracle MYSQL.

Our team have expertise working in various industries therefore we understand how different businesses approach their databases while developing their applications.

​

 

OUR EXPERIENCE

​

• Administration and organization of the complete development, QA and production environment

• Installed and organized MySQL on Linux and Windows settings

• Dealing/Troubleshooting MySQL in production and developer settings on both Linux and Mac OS X

• Done installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity

• Improved database performance by using MySQL configure changes, several instances and by upgrading hardware

• Supported with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security as well as other administration functions as part of profiling strategy

• Confirmed production data being replicated into data warehouse without any data irregularities from the processing databases

• Worked with the engineering team to device new design systems of databases used by the company

• Successfully configured MySQL Replication as part of HA solution

• Designed databases for referential integrity and involved in logical design plan

• Performance Tuning daily for preventing issues and providing capacity planning using MySQL Enterprise Monitor

• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients

• Managing database clustering on NDB technology

• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server

• Proficiency in Unix/Linux shell commands

• Created and deleted users, groups and set up limiting permissions, configuration of the sudo files etc

• Configuring/Installing/Troubleshooting Apache and PHP

• Created data abstracts as part of data analysis and exchanged with inner staff

• Done MySQL Replication setup and administration on Master-Slave and Master-Master

• Document all work on servers and databases

• Database engineering is based on SDLC pattern. Elaborate all the steps like requirement analysis, Design, Development and Testing and then placement

• Draw.io for database architecture plan

• Setup MySQL based event scheduler which manages different application level events. This is heart of whole system

• Shell and python script are being used for some data migration and back-end work management

• Supportive management with different database linked decisions

• Conduct Release management and user acceptance

​

​