SUMMARY

• A Professional with over 12+ years of IT experience as a Database Administrator (UDB EE/ESE/EEE) and as a Database Architect with extensive experience in design, administration, maintenance, installation, migration and performance tuning using DB2 UDB on UNIX(AIX, Solaris, Linux, HP - UX) and Windows (NT,2000,XP).
• Seasoned application database administrator with strong technical skills on SQL Server 2000 and Oracle 8i/9i/10G.
• Performed Database, Analysis, physical and logical Database Design, Creation, Performance Tuning, Security, Backup, Recovery, Installation, Upgrades and development on AIX/Win NT systems.
• Experienced IBM DB2 DBA having experience with Data Propagator Replication (DPropR) and also poses good experience with SAP R/3.s. Expertise in both OLAP & OLTP systems.
• Created Database, Instances, Database Partition, Schemas & Archival Logging Implementation
• Installed IBM DB2 UDB EE/EEE and ESE for AIX/NT server, Administration tools like Control Center, Command line Processor, Script Center, and Alert Center.
• UDB DB2 Database installations starting from V6.1/7.1 EE and EEE/8.1 ESE V9.x (9.1 & 9.5) V10.x (10.1 & 10.5. Done migrations from UDB DB2 V6.1 to V7.1 & UDB DB2 V8.2 to DB2 V9.1 & V9.7 to DB2 V10.1 upgraded multiple databases to V 9.7 V10.1 v10.5.
• Performed Database maintenance, backup, recovery, restore and moving the data between different databases/servers
• Performed database monitoring, tuning, maintenance of logs, problem identification (db2diag.log) and resolution, security and disaster recovery planning
• Troubleshoot and fix both development and operational systems (Development/Testing and Production)
• Used database maintenance utilities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT, EXPORT, DB2LOOK, DB2MOVE
• Designed and Implemented databases in ERP Application environment like SAP, PeopleSoft and Siebel
• Performed monitoring and fine-tuning of database for optimal performance of SQL queries using DB2EXPLAIN
• Excellent expertise in Logical and Physical relational/dimensional modeling using Erwin
• Administrator with expertise in 24X7 Application/Production Support Database Administration environment on DB2 EEE (AIX), Data warehouse, SAP R/3, Enterprise Portal and PEOPLESOFT platforms
• Experienced in Data ware housing tools like Informatica, Data stage
• Proficient in designing, developing and implementing multi-terabyte Data Warehouse and Data Mart Business Intelligence systems
• Performed application, Stored Procedures, system architecture design using ER/Studio
• Worked on DB2 Data Warehouse, Multi Partition Databases and ETL methods
• Worked on DPROP, transferring data from various databases such as Oracle with DB2 and maintaining a connection Protocol
• Provided technical database support to different development sections of CresSoft, which included installation and administration of Oracle Database Server, Oracle Application Server, and DB2/UDB databases on Solaris and Windows NT
• Configured user privileges by configuring SYSTEM AUTHORITIES (SYSADM, SYSMAINT, SYSMON) parameters
• Experience on replication using Replication Center
• Knowledge of working with federated objects
• Good knowledge on High Availability Disaster Recovery (HADR)
• Monitored DB2 using BMC Patrol, Visual Explain or Access plan and Tivoli Monitoring
• Created User accounts and User groups with AIX and NT authentication
• Established and Maintained DBA monitoring and reporting standards to ensure compliance with applications at service levels
• Implemented federated access from one DB2 Database to another
• Used Bash, Ksh, Perl, Awk and Sed for scripting and massaging the data
• Experience on writing Shell Scripts for running database scripts and deploying DDL, DML SQL scripts
• Provided 24/7 support for Production Database and Application Database
• Performed Overall Database Management and Quality Assurance
• Coordinated with Business Applications and IT infrastructure Staff as well as business partners to ensure ongoing data needs are met and data security risks are minimized
• Database maintenance for development, and synchronizing it with the production database
• Performed Database Space management
• Database security & Audit Design, test & implementation
• Have done all necessary administration on the OS AIX, Linux, Solaris and Windows for Database boxes

TECHNICAL SKILLS

Operating Systems: AIX 5.2/4.3, Solaris 2.8/2.7/2.6, Linux 8.x/7.x and SCO-UNIX 5, Windows NT, W2K.

RDBMS: DB2 UDB V 10.5/10.1 9.7/9.1 , 9.1/8.2 7.x, 6.x V8.2 ESE, EEE & all Earlier Versions, SQL Server 2005, Oracle 8i/9i/11i/10g.

Data Warehouse: Informatica, Cardonet, SAS Data Warehousing.

Languages: C/C++, JAVA, Cobol, JCL, PL/SQL, PERL, KORN, CICS, UNIX, REXX, KSH and Bash.

Tools: DB Artisan, Exceed, Erwin, BMC, DPropR, Rational Rose, ODBC, SQL*LoaderExport/Import, Server Manager, Enterprise Manager, Control Center, CLP, Quest CentralVeritas Volume Manager, Quest Foglight, ER/Studio and Smitty.

ERP: SAP (4.0b, 4.6b, 4.6c), PeopleSoft 8.3, Siebel

PROFESSIONAL EXPERIENCE

Confidential, WI

SR DB2 DBA Administrator / Database Encryption Expert

Responsibilities:

• Implemented InfoSphere Guardium Data Security and Vormetric tool for Encryption of all the Database in the Environment which includes DB2 SQL Oracle.
• Lead for the Encryption project and involved in Configuration and Setup of Encryption devices.
• Created and managed “keys” within the DSM (Data Security Manger) and applied, via specific policies, to hosts that run the Encryption Expert Agent software.
• Implemented various functionality On the InfoSphere Guardium Agent software like DSM (Data Security Manger) Initial Setup, Add Data Security Manger Console Users, Data Security Manger Upgrade Procedure, Data Security Manger Backup & Restore, Clustering the DSM for High Availability, Exporting and Importing Symmetric Keys, Key Rotation, Policies, Troubleshooting.
• Key member on the Various project (Flash G, HCM) on planning and Implementing as DB2 DBA.
• Used Flash copy Backup and restores Technology on the 6 TB Database IN HD Environment.
• Upgraded the Db2 V9.1FP4 to v10.5FP2 On all various applications (SAP, TIM/TAM PORATAL etc..).
• Involved In Build of Db2 V10.5 on Aix on power 7 Blade with os level v7.1.
• Involved in Post Upgrade of the Db2 activities like Configure and automatic memory management (STIMM), Configure recommended settings for this fixpack V10.5 FP2, Configure online backups,
• Configure file system caching, Configure maintenance.
• Worked on the 6 Partitioned Data Warehouse (EEE) databases with analysis, design, creation and maintenance.
• Advanced knowledge of DB2 ESE (EEE) in a UNIX-based data warehouse environment and perform administrative tasks under partitioned databases, such as: increasing tablespaces, checking applications status, creating backups, performing restores.
• Implemented disaster recovery of a highly transactional OLTP environment with HADR and TSA (Tivoli Software Automation).Used root authority on the test servers and produced a step-by-step documentation to implement both HADR and TSA across the primary and the standby clusters.
• Automated the Daily Online backups to TSM, Manually Archiving the Logs to TSM in case of backup failures, setting up the TSM prams for the Redirected restore.
• Extracting the backup image of one database and redirecting to another database from TSM to disk.
• Configuring and fine tuning DB2 DBM and DB configuration parameters for better response, throughputs and proper utilization of Global memory.
• Handled Db2 Database on SAP Environment, Implemented the SAP Notes on the Database.
• Experienced in using Imports, Exports, db2move utilities on the schema level and table level.
• Checking the AIX performance on frame/blade using LPAR2RRD tool by monitoring the processor, memory, and disk.
• Worked on physical and logical designing, performance monitoring, maintenance, query analysis, optimization, backup, recovery, replication and migration.
• Proactively managed multiple databases in Production, Development, and QA environments.
• Extensively used DB2 utilities like RUNSTATS to collect table and index statistics and REORG to reorganize tables and indexes to improve access and storage efficiency
• Handed over the work & methodology to offshore team.

Environment: DB2 V 10.5/10.1/9.7/9.1.3/8.1.5 , AIX 5.3/6.1/7.1, SAP Environment ECC BW AP0, Db2 data ware house, InfoSphere Guardium Data Security and Vormetric tool, InfoSphere Warehouse Enterprise Edition v9.5/9.7,Ldap database, IBM Web sphere Commerce Suite, DB2RC (DB2 Replication Center), Tivoli Storage Manager (TSM), DB2 Control Center

Confidential, Boston, MA

Sr. Database Administrator

Responsibilities:

• Installed new DB2 subsystems on Solaris SAP based environments
• Write design specifications, security plans, data migration plans, and Architecture guidelines
• Performed Overall Database Management and Quality Assurance
• Data Architecture, Data Modeling, getting specifications from business analysts and Marketing groups
• Setup and modified database manager configuration parameters and database configuration parameters
• Performed Loading and Unloading of data
• Performed day to day tasks on R/3 and BW environment (Development/Testing and Production)
• Supported database activities in implementing Dual Landscape in Production and Development phases
• Performed Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Maintained Instances, databases, table spaces, in DB2UDB for developers
• Used db2look, db2move, import/export and load utilities to move structure and data between different environments
• Installed fixpaks and kept DB2 at most recent level to overcome application issues and utilize new functionalities
• Supported High Availability in Production and Quality Analyst Testing Environment through Failover Schemes
• Performed Database restoration from crash recovery using point-in-time restore roll forward recovery
• Performed Data modeling (logical and physical data modeling using ERWIN)
• Experimented with Indexes and employed Index Advisor to improve user report and speed ETL runtime
• Used REORGCHK, REORG and RUNSTATS to optimize system performance
• Performed backup, restore and migrating data between different databases/servers
• Migrated databases from V 8.2 to V 9.2 in UNIX environment
• Cleaned up Transaction log as and when needed
• Worked on High Availability Disaster Recovery (HADR) setup on production servers using Log Shipping mechanism
• Designed/Management of an HACMP cluster for the current production environment
• Executed shell scripts to perform redundant data base activities
• Created scripts to monitor table space thresholds deadlocks lock waits
• Extensively involved in performance tuning of complex SQL queries for better performance
• Captured Explains for the SQL queries and modified them to reduce the timerons
• Worked with AUTOSYS teams to establish critical day to day activities
• Administered user groups to execute certain fenced routines and functions
• Performed Database sizing, table spaces, indexes and log spaces design & implementation
• Provided Database security & Audit Design, test & implementation
• Worked on applications which required Extract, Transform and Load data from different subsystems into Data Warehouse and Data Mart
• Used Informatica as an ETL tool to Extract, Transform and Load data to flat files extracted from the operational database and exported to the data warehouse setup
• Provided data security solutions with the help of Informatica
• Designed, developed and implemented multi-terabyte Data Warehouse and Data Mart Business Intelligence systems
• Setting up DB2 UDB/Solaris production and development environments
• Created/modified korn shell scripts for database log pruning backup/restore of databases and SAP system start/stop
• Used BW accelerator to boost query performance
• Installed SAP application servers for the components CRM5.0 and applied OSS notes support packages
• Setting up all SAP system environments for backup/restore and log file management using TSM for ERP scheduled via TSM scheduler
• Upgrading of kernel and applying patches on SAP central instances
• Provided support to DBG SAP Basis team in performing day to day database activities
• Creating Stored Procedures, Functions, Packages and Database Triggers for Database and Application uses
• Used Quest Central for DB2 tools to administer and to modify the database and database parameters
• Used Cognos 8 BI data integration to provide data merging, extraction, transformation, and dimensional management
• Improved performance of business queries by generating a Cognos BI metadata model from a DB2 multi-dimensional model
• Worked with IBM Support to resolve database issues and communicated with them to resolve database and SQL performance issues
• Administered Solaris for Database boxes

Environment: Solaris 9, DB2 UDB 8.2/9.2, SAP R/3, CRM 5.0, BW, Data warehouse edition, Quest Central, UNIX Shell Scripts (Ksh), Erwin, Windows, Cognos, Informatica, BW accelerator, Data stage.

Confidential, NYC, NY

DB2 UDB Database Administrator

Responsibilities:

• Created and maintained the instances and databases in development test staging and production environments
• Installed DB2 UDB ESE/ESE with DPF on AIX and Linux servers.
• Installed the latest fixpacks and kept DB2 at most recent level to overcome bugs and utilize new functionalities.
• Installed new DB2 subsystems on UNIX, SAP based environments.
• Monitored the databases using db2pd tool in UDB v8.2
• Supported and maintained DB2 UDB ESE with DPF data warehouse environment for monthly loads
• Troubleshoot and fixed both development and operational systems (Development/Testing and Production)
• Developed shell scripts for installing DB2 software, configuring instances, creating databases, replicating DB2 database
• Granting and revoking access to a large number of users, resolving user access related problems
• Working with Logical and physical data modeling using ERWIN and ER/Studio
• Designed and implemented database with Database partitioning feature(EEE & DPF)
• Set up and modify database manager configuration (DBM) parameters and database configuration (DB) parameters
• Data Architecture, getting specifications from business analysts and Development groups
• Responsible for backup, restore and moving the data between different databases/servers
• Database sizing, tablespaces, indexes and log spaces design & implementation work
• Database security & Audit Design, test & implementation
• Worked on installing DB2 and applying Fix Packs
• Experimented with Indexes and employed Index Advisor to improve user report and speed ETL runtime
• Used REORGCHK, REORG and RUNSTATS to further performance goals
• Used DPropR replication tools to transfer data remotely in a secured fashion
• Moved the company's data infrastructure from early pilots to robust, revenue-generating, operational systems
• Migrated databases from V 8.2 to V 9.2 in UNIX environment
• Creation of Database Objects, Tables, Table spaces, Indexes and Storage group
• Created Buffer Pool objects to cache database data pages in memory and reduce the physical I/O access to disks
• Extensively involved in performance tuning recommending SQL queries for better performance
• Extensively used Quest Central and Db2advis for creating indexes on tables to improve query performance
• Developed automated scripts using Unix Shell and Perl for performing RUNSTATS, REORG, rebind, backup, load export and other related to database activities
• Handled On-line Backups On-line reorgs without bringing the database down
• Handled Off-line Backups for weekly maintenance activities by bringing databases down
• Used EXPORT IMPORT and LOAD utilities and moved data between tables and output files
• Analyzed user requirements to design star schema to implement Data Mart
• Involved in the homogeneous migration of database for changing of schemas on R/3 platform
• Supported users in various SAP modules like IS-T, HR- Event and Training Management and likewise
• Supported SAP R/3 and Enterprise Portal environment
• Responsible for backup, restore and migrating data between different databases/servers
• Performed Database sizing, table spaces, indexes and log spaces design & implementation work
• Provided Database security & Audit Design, test & implementation
• Performed Initial Space estimation & created Database and associated objects using BMC
• DB2 monitoring using BMC utilities
• DB2 management using Quest Central
• Performed HACMP troubleshooting, and administration
• Monitoring the health of the databases, tablespaces, bufferpools by running different health monitor scripts
• Database tuning to release memory allocated but not used by the database
• Database restoration from crash recovery
• Setting up USEREXIT programs for log archiving to TSM disk and shipping logs to fail-over server and applying the logs using Roll-forward
• Setting up Incremental Backup
• Involved in dumping node wise table data and schema changes
• Specified the isolation level in DB2 database to minimize deadlocks and improve concurrency level among applications
• Performed requirement analysis, capacity planning and prepared study document
• Set up DB2 UDB/AIX production and development environments
• Database maintenance for development, and synchronizing it with the production database
• Database Clean up (development database) scripts (Unix Shell Scripts, Cron, & SQL) for automated clean up every week
• Administered AIX for Database boxes

Environment: AIX 5L/4.3, DB2 UDB V8.x/9.x, SAP R/3, Erwin, Rational Software Architect, Clear Quest, REXX, UNIX Shell Scripts (Ksh) and BMC Utilities Data Stage 7.0, 7.5 enterprise edition.

Confidential, Plano, TX

DB2 UDB Database Administrator

Responsibilities:

• Creation of multiple DB2 UDB EEE instances on AIX
• Involved in Migration from V8.1 EE database to V9.1 DPF database. Had lot of challenges during cutover time while moving close to 1 TB of data using High Performance Unload and load utility
• Performed Replication using DB2 DPROPR source DB2 UDB to Oracle with Data joiner and gateway
• Tuned the database logging parameters to ensure that application volumes are met
• Compared logical and physical domain models using ERWIN and RSA
• Involved in regular day-to-day administrative tasks, supporting developers, Production support, Problem solving and solution complete Database Design and Modeling
• Experimented with changing buffer pools and table space page size to improve time taken by ETL to build data marts
• Experimented with indexes, and employed Index Advisor and Visual Explain, to improve user report performance and speed ETL run times. Performed REORGCHK, REORG TABLE and RUNSTATS for performance
• Worked with developers to improve their report SQL (generated by Micro strategy 7i) through analysis of access paths. Supported developers in the development of very large SQL statements involving in some cases ten or more table joins with left outer joins, nested SQL, and other high performance features. Worked with them on indexes, database configuration, and SQL rewrites
• Used DB2audit to develop reports on kinds of SQL run on database
• Used DB2audit utility to track changes in the database, the time it occurred along with users committed that change to maintain SOX security compliance
• Specified the isolation level in DB2 database to minimize deadlocks and improve concurrency level among applications
• Tuned db parameters like (MAXLOCKLIST, DLCHKTIME, and LOCKTIMEOUT) to minimize DEADLOCKS in the application level
• Supported SQL included large joins, global temporary session tables, mass updates, left and full outer joins, nested queries, insert triggers, sub queries, common table expressions, materialized query tables (summary tables), mass updates, and case expressions
• Performed high volume IMPORT, EXPORT, INSERT and LOAD
• Performed Logical Design and Physical Design of the database using RSA
• Creation of Node groups and Partitions
• Configuring Client-to-Server Communications by Cataloging and Un-cataloging nodes
• Fine tuning the databases, if there are any problems relating to performance issues using DB ARTISAN
• Loading the monthly updates into the production
• Developed a batch process to purge data automatically from the archived location after certain period of time
• Performed offline and online backup on a regular basis
• Involved in maintenance activities for Websphere Application server Websphere MQ LDAP server and Portal server
• Automated the generation of recovery jobs using REXX
• Created shell scripts for the automation of Backups, RUNSTATS, REORGCHK, REORG & space monitoring
• DB2 Monitoring using BMC Utilities
• Creating Stored Procedures, Functions, Packages and Database Triggers for Database and Application users

Environment: DB2 UDB v8.x / V9.x, AIX, BMC, IBM RSA, Erwin, DB ARTISAN, Replication and Migration Tool Kit, Export/Import, DB2DPROP, ETL, SQL Explain, REXX, Websphere 5.0, Shell Scripts Windows NT 4.0, DPROP, ERWIN and Tivoli Monitoring, Erwin Data Modeler and SQL*LOADER.

Confidential, Detroit, MI

DB2 UDB DBA

Responsibilities:

• Wrote design specifications, security plans, data migration plans, and Architecture guidelines
• Installation of DB2 UDB EE Product on AIX, Windows NT including DB2 Connect
• Creating and updating of admin (DAS) instance, DB2 instance (DBM) and databases
• Design and creation of database and database objects
• Data Architecture, Data modeling, getting specs from business analysts and Marketing groups. Determine scope, project timelines, and resources for enterprise class data migrations and re-engineering projects
• Troubleshoot and fix both development and operational systems (Dev/QA and Production)
• Move the company's data infrastructure from early pilots to robust, revenue-generating, operational systems
• Lead a phased Oracle to DB2 UDB migration including a major data cleans up
• Trouble shooting Data Propagator replication (DPROPR) in associating with all Control tables and Source Table, Apply and capture Problems
• Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, table spaces, rollbacks, indexes, data files & logs)
• Backup & Recovery procedures Design, Test & implementation using Shell Scripts & SQL
• Database security & Audit Design, test & implementation
• Set up DB2 UDB/AIX production and development environments
• Database maintenance Production 24x7 with zero down time
• Database Clean up (development database) scripts (UNIX Shell Scripts, Cron, & SQL) for automated clean up every week
• Have done tuning (SQL, application, Memory)
• Set up database manager configuration parameters
• Generated ERD for the database using Erwin
• Has done all necessary administration on the OS AIX, Sun Solaris and Windows for Database boxes. Create and maintain file systems/ users

