Summary:

• Over 7 years of qualitative experience in the diverse areas of Database Administration with emphasis on DB2 UDB LUW Database.
• Worked in test, development and production Databases in LUW environment.
• Create, Maintain and Manage the UDB DB2 Physical Database 9.x structures in Production, Staging and Development environments.
• Develop/Implement/Maintain Database utilities to support RDBMS implementations with minimal guidance.
• Planning for Strategic Design which can support high volume transactions, Design using appropriate Data Models and Implement the best possible Database Infrastructure for Enterprise wide Applications to run efficiently.
• Excellent knowledge of Database Backup and Recovery of very large databases
• Performed Installations, Upgrades, Maintenance, Monitoring, and Performance Tuning on databases in Production and non-Production environment
• Worked on HADR set up on production envionment.
• Experienced in data movement utilities like export, import and load including loading data.
• Handled oncall rotations and actively partcipated on Enterprise Releases.
• Monitor DB2 database using Infoshpere Optim Performance Manager Tool, a product of IBM.
• Auditing DB2 database usage to estimate the growth for capacity planning effort.
• Demonstrated aptitude towards root cause analysis, problem identification and resolution of day-to-day issues.
• Eagerness to learn and understand new things and environment.

Technical Skills

• Systems Unix IBM AIX 6.1, Linux 5.5, Windows 2003,2008
• Tools Packages DB2 UDB Enterprise Server Edition, MS Office-2000/Xp/PowerPoint, Dhristi Tool for Analysis
• RDBMS DB2 v8.1, DB2v9.5 IBM Products Open System : IBM DB2 UDB, V 7 through V 9.5, AIX 6.1,Replication, Control Center, Event Monitor, Triggers, Audit Facility, Stored Procedures, HADR, DB2 Administration tool,IBM's OPM tool.

Professional Details

Confidential

DBA Associate

Responsibilities

• Performed DBA tasks in a DB2 environment across unix platform
• Developed, implemented, and supported a number of finance applications.
• Hands on experience on setting up HADR and working with HADR failovers
• Performing Refresh of development and test databases with production copy as per Application or Client Requirement.
• Handling oncall rotations,and actively particiated on Enterprise Releases.
• Pretty hands on experience with oracle environment like db failovers
• Worked closely with application managers, planning data requirements to avoid data redundancy and provide a highly integrated data environment.
• Working closely with SAN team as per requirment of SAN across production environemnt.
• Working on IBM tool OPM Infosphere Optim Performance Manager for better performance analysis.
• Worked closely with IBM by attending meetings and raising PMRs for any problem solution.
• Performing backup and recovery.
• Have an excellent oral and written communication skills as well as the ability to interface with management, clients etc.
• Worked on load, import and export of data as per requirements.
• Worked on store procedure runs across lower to prod environments.
• Maintained and documented lessons learnt and best practices.

Technologies: DB2 UDB v8.1, DB2v9.5, DB2 UDB LUW Enterprise Server Edition , OPM v5

Confidential

DBA Associate

Responsibilities

• Performed DBA tasks in a DB2 environment.
• Developed, implemented, and supported a number of finance applications.
• Participated in all aspects of the application design and building process.
• Led data modelling sessions, created logical data models that were then transformed to physical models for implementation.
• Educated developers by suggesting where utilities should be used by applications in order to handle very large volumes of data.
• Worked closely with application managers, planning data requirements to avoid data redundancy and provide a highly integrated data environment.

Technologies: DB2 UDB v8.1, DB2v9.5, DB2 UDB LUW Enterprise Server Edition

Confidential

DB2 DBA

Responsibilities

• Maintained documentation and coding standards, lessons learnt best practices, and quality improvement documentation.
• Provided performance and application tuning.
• Managed backup and recovery procedures.
• Managed space management and other database maintenance procedures in development, test and production environments.
• Collaborated with about 40 developers to exploit database technology which significantly reduced coding effort and time to project delivery.
• Managed the maintenance and administration of the DB2 UDB LUW 7.1 and 8.2. There were 10 DB2 UDB databases.
• Planned, designed, tested and implemented upgrades for the databases.

Technologies: DB2 UDB v8.1, DB2v9.5, DB2 UDB LUW Enterprise Server Edition

Confidential

DB2 Administrator

Responsibilities

• Responsible for Installation, Upgrading, Migration of DB2 Servers.
• Monitoring Tuning database performance using DB2 Tools Utilities.
• Work as part of a team and provide 7x24 supports for all servers
• Maintaining Production , Test and Development Databases
• Performing Refresh of development and test databases with production copy as per Application or Client Requirement.
• Taking export of all tables as per client requirements.
• Have resolved Problem tickets of different severities during production support.
• Executed the DDL and DML scripts as per the customer request.
• Attended regular customer meetings and precisely reported the weekly and monthly status in different calls.
• Performing backup and recovery.
• Cataloging Databases on various nodes.
• Frequently worked with cron scheduler jobs.
• Have a good exposure on Replication , Installing Fixpak, DB migration from v8.1 to 9.5 on LUW environment, run Audit checker scripts as a per of Health Checks.
• Maintained more than 200 to 300 instances and 1000 databases in TEST, DEV and PRODUCTION Environment.
• Perform general technical trouble shooting and give consultation to development teams
• Monitoring and performance tuning of the databases.
• Reorganization of tables and Indexes.
• Creating database objects for the new setup.
• Monitoring the database growth on the basis of report.
• Monitoring periodic backups status for all databases
• Have worked on XML sided by sided with the developers as per client request
• Good Co-ordination with System Administrators and Network Administrators to achieve zero down time and better server performance.
• Have an excellent oral and written communication skills as well as the ability to interface with management, clients etc.
• Have even Attended MIR's and Audits which were all successful.

Technologies: DB2 UDB v8.1, DB2v9.5, DB2 UDB Enterprise Server Edition