A M

Software Industry, Manage team activities. Manage Team of Reporting Services and tools support. People Management, Stakeholder Management, Delivery Management and License Management. Technical Skills on Database DB2 support and delivery.

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