Environment: AIX 4.3, Solaris 2.7, Linux 7.1, Data Propagator replication (DpropR), Windows, DB2 UDB 7.2, Erwin, Power Designer, Rational Rose, BMC, C++, UNIX Shell Scripting (Ksh, Bash) and PERL

Confidential, Baltimore, MD

DB2 UDB DBA

Responsibilities:

• Write design specifications, security plans, data migration plans, and Architecture guidelines
• Performed Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, materialized query tables, problem identification and resolution, security and disaster recovery planning
• Data Architecture, Data modeling, getting specifications from business analysts and Marketing groups
• Supported Clients on existing DB2 platform v8.2, v7.2 running on Windows 2000 and 2003 Server
• Implemented different Database Maintenance Plans to accommodate 24X7 applications using HACMP failover
• Monitor and schedule OPTILOAD jobs from OS/390 to EEE Data warehouse
• Migrating the company's data infrastructure from early pilots to robust, revenue-generating, operational systems.
• Automated Database backup and archive logs on to TSM
• Resolved application locking problems in WAS environment
• Performed database level parameters like MAXLOCKS, LOCKTIMEOUT to minimize deadlocks
• Created MDC and MQT have to get optimum performance of the SAS-Online Reporting Applications
• Maintained logical and physical data models
• Performed Overall Database Management and Quality Assurance
• Trouble shot Data Propagator replication (DPropR) in associating with all Control tables and Source Table, Apply and capture Problems
• Database security & Audit Design, test & implementation
• Performed monitoring and fine-tuning of database for optimal performance of SQL queries using DB2EXPLAIN
• Set up DB2 UDB/AIX production and development environments
• Performed routine Reorg, Runstats on tables and Indexes to optimize performance
• Created Type II indexes to increase concurrency level and facilitate row level isolation
• Generated ERDs for the database using ER/Studio
• Responsible for maintaining the repository for all the databases (production/dev/QA)
• Create users accounts and maintained file systems/ users
• Granting and revoking access to a huge number of users, resolving user access related problems by using iSeries Navigator
• Database maintenance 24x7

