DB2 and SQL Server DBA
This is a candidate registered on Gulfoilandgas.com. To contact this candidate you need to purchase a subscription.
Education: 5
Experience: 7 years
Relocation: Yes - Internationally
Career Objective
Looking for some challenging opportunity where I can utilize my experience in the field of Database administration.
Professional Experience
• Total 7 years of IT experience and around 5+ years into DB2 Database administra-tion, which ranges from setting up environments on the Development, Test and Production layers.
• Good exposure on Insurance, Healthcare and Automotive domains.
• Good client handling skills.
• Well versed with the Onsite-Offshore functional model.
• Responsible for quality assurance, metrics, audits and project management reviews.
• Good team management skills. Currently leading the people in different service lines.
• Experience in ITIL Process (Incident and Change Management)
Technical Skills:
• DB2 V8.2, DB2 V9.5, V9.7
• AIX, Linux, Windows
• SQL Server 2008
• SAP BASIS Administration
• TSM
• Shell scripting
• JAVA/J2EE(JSP, Servlet), JDBC
• ANT
• Maximo, Managenow
Eductation
• Master of Engineering (M.E) from Govt. College of Technology, Anna University with an aggregate of 72.4%.
Certification
Certification Details:
• IBM Certified Database Associate (730) - DB2 9 Fundamentals.
• IBM Certified Database Administrator (731) - DB2 9 DBA for Linux UNIX and Windows.
Additional Information
As a Database administrator I am responsible for:
• Building Development, Quality Assurance, Integration, Staging Database environments for the customer.
• Creating objects (Tablespaces, Tables, Views, and Indexes) based on the application team request.
• Backups and recovery whenever needed.
• Restoring databases based on the requirement
• Working with export, import, load utilities to manage table data.
• Creating Federated Servers to access different data source.
• HADR Setup.
• Replication setup.
• Data movement from Mainframes to UDB.
• Using RUNSTATS, REORGCHK and REORG to enhance application performance.
• Carrying out any performance analysis by taking snapshot in case of any performance degrades.
• Supporting database issues for different environments which had been setup.
• Installing db2 clients.
• Fixpak was successfully applied for all servers.
• Performed migration from version 8.2 to 9.5 for all Development, Quality Assurance, Integration, Staging servers and was well planned and executed successfully.
• Installation of DB2 instances on AIX test servers.
• Creating EXPLAIN tables and running the visual explain utility on SQL statements.
• Creating Instances and databases and updating DB/DBM configuration parameters based on the requirement.
• Recovering data to a prior point in time.
• Deployed all application releases in time and completed successfully.
Hot Categories
Chemicals
Batteries