Senior Db2 Dba & Data Architect
Home Office
Worked as a member of a team of eight Database Administrators assigned to the Sales Transformation Model group of IBM to install, develop and maintain OLTP, and Data Warehouse databases running on DB2 UDB 9.7/10.5 on AIX and Linux(Bluemix) platformsAchievements:Provided Application DBA support to implement optimized physical database structures.Designed and developed database security using AIX\Linux groups and roles.Owned and managed all changes to the data models, created data models, solution designs and data architecture documentation for complex information system.Created and managed instances, databases, tables, views, MQTs, indexes, triggers, functions and procedures.Optimized the existing stored procedures, ETL jobs, db structure, extract and load processes, archiving the historical data.Implemented the ETL process using stored procedures, cron jobs and shell scripts Created redirect-restore scripts to support development and testing activities between test and production databasesCopied the databases between AIX and Linux env.Installed the fixpacks Provided System DBA support to manage day to day database activities. System Admin Role in Bluemix (Linux)Developed and implemented monitoring shell scripts on AIX and Linux platforms. Environment: DB2/UDB multi-partition 9.x/10.5, AIX, IBM Bluemix (Redhat Linux)