A M

PROFESSIONAL SUMMARY

Manage Decommissioning team activities. Manage Team of Reporting Services and tools support. People Management, Stakeholder Management, Delivery Management. License Management.

• 20 years of experience in Database Technologies, Management, myWizard.
• Expertise in Administering DB2 Production databases. 
• MS SQL Server 7, 2000, 2005, 2008 andDB2 v6, v7, v8, v9 and v10.
• Experience in Database Modeling; Physical and Logical Database designing and developing.
• Proficiency in DDL, DML, Stored Procedures, User Defined Functions, Triggers and SQL PL.
• Designing the Star Schema, partitioning key, loading data, Cursor Load. Federation.
• Database migration to AWS
• Creating Database Objects; Tables, Views, Triggers, Indexes etc.
• Database migration between SQL Server 2000 and DB2.
• Proficiency in Installation and Configuration, upgrading by applying patches using db2setup, db2_install, DB2 Architecture and database Migration, IBM MTK. Experience in Database implementation; Used DB2 Utilities in Creation of database objects and import, export and loading data.
• Expertise in Database Backup and Recovery. Flash Copy backup setup and restore.
• Proficiency in Database maintenance; Space management, Configuration Management and Security Management of production databases. Monitoring DB2 activity, performance tuning; SQL tuning, I/O and Memory Tuning, Registry Tuning, Runstats, Reorgs and Trouble-shooting.
• Proficient in DB2 Security; Controlled by Authentication, authorization and
  privileges.
• Experience in enabling replication of Data.  Have used DPropr Replication Tool and DB2 native replication tools. Change data capture CDC replication, using IIDR (IBM Infosphere Data Replication)
• Proficiency in Range Partitioning (Table Partitioning), Data Partitioning Feature DPF, High Availability and Disaster Recovery setup HADR.  Experience in System Verification Testing of DB2 UDB V8 FP14 product.
• Worked with DB2 Research Lab, Toronto for testing on DPF and HADR. Experience as a Team lead. Ensured the 24/7 support by Managing the Time Schedules and Task distribution for Team Members, used written Perl/developed scripts for job schedules.
• Proficiency in IBM Data Warehouse, InfoSphere Balanced Warehouse environment and ETL tools. Optim Performance tool, BLU Acceleration, Columnar tables. Omegamon, BMC.
• SQL Server and Oracle database migration to DB2.  Migrated DB2 on Z/OS to DB2 on Linux Azure.
• SAP Basis DB2 administration
• Sybase System backups, management of user accounts, T-SQL programming
• Experience on iSeries i5 6.1, AIX, UNIX, Linux, Sun-Solaris platforms and Windows NT/95/98/2000/XP. 

Bachelor of Engineering