Db2 Dba Resume
0/5 (Submit Your Rating)
MilwaukeE
SUMMARY:
- Member of the DB2 LUW IBM Customer Advisory Council - a select group of about 40-50 people from around the globe working with IBM on DB2 LUW features, defects, and new offerings.
- Designed and manage the Confidential (Wisconsin DB2 User Group) site www. Confidential .com
- More than 15 years experience as a professional information technology manager.
- More than 20 years experience in technology (programming, DBA, operations, call center.)
- Ability to direct complex projects from concept to fully operational status.
- Goal-oriented individual with strong leadership capabilities.
- Organized, highly motivated, and detail directed problem solver.
- Proven ability to work in unison with staff, cross departments and executive management.
- Ability to utilize technical background to assist in all areas of operations management as well as customer care.
PROFESSIONAL EXPERIENCE:
Confidential
DB2 DBA
Responsibilities:
- AIX 5.x DB2 (8.2, 9.1, 9.5)
- Install, configure, tune, manage DB2 on AIX, Windows
- HADR configurations
- Tivoli suite db2 management (TEP,TPM, TSOM)
- Partitioned databases and warehouses
- Windows DB2 (8.2, 9.1, 9.5)
- SAP product suite management (upgrades from V8 to V9)
- Korn shell development for critical functions (check backups, check diaglog, etc.)
- On-call support 24x7
- Support tier1 and tier2 databases
Confidential, Milwaukee
DBA - Assurant Health
Responsibilities:
- Maintain DB2 z/OS V7 databases (7 DB2 subsystems)
- Internally written applications and some purchased packages.
- Strobe analysis - application tuning
- Space management
- Maintain SQL Server 2000 databases
- Maintain DB2 UDB Windows V8.2 databases
- Maintain IMS/VS V8 Databases (PSB gens, DBD updates)
- On-call responsibilities (DB2 z/OS, Oracle, SQL Server)
- Responsible for all help desk tickets - first level support in DBA group.
- Unix - script management
- Special projects included:
- DB2 UDB V8.2 Fixpack 14 installation
- DB2 UDB Application tuning for Rational product suite
- DB2 z/OS BMC Reorg implementation in production JCL
- DB2 z/OS authority lockdown implementation
- DB2 z/OS subsystem migration using BMC Change Manager
- CA/Autosys job updates and moves
- DB2 z/OS Encryption
- Some exposure to Oracle
- DB2 z/OS Audit
- DB2 z/OS V8 planning
- Document standards/best practices as it relates to windows based jobs
Confidential, Milwaukee, WI
E-Finance Sales Solution Consultant
Responsibilities:
- Instrumental in integrating the corporate eBanking suite acquired from Brokat Technologies (J2EE application.)
- Designed, proposed and sold solutions outside the normal sales model to clients in the Financial Fortune 100 market segment.
- Researched, prepared and presented Request for Proposal (RFP) responses. RFP’s ranged from three to hundreds of pages.
- Primary liaison between sales team and internal Confidential teams to solution new opportunities (create solution, obtain commitments, and deliver proposals.)
- Provided direction on new products and services to increase revenue opportunities.
Confidential, Milwaukee, WI
Assistant Vice President - Consumer eBanking Development Manager
Responsibilities:
- Management responsibility for development, conversions, new technology and operations related to Confidential ’s Consumer eBanking product suite.
- Customer base grew to over 100,000 unique users.
- Project manager for data warehouse implementation. Extracted operational information for use in summarization and aggregation. Operational reporting and management reporting interfaces designed and developed.
- Responsible for internet based technical product direction (aggregation, bill presentment integration, secure email, etc.) Technical manager for potential acquisitions of complementary products and services including securities related products for consumer and commercial use.
- Management of senior leads, product managers, business analysts, testers and conversions.
- Recognized as Distinguished Performance on reviews (highest rating.)
Confidential, Milwaukee, WI
Responsibilities:
- AVP - Consumer eBanking Payment Development Manager (formerly Home Banking)
- Management responsibility for all development, operations, acquisitions, and sales support related to Consumer eBanking product suite.
- Project manager for migration of vendor acquired product to in-house (ASP) deployment. Product purchased from TravelersExpress. Project was recognized by the CE0 for superior conversion related to migration from TravelersExpress to Confidential ASP model.
- Project manager in preparation for Year 2000 related to Consumer eBanking (planning, development, testing and actual event.)
- Prepared technical proposals and strategic analysis planning with the CIO and sales executives.
- Liaison for Confidential to Microsoft for eBanking online product direction.
- Rated as Exceed Expectations
Confidential, Milwaukee, WI
AVP - Home Banking Development Manager
Responsibilities:
- Responsible for all development, operations, acquisitions, and sales support related to Home Banking online banking and bill payment product (product licensed from TravelersExpress)
- Promoted to officer in 1997.
- Project leader for the largest bill payment conversion for telephone bill payment in-house to M&I ASP product offering (determine product deficiencies, develop plans, plan conversion, perform data conversion, plan/size server farm.) Conversion was for Bank of Hawaii.
- Rated as Distinguished Performance.
Confidential, Milwaukee, WI
Enterprise System Architect
Responsibilities:
- Responsible for technical assistance to product areas in utilizing the new wave of client/server based applications.
- Project manager for the Home Banking integration project (first Windows NT application) into an MVS/OS based operations and support area.
- First System Architect to deploy a Windows NT application into production 24x7x365.
- Home banking was the area of growth, therefore, I was asked to lead the team.
Confidential, Milwaukee, WI
Database Analyst promoted to Database Manager
Responsibilities:
- Management of seven DBAs responsible for MVS/DB2 and client/server DBMS technologies (Oracle, Informix.)
- Lead contact to Technical Architecture Group related to new DBMS technologies (Informix on UNIX, Oracle on UNIX, DB2 on AIX, etc.)
- Led effort to design a data warehouse architecture including an operational data mart, management data mart and executive data mart. Utilized Oracle and Sun Solaris platform.
- Database Analyst
- Lead DBA on DB2/MVS for audit and security (RACF) configuration. SAS70 audits performed on all DB2 applications and systems.
- Lead DBA on first installation of DB2/MVS application.
- DBA responsible for tool evaluation/selection/proposal/installation/support (Platinum & BMC product suites.)
- Responsible for development and publication of DB2 standards for programmers and DBAs. Documents created in text form and available via ISPF fast path commands (DB2ADMIN & DB2OVRVW.)
- Worked closely with programmers on troublesome SQL statements and performance tuning efforts.
- Lead DBA for disaster planning efforts including designing and developing tools to speed recovery time (ISPF based.)
- Continually reviewed systems for performance improvements. Savings ranged from $10,000 to over $40,000 per year in CPU, elapsed execution time, etc.
Confidential, FL
Software Engineer promoted to Senior Software Engineer
Responsibilities:
- Responsible for designing, developing and deploying a sophisticated security tool (CSPsec) for use with IBM’s Cross System Product technology.
- CSPsec solution reviewed individual security roles and rights, and then created screens dynamically (block entry, block display of field or tag, workflow.) Developed in REXX with SQL/DS DBMS database.
- Designed, developed and deployed a custom SQL/DS real-time monitoring tool. Recognized by IBM Southern Area Systems Center for the solution’s design.