We provide IT Staff Augmentation Services!

Dba Associate Resume

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: 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, Long Island City, NY

DB2 DBA

Responsibilities:

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

Hire Now