We provide IT Staff Augmentation Services!

Dba Associate Resume

0/5 (Submit Your Rating)

NY

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 DB2v9.5 and DB2v10.5 structures in Production, Staging and Development environments on AIX platforms
  • 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 noledge 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 few AIX maintenance support.
  • Monitor database performance to identify database configuration, hardware, andSQLquery tuning opportunities
  • Worked on HADR set up on production environment.
  • Experienced in data movement utilities like export, import and load including loading data.
  • Handled oncall rotations and actively participated on Enterprise Releases.
  • Monitor DB2 database using Infosphere Optim Performance Manager Tool, a product of IBM.
  • Auditing DB2 database usage to estimate the growth for capacity planning effort.
  • Executed the DDL and DML scripts as per the customer request.
  • Worked on performance tuning with dbm cfg parameters.
  • Worked on AIX shell scripting for some automated jobs.
  • 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,DB2v10.5 IBM Products (Open System) IBM DB2 UDB, V7 through V9.5, AIX 6.1,Replication, Control Center, SQL, Event Monitor, Triggers, Audit Facility, Stored Procedures, HADR, DB2 Administration tool,IBM’s OPM tool.

PROFESSIONAL EXPERIENCE

Confidential

DBA Associate

Responsibilities:

  • Performed DBA tasks in a DB2 environment across unix platform
  • Involved into updating procedures, functions, triggers, and packages based on the change request.
  • Developed, implemented, and supported a number of finance applications.
  • Hands on experience on setting up HADR and working with HADR failovers\
  • Worked closely with the Developers to change sql to be compatible with AIX federation standards.
  • Performing Refresh of development and test databases with production copy as per Application or Client Requirement.
  • Handling oncall rotations,and actively participated 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.
  • Worked on DDL and DML execution as per requirement.
  • Working closely with AIX and SAN team as per requirement of SAN across production environment.
  • 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 and on redirect restore as required
  • Tuning the long running sql’s using db2explain, db2advis utilities
  • Have an excellent oral and written communication skills as well as the ability to interface with management, clients etc.
  • Worked on load, import,reorg and export of data as per requirements.
  • Worked on store procedure runs across lower to prod environments.
  • Working closely with AIX team during maintenance.
  • Maintained and documented lessons learnt and best practices.

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.
  • Writing UNIX Shell scripts to run batch jobs, to connect to database server onAIX, to executeSQLqueries onAIX, to connect toDB2-LUWDatabase server onAIX, and to executeSQLqueries on theDB2-LUWserver
  • 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.

Confidential, 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. unedSQLin various programs, along with data propagator us sync databases. Environment included UDBDB27.3AIX, Mainframe, and NT
  • 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.
  • Maintained and monitored memory usage of AIX servers during oncalls.

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 TEMPthan instances and 1000 databases in TEST, DEV and PRODUCTION Environment.
  • Perform general technical troubleshooting 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 Coordination with System Administrators and Network Administrators to achieve zero downtime 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.

We'd love your feedback!