We provide IT Staff Augmentation Services!

Senior Db2 Database Administrator Resume

SUMMARY:

Seasoned DB2 professional with 25 years of DB2 progressive experience in the Information Technology field that spans 35 years. DB2 experience includes 5 years of system programming related experience, 16 years of DBA experience and 9 years of application programming experience.

PROFESSIONAL EXPERIENCE:

Confidential

Senior DB2 Database Administrator

Responsibilities:

  • Provided oversight for physical database structures using complex technical skills based on physical design for development, test, and production environments.
  • Responsible for complex database performance tuning, security, database backup/recovery strategy, replication, and implementing monitoring procedures to maximize availability of the database.
  • Implemented monitoring procedures to maximize availability and performance of the database, while meeting defined targets.
  • Provided oversight to application development teams on DBMS product technical issues, techniques and SQL review.
  • Coordinated with system programmers to configure systems for DBMS product installation and complex database creation.
  • Configured and maintained DBMS product software on complex database and application system.

Hardware: Confidential 3090 Z/OS

Software: DB2 9.0 DB2 10.0 CA DB2 Tool Suite

Confidential

Senior DB2 DBA

Responsibilities:

  • Participant in the implementation of database changes for releases of software.
  • Promotion of database changes from the development, quality assurance, and production environments.
  • Implementation and enhancement of DB2 utilities in the production environment.
  • Participated in the migration of releases of DB2 software.

Hardware: Confidential 3090 Z/OS, DB2 Linux 9.7.4

Software: DB2 9.0 DB2 10.0, Confidential DB Admin Tool, Data Studio, Omegamon XE for DB2 Performance Expert

Confidential

Senior Database Administrator

Responsibilities:

  • Participated in migration of releases of DB2 software and intermediate upgrades of current releases.
  • Implemented DB2 utilities for the various client databases.
  • Reviewed and enhanced where needed data security to meet company objectives.
  • Implemented various releases of product software.
  • Recommended and implemented features of DB2 that enhanced the company s product software.
  • Introduced pro - active DB2 monitoring techniques.

Hardware: Confidential 3090 Z/OS

Software: DB2 9.0 DB2 10.0 Confidential DB Admin Tool, Omegamon for DB2

Confidential

Database Administration Advisor

Responsibilities:

  • Participated in DBA 24/7 on - call support rotation.
  • Determined database requirements for projects, and ensured database design and support activities meet those requirements.
  • Translated logical data models into physical database structures optimized for the DBMS.
  • Participated in the review of ETL processes and made recommendations regarding DBMS load strategies.
  • Supported development and test database environments.
  • Managed DBMS software including major upgrades, patches, maintenance releases, incidents, and technical alerts.
  • Monitored, analyzed, and managed overall system performance utilizing DBMS tools.
  • Monitored, analyzed, and reported on overall system capacity including but not limited to memory, space, I/O, and CPU.
  • Implemented and made recommendations regarding new database features as they became available.
  • Developed and documented database administrator procedures and service level agreements.
  • Established and monitored corporate database standards, including disaster recovery, security, and data retention.
  • Coached, mentored, and provided guidance for less-experienced database administrators .

Hardware: Confidential 3090 Z/OS

Software: DB2 8.0 DB2 9.0, Confidential DB Admin Tool, Confidential Application Performance Analyzer, Mainview, Confidential SQL Performance Analyzer.

Confidential

Senior DB2 Administrator

Responsibilities:

  • Responsible for the implementation of DB2 V8 subsystems, evaluation and recommendations for third party products, and interface to other Confidential products.
  • Established both system and application backup and recovery plans.
  • Resolved system and application performance issues.
  • Supported the application development community in table loads and SQL reviews.
  • Performed DB2 object creations and maintenance for both packaged and in-house projects.
  • Scheduled DB2 maintenance via utility development for system and application DB2 objects.

Skills Utilized:

Hardware: Confidential 3090 Z/OS

Software: DB2 8.0, IMS, BMC Tool Suite (Catalog manager and Change manager), File-Aid for DB2, Mainview for DB2.

Confidential

DB2 DBA

Responsibilities:

  • Supported the application development team of Social Security
  • Administration for new and existing databases at the development, integration, and production levels.
  • Performed database administrative tasks for DB2 object creation, database performance monitoring and tuning and application tuning.
  • Performed DB2 application wide performance monitoring and tuning, developed application backup and recovery procedures, enhanced application security.
  • Scheduled jobs to perform DB2 maintenance via utility development.

Hardware: Confidential 3090 Z/OS

Software: DB2 7.0, CICS, CA-Platinum Tool Suite, Omegamon for DB2, STROBE, COBOL, and Erwin/ModelMart 4.14.

Confidential

Senior Application Development Specialist (DB2 DBA)

Responsibilities:

  • Supported the application development team of Perot Systems and their client, in the expansion into additional states for insurance business.
  • Performed database administrative tasks for DB2 object creation, database performance monitoring and tuning and application tuning.
  • Performed DB2 system wide performance monitoring and tuning, developed system backup and recovery procedures, enhanced system and application security.
  • Scheduled jobs to perform DB2 maintenance via utility development.

Hardware: Confidential 3090 OS/390

Software: DB2 6.0/7.0, CICS, CA-Platinum Tool Suite Confidential DB2 Tool Suite, Omegamon for DB2 and CICS.

Confidential

Consultant (DB2 Systems Programmer)

Responsibilities:

  • Participated in the data center consolidation effort provided by Confidential for the various agencies of the Confidential .
  • Performed database administrative tasks for DB2 subsystem installations and upgrades, system support and security, system-wide performance monitoring and tuning.
  • System backup and recovery procedures, utility development, and capacity planning.

Hardware: 3090 OS/390

Software: DB 2 5.0/6.0/7.0 , Platinum Tool Suite, BMC Tool Suite, CICS, IMS/DC, Omegamon for CICS and DB2, COBOL, DB2 PM

Hire Now