HELLO!

My major roles and responsiblites include :-

• Database Programming.
• Query Optimization with efficient use of various DDL and DML statements.
• Automating various processes by Stored Procedures and Functions.
• Data Analyzing.Designing, architects, and building MySQL databases after determining business requirements in order to create logical models, building physical models, and plan system architecture.
• Logical & physical design of the database, creation of tables, views, triggers, procedures and other database objects.
• SQL programming to perform data troubleshooting and data manipulation tasks.
• Data profiling, metadata analysis, data modelling and relational schema design.
• Generation of various strategic reports.
• Creating automated reports using bash, PHP.
• Addressing Performance, Scalability and efficiency issues with large data.
• Designing and managing huge Database Structure and efficient use of Mysql storage engines in designing of tables.
• Administering of InnoDB, MyISAM, Memory, Partition, Federated, archive, Blackhole and other table types.
• Scheduling various archival processes.
• Handling more than 50 production database servers and high volume MySQL database administration.
• Setting up replication environment (master-slave and master-master) and Managing Master-Slave replication issues, Error Handling, Managing Disk Space Issues.
• Understanding and experience in disaster recovery, planning and implementation.
• MYSQL comprehensive backup and recovery solutions.
• Performance Tuning /Query Tuning.