Summary:

• Experience of more than 6 years in Database Administration, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration.
• Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySql DBA.
• StrongMySqlandSQL Serverskills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Expertise with Shell Script, & development.
• Experience in the administration of Web based Internet/Intranet Client/Server multi - tire distributed application, major in database technologies in Consulting, Sales & Finance, Telecom, Quality & Standards domains.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases:MySQL, Oracle10g,MySQL Workbench tool.
• Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Experienced inPerformance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, db optimization with the help ofexplain plan.
• Expertise in database migration fromMyISAM format to Innodb storageengine 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 Waterfall, Agile, SCRUM etc.
• Expert of writingshell 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.
• Experienced with Requirements gathering, data modeling, System Architecture, Feasibility studies, Scope Documents & requests for proposal (RFP).
• Good analytical, verbal and written communication skills.
• highly motivated with strong commitment to quality and customer service.
• Strong in solving problems of diverse scope where technical analysis and evaluation is required
• Good Team Player.

Technical Skills:

RDBMS: MySQL 5.5,MS SQL SERVER 2000/2005/2008, Oracle 10g,MS Access

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor(DTA), Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Jobs and task creating and scheduling, MS Visio, Crystal Reports 10.0, SQL reporting, SSIS.

Programming Languages: SQL, TSQL, XML, PL/SQL, C, VB 6.0, Perl, HTML, XML.

Web Tools: MS-Front Page, Internet Information Server (IIS), FTP, TCP/IP, LAN, MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/XP/NT 4.0, Linux, Novell Netware, MS-DOS.

Professional Experience:

Confidential, Columbus, OH

MySQL DBA

Responsibilities:

• Administration and management of the entire development,QA and production environment.
• Installed and configured MySQL on Linux and Windows environments.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication as part of HA solution.
• Designed databases for referential integrity and involved in logical design plan.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Proficiency in Unix/Linux shell commands.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Created data extracts as part of data analysis and exchanged with internal staff.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Documented all servers and databases.
• Database engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment.
• ERStudio for database architecture design.
• Shell script is being used for some data migration and backend work management.
• Supporting management with different database related decisions.
• Handling Release management and user acceptance.

Environment: MySQL 5.6.2, SQL Server, Sybase, Oracle10g.

Confidential, Bloomington, IL

MySQL DBA

Responsibilities:

• Provided 24x7 on call production support
• Worked as an MySQLDBA, my responsibilities, included Databases support to developers and users, Monitored sysdba privileges, O.S authentication, passwords, privileges, register for security update using metalink, worked with sys admin to close unnecessary open ports, used secure protocol, used password to protect listeners also audit users log on/ log off created/ dropped objects and capturing the actual sql statement that was issued rather than only the fact or the event occurred.
• Also my responsibilities is to make sure that the parameters set up properly so we don't end up with memory swapping (cash area large enough) sized redo log so is not switching every 2 second, using tuning advisors, putting packages in memory that we executed often rather than loading them over and over. Created snapshot of the database every couple minutes and analyzed what is going on during that time. Used oracle optimizer mechanism which allows us to figure out what execution path to take on sql statement. Eliminated database contention (locks, latches and wait event).
• Regular logs usage review.
• Regular Database Monitoring, using Grid Control (Oracle &MYSQL).
• Review status of nightly Database and Application Server incremental backup reports. (Oracle &MYSQL) Work with system administrator on any issues.
• Verify database backups for exports and hot backup emails.
• Verify free space host availability on (backup/archive) directories.
• Monitored the database size and increased the size when required, analyzed the database tables and indexes and then rebuilt the indexes if were fragmentations in indexes.
• Check completion results for any scheduled jobs, corns or data processing including refreshes.
• Review daily invalid object reports for all databases.
• Verify and confirm applications, databases and application servers are operational and functioning normally by monitoring OEM, server processes, automated e - mails, etc.
• Created users, allocation of appropriate tablespace quotas with necessary privileges and roles for MYSQLdatabases.
• Build Bitmap indexes and created materialized views for data warehouse project.
• Turned the Flash Recovery Area on to backup oracle databases from any logical corruptions (table, index ) that making the backup faster.
• Responsibilities also, included removing row chaining for better performance deciding the naming conventions of datafile, redo log file, tablespaces and segments.

Environment: MySQL 5.1.6, PHP MyAdmin, PHP 4.x, 5.x, NDB Cluster, Web Services, Shell Script, Apache, LINUX.

Confidential

MySQL DBA

Responsibilities:

• Monitor database operations.
• Installation of Nagios monitoring tool, setting of different alert level to different parameters (System, Memory and Hard disk).
• Setting up alert and level for MySQL (uptime, Users, Replication information, Alert based on different query).
• Setting up alert and level for Application (Port/Binary running).
• Estimate MySQL database capacities; develop methods for monitoring database capacity and usage.
• Develop and support MySQL database replication (Active-Passive, Active-Active(MMM))
• Develop and optimize physical design of MySQL database systems.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Tune and optimize the performance of all the staging and production database instances.
• Develop stored procedures, Functions and triggers in support of application development.
• Participate in application development projects and be responsible for the database architecture and design.
• Develop application-specific fault-tolerant distributed database mechanisms.
• Synchronization of replicated database.
• Benchmarking of database and servers.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• On-call support to users.
• Participate in the creation of development, staging and production database instances, and the migration of those instances from one environment to another.

Environment: MySQL 5.1.4, PHP, Shell Script, Apache, NDB Cluster, LINUX 5.0, 5.1.