Assignment History

Expertise

  • IBM UDB DB2, UDB Replication, HADR
  • DB2 Utilities, DbArtisan
  • MS Access, Word, Excel, Project, Power Point
  • Database Administration, Operational Implementation, Database Design, Performance Monitoring and Tuning
  • Maintenance script design and implementation, Performance Tuning
  • Korn Shell, Perl, Sed, Awk, HP/UNIX, IBM AIX

 

Assignment History

 

Major Insurance Company, Toronto, Ontario

 

DB2 LUW DBA (DB2 LUW 9.7 )

 

May 2011- Present

 

  • Project DBA for large project
  • Provide application development DBA services
  • Performance tuning
    • Review and recommend index changes
    • Review and advise on SQL performance problems
    • Monitor DB2 System during performance testing
    • Make recommendations for database configuration changes to optimize performance

 

Software Company, Palo Alto, California

DB2 LUW DBA (DB2 LUW 9.7 )

November 2010- Febuary 2011

  • Worked remotely from Toronto office
  • General database support
    • Support developers for DB2 issues
    • Backup, restore and move development databases as required
    • upgrade and install various instances to DB2 V9.7
  • Performance tuning
    • Review and recommend index changes
    • Review and advise on SQL performance problems
    • Monitor DB2 System during performance testing
    • Make recommendations for database configuration changes to optimize performance

Major Canadian Bank, Toronto, Ontario

Production Deployment DBA  (DB2 UDB 8.2 – 9.x on LUW)

October 2009 – December 2009
Febuary 2010 – October 2010

  • Deploy database changes in the production environment
    • Ensure that all processes and procedures are followed
    • Deploy changes to production
  • Participate in projects representing production deployment

Major Insurance Company, Toronto, Ontario

Development DBA  (DB2 UDB 8.2 on AIX and Windows)

April 2005 – September 2009

  • Provided development support for a large insurance company
    • write and analyse java stored procedures
    • support QC cycle for application

Lottery and Gaming  Company, Toronto, Ontario 

Database Administration (DB2 UDB 7.2 )

July 2004 – March 2005

  • Lead development DBA for conversion of warehouse from Microsoft SQL Server to UDB
    • Primary responsibility to monitor and tune database and SQL using DB2 Snapshot and Event Monitoring
    • Make recommendations to improve  performance
    • determine initial settings for all dbm/db configs for data warehouse and datamarts
  • Lead performance tasks for ETL (Datastage), and Cube building (Cognos)

Major Insurance Company, Toronto, Ontario

Development DBA  (DB2 UDB 7.2 on AIX, OS/390 DB2 V6)

May 2002 – April 2004

  • Project DBA for Java web application
    • Development DBA for large web application using Java – US Group Pensions 401K site
    • Develop, build and maintain development database build process using Jakarta ANT (XML processor)
    • Develop and maintain extract and load process (ETL) from OS/390 DB2 to UDB application database using korn/awk/sed scripts as well as java programs
    • Develop and maintain various Java programs and java stored procedures
    • Participate in overall database design and load process design
    •  Provide UDB development support as required for programming groups
    • UDB Performance tuning using DB2 native tools
    • Troubleshoot application problems in the database
    • Provide consulting expertise to database group members as required
  • Participated in many follow-on projects for the US Group Pensions 401K site
    • PIN/CTI project converted IVR security from unsecured mainframe process to secure LDAP process (MS Active Directory)
    •  Provided DBA support for many small enhancement project
  •  Provide coaching and technical expertise to DBA group
  • Assisted in troubleshooting activities for other US Group pension applications
  • Write and analyze complex SQL to provide reports on application data to business

Financial Institution, Toronto, Ontario

Database Administration (DB2 UDB 7.2 on AIX)

April 2002 – May 2002

  • DBA support for UDB DB2 applications
  • Provide DBA development support for SEDI application re-architecture
  • Review performance statistics and make recommendations
  • Script process for database tablespace reconfiguration
  • Write various korn, sed and awk utility scripts for DBA group
  • Assist with application changes and analysis as required

 Major Wireless Telco, Etobicoke, Ontario

Database Administration (Sybase 11 and 12/MS SQLServer 6.5 and 7.0/DB2)

Apr 2000 – December 2001

  • Primary support for numerous Microsoft SQLServer 6.5 and 7.0 servers
  • Primary support for numerous Sybase ASE 11/11.9.2/12 servers on HP/UX
  • Secondary support for OS/390 DB2 applications
  • Provide application development support for Sybase ASE and MS SQLServer projects
  • Write and maintain various UNIX scripts in Korn and Perl
  • Provide coaching to employees to improve database skills
  • Participated in Sybase ASE upgrade from 11.0.3 to 11.9.2
  • Provide 7/24 database support for Sybase ASE, Microsoft SQLServer and DB2
  • Performance and tuning services for SQL and databases

 

Major Financial Institution, Toronto, Ontario

Database Specialist (UDB)

November 1998 – Apr 2000

  • Project DBA for Business Banking Platform project (IBM Universal DB2 on AIX)
    • Managed multiple environments for various aspects of project
    • Applied database updates as supplied by vendor
    • Assisted with application problem determination
    • Provide 7/24 on-call support for production application
    • Troubleshoot production data and database problems
    • Provide after-hours support for production application
  • Perform installations and upgrades to UDB 5.2 as required
  • Tested UDB Replication facility for disaster recovery
  • Performance and tuning issues with UDB v5.2
    • Assisted with SQL and database tuning exercise
    •  Review SQL and table structure to provide optimum query performance
    • Database performance monitoring
  • Developed various support and management scripts in Perl/Korn/Awk/Sed scripting languages

Major Wireless Telco, Etobicoke, Ontario

DB2/Sybase Database Analyst

September 1996 – November 1998

  • Sybase Database Analyst on HP/UX
  • Conversion of database software from 11.02 to 11.03
  • Analyze and recover data from corrupted databases
  • Performance tuning in Sybase environment using sp_sysmon and other tools
  • Project DBA for Master Customer Profile project
    • 50b Sybase database
  • Support various Sybase production and development systems
    • 30b Data Warehouse
    • 360 Gb Message Processing System (primary support)
  • Maintain and develop various support scripts (Korn Shell and Perl)
  • Support for MVS/DB2 database management (@ 300Gb)
    • Assist application developers in problem resolution
    • Participate in application projects
    • Reorg, backup, table maintenance
  • 7/24 oncall support for batch and online applications (Sybase and DB2)

Major Wireless Telco, Etobicoke, Ontario

MVS System Programmer

February 1993 – September 1996

  • Implemented IBM 3495 ATL and SMSTAPE
  • Analyze MVS system performance using RMF/SMF and make changes to achieve optimum performance
  • Collect Capacity Planning data and produce reports for management
  • Produce and maintain MVS System Disaster Recovery Plan
  • Primary support for TMS, all data management products including ICKDSF, DFSMShsm and DFSMSdss
  • Perform general Storage Management duties
  • Perform general Performance Management duties

 

Major Financial Institution, Toronto, Ontario

Technical Analyst

August 1989 – February 1993  

  • DASD Fastwrite implementation project
  • I/O tuning of DASD subsystem and devices
  • Cache tuning and analysis
  • Documentation of I/O subsystem monitoring procedures
  • Primary support for DMS/OS
  • Major participant in the STK 4400 Automated Cartridge System implementation
    • Assisted in long term vault implementation
    • Wrote programs to interface ACS and TMS
    • Participated in overall implementation
Buy Generic Viagra USA
Where TO Buy Viagra Online
Buy Viagra Where
Cheap Cheap Viagra
Line Viagra
Buy Discount Viagra
Cheapest viagra online Pills
Buy Viagra Sample
Cheap Viagra Online
Cheap Viagra FAST Shipping
Viagra for Sale
Buy Viagra New York
Cheap Websites For Viagra
Viagra FOR Sales Online
Cheapest Viagra Prices
Cheap Viagra Pills