Database Administrator-DBA with extensive experience in installation, configuration, Upgrade, administration, monitoring and maintenance of database solutions in MYSQL,PostgreSQL,MSSQL environments. Proficient in an assortment of Technologies, including MYSQL, Windows, PostgreSQL,MSSQL and Linux. DBA skills include: MySQL,Postgre SQL,MSSQL Database Administration Data Security, Backup & Recovery Administration/ Installation /Standby/Failover Administration Database-Backed Web Solutions
· Configured, tuned and maintained MySQL Server database servers.
· Performed database development and implementation activities
· Ensured 24×7 database availability, reliability and security while in a production environment.
· Provide technical support and assistance to all database end-users and Creating users.
· Installing & Configuring Mysql & Postgre SQL Server in Windows, Linux, Ubuntu platform.
· Maintaining and Writing shell script for Mysql Backup.
· Planning for backup and recovery of database information.
· Configured, tuned and maintained MySQL& Postgre Sql Server database servers.
· Performed database development and implementation activities
· Ensured 24×7 database availability, reliability and security while in a production environment.
· Generating various reports by querying from database as per need.
· Coordinating with development team and writing views, stored procedures and functionsTriggers as per business requirements
· Involved in writing stored procedures and functions, views to handle report automation tasks.
· Written functions and views and Creating Reports as per the Client requirement.
· Created numerous simple to complex queries involving joins and correlated sub queries.
· Customized development and bug fixing.
· Interacting and Coordinating with the Client.
· Monitoring and optimizing the performance of the database
· Planning for backup and recovery of database information.
· Generating various reports by querying from database as per need.
· Creation and Maintenance of Replication Process.
· Installing Client OS like Win XP prof, Win 7, and LINUX through Imaging Software.
· Provide technical support and assistance to all database end-users and Creating users.
· Experience in maintaining Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery.
Mysql Database Administratior