We provide IT Staff Augmentation Services!
Db2 Database Administrator Resume
0/5 (Submit Your Rating)
TN
Hire Now
SUMMARY:
- An Information Systems consultant with over twenty one years of full life cycle applications development expertise. As a DB2 Database Administrator, he has created, configured, updated and maintained databases, and converted systems to DB2 Development, Test, Production and various environments on Windows 2000/2003, Mainframes, Solaris, AIX, AS/400, UNIIX.
- Twenty one years of total IT experience.
- Over five years of experience as a UDB, DB2 in z/OS, ORACLE and SQL Server Database Administrator.
TECHNICAL SKILLS:
Database: DB2,UDB, DB2 LUW, DATAMART, IMS, ORACLE, MS - SQL SERVER, MS-ACCESS, SYBASE, TERADATA.
OS: LINUX, UNIX, AIX, HP-UX, WINDOWS, AS/400, MVS, Z/OS
Language: VB SCRIPT, ASP, VB 3.0/4.0/5.0, C/C++, SEQUEL, CL, HTML, XML, JAVA SCRIPT, PERL, OO COBOL 4.0, COBOL/COBOL II, CICS, JCL
Software: SYSPLEX, POWER DESIGN, IBM CASE MANAGEMENT TOOLS, RC QUERY, DATA MANAGEMENT TOOLS, DBA EXPERT, CHANGE MANAGER, PILOT, TOAD, PEOPLESOFT, MQT, QMF, DB2 CONNECT, DATA FLOW DIAGRAMS, ERD'S, PROCESS MAPPING, BUSINESS OBJECTS, SURETRACK, MQ SERIES, Websphere MQ VER. 6, CRYSTAL REPORTS 9,10, 11, Microfocus COBOL..
PROFESSIONAL EXPERIENCE:
Confidential - TN
DB2 Database Administrator
Responsibilities:
- Backup and recovery. Disaster recovery using HADR.
- Created, configured, updated, upgraded and maintained the database on Dev/QA and Prod.
- Coordinated, reviewed, analyzed and approved the physical database requirements of databases and all associated objects; i.e., tables spaces, tables, indexes, and views
- Involved in Data Modeling, Performance tuning, use of snapshot monitoring, visual explain.
- Performance and tuning. Used Explain, Event Monitoring, Snapshot Monitoring, TOAD, Query Patroller and DB2 Optimzer.
- Worked with Parallel Sysplex and Power Design.
- Capacity Planning
- Used DB2 utilities (REORG, RUNSTATS, REBIND, LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, and DB2MOVE) for database administration.
- Worked with clusters and Replication..
- Routine production operational support,
- Support Applications and Productions.
- Used Triggers, Stored Procedures and with or without use of wizard for back ups and recovery was also involved.
- Installed, configured and implemented DB2 Connect, used DB2 Connect to connect from Sun Solaris and Windows 2000 to Mainframes test and production database of the client site.
- Implemented physical database support.
- Installed, upgraded and supported DB2/UDB, ORACLE, SQL Server on UNIX(AIX), LINUX, WINDOWS 2000 and 2003 Advanced Servers, and Z/OS, also include applied patches and fixed packs..
- Used Crystal Reports version 9, 10, 11 for Wire Transfers, Mortgage, Loan Systems. Also used for Monthly Reports.
- Used SPUFI to run Z/OS SQL, also trained other developer.
- Worked with datawarehouse and repositories.
- Strong customer service, production focus and worked 24x7.
- Worked with system methodologies. Created, maintained and tuned Stored Procedures.
- Installed and supported 3rd party application .
- Installed and tuned DB2 Connect client and gateway.
- Worked with Range Partitioning, Table Partitioning, Compression, Q Replication, database monitoring tools, administration tools and database utilities, such as Omegamon, BMC tools and utilities. SQL Power, Administration Wizard.
- Created and maintained Disaster Recovery environment.
- Recommended cost-effective solutions when necessary.
- Worked with Data migration, building environments and database security..
Environment: DB2 Z/OS ver. 8/9, UDB EE/EEE ver. 8 and 9, DB2 LUW, IBM Case Management Tools, VSAM KSDS, INFORMATICA ETL, DATAMART, MQT, HADR, SYSPLEX, HACMP, MDC, TOAD, DBA Expert, CHANGE MANAGER, PILOT, Power Design, SQL Server, Oracle, UNIX, Perl, Confidential -SQL, Omegamon, BMC Utilities, Sun Solaris, Linux, AIX, Windows XP, Windows 2000 Advanced Servers, Windows XP, Windows Vista, Windows 2003/2008 Servers, Distributed Platforms, Crystal Report 9, 10, 11, Top Secrets, Query Patrol, Mainframe Z/OS, Tandem, LINUX, CICS, JCL, Shell Scripts, MS Project, TSO, SPUFI, JCL, RC QUERY, DATA MANAGEMENT TOOLS, WMQ, MB .
Confidential - IL
DB2 DBA
Responsibilities:
- Capacity Planning.
- Created and maintained Disaster Recovery environment.
- Provided performance-related and system support for RDBMS data structures in test, quality assurance, and production environments utilizing current tool-sets
- Converted the existing Sybase Product Category System to DB2 Databases in a Unix, Linux and Windows 2000 environment hooked up to an e-commerce system.
- Installed, configured and implemented DB2 Connect, used DB2 Connect to connect from Sun Solaris and Windows 2000 to Mainframes test and production database of the client site. Work also involved product analysis.
Environment: DB2,/UDB, Z/OS, TOAD, SQL Server,JCL, Korn Shell Scripts, Query Patrol, Omegaom, Reflections, Lotus Notes, SMP/E, Windows 2000, UNIX (Sun Solaris, AIX), AS/400, OS/390, z/OS, Linux.
Confidential - IL
DB2 DBA
Responsibilities:
- PL/SQL was used to retrieve data from these tables and made the necessary changes to the actual tables.
- Provided performance-related and system support for RDBMS data structures in test, quality assurance, and production environments utilizing current tool-sets. Created, maintained Stored procdures.
- Created and maintained Disaster Recovery environment.
- Utilized INFOMAKER to verify the results. Cross- maps were created and Excel was used for generation of tables.
- Data modeling.
Environment: DB2, Z/OS, UDB, IMS DB, OMEGAMON, BMC, LINUX, WINDOWS, COBOL II, COBOL, JCL, CICS/VS, SURETRACK, ENDEVOR, Windows NT, CHANGEMAN, QMF, FASTLIST, FILEAID, Expediter, IMS/DB/DC/TM, Window NT, Visio, MS Word.
Confidential - IL
UDB DBA
Responsibilities:
- Worked with Microfocus COBOL .
- Data mart work included file transfers using FTP; loaded files to Oracle using SQL*LOADER and PL/SQL.
- Provided performance-related and system support for RDBMS data structures in test, quality assurance, and production environments utilizing current tool-sets
- Used INFOMATICA ETL for data retrieval from CIS and Accounting systems.
- Performed Oracle database configuration; tuning and monitoring activities.
- Responsible for performance tuning, database administration, project management, design, development, testing and implementation of an UDB/COBOL Accounting System.
- Implemented, maintained, administered MQ Series to Development, Test and various environments on Windows NT, Mainframes (OS/390), UNIX, Solaris Performed E-Commerce development using Oracle Web Application Server 3, Oracle Developer 2000, Java and MS Access.
- Created and maintained Disaster Recovery environment.
Confidential - IL
Programmer/Analyst/Manager
Responsibilities:
- Provided leadership for the PeopleSoft HRMS and Financials upgrades.
- Participated in analysis, coding, testing and implementation using Application Designer, People Tools, Crystal Reports, and SQR/SQL.
- Worked with Microfucus COBOL.
- Analyzed workflow issues and was responsible for documentation, troubleshooting, support and disaster recovery. Work was completed using TUXEDO, Triggers, Stored Procedures, SNAPSHOT and DB2 CONNECT for DB2.
- Consulted on Year 2000 issues, including analysis, data flow diagrams, documentation and benchmarking and unit testing for UDB, COBOL and Visual Basic systems. Also work included developed MQ programs.
Confidential - IL
Consultant Programmer/Analyst
Responsibilities:
- Participated in YEAR 2000 for MVS, DB2, IMS, PACBASE and VIASOFT systems. Used 40/60 windowing and HOURGLASS 2000.
- Tested critical and invalid dates.
Confidential - IL
DB2/UDB DBA/Lead
Responsibilities:
- Functioned as UDB Database Administrator responsible for performance and tuning of UDB programs for promotions and enrollment applications.
- Converted Sybase System 11 to UDB V.5 as a Sybase DBA.
- Moved data from Sybase tables to UDB.
- Identified differences between Sybase and UDB, and created FTP plans and verified testing.
- Performed UDB database analysis and design for data handling, physical and logical design, normalization and conversion of data from VSAM to UDB.
- Monitored, maintained and supported the data repository which used Brownstone Repository, Platinum Repository and Silver-Run.
- Extracted data using INFORMATICA ETL.
- Cleaned DB2 table access, granted access, revoked authorities from user ID's and created reports.
- Used OMEGAMON II, DB2 Accounting Report, DB2 EXPLAIN, DB2 BUFFERPOOL Accounting Report and STROBE
- Worked with Microfocus COBOL..
Confidential - IL
DB2 DBA
Responsibilities:
- Coded several DB2 extract modules (I/O Module) using SPUFI, QMF and embedded SQL with COBOL II, also provided DB2 administrative functions.
Confidential - IL
DB2 DBA
Responsibilities:
- Worked with Microfocus COBOL environment.
- Coded several DB2 extract I/O modules using SPUFI, QMF and Embedded SQL.
- Responsible for DB2 administration functions.
- Performed project leadership and development activities on Oracle Financials systems using Visual Basic, Java and Oracle.
- Responsible for performance tuning, database configuration, tuning applications, shared pool, buffer cache, rollback segments and redo mechanisms; and monitoring and detecting lock combinations.
Hire Now
Report an issue
Resume Categories
- .NET Developers/Architects Resumes
- Java Developers/Architects Resumes
- Informatica Developers/Architects Resumes
- Business Analyst (BA) Resumes
- Quality Assurance (QA) Resumes
- Network and Systems Administrators Resumes
- Help Desk and Support specialists Resumes
- Oracle Developers Resumes
- SAP Resumes
- Web Developer Resumes
- Datawarehousing, ETL, Informatica Resumes
- Business Intelligence, Business Object Resumes
- MainFrame Resumes
- Network Admin Resumes
- Oracle Resumes
- ORACLE DBA Resumes
- Other Resumes
- Peoplesoft Resumes
- Project Manager Resumes
- Quality Assurance Resumes
- Recruiter Resumes
- SAS Resumes
- Sharepoint Resumes
- SQL Developers Resumes
- Technical Writers Resumes
- WebSphere Resumes
- Hot Resumes
Client Services
- IT Staff Augmentation
- Hire Programmers
- Government Services
- IT Project Management
- Industry Expertise
- Resume Database
Job Seekers
- Browse Jobs
- Upload Resume
- Employee Benefits
- Resume Marketing
- Us Citizens/Green Cards
- Visa Sponsorship
- Employer on Record Services (EOR)
- Forms Checklists
Visa Sponsorship
- H1B Visa Transfer
- E3 Visa Sponsorship
- TN Visa Sponsorship
- EB3 to EB2 Porting
- Green Card Sponsorship