SUMMARY

• Over 8.2 years of IT experience with emphasis on Database Administration, development, migration, Business Requirements Analysis, Application design, testing, implementation and maintenance of databases on DB2 UDB EE and DB2 UDB EEE on UNIX and Windows Platforms
• DB2 UDB Architecture/Server knowledge
• Migrating DB2 UDB databases and applying fix packs to keep DB2 at most recent level
• Database migration from V9.7 to V10.5 with Minimum downtime using Q Replication.
• Working with partition databases(DPF) with 32 Partitions
• Experienced in implementing High Availability Disaster Recovery (HADR with TSA) and HACMP Strategy, DB2 SQL replication, Federation, Performance monitoring and fine tuning OLTP Applications, and Problem determination and troubleshooting, interacting with UNIX and Application group, and playing a diverse role with a large team of DBA’s.
• Experience is on DB2 v8, DB2 v9, DB2 v9.5 and DB2 v9.7 and DB2 V10.5 Performance Tuning, Database Administration, Monitoring/Alerting System Implementation and Standardizing teh process with respect to administration.
• Perform database maintenance activities such as backup, reorg, runstats, rebind
• Design implement SQL replication in CCD replication and db2 queue replication using WebSphere MQ
• Installing DB2 on AIX on Linux, HPUX, Solaris & Windows
• Installing DB2 Connect on Linux, HPUX, Solaris & Windows
• Enabling DB2 Compression to save disk space
• Writing Scripts for Monitoring MySql and Galera Cluster databases
• Configuring SQL and Q Replication Setup
• Worked on applying fixpaks, database restoration
• Assisting with teh creation and modification of primary database storage structures (table spaces) and primary objects ( tables, views, indexes)
• Proactively monitor performance, diagnose problems and tune queries and database.
• Scripts to automate teh scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
• Configuring MySql replication between master and Slave Server’s
• Taking Snapshots and gathering other information related to teh database and teh system during stress tests or performance tuning.
• Enhance teh loading performance to meet teh desired standards.
• Managing table spaces, Creating Users, Profiles, roles and granting to users based on requirements.
• Automating daily backups and weekly full backups.
• Monitoring teh database health, system resource usage and so on.
• Manual intervention/loading of data from source systems incase tables are found to be out of sync.
• Database backup strategy and Recovery scenarios.
• Using Export/Import utilities for data export/import between different databases.
• Experience in writing scripts using Unix shell script
• Atomization of tasks like generation of monitoring reports, tuning reports, etc.
• Worked on enhancements of systems and change of code for teh changing requirements from teh client side
• Added value to teh project by publishing different plans so dat our process failures do not affect teh Business at any time.
• Writing Shell scripts to avoid all teh manual efforts in teh application.
• Created databases on Solaris Box whenever client required.
• Taking backup using Export and Import utility.
• Table space administration and monitoring teh Database.
• Testing teh scripts and migrating into teh Production Environment
• Resolved various tickets pertaining to EE and EEE issues.
• Help teh developers to formulate teh queries.
• Recovered data to a prior point in time.
• Automated teh backups, Reorgs, Runstats, Space monitoring, moving teh db2diag.logs, monitoring teh size of teh table spaces by setting up a threshold (70%) etc.

TECHNICAL SKILLS

Operating System: Windows 98/2000/NT, UNIX

PROGRAMMING SKILLS: Shell scripting, C, C++

RDBMS: DB2 UDB v8, v9.5, V9.7, V10.5, Oracle 9i, MySql, Galera DB, Postgresql

Tools: DBI Brothers, Toad, IBM Warehouse Manager, Control Center, Command Editor, Task Center, Quest central, Abinitio basics

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Provided production support for .COM database running on 24/7 basis
• Migrating DB2 UDB databases and applying fix packs to keep DB2 at most recent level
• Design implement SQL replication in CCD replication and db2 queue replication using WebSphere MQ
• Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning
• Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of WCS database applications
• Familiarity and experience with WCS data modeling
• Excellent analytical and functional skills with strong communication and interpersonal skills. Actively involved in teh full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges
• Writing Shell Scripts to avoid manual efforts in monitoring .COM Database
• Supporting MySql DBA tasks
• Writing Scripts for Monitoring MySql and Galera Cluster databases
• Performing all DBA Activities on MYSql databases
• Configuring MySql replication between master and Slave Server’s
• Performing backup and restore on MySql databases
• Automated teh backups, Reorgs, Runstats, Space monitoring, moving teh db2diag.logs, monitoring teh size of teh table spaces by setting up a threshold (70%) etc.
• Federated database server creation in order to allow access of another databases (DB2 or non - DB2) inside a DB2 database.
• Version migrations from DB2 V8.2 to V9.1 and V8.2 to V9.5 and V8.2 to V9.7
• Performing SQL Replication to replicate tables
• Enabling Federation Database feature to access tables from other LUW database
• Enabled Q Replication to replicate entire database for Reporting purpose. This reduced overload on .com database
• Database migration from V9.7 to V10.5 with Minimum downtime using Q Replication.
• Currently Testing DB2 Native Encryption tools in Test Server’s

Confidential

Responsibilities:

• Administration of more TEMPthan 40 DB2 UDB database servers including HACMP clustering with SAP applications
• Installing DB2 on AIX & DB2 Connect on Linux, HPUX, Solaris & Windows
• Performing Flash copy and debugging any issues in database
• Migrating database from lower version to higher version
• Worked with data movement utilities IMPORT, LOAD, EXPORT and DB2MOVE under high volume conditions.
• Creating MQT tables and refreshing it.
• Database creation as per user request
• New Instance builds on OLAP and OLTP environments.
• Database restores including redirected restores within production, stage and development environment as per user request.
• Used RUNSTATS, REORGCHK and REORG to enhance application performance
• Scheduling backups and tablespace report in cron jobs
• Responsible for moving Stage/Development database objects to production and vice versa
• Checking DB performance bottlenecks and fixing teh same.
• Tuning memory and db and dbm parameters.
• Tuning long running queries in OLAP and OLTP environments using db2advis, db2batch, and db2explain.
• Raise PMR and interacting with IBM support team to resolve various database issues
• Tuning for better performance of database and application
• Checking DB performance bottlenecks and fixing teh same.

Confidential

Responsibilities:

• Provide 24X7 on-call support to troubleshoot issues with teh Production schedule.
• Perform capacity planning and analysis and implement required changes on teh database server.
• Loading all kind of corporate card transaction details into Data warehouse, which contains more TEMPthan 400 loads.
• Worked on enhancements of systems and change of code for teh changing requirements from teh client side
• Familiar with tools like QUEST CENTRAL, LOAD, IMPORT, EXPORT, DB2 Connect for moving data within or from one database to another.
• Writing Shell scripts to avoid all teh manual efforts in teh application
• Created databases on Solaris Box whenever client required.
• Atomization of tasks like generation of monitoring reports, tuning reports, etc.
• Using Export/Import utilities for data export/import between different databases.
• Highly involved in performance tuning like performing REORGS, RUNSTATS on teh database tables frequently and tuning SQL Queries and REBINDING them to teh database.
• Taking backup using Export and Import utility.
• Table space administration and monitoring teh Database.
• Tuning of memory structure like shared pool, data buffer cache.
• Testing teh scripts and migrating into teh Production Environment
• Loading all kind of corporate card transaction details into Data warehouse, which contains more TEMPthan 400 loads.
• Working on teh Problem tickets.
• Added value to teh project by identifying teh processes dat involved manual intervention and provided optimal solutions for teh same thereby decreasing teh time spent on it, which in turn increased teh efficiency of teh employees.