Database Data
Resume:
Anjaneya Raju
Email:
********.*.****@*****.***
Ph: 551-***-****
Summary:
Around six years of experience in software design, development, testing,production and maintenance of secure, internet/intranet and client-server
applications, proficient in designing, modeling, creating and maintaining
the MYSQL database. Possess excellent communication, interpersonal and
analytical skills, self motivated, creative and a team player.
Professional Summary:
. Ability to work 24x7 operation to support production environment
. Expertise in MYSQL and PHP admin installations, configurations, MYSQL
backup/recovery and administration.
. Good knowledge in import, export, snapshot, optimization using analyze
and explain plan.
. Strong knowledge in database performance strategies and tuning MySQL
Databases.
. Knowledge in Physical and Logical Database design, development &
implementation.
. Experience in developing, programming, and testing numerous projects
in a variety of languages including, C, C++, Bash Script, HTML, PHP,
SQL, PostgreSQL and others.
. Proficient in developing and maintaining of functions, procedures,
triggers, tables, indexes using MYSQL database programming language.
. Expertise in converting all databases from MyISAM format to Innodb
storage engine to improve referential integrity as well as to increase
performance.
. Knowledge on MYSQL database clustering.
. Expertise in performing query analysis of troublesome and slow queries
and provided suggestions to improve query optimization.
. Expertise in setting-up replication for disaster and point-in-time
recovery.
. Extensive knowledge in Installing and maintaining MYSQL on windows and
UNIX based systems.
. Experience in upgrading MYSQL from 4.1 to 5.1 and above.
Certification:
Mysql 5.0 CMDBA certification
Technical Skills:
Databases: Oracle 8i, Oracle 9i, Oracle 10g, MYSQL 4.0, 5.0, 5.1,
PostgreSQL, MS.sql server 2005/2006
Languages: SQL, PL/SQL, Java, UNIX Shell Scripting, Perl Scripting, PHP 5,
C, C++, HTML, XML
Development Tools: SQL*PLUS, PL/SQL Developer, SQL Impact, SQL Loader,
Export/Import Utilities, web content 2.0 management tool, MYSQL
administrator, MYSQL query browser
Operating Systems: Windows (98/2000/XP), Solaris (5.6/8/9/10), UNIX, Red
Hat Linux (7/9), MS-DOS
Application Servers: Apache HTTP Server 2.2.6
Work experience:
WellPoint, Richmond, VA
APR'10-Till Date
MYSQL DBA
WellPoint is the nation's leading health benefits company serving the needs
of more than 33 million medical members nationwide. The project is to
design database strategy for open connect who is maintaining claims data on
MySql server.
Responsibilities:
. Designing a backup and recovery strategy
. Writing shell scripts for backup automation of server/database.
. Scheduling the backups process using crontab
. Create the logins to the server and users to the appropriate databases
. Create the objects and granting appropriate permissions on them to the
groups
. Documented all database servers, database processes.
. Monitoring/Repairing MyISAM, Memory and InnoDB tables. Good
understanding of the tradeoff of using those table engines based on
client applications requirements
. Collecting and analyzing performance metrics to determine sources of
bottlenecks
. Using explain plan for analyzing and improving the performance of the
databases
. Adjust MYSQL config parameters to increase performance
. Monitoring and optimizing the performance of the database
. Performed Data server error log monitoring - to trace and identify
issues reported by MYSQL servers within production.
Environment: MYSQL 5.0.28,Linux,perl/shell scripting
Fortify infrastructure services
NOV'09-Mar`10
MYSQL DBA
Client: VIACOM, New York, NY
VIACOM a leading global entertainment content company, that delivers
products across the globe through television, motion pictures and a wide
range of digital media. The family of prominent and respected brands
includes the multiplatform properties of MTV Networks, BET Networks,
Paramount Pictures and Paramount Home Entertainment
. Creating and maintaining multiple MYSQL instances that support
replication.
. Creating the new databases from existing databases.
. Create the logins to the server and users to the appropriate databases
. Create the objects and granting appropriate permissions on them to the
groups
. Refreshing data between the instances.
. Start/stop MYSQL instances when there are changes in the configuration
file.
. Publishing the code from DEV/QA to live
. Setting up replication for backup, disaster recovery purpose and high
availability.
. Cloning the replication to balance the loads, read-only and reporting
purpose
. Automate the various MYSQL process using perl/shell scripts.
. Scheduling the backups and refresh process using crontab.
. Using Nagios Server Monitoring, MySQL Enterprise Monitor to monitor
the servers
. Support and co-ordinate the offshore team by guiding them through the
various MYSQL process.
Environment: MYSQL 5.0.45,nagios,Linux,cactai,perl/shell scripting
Cricket Communications, Inc, San Diego, CA
May `09 - OCT' 09
MYSQL DBA
Cricket Communications is the affordable wireless carrier, with great deals
on cell phones and cell phone plans. Cricket offers unlimited local
calling, unlimited US long distance, unlimited text messaging, and
unlimited picture messaging.
Responsibilities:
. Modelling the databases from logical to physical state inorder to meet
the bussiness requirements based on the usage.
. Involving with database architects in designing the databases and
normalising the data.
. Converting database tables from MYISAM to INNODB storage engine to
maintain refrential integrtity, ACID compliance, and foreign keys and
to increase performance.
. Monitoring/Repairing MyISAM, Memory and InnoDB tables. Good
understanding of the tradeoff of using those table engines based on
client applications requirements.
. Creating Views, Triggers, Stored Procedures, Stored Functions for
various applications and maintain good coding practices.
. Installing and configuring the MYSQL database servers.
. Performing Back Ups using mysqldump, ibbackup on regular basis.
. Migrating data from oracle to Mysql.
. Disaster Recovery Preparations and Exercises
. Create the logins to the server and users to the appropriate databases
. Create the objects and granting appropriate permissions on them to the
groups.
. Grant and revoke the permissions from the users as and when required.
. Using Nagios Server Monitoring, MySQL Enterprise Monitor to monitor the
servers
. Writing shell scripts for backup automation of server/database startups
and deleting aged trace
. Create and maintain MySQL replication environments for DR (hot standby)
and reporting, load balancing and HA purpose.
. Performance tuning of MySQL scripts and procedures using different
methods.
. Monitoring and optimizing the performance of the database
. Performed Data server error log monitoring - to trace and identify
issues reported by MYSQL servers within production and development
environments.
Environment: MySQL, PHP, Linux (Red Hat), Windows XP, MySQL Administrator,
Nagios, MYSQL administration tool.
Westone laboratories, Colorado springs, CO
Nov `08 - Apr `09
MySQL DBA
Westone Laboratories is a leading global manufacturer of custom-made
products for the ear. The nearly 50-year-old company makes custom earpieces
for hearing aids, in-ear monitors, communication devices, hearing
protection systems and related supplies.
Responsibilities:
. Creating a flexible filesystem layout to support multiple MYSQL
instances running on a single server that can support replication.
. Managing/Troubleshooting the Master/Slave database servers on a daily
basis.
. Developing scripts to manage and monitor the various MYSQL instances
and databases.
. Designing a backup and recovery strategy.
. Setting up master/slave replication for HA and load balancing.
. Ability to work at MySQL binary logs level
. Designed and performed MYSQL benchmarks for achieving optimal database
performance
. Collecting and analyzing performance metrics to determine sources of
bottlenecks.
. Converting data from logical model to physical model based business
requirements.
. Interacted with application team on normalizing database design by
keeping in view its scope to meet future changes in requirements.
. Working with developers to create and optimize various database
objects and queries.
. Using explain plan for analyzing and improving the performance of the
databases.
. Converting the tables from MYISAM to Innodb storage engines to support
referential integrity and transaction for better performance.
. Writing extensive documentation on the design and implementation of
this new architecture.
. Created, tested, and maintained PHP scripts, PostgreSQL programming,
forms, reports, triggers and procedures for the Data Warehouse.
. Training colleagues on the details and nuances of MYSQL
administration.
. Upgrading the MYSQL servers from 4.1 to 5.1 versions.
Environment: MySQL, PHPMyAdmin, Linux, Erwin tool, Pentaho
Letstalk, North Richland Hills, TX
Jun `07- Sep `08
MySQL DBA
Letstalk is a cell phone and accessories company that is committed to
provide the best customer experience in the industry. This website offers a
wide range of cell phone with their plans and features. This web-based
application is developed for online sales for all kinds of wireless phones.
Responsibilities:
. Discovering the Disaster Recovery machines that were down, time out of
sync or even in wrong time zone and correcting the same.
. Modelling the databases from logical to physical state inorder to meet
the bussiness requirements based on the usage.
. Involving with database architects in designing the databases and
normalising the data.
. Fixed master db character-set and collation issue with utf8 by adding
init_file in my.cnf setting utf8 parameters correctly whenever the
database is started.
. Advising the team to sort a MyISAM source table by primary key before
converting it to InnoDB, saving much time in the conversion process.
. Advising the team their InnoDB log files are too small and to up them
from 90Mb to 200Mb, eliminating mysql warnings in the error log.
. Monitor and advise developers on database performance and slow queries.
. Provide the developers with a nightly 24-hour snapshot of slow query
performance.
. Providing support in solving web related problems and made web service
available for users withou any issues.
. Adjust MYSQL config parameters to increase performance.
. Explore methods outside MYSQL to improve database performance, Solid
State Disk.
. Discovered causes and offered solutions to team to always maintain
slave in sync with the master.
. Perform code reviews on slack role updates and scripts such as database
backup scripts.
. Create scripts for automating processes as well as updating slack roles
as necessary .
. Assisted developers locally and abroad via e-mail/chat or the MYSQL
users' mailman group with SQL, performance issues, ODBC, mysqldump and
installing the server.
Environment: PHP 5.0, MySQL 5.0, phpMyAdmin 2.7, Linux, Erwin, pentaho
Bio-Engineered Supplements and Nutrition Inc (BSN), Boca Raton, FL
Feb'06-may'07
Mysql DBA
Bio-Engineered Supplements and Nutrition, Inc. (BSN) was formed in order to
provide the most unique and effective products, scientifically engineered
to enhance peoples' physique, figure, physical performance, and sense of
well being
Responsibilities:
. Applied performance tuning to improve issues with a large, high-
volume, multi-server MySQL installation for job applicant site of
company.
. Converted all databases from MyISAM format to Innodb storage engine to
improve referential integrity as well as boost performance.
. Performed query analysis of troublesome and slow queries and provided
suggestions to improve query optimizations.
. Setup replication for disaster and point-in-time recovery.
. Replication was used to segregate various types of queries and also
simplify backup procedures.
. Setup scripts to monitor MySQL process list and replication status.
. Enhanced backup system to report on failures and to be aware of binary
logging status. The pages were sent if the slave in the replication
environment was running more than x number of seconds behind the
master, pointing to the inability of the slave to keep pace with the
master server.
. Upgraded all servers from MySQL 4.1 to 5.0. Standardized all MySQL
installs on all servers with custom configurations.
. Used CVS to keep various versions of the MySQL configuration files for
the multiple database servers.
. Performed security audit of MySQL internal tables and user access.
Revoked access for unauthorized users.
Environment:
PHP5, MySQL 5.0, MySQL GUI Tools, DB Designer, LAMP, Window XP, MS Visio.
Softcum Systems, Hyderabad, India
May'04- Dec '05
Softcum systems, a Software firm started in the new millennium is a
complete IT and Business solutions provider. My work was basically focused
on monitoring multiple MySQL DB servers at the backend of the website.
Project 2:
DR.Reddy's pharmaceuticals
Mysql DBA
Dr. Reddy's is providing affordable and innovative medicines for healthier
lives. The company serves society's important needs for affordable
medicines through the API component of PSAI and the Global Generics
business, and for innovative products that solve unmet medical needs
through the CPS component of PSAI and the Proprietary Products Businesses.
Responsibilities:
. Created script to be able to modify all MYSQL instances enterprise-
wide.
. Increase database performance utilizing MYSQL config changes, multiple
instances and hardware upgrades.
. Monitor database disk space utilization as well as recommend and
acquire more space as required.
. Optimize queries for developers as well as end-users running ad-hoc
queries.
. Performing backup and recovery on regular basis using MYSQL dump.
. Worked with MYSQL Support to resolve bug issues and add enhanced
features/functionality to MYSQL.
. Documented all database servers, instances and databases.
. Performed query analysis of troublesome and slow queries and provided
suggestions to improve query optimizations.
Project 1:
Society General Global Solution Centre Pvt. Ltd.
MySQL DBA/DEVELOPER
Responsibilities:
. MySQL database administration on a large scale MySQL installation.
. Created primary database storage structures, i.e. table spaces,
database objects, users and roles.
. Assisted with sizing, tuning, backup and recovery, installations,
upgrades and security including other administration functions.
. Monitored sessions, performance and free space
. MySQL processes and queries optimization. Exported and Imported
database 10g objects from development to production.
. Controlled user privileges and roles such as granting and revoking
privileges and roles, allocation of resource limits and table space
quota for users
. UNIX shell programming and customizing scripts for automating regular
maintenance, batch jobs.
. Performance tuning of MySQL scripts and procedures using different
methods.
. Diagnosed database corruption problems and hanging issues and
proposed solutions.
Environment: PHP, UNIX Shell scripting, Perl 5.6., MySQL
Education:
Bachelors of Engineering from MADRAS UNIVERSITY APR'04
Contact this candidate