We provide IT Staff Augmentation Services!

Database Dba / Systems Programmer Resume Profile

2.00/5 (Submit Your Rating)

New, JerseY

Hire Now

Skills:

32 years database administration, programming and systems programming experience. 22 years ZOS DB2. Database implementation, maintenance, recovery, disaster recovery planning and testing, database-application-system performance monitoring and tuning, SQL tuning. 6 years UDB AIX DB2 / SAP / UDB server, Sybase, DB2 Connect, DB2 Data Propagator, IBM Infosphere CDC, Quest for UDB DB2, ZOS DB2 data sharing. DB2 SQL stored procedure writing. Install, upgrade, maintain ptfs, zparms of DB2, IDMS, IMS using SMPE and 3rd party install processes. Migrated ZOS DB2 from v3 to v4, v4 to v5, v6 to v7, v9 to v10 and v8 to 10. Use of BMC, CA Platinum, IBM DBA Tools, Softech and Softbase data moving tools, Fileaid and DbArtisan support products. QMF and QMF batch, Spufi. Insight, Omegamon, TMON, and CA-Detector performance monitoring tools. 8 years IMS database administration HDAM, HIDAM, HALDB, Fastpath, DBRC. SQL Server 6.5, 2000, 2005 administration and installation. IDMS and IMS conversions to DB2, and mainframe conversions to AIX DB2, SQL Server and Oracle. Logical and Physical design using Erwin, Bachman. Mainframe CICS, DB2, IMS, IDMS, ADSO, Visual Basic, and Powerbuilder programming experience. Ksh scripting. Project management, MS Project. Working knowledge of ZOS, CICS, VTAM, SMS, TSO, Clist, REXX, RACF/TSS, NT, AIX and networking.

Work Experience:

Confidential

Database DBA / systems programmer

ZOS DB2 migration from v8 to v10. Also, application dba support for development and production DB2 and IMS databases on ZOS.

Confidential

Database Specialist

ZOS DB2 80 , UDB DB2 10 , and 10 Sybase production support, maintenance and development DBA. Large OLTP and data warehouse environment. Hundreds of tables and many partitioned tablespaces with billions of rows. Use of BMC and then conversion to CA DB2 products. Sql, systems, and database tuning as well as database maintenance. Full time at times. Perform all db maintenance support in a busy production and development environment

Confidential

Database Specialist

  • Database administration of ZOS DB2 in one of the largest ZOS/DB2/Data sharing sites in the world. Over 45 test and 3 production environments with 5 way data sharing at 3 locations containing 14 prod and 9 test DB2 subsystems that process 1.6 billion DMLs daily in production. Use of the BMC suite of tools and heavy Infosphere CDC data mirroring. Work in an almost perfect 24 x 7 system. Cleaned up all 45 test database environments compared to each's production and make changes, and reorged and changed space allocations to save space and increase performance. Each environment has thousands of tables with many hundreds having 254 partitions.

Confidential

Database Specialist

Database administration ZOS DB2. Use of CA and IBM tools. Also UDB DB2 replication and federated server. Some Sql Server 2005 db admin. Convert an application data replication system from using CA LA to the IBM log analyzer

Confidential

Database Specialist

ZOS DB2 AIX DB2 database administration, heavy SQL tuning. IBM, Softech, Quest, CA, BMC, database tools. Design, plan and implement new databases and changes in very active development environment. 24x7 production support. Backup and recover, DR planning and testing. Copying data between environments using Softech data mover, CA, BMC and IBM tools. Clustered and partitioned UDB environment. Partitioned ZOS DB2 environment with 3 production and 24 test environments.

Confidential

Database Specialist

ZOS DB2, AIX DB2 and IMS fulltime and then remote and part time database administration. Maintain multiple DB2 databases using the BMC, then the CA database products. Maintain IMS HDAM databases. Install, then redirect restore of mainframe databases to the AIX/SAP databases. Then maintain them using SAP's DB2 products.

Confidential

Database Specialist

UDB DB2 AIX DB2 data warehouse performance and tuning review. Analysis of a few databases using Quest performance monitoring software and writing a report detailing a to-do list to increase performance.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship