OBJECTIVE

To obtain a position where I can strive for Excellence in the field of software development with dedication, focus, proactive approach, positive attitude and passion. And to utilize my knowledge and skills in the best possible way for the fulfillment of organizational goals.

WORK EXPERIENCE

DB2 UDB DBA (Confidential, Boston, MA, USA) Aug 2010 Present

Working on installations of PEOPLESOFT UPGRADE project where the backend databases are on DB2. Migrated DB2 UDB V8.2 to DB2 DB V9.7 on AIX 6.1 from 32 bit to 64 bit code. Woking on Implementing a server right from scratch like- Installaling, Creating instace, database, tablespaces, tables, indexes & views along with installing IBM DB2 Client on AIX and windows platforms. Migrated databases acrpss subsystems to create working environmnets for development, test and production. Tuning the database using db2advis, dblook, visual explain and other DB2 tools like db2move IMPORT, EXPORT and LOAD. Monitored and scheduled tasks through Crontab. Verified the output files to ensure the tasks were successful or not and resolve the issues. Involved in taking both online, offline incremental backups (compress) of the datases and restoring the databases from the backup copies. Running the import, export and load scripts and sent the log files development team. Extending the table spaces sizes and increasing the logical volumes of the containers. Improving the performance of the database by tuning the database memory parameters like sorts, heaps, sizes, logfilsz, utility heap size and running REORGCHK, REORG, REBING, RUNSTATS on databases. Providing 2/7 Production environment Monitoring, Diagnosing and Trouble shooting. Addtionally assisting all the day to day activities assigned by TeamLead like running scripts from peoplesoft tools etc.

Environment: DB2 UDB V8.2/9.7, AIX 6.1, WIN NT/2000, Peoplesoft

DB2 UDB DBA (Confidential, Tampa, FL, USA) Nov 2009 Jul 2010

Work closely with development team to review and analyze database requirements for OLTP, data warehousing and reporting & analysis applications. Interfaced with system administrators and development project team on a daily basis in handling change requests and for incorporating new functionality. Design and implement data migration plan for Frontier North Databases. Migrate databases across subsystems to create working environments for development, test and production. Involved in data analysis to ensure accuracy and completeness of data. Responsible for capacity planning for adequate storage and file system layout. Responsible for fine tuning of databases and poorly performing queries. Providing 24/7 Production environment Monitoring, Diagnosing and Trouble shooting. Performed online and offline backups for both incremental and delta type on different applications. Performed database recovery using restore and redirected restore from both command center and control center. Also performed crash, version and roll forward recovery. Level 3 support for daily Operations for Frontier Databases. DB2 UDB EEE Database administration and support. Logical and Physical Database design. Experience with Linux (RedHat) and data replication. Altered tables and added check constraints and referential integrity. Created and maintained databases, table-spaces, tables, views, and indexes. Participated in enterprise-wide application and database production releases. Compressing the backup copies of the databases and sending them to Netbackup and make sure the older copies are sending to Netbackup to avoid disk full situations. Developed shell scripts to handle DBA tasks and alerting systems. Documented plans and procedures in terms of backups, restores and disaster recovery. Improving the performance of the database by tuning the database memory parameters like sorts, heaps sizes, catalog cache, package cache, utility heap size and running REORGCHK, REORG, REBIND, RUNSTATS on databases. Tuning application queries, databases and systems for best performance. Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots.

Environment: EEE V 8.1/9.1/9.5, DB2 Connect, IBM Websphere 6.1/5.1, AIX 5.2/5.3, Windows NT/XP, Linux, TSM 5.3, Netbackup, Tools BMC Patrol, Event Manager & Performance Manager Portal.

Database Administrator,Dallas, TX (Confidential, , USA) Aug 2008- Oct 2009

Design, build or maintain web sites, using authoring or scripting languages, dynamic content creation tools, management tools, and digital media. Write, design or edit web page content to direct others producing content. Document design specifications, installation instructions, and other system-related information. Evaluate current or emerging technologies to consider factors such as cost, portability, compatibility or usability. Identify system data, hardware, or software components required to meet user needs. Identify, analyze, and troubleshoot DB2 and Oracle database performance problems and perform disaster recovery for clients. Involved in Database design, performance monitoring and tuning using snapshots and event monitors, query analysis, optimizing backup and recovery, migration, writing SQL queries, stored procedures and packages and triggers.

Student Worker (Confidential, LA, USA) Jan 2008- July 2008

Database Developer (Windows, MySQL, PostGreSql, Linux):was involved in designing and programming of databases, tables, views, functions, indexes, triggers, and stored procedures; monitoring database instances; database migrations; creating statements in JDBC; managing server connections.

Teaching Assistant (Confidential, LA, USA) Jan 2007-Dec 2007

Taught Advanced Operating Systems & Database Management Systems. Assisted undergraduate students in Many Math Courses.

DB2 UDB DBA (Confidential,Hyderabad, INDIA) Jan 2005 Dec 2006

Provided support for development, test and production environments including setup of new instances, databases and objects within the database. Supported production implementation and migration of database objects. Monitored/tuned DB2 systems, upgraded servers following change process and procedures. Worked on database catalogs, load, import, export, backups, restores and redirected restores. Assisted in problem determination and resolution to DB2 server and application related functions. Assisted Project Manager with project plan that involve DB2 tasks. Installed DB2 UDB ESE, DB2 Connect Server, Runtime Client on client machines. Applied regular fixpaks, alternate fixpaks and special builds on DB2 Client (CAE), DB2 UDB and DB2 Connect. Worked on SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots. Created and Monitored Users, authorities and responsibilities and password management. Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities. Monitored and managed disk space, I/O contention & DWE. Experience with ETL/ELT concepts and data replication. Designed and implemented backup and restore procedures. Monitored databases using database monitors, snapshot monitoring and event monitoring. Generated reports of database statistics using DB2LOOK Utility. Recovered data to a prior point in time using ROLLFORWARD command. Implementing capacity planning and partition table/index for very large and fast growing tables. SQL tuning and query optimization. Tuned application, database and system for best performance. Day-to-day attending to the user queries in sorting out database problems. Coordinating with user departments and attending their requirements for smooth functioning. Involved in granting various authorizations and privileges to different users. Upgraded instances regularly with latest fixpaks and alternate fixpaks. Worked extensively with restores, redirected restores and Unicode conversions. Setup and monitored replication between operational database and reporting database. Setup User Exit for archival logging.

Environment: DB2 EE V 7.1/8.x, IBM Websphere 5.0, AIX 4.2/5.0, Windows NT, DPROP, TSM, DB2 Connect

Internship (Confidential, India) Dec 2003-Dec 2004

Analyst/Designer/Developer (Java, Servlets, JSPs, Struts and UML design): was involved in maintenance of Web Apps for several projects by fixing issues generated by help desk team and manager; committing changes to Company; supporting backend programmers in testing new features by developing GUI; documenting existing and new Web Apps using UML as design method.
Desktop Application (Java, Perl, MS Access, and UML design): developed an elegant automated desktop programs to support team leaders in their monthly activities, who does manually, of downloading large files from ftp server to databases in their local system; executing queries, generating reports and archives, and submitting them to accountants.

EDUCATION
Masters in Computers and Mathematics

TECHNICAL SKILLS
Languages: Java, C, C++, Perl, PHP, Ruby, HTML, XHTML, JavaScript, PL/SQL, XML,
UML 2.0, Python
Database: MySQL, Oracle 10g, MS-Access, PostGreSql 8.2.
Desktop Application: Applets and Swing.
Web Technology: JSP, Servlets, JSF, My Faces, spring, ibatis, Hibernate, HTML, XHTML, JavaScript, AJAX, Ruby on Rails, REST
Design Patterns: Front Controller, Business Delegate, Data Access Object, Session Facade, Dispatcher view, Service Locator.
Web Development Tools: Dream Weaver, Flash, Photoshop, MS FrontPage and Fireworks
Engineering Tools: PSPICE, MATLAB, LabView
Web Containers: Tomcat 5.0, Mongrel, Web rick, and JSWDK
Tools: DB2 utility tools, BMC Patrol, TSM, Quest Central
Operating Systems: Windows XP, Linux, UNIX, Windows and MSDOS
Others: MS Office Suite, SSH, FileZilla

RELEVANT COURSE WORK

MASTERS OF SCIENCE - Math Courses ( Numerical Analysis, Advanced Calculus) , Design and Analysis of Algorithms, Operating Systems/Advanced Operating Systems, Computer Organization, Networking, Data Mining, Network Security & Cryptography, Parallel Processors.

BACHELORS OF ENGINEERING - C and Data structures, Database Management Systems, Object Oriented Programming Language, Computer Architecture, Internet Protocols, Switching theory and logical Design, Artificial Intelligence, Neural Networks, Embedded Systems, Information Tech & Numerical Methods, Logical Integrated Circuits, Digital Image Processing, Introduction to Computer Networks and Internet, Intranet Technology, Software Engineering Projects.

TECHNICAL PAPER PRESENTATIONS

• Presented paper on Intelligent Game Playing using Neural Networks at VRKW College of Science and Technology.
• Presented paper on WiMAX at Vidhya Jyothi Institute of Science and Technology

PERSONAL SKILLS

Quick to grasp new ideas, concepts and technologies and to develop practical solutions to problems and issues. Possesses excellent interpersonal and communication skills and the ability to develop and maintain productive relationships with clients, colleagues and subcontractors alike. Enjoys being part of, as well as managing and motivating, a successful and productive team and thrives in highly pressurized and challenging working environments.