Environment: AIX, Linux, AS/400,Data Warehouse, DB2 on i5/OS V4R3, Data Propagator replication (DPropR), Windows, WAS, Erwin, ODBC, Enterprise Manager, DB2 UDB, Oracle, Query Patroller, ER Studio, Power Designer, iSeries Navigator, BMC, Cognos, C++, UNIX Shell Scripting (Bash).

Confidential, Princeton, NJ

DB2 UDB DBA/Data Security Admin

Responsibilities:

• Physical designing and creating the databases in UDB
• Data information integrator V 8.1 installation and configuration
• DB2 Client Installation and Migration for a very large environment. Used Response File Installation to silently install DB2 client across multiple nodes
• Supporting the development people in resolving the database related issues
• Writing Shell scripts to automate some of the database administration activity like backup, recovery, monitoring, table space reports, file system usage, and virtual memory and CPU usage
• Performance Tuning, Monitoring Hardware, Database and SAP Basis involving Technical Optimization and Application Tuning
• Configure AIX environment for the NEW SERVER for DB2 and SAP. Configure Dynamic Links, soft links
• Working with Logical and physical data modeling group
• Performed Disaster Recovery Planning for the database
• Designing and developing the relational database using ERWIN Data Modeler tool
• Replicating data across various sites using Data propagator (DPropR)
• Configure Database Manager and Database Parameters and Buffer Pool Sizes
• Scripted stored procedure and Database Triggers as and when asked by the developer team
• Granting and revoking access to a huge number of users, resolving user access related problems
• Establishing security standards and compliance standards
• Logged and Archived Database Logs
• Continuous monitoring of compliances of the database
• Worked on expensive SQL, Locks, database error longs, and Memory analysis

Environment: UNIX (AIX & Solaris), DB2 UDB 7.2, Smitty, ERWIN, data propagator (DPropR), SAP 4.6c, Exceed, DB Artisan, Power Designer, MS Visio, Replication and migration tool kit.

Confidential

DB2 UDB DBA

Responsibilities:

• Responsible for Data Architecture, Analysis, design, creation, implementation of database
• Configure AIX environment for the NEW SERVER for DB2
• Institute Policy & Procedures for security of highly sensitive business data, and for backup media. Design, Data Modeling, Creation, implementation and maintained data warehouse projects
• Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, control files & data files)
• Physical Database design for optimum performance including tablespaces (tables/indexes) and log spaces design & implementation work
• Backup & Recovery procedures Design, Test & implementation using Shell Scripts & SQL
• Database maintenance (Production 24 x 7) for web applications (crosscommerce.com)
• Database maintenance for development, and synchronizing it with the production database
• Monitored space requirements with BMC space expert product
• Database Clean up (development, QA database) scripts (UNIX Shell Scripts, PERL, CRON, SQL) for automated clean up every two weeks
• Achieved significant gains in the performance of SQL queries against the database typically brought the execution time to less than 5 minutes for never ending queries
• Created AIX Korn shell scripts to collect production databases comparative resource utilization metrics on DB2 v.6 and v.7 environment
• Have done data load, and updating of the underlying table well within one hour for 2,800,000 rows

Environment: DB2 UDB 7/6.1/5, Erwin, BMC Solaris 2.7, AIX 4.3, Rational Rose, Java, Web LogicCardonet, UNIX Shell Scripting (Ksh), Automated Hot Backup, Cleaning Archived Files, and PERL