Software: TMON, Omegamon, ERwin Data Modeller, CA tools (Platinum Products),IBM Utilities, BMC tools,DB2 Connect, Spufi, QMF, VSAM, Endevor,File-Aid, MQ series,VB Demo, CA7īachelor of Technology in Electronics and Instrumentation |Andhra University, India. Languages: VS COBOL II, REXX, JCL,CICS,PL/I. Operating System: z/OS, z/VM, Windows, UNIX. IBM Certified DB2 V9 Database Administrator (for z/OS). Proficient in Insurance and Telecom domains. Ability to work independently or as an effective team player. Experienced in supporting critical production databases and worked on 24*7 production support. Database Administration and Programming experience in maintenance, production support, development and migration projects. Worked with universal table spaces and hands on experience in exploiting the new features of version 9 and version 10 to improve overall system performance. Experienced in working with large tablespaces, processing and maintenance of partitioned tablespaces, NPIs and DPSIs. Co-ordinated and actively worked in database version migrations DBA support team. Knowledge and experience in data modelling, normalization and performance tuning of applications and database design. Proficient in daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job abend issues, locking issues and contentions, scheduling administration activities. Experienced and programmed REXX tools to simplify database administration. Competent and experienced in using IBM utilities, Omegamon and other third party tools like CA/DB2 tools (platinum products), TMON, Omegamon and BMC tools. Extensive experience in utilities and tools used for database monitoring (DB2 traces, online performance monitors, reports, EXPLAIN, DB2 catalog queries), data movement and organization (LOAD,UNLOAD,REORG) ,data consistency utilities and catalog manipulation utilities (RUNSTATS,MODIFY,STOSPACE),etc. 
Worked with remote stored procedure calls. Designed, tested and debugged external and DB2 native stored procedures.Expertise in application development support activities including database design, optimizing SQL queries, building complex SQLs ,dynamic SQLs and triggers, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.Database Administrator for DB2 in z/OS environment for more than 5 years.
#Db2 universal database v8.1 software#
6 years of IT experience in database administration and software programming.
0 kommentar(er)
