OBJECTIVE:

To secure a promising position in an organization that offers the challenge, an excellent opportunity for growth and a platform for innovation, which help to drive the customer business effectively and efficiently

PROFESSIONAL SUMMARY:

• 11+ years of experience in both OLTP and OLAP enterprise environments
• An Expert in IBM DB2 database technology for SAP.
• DB2 DPF datawarehouse
• DB2 BLU Acceleration Analysis.
• IBM IIDR/CDC
• Very good exposure to Unix & Shell scripting.
• Excellent understanding of Client - Server architecture. Good understanding on various load, BI tools such as SAP data services BODS.
• Excellent Leadership and Public speaking skills

SOFTWARE SKILLS:

Languages: Perl, Shell Scripting

Operating Systems: UNIX and Linux

Database Systems: HP Vertica, DB2

Debugging Tools: dbx, gdb, Sun Workshop

Version control system: Rational Clearcase, CM Synergy

Bug reporting system: Remedy, Clear Quest, QC

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Linux

Senior Database Administrator/Team Lead

Responsibilities:

• Created individual JOBS to load data into tables from source systems.
• Created individual Workflow and dataflow as per requirements
• Configured Scheduler to execute JOBS.
• Performed UNIT testing for all Jobs.
• Fixed issues occurred during development.
• Used various transformations to complete the development.
• Created reports to track database usages, table level usages.
• Worked with the SAP application team to resolve issues with Performance and space with Transaction logs getting Full, log files running out of space, dead locks.
• Used the following transaction in the SAP Application for database task DB01, DB02, DB50, ST04, DB13, DB13C, DB26, DB03, DB12.
• Worked with the SAP Basis, BI/BW team and OS team to resolve infocube compression issues due to sizing of transaction log and log file .
• Rebuilt DB indexes and Statistics
• Monitored the following for the BW database NLS Near Line Storage, Organic growth, new development/content related growth, system administration table growth and deletion of PSA or change log table after getting approval from the BW team
• Constantly monitored free space, table spaces and date of last statistic update.
• Used the BW analysis view to monitor the growth of DSO and InfoCube table sizes against the total database growth to determine whether to cleans the PSA, change log and system administration table.
• Worked the Hana Administration team to monitor memory consumption for the database admin, code and stacks, column store tables, row store tables. Ran the Memory consumption by component report. Aslo Applied SAP NOTE 1813245 for row store compression.
• Responsible for SQL analysis at the database level to make recommendation to application developers on additional code tuning.
• Worked with the SAP Business, ABAP developers and Functional team on big one off jobs that involved high volume of data being loaded from the application to the database, did the sizing the of volume of the records/ size of the file to the size and number of transaction log files to make sure the job or session runs successfully.
• Used SAP transactions for the Database Cockpit and Scripts to do pro active monitoring and health checks on the both the database and application.
• Worked with the ETL tools BODS and Datastage, to resolve any database issues for the ETL processes.
• Worked with the BI team using BOBJ and Cognos, resolved any performance or show stopper issues for reporting.
• Worked the SAP Functional and Basis team to change Database manager configuration as directed in SNOTES for the SAP applications.
• Built the Development, Quality Assurance, Integration, Staging Database environments.
• Creating objects (Tablespaces, Tables, Views, and Indexes) based on the application team request.
• Backups and recovery whenever needed.
• Restoring databases based on the requirement
• Working with export, import, load utilities to manage table data.
• Creating Federated Servers to access different data source.
• Confidential Setup.
• Replication setup.
• Data movement from Mainframes to UDB using ETL customized scripts.
• Using RUNSTATS, REORGCHK and REORG to enhance application performance.
• Carrying out any performance analysis by taking snapshot in case of any performance degrades.
• Supporting database issues for different environments which had been setup.
• Installing db2 clients.
• Applied fixpack for all servers.
• Did Refreshes from Production to QA and Refreshes from Prod/QA to Sandbox when required for Proof of Concept or Protyping.
• Installation of DB2 instances on AIX, Linux test servers.
• Creating EXPLAIN tables and running the visual explain utility on SQL statements.
• Creating Instances and databases and updating DB/DBM configuration parameters based on the requirement.
• Recovering data to a prior point in time.
• Deployed all application releases in time and completed successfully.
• Worked with Unix shell scripting to automate process of ETL and backup
• DB2 up-gradation from DB2 V8.2 to DB2V9.1 and fine tuned many db, dbm and registry variable to best utilize the advance features of databases.
• Database backup, restore activities, common TSM activities like defining the storage class and schedules etc
• Enabling the database for STMM, archive logging, analyses of database deadlocks and solving the lock contention etc
• Support for inbuilt homegrown replication environment.
• Implemented the Advance Recovery tool Merge backup, High Peformance Unload (HPU) and Advance recovery. Did tablespace backup, restored tables from backup and tablespace using HPU.
• Used merge backup to reduce the number of full backups taken monthly.

Environment: DB2 UDB V8.2/DB2 UDB V9.1, AIX V5.1, Tivoli Storage Manager (TSM), CVS, Web Sphere.

Skills & Expertise: DB2, Q-Replication, AIX, SAN, TSM, HMC, SQL Tuning and Operating Systems

Confidential

Environment: DB2 UDB V9.1, DB2 UDB V9.5, DB V9.7, AIX V5.3, AIX6.1, Windows Server 2003/2008, Q-Replication, SQL-Replication, Optim Performance manager, Control-M job scheduler.

Team Lead

Responsibilities:

• Instance migration from one level to other level
• Capacity planning for new database infrastructure.
• Architectural design of db2 systems. New environment provisioning.
• Basic AIX administration for security access and disk space allocation
• Basic TSM administration activities and backup and archive pool maintenance and cleaning
• Database snapshots and analysis of the reports
• Worked with deadlock event monitors to support development region
• STMM vs Manual memory tuning, fine tuned many heap parameters for best results
• Q-Replication environment setup, installation, administration and development
• SMS to DMS conversion of tablespaces
• AIX technology pack up gradation, Memory planning, analysis of AIX performance reports
• Adding and maintaining new users and user group's to AIX and DB2 system
• AWK, Shell and perl scripting for automating backup and restore operation
• Confidential setup, Federation setup, db2look data movement, Database/table recovery from log files, Log shipping
• Implementation of in-house development environment (pSeries and SAN).
• SQL reviews, re-write and tuning.
• Generating and analyzing performance reports.
• Working on reducing database implementation time for releases, while leveraging both technology and process changes.
• Control-M server administration and jobs maintenance.
• Worked with Optim performance manager server
• 24X7 production support and change implementation/change control of databases.