SUMMARY

• 8+ years of IT experience encompassing a wide range of skill sets, roles and industry verticals.
• Strong DB2 database administration and development skills.
• Extensive experience of performance tuning at database as well as SQL level.
• Proficient in setting up and maintaining HADR databases.
• Extensive experience in supporting highly transactional databases.
• Expertise in teh installation and setting up of IBM infosphere CDC replication.
• A Senior DB2 UDB Database Administrator wif 5+ years’ experience of DB2 UDB on AIX/Redhat Linux.
• Prepared and executed Rexx programs utilizing various programming languages.
• Installed, configured and maintained BMC and IBM utilities.
• Over 5+ years of specialized experience in AIX Administration.
• Managed RDBMS installation, upgrade, and configuration. Implemented DB2/UDB replication, federation, and partitioning (DPF).
• 4 + years of experience in DB2 UDB LUW administrator. Extensive Knowledge in requirement gathering, analysis, design, development, implementation, testing, integration deployment, documentation and maintenance of IBM Mainframe applications.
• 5 + Year experience in Database Administrator for DB2 v8.xx in z/OS environment.
• Proficient in Insurance and Telecom domains.
• IBM Certified DB2 V9 Database Administrator (for z/OS)
• Proficient in monitoring databases using snapshots, event monitors and database monitoring tools like IBM Optim Performance Manager, Quest & DBI.
• Experience in writing DB2 stored procedures using PL/SQL.
• Experience in DB2 software installation, fix pack installation and database upgrade.
• Experience in unix shell programming.
• Good noledge in IBM AIX hardware components (RS/6000, pSeries), trouble - shooting and maintenance of PC's
• IBM Certified DB2 Database Administrator.
• Experience in working on projects for Retail, Banking, Telecom, Manufacturing and Travel industry.
• Extensive experience of administering ecommerce databases.
• Excellent communication and interpersonal skills.
• Self-motivated, quick learner and a team player.

TECHNICAL SKILLS

RDBMS: DB2 LUW 8.x, 9.x, 10.1, SQL Server 2005/8

Languages: SQL, PL/SQL, Unix scripting

Operating Systems: IBM AIX, Redhat Linux, Windows NT/2000 Server

Tools: Quest, IBM Optim Performance Manager, Foglight, Toad, IBM Data Studio, IBM Migration Tool Kit Data Modeling ERStudio

PROFESSIONAL EXPERIENCE

DB2 DBA

Confidential, New York, NY

Responsibilities:

• DB2 Installation, applying fix packs and upgrading databases
• Monitoring database performance and generating reports for various performance parameters
• Performance tuning at database as well as application/SQL level
• Preparing databases for peak/holiday season readiness
• Server versions ranged from PostgreSQL 7.4 to 8.3
• Responsible for maintaining teh reporting, billing, and invoicing databases (PostgreSQL) (about 125 databases on three servers)
• Organized automated monthly restores (24 databases on three servers)
• Database design review / modification for enhanced performance.
• Data refresh from one environment to another
• Developing and maintaining applications in teh BMC Remedy ITSM Suite - IM, CM
• Setting up and administering HADR
• Setting up and administering data replication using CDC
• Creating test databases and database objects
• Installation and configuration of LPAR's wif AIX 5.3, 6.1 on p5 servers.
• Copying table data using utilities like EXPORT/IMPORT, LOAD & db2move
• Managing Backup and Recovery activities
• Performing regular database maintenance activities (Data purge, REORG, RUNSTAS & REBIND etc.)
• Review and modify database configuration parameters for optimal performance
• Troubleshooting database issues
• Work wif IBM through PMRs for product and complex issues
• Capacity planning
• Preparing and executing production implementation plans
• Performing health checks on databases

Environment: DB2 LUW 10.1/9.7, AIX, SQL, WebSphere Commerce, PostgreSQL, IBM Sterling Order management and Warehouse management, OPM, Quest, HADR,DBMS, CDC, TSM

DB2 DBA

Confidential, Irving, TX

Responsibilities:

• Responsible for Installation, Configuration, support and troubleshooting existing systems in AIX 4.3.3/4.5/5.1 L operating environment
• Analyzed, developed and designed COBOL Codes which interacts wifOracle 10g, 11 g database for customer information systems, debit returns, deposits and loan modules.
• Creation of database objects such as tables, stored procedures, functionsusing PL-SQL wif Oracle database.
• Development of new batch jobs using UNIX shell scripts to interact wifOracle Database.
• Developed reports using COBOL which processes teh incoming/outgoinginterface files from various other applications.
• Designed UNIX shell scripts for automating report generation implementedusing COBOL.
• Utilized COBOL, FTP, PC FOCUS, MICROSOFT ACCESS 97, MS VB6, SYNCSORT, MVS JCL, and FOCUS.Setup and/or upgrade database servers and replication environments (AIX/PostgreSQL 8.3/Slony 1.2.12)
• Managed database instances for Consolidated Online trading system in DB2 UDB in version 8.x and 9.x on AIX 5.3 and Redhat Linux servers.
• Provided DBA 24x7 on call Support for companywide UDB Production databases. Responded and troubleshoot all database related issues and had a 100% on-time resolution for all PROD and DR issues.
• Preparing Technical specifications and implementing teh same.
• Unit testing and preparation of Unit test Specifications.
• Tracking of code versions using PVCS.
• Involved in optimizing EOD and SOD activities, development of batch jobs by writing new shell scripts.

Environment: DB2 LUW 10.1/9.7, AIX, SQL, WebSphere Commerce, IBM Sterling, PostgreSQL Order management and Warehouse management, OPM, JCL, Quest, HADR,UDB, CDC, TSM

DB2 DBA

Confidential, Milwaukee, WI

Responsibilities:

• Converting logical database design into physical design
• Administering various database environments including test, integration and performance
• Creating database objects like tables, views, triggers etc.
• Implemented REXX programs that aid in database maintenance and developed a REXX program to automatically send and receive files from z/VM to z/OS environment and vice versa
• Creating DB2 stored procedures
• Performance monitoring and tuning
• Performing Customizations in teh BMC Remedy IT Service Management (ITSM) Application.
• Manage OEM engagements to design strategies to acquire more business deals.
• Provide an interface wif senior management and junior staff regarding value based product proposal and marketing to ensure optimized OEM Sales.
• Data refresh from one environment to another
• Managing Backup and Recovery activities
• Monitoring databases resources including data space, memory usage, CPU utilization etc.
• Performing health checks on databases

Environment: DB2 LUW 9.7, AIX, Redhat Linux, BMC, SQL, PL/SQL,OEM, ERStudio,z/OS, PostgreSQL

DB2 DBA

Confidential, Irvine, CA

Responsibilities:

• Lead person responsible for installing z/OS 1.7 and setting up a Parallel Sysplex environment that supports large, complex CICS (CPSM) and DB2 (Data Sharing) subsystems. Previously participated in teh installation of z/OS 1.4.
• Support and maintenance of Production, Development and Integration environment databases.
• Monitoring database performance and generating reports for various performance parameters
• Performance tuning at database as well as application/SQL level
• Custom website/database work (PostgreSQL/MySQL/Apache)
• Preparing databases for peak/holiday season readiness
• Database design review / modification for enhanced performance.
• Data refresh from one environment to another
• Setting up and administering HADR
• Provided backup systems programming support for DB2.
• Review and modify database configuration parameters for optimal performance
• Maintaining system security through authentication and database privileges
• Creating test databases and database objects
• Copying table data using utilities like EXPORT/IMPORT, LOAD & db2move
• Managing Backup and Recovery activities
• Provided server and applications administration including IBM AIX P-Series and P5 systems.
• Performing regular database maintenance activities (Data purge, REORG, RUNSTAS & REBIND etc.)
• Preparing and executing production implementation plans
• Performing health checks on databases
• Conducting Root Cause Analysis for database outages and critical issues

Environment: DB2 LUW 9.7, SQL Server 2000/2005/2008, AIX, DBMS, WebSphere Commerce,UDB, Windows Server 2008

DB2 DBA

Confidential

Responsibilities:

• Support and maintenance of Production, Development and Integration environment databases.
• Sole person responsible for installation, customization and testing of z/OS 1.2. Previously assisted in upgrading from OS/390 2.7 to OS/, including required upgrades to numerous OEM products.
• Data refresh from one environment to another
• Managing Backup and Recovery activities
• Migrating databases to higher versions
• Setting up and maintaining HADR
• Maintaining DB2 wif DPF ( Database Partition Feature )
• Troubleshooting database issues raised through Remedy tickets.
• Creating federated objects for data refresh activity
• Performing health checks on databases
• Creation and maintenance of mainframe execution JCL (jobs) to support system replacement project in User acceptance (UAT) and Production environments.
• Work wif IBM through PMRs for product and complex issues
• Performing day to day database administration tasks using utilities like REORG, RUNSTATS, IMPORT, EXPORT, LOAD etc.
• Database design review / modification for enhanced performance
• Responsible for database performance monitoring, tuning and optimization through teh use of snapshots and event monitoring
• Conducting Root Cause Analysis for database outages and critical issues
• Monitoring databases resources including memory, storage and CPU utilization
• Maintaining system security through user authentication and profiles

Environment: DB2 LUW 9, ETL, JCL, AIX 5.3

Junior DB2 DBA

Confidential 

Responsibilities:

• Migrating databases to higher versions
• Setting up and maintaining HADR.
• Experience wif full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• DB2 Connect V9 AIX Runtime Client Installation and migration
• DB2 thin client installation project currently in progress
• DB2 UDB V9 HACMP setup
• Wrote custom websites and database access routines (PostgreSQL/MySQL) for customer websites.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Implementing range, list partitions, hash partitions.
• Creating and refreshing materialized views.

Environment: HP-Unix, UNIX, Linux 4.0. DB2 LUW 9, DBMS, EDW, AIX 5.3