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