· Installing MySQL 5.5 on all production Red Hat Enterprise Linux 5.1 servers.
· Upgrading MySQL Database to version 5.5
· MySQL software installation, configuration, upgrading/patching, monitoring, tuning/optimizing,
Troubleshooting and maintenance.
· Provide administration, design and architecture of NoSQL database services
· Database security, creating users and managing permissions.
· Installation and configuration of MySQL database servers by using MySQL GUI Tool.
· Database designing and development and Backup / Restore of databases.
· Database replication and monitoring the replication.
· Writing SQL code and code review and Writing Complex Queries.
· Optimizing database Capacity planning for database server and Creating and Monitoring Indexes
by rebuilding the index.
· Database links were created to access the data from remote databases.
· Restoring and Recovery Management from Tables are crashed.
· Performance tuning at different stages and replicating the Servers.
· Configuring Replication, Checking Completion of Backups and Monitoring System Performance.
· Work assignment within team to fulfill the customer requirement in proper time manner.
· Installed postgres database on 8 servers.
Environment: MySQL 5.X, MongoDB 2.X, , Work bench, SSH Tectia and Red
Hat Enterprise Linux 5/5.1.