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.