Resume

Sign in

Sr. DB2 LUW DBA

Location:
Cumming, Georgia, 30041, United States
Salary:
negotiable
Posted:
January 06, 2011
Email:
qgose0@r.postjobfree.com
Contact Info:
******@*****.***


Professional Summary Proven performer in the Information Technology Field, with experience in UNIX Systems Administration, Informix, DB2 LUW and SQL Server Database Administration. I am seeking the opportunity to use my Database skills in a dynamic environment and invite the opportunity to learn new skill-sets.
Certifications IBM Certified Solutions Expert Informix Dynamic Server 7.X
IBM Certified Database Administrator DB2 Universal Database V8.1 for Linux UNIX and Windows

Technical Competencies Operating Systems: HP-UX, IBM AIX, Sun Solaris, Novell LAN Systems, Windows 2000, Windows Clustering, LINUX
Languages: Informix 4GL, ESQL, C, SHELL SCRIPTING USING KSH, SH, CSH, BASH, PERL, TSQL
Networking: FTP, IP, TCP, TCP/IP, TELNET
RDBMS: INFORMIX DYNAMIC SERVERS 7.X, INFORMIX ODS 7.X, SQL SERVER 7, SQL SERVER
2000, IBM DB2/UDB V7.X V8.X
Software: TIVOLI, MAESTRO, BMC PATROL, REMEDY SOFTWARE, EXCEED TERMINAL EMULATION, SEQUELINK, DRDA GATEWAY, C/C++ ,
Backup Utilities: Net Backup, Tivoli- TSM Omni Back

Career Highlights and Qualifications
DB2 Universal Database (UDB-LUW)
V8.1 , V8.2, V9.5, V9.7
Informix Dynamic Servers V7x, 9x,10x,11
SQL Server 7/2000

Windows NT/2000/2003
UNIX (DCOSX, HP, AIX, Sun Solaris,Linux)

IBM DRDA Gateway 7.31

LINUX
Sequelink 4.5

Professional Experience

Community Loans of America
DB2 DBA
11-2009 – 07-2010
Maintain and administer the DB2 data warehouse and DB2 OLTP databases. The data warehouse is 1TB in size and runs on DB2 9.5fp5 on a Linux platform. Coordinate and manage the upgrade of the OLTP database from level 8.1fp12 to 9.7fp1. OLTP database runs on the AIX 6.1 platform.
• Manage upgrade and migration to new version of DB2
• Devise plan and document required steps to upgrade to DB2 9.7fp2 from DB2 8.1.fp12
• Manage project to upgrade all DB2 environments and accommodate new releases.
• Configure and manage HACMP for the OLTP database
• Configure and maintain Log Shipping of transactions to the standby database.
• Run reorgs and runstats routinely to maintain the performance of the Data warehouse and OLTP databases
• Provide backup and recovery strategies for DB2 LUW on TSM
• Strong unix shell scripting to create runstats, restores, backups, capacity planning scripts
• Trouble shooting skills using nmon, top, topas, vmstat and db2top and db2pd utilities
• DB2 LUW installations and Fixpacks on AIX and LINUX
• Performance tuning of complex queries, registry setting and database configurations
• Use automatic storage
• Monitor database and support development of new releases
• Comply with change management procedures
• Develop new scripts, interpret old scripts for managing the database environments.
• Use event monitors, db2advis and db2 explain, db2pd and snapshots to monitor and performance tune

Technical Environment:
DB2 Universal Database (UDB) V8.1fp12 and 9.5fp5, 9.5fp7, AIX 5.3, AIX 6.1, Linux Red Hat V.4.1.2
Ajilon Consulting – Verizon Business
Informix Database Analyst Contractor
07-2008 – 10-2009
Contracted to Verizon Business to administer Informix on major corporate applications. Coordinate various production support activities, extent management, maintain database disk space using PHP tools, including, onspaces, update statistics, onbar, oncheck, and ontape. Manage multiple database environments while providing on-call support in 24/7 environments. Expertly handle sql analysis to development teams.
• Identify and solved Informix bug issues with Informix version 7.3 which allows multiple path names for a single database space chunk.
• Reorganize large tables with a high number of extents to eliminate fragmentation and to free wasted disk space.
• Identify and resolve performance issues for queries requiring too many locks, missing indexes, high shared memory and CPU utilization.
• Configured recovery solution for Informix utilizing HDR. Managed, troubleshoot and monitor databases running HDR.
• Maintained Redbrick Data Warehousing weekly maintenance using table partitioning for 50TB database.
• Provide Production changes using Change management to increase stability and systems controls.
• Develop and enhance UNIX SHELL scripts on AIX and LINUX
• Manage database space using RAW devices

Technical Environment:
Informix Dynamic Server (IDS) 7.31, 9.2, 10.xl., 11.50, Informix HADR
Informix SQL, SunOS 5.8 ,5.10 HPUX 11, AIX 5.3

Superior Design International, Inc – IBM Global Solutions
DB2 Database Administrator - Contractor
04-2006 to 06-2008
• Provide Database Support for PeopleSoft on DB2 UDB.
• Manage the People Soft Database on DB2 UDB, supporting new releases, tablespace management, weekly reorgs and performance tuning.
• SQL Code Review, analyze Query Plans and Performance Tuning.
• Schema management, performance monitoring, tuning and backup/recovery planning.
• Space allocation and data placement.
• UDB Database Upgrades.
• Database Integrity checks using reorgchk, runstats and reorgs.
• Develop generic maintenance scripts to monitor and report database activities
• Redirected restores and database builds for UDB.
• Performance monitoring using the event and snapshot monitoring.
• PeopleSoft Enterprise Financials/Supply Chain Mgt. Upgrade 8.4x to 8.9
• Schedule jobs/scripts through unix Cron
• Design, document and implement maintenance scripts and standard procedures.
• Create maintenance and support scripts using ksh, sh and bash.

Technical Environment:
DB2 Universal Database (UDB) V8.1 and 8.2, DB2 8.2 Portal DB, DB2 9.1 Cognos , UNIX AIX 5.3, AIX 5.3, , PeopleSoft Apps, 8.9, PeopleSoft Tools 8.46

The John H. Harland Company
DB2/ Informix Database Administrator
01-2005 to 04-2006
• Provide Production and Development Support configuring DB2 UDB and Informix databases.
• Manage the Siebel Database on DB2 UDB, supporting new releases, tablespace management, weekly reorgs and performance tuning.
• Manage the Custom Web database running on DB2 UDB, supporting DDL, DML changes, space management, performance tuning and ETL management.
• Provide Informix database support for the People Soft application.
• Stage physical database models for several Informix and UDB databases.
• SQL Code Review, analyze Query Plans and Performance Tuning. Tuned People Soft query to run in 15 minutes down from 24 hours..
• Schema management, performance monitoring, tuning and backup/recovery planning.
• Space allocation and data placement.
• Informix and UDB Database Upgrades.
• Database Integrity Checks using oncheck, Update Statistics, reorgchk, runstats and reorgs.
• Develop generic maintenance scripts to monitor and report database activities
• Organize DBA functions for effective proactive and production support
• Informix Fragment management for 5 TB data warehouse database.
• Data loads and unloads using onpload
• Redirected restores and database builds for UDB.
• Performance monitoring using the event monitor

Technical Environment:
DB2 Universal Database (UDB) V7.x and 8.x , Informix SQL, AIX 4,Sun Solaris 5.1,
Informix Dynamic Server (IDS) 7.3 and 9.3, 9.4

The Home Depot
Chief Systems Engineer/Database Administrator
12-1999 to 01/2005
• Provide Production and Development Support configuring Informix, DB2 Universal Databases, and Microsoft SQL Server Databases for maximum performance and high availability.
• Define monitoring strategies; perform detailed analysis and recommendations for operational stability.
• Exhibits expertise in Unix Shell Script writing and the management of Informix Version 7.x and 9.x, DB2 7.x, 8x, SQL Server V7 and 2000 databases.
• IBM DRDA Gateway 7.31 Support and configuration.
• Sequelink 4.5 support and configuration.
• Develop and support stored procedures and triggers.
• SQL Server T-SQL development and maintenance.
• Formulate and monitor policies/procedures, and standards relating to database management.
• Design and stage physical database models and DDL.
• SQL Code Review, analyze Query Plans and tune when needed.
• Manage Indices.
• Schema management, performance monitoring, tuning and backup/recovery planning.
• Transaction Log management.
• Space allocation and data placement.
• Database Upgrades.
• Database Integrity Checks and Update Statistics.

Technical Environment:
Informix Dynamic Server (IDS) 7.2, 7.3 and 9.2, Informix 4GL,
Informix SQL, HP-UX 11.0, AIX 4, WINDOWS 2000, SQL SERVER 7.0, SQL SERVER 2000, DB2 Universal Database (UDB) V7.x and 8.x, Windows NT, Windows 2003, Windows Clustering.

Hewlett Packard/Volt Services Group
Informix DBA (Consultant)
10-1998 to 12-1999

• Provided Informix Database support to several major clients running 7.30.UC2 on HP-10.2 with SAP 4.
• Configured database -monitoring, to interface with Remedy.
• Maintained documentation of the database configurations and data layouts for each client.
• Performed database reorganizations using the SAPDBA tool.
• Define monitoring strategies; perform detailed analysis and recommendations for operational stability.
• Exhibits expertise in Unix Shell Script writing.
• Formulate and monitor policies/procedures, and standards relating to database management.
• Performance monitoring, tuning and backup/recovery planning.
• Transaction Log management.
• Space allocation and data placement.
• Database Upgrades.
• Database Integrity Checks and Update Statistics.
Technical Environment:
Informix Dynamic Server (IDS) 7.3, HP-UX 10.2 and 11.0, OMNI-BACK, Remedy, SAP 4.

The United States Department of Treasury
UNIX Systems Administrator/Informix DBA
04-1994 to 101998

• Tier II Level UNIX 24x7 Technical Support for several Servers.
• Effectively managed and integrated several Unix SVR4 Servers.
• Managed Informix Online Dynamic Server Engine 5.x and Informix Dynamic Server 7.1 and 7.2 environments.
• Provided Optimization to several IDS 7.2 servers configuring database changes at the database and O/S level.
• Performed database integrity checks, space allocation, and backup/recovery and monitoring.
• Developed shell scripts to backup the UNIX OS and database servers.
• Developed monitoring strategies and implemented procedures scripts to page or alert.
• Database Integrity Checks and Update Statistics.
• Developed SHELL, PERL and SQL scripts to provide User administration and database access.
• Designed physical placement of data.
• Partitioned disk drives, configured printers and set up print servers.
• Configured new database instances, calculated extent sizes, designing physical placement of tables in dbspaces, and created backup/recovery strategies.

Technical Environment:
Informix Online Engine 5.x, Informix Dynamic Server 7.2,
ATT System V UNIX (SVR4), BSD UNIX, SCO UNIX and DC/OSx UNIX, PERL Scriptwriting.

The United States Department of Treasury
Programmer Analysts
03-1992 to 04-1994

• Provided maintenance, development, modifications and enhancements to the Informix 3.3 Standard Engine and Informix SQL applications.
• Completed the conversion and migration of Informix 3.3 applications and the ALL II programs to Informix 4.2 Online Engine, using SQL and SHELL scripting and ESQL.
• Moved the applications and databases from the Unix Sequents Servers to the Pyramid UNIX Servers.
• Converted all the CSH scripts to KSH scripts.
• Developed an Online Survey Reporting Application using Informix 4.2, SQL and ACE reports.
• Modified and enhanced existing Informix 4.2 Applications.
• Developing a Resource Tracking Reporting Application using Informix 4.2 Ace Report Writer and Forms.

Technical Environment:
Informix Standard Engine 3.3, Informix Online Engine 4.2,
Informix SQL, ACE, Forms, BSD UNIX, SVR4 UNIX.