SUMMARY:

• 11 years of IBM experience in System Analysis, Design, Development as Database Administrator in DB2 (UDB 8.0),Z/OS (1.7) OS 390 and DB2 UDB (AIX), Oracle 11g under Liux/Unix, Z/OS, windows, Unix sun OS 5.8/ HP - UX 10.01/AIX/OS 390/NT.
• Install, Configure, Upgrade DB2 UDB server and application tools in Data Warehouse center.
• Worldwide Consolidation Accounting Support on Hyperion databases Confidential Accounts.
• Implement DB2 upgrades, patches and Fixpacks, Configure, monitor HADR configure, monitor and trouble shoot qrep replication
• Manage Tablespaces, tables, Users and other Database Objects on Z/OS.
• Monitor Database operations using unix shell scripts and writing Data sets.
• Setup and Support DB2 Replication on Main Frame/AIX, Data Modeling/Design Databases, Data partition, Data Warehouses (Erwin 3.5.2), SYSPLEX
• Mainframe data replication ( Confidential QREP ), installing and supporting, monitoring.
• Excelent in Shell Scripting (k shell ), Peregrine service center (5.1.0)
• Catalog Manager, Change Manager
• Enroll users, control and maintain user access to the database to maintain security.
• Implement RACF Security using Roles, Privileges, Grants, and Views.
• Monitor and Optimize database for better performance.
• Perform database tuning using Explain Plan, utlbstat/utlestat, and tkprof.
• Timely implementation of Changes, Incidents and Problem tickets steady state support for databases, Curam databases steady state support
• Security & Compliance ( CIRATs, APARs, GSD )
• Implementing Symmetric Replication, Distributed databases across the network.
• Select appropriate INIT.ORA parameters for efficient database operations.
• Use Import, Export, SQL*Loader and other tools to load and backup data.
• Backup and Recovery of Database in case of Crash/Failure.
• Planning and Implementing Data warehouse with Multiple Data marts.
• Planning, implementing data roll-up from live site to data warehouse using (Informatica.)
• Worked with data transformation tools. Ascential Datastage (6)(Administrator, Director, Designer, Manager)
• Create Packages, Stored Procedures and Functions to process data.
• Create Tables, Indexes, Views, Sequences and Database Links to develop applications.
• Support for Production database (24x7).
• Maximo data loader, Loading data and transforming, implementation of large scale data models for Maximo databases.
• Experience in Z/OS operating system, zSeries Hardware, Mainframe Storage Management,IMS DBA tasks and activities,CICS Systems Programming.
• Write PL/SQL code utilizing Cursors, Arrays, Exceptions and Advanced Constructs.
• Experienced with C/C++/ Pro C, JDBC, UNIX Shell Scripting, Power Designer, COBOL II/RMDS, FTP, JCL, CICS, Trim, TSO (M/F), Embarcadero DBArtisan(8.1.5), RACF, REXX
• Recipient of state merit scholarship.

TECHNICAL SKILLS:

Operating Systems: OS/390, Z/OS (1.7), HP-UX 10.01/IBM, AIX, SUN Solaris 5.6/2.6/2.7, Win 3.11, 98, NT 3.5/4, MS-DOS, AS/400, VM, SCO UNIX 5.0.4E, Novell NetWare v4.1, Open VMS 7.1, MVS, NET 8

GUI: Visual Explain for Z/OS(v1.0.11),Developer2000 (Forms 6i,Reports 6i)/Designer 2000

DBA: Mainframe UDB(Z/OS), DB2 UDB (AIX) DBA, Oracle DBA (7, 8i, 9I databases) Sybase ( v8 )

Languages: C/C++/Pro C, SQL, PL / SQL, JDBC, UNIX Shell Scripting, Power Designer, COBOL II/RMDS, FTP, JCL, CICS, Trim, TSO (M/F)

Utilities BMC Amin Tools: Informatica, Peregrine service center(5.1.0), Ascential DataStage (4, 6), SQL*Loader, TSD Tool,Export/Import Enterprise Manager, SQL*Net, TKPROF, Designer /2000, Erwin 3.5.2, Datacom

PROFESSIONAL EXPERIENCE:

Confidential, NY

DB2 ( UDB ) DBA

Responsibilites:

• Install, Configure, Upgrade DB2 UDB server and application tools in Data Warehouse center.
• Worldwide Consolidation Accounting Support on Hyperion databases Confidential Accounts.
• Implement DB2 upgrades, patches and Fixpacks, Configure, monitor HADR configure, monitor and trouble shoot qrep replication
• Manage Tablespaces, tables, Users and other Database Objects on Z/OS.
• Monitor Database operations using unix shell scripts and writing Data sets.
• Setup and Support DB2 Replication on Main Frame/AIX, Data Modeling/Design Databases, Data partition, Data Warehouses (Erwin 3.5.2), SYSPLEX
• Mainframe data replication ( Confidential QREP ), installing and supporting, monitoring.
• Excelent in Shell Scripting (k shell ), Peregrine service center (5.1.0)
• Catalog Manager, Change Manager
• Enroll users, control and maintain user access to the database to maintain security.
• Implement RACF Security using Roles, Privileges, Grants, and Views.
• Monitor and Optimize database for better performance.
• Perform database tuning using Explain Plan, utlbstat/utlestat, and tkprof.
• Timely implementation of Changes, Incidents and Problem tickets steady state support for databases, Curam databases steady state support
• Security & Compliance ( CIRATs, APARs, GSD )
• Implementing Symmetric Replication, Distributed databases across the network.
• Select appropriate INIT.ORA parameters for efficient database operations.
• Use Import, Export, SQL*Loader and other tools to load and backup data.
• Backup and Recovery of Database in case of Crash/Failure.
• Planning and Implementing Data warehouse with Multiple Data marts.
• Planning, implementing data roll-up from live site to data warehouse using (Informatica.)
• Worked with data transformation tools. Ascential Datastage (6)(Administrator, Director, Designer, Manager)
• Create Packages, Stored Procedures and Functions to process data.
• Create Tables, Indexes, Views, Sequences and Database Links to develop applications.