Manish S.

Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration. • Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions. Implementing SQL Server security and Object permissions. • IT industry performing Database Administration, Design and Development using SQL Server 2005/2008 R2/2012. • Performance Tuning like execution plan, joins, indexes, Query optimization, Client / server connectivity. • Excellent experience in installation and configuration MYSQL in UNIX/LINUX and Windows environment. • Experience Deploying, automating, maintaining , performance, scalability and security of productions systems. • Experience of leading a project of migrating and upgrading large MS SQL Server,Mysql database. • Database Administration on 24x7 critical production and large databases for MS SQL Server and MySql • Experience in MS SQL Server and Mysql database Import, Export, replication and high availability database clustring • Experienced in MS SQL Server and Mysql query optimization and table indexing • Proficiency and expertise in Backup and Recovery, Disaster recovery PTR and planning of Mysql and MS SQL Server Database • Experience in database Table partitioning to improve I/O access. • Experience with replication and clustring configuration in MySQL • Expertise with Shell Script, java backend, C# application integrations & development. • Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, SQLSERVER. • Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance. • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities. • Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints. • Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as frontend. With different project development model like SDLC etc. • Expert of writing shell scripting, Perl script for Linux/Unix. • Sound understating of project Management. • Involved in client Production Support and Maintenance - Tasks including programming, debugging and testing of existing applications that run in a production environment for purposes of remediation system errors or to extend application life span. • Good analytical, problem-solving skills, verbal and written communication skills.Expertise on technical documentation as project plan, development strategy, user manual test.