Database Administrator DB2

Top Database Administrator DB2 Skills

Below we've compiled a list of the most important skills for a Database Administrator DB2. We ranked the top skills based on the percentage of Database Administrator DB2 resumes they appeared on. For example, 15.0% of Database Administrator DB2 resumes contained DB2 as a skill. Let's find out what skills a Database Administrator DB2 actually needs in order to be successful in the workplace.

DB2, 15%
Reorg, 5%
AIX, 5%
Linux, 3%
SQL, 3%
The six most common skills found on Database Administrator DB2 resumes in 2020. Read below to see the full list.

1. DB2

high Demand
Here's how DB2 is used in Database Administrator DB2 jobs:
  • Researched new DB2 system and application functionality and develop implementation strategies.
  • Generated reports of database statistics using DB2LOOK Utility.
  • Created and managed the Operational Level Agreement document and process; produced website for the DB2 Linux Unix and Windows team.
  • Developed an automated process to identify Index usage stats using db2pd and dropped unused indexes, thereby helping the performance updates/inserts.
  • Brief description: Designed, developed and maintained DB2 z/OS v9.1 databases in development, test, QA and production environments.
  • Identified and eliminated unused indexes in the databases Using DB2PD tool and improving the performance of the databases.
  • Created new techniques applying Dynamic-States Modeling to enhance FAM/DB2 performance, and speed up Walker delivered transactions.
  • Created High Tech assembler programs to Auditing DB2 TimeStamps for Walker modules and for Walker troubleshooting.
  • Experience on DB2 utilities, data modeling, creating, loading and unloading of tables.
  • Assisted application teams with all DB2 issues and questions during ON and OFF peak hours.
  • Managed Database Administration and software staffs in mission critical systems for Mainframe DB2 and IMS.
  • Brief description: DB2 Database Administrator supporting the Cards and Merchant system development effort.
  • Monitored remote processing and assisted with DB2 installation, configuration and SQL performance tuning.
  • Worked with the programmers to make efficiency changes to our DB2 tables and SQL.
  • Lead project administrator for the conversion the business file structure from VSAM to DB2.
  • Created my own weekly training program for the DB2 programmers.
  • Used BMC tools to maintain DB2/UDB databases.
  • Provide on-call support on both DB2 for LUW and DB2/ZOS.
  • Use of DB2 tools for Performance tune up.
  • Led the upgrade of DB2V7 to DB2V8 on DB2 z/OS platform Taught RC/Secure class on DB2 z/OS platform

Show More

2. Database

high Demand
Here's how Database is used in Database Administrator DB2 jobs:
  • Project planning, database design, distributed order management, reverse logistics and warehouse management.
  • Provided maintenance like backups, reorganization, recovery, and database analysis error.
  • Monitored databases using database monitors, snapshot monitoring and event monitoring.
  • Develop and document database standards.
  • Key areas of responsibility: in database developments, which include the design and physical implementation.
  • Created and maintained databases, table-spaces, tables, views, nicknames and indexes.
  • Involved in database sizing estimates for the new projects in pipeline.
  • Involved in various database benchmark testing and proof of concepts.
  • Implemented the database backups, restores and disaster recovery.
  • Handled SQL data replication from Mainframe to LUW databases.
  • Analyze and deploy application and database code.
  • Provide 24/7 on-call support for production databases.
  • Configured backup strategy for LUW databases.
  • Deliver rotational 24x7 on-call coverage for all team-supported accounts to provide availability and recoverability of production databases.
  • Administer databases in complex, multi-server environments for internal and commercial customers.
  • Managed DB2 UDB Databases, in Dev and Production environments, at both home and client sites.
  • Monitored the production database regularly using various administrative views sysibmadm and MON_GET / V9.7 SQL functions.
  • Monitor database applications via Omegamon and PM reports.
  • Performed regular database tuning activities during the initial phases of the project so as to improve throughput and meet SLAs.
  • Developed Bourne/Korn shell scripts to automate Multiple Drive & Single Drive installations of the DB2 Footwrks Database, at client sites.

Show More

3. Reorg

high Demand
Here's how Reorg is used in Database Administrator DB2 jobs:
  • Involved in high availability database reorganization procedures that minimize client impacts.
  • Established procedures for backup, recovery and reorganization.
  • Created and maintain regular database maintenance routines for scheduled backups, table / index statistics collection, and table reorganization.
  • Reduced required manpower, and dramatically increased quantity of resources reorganized during a one hour per week window.
  • Key Accomplishments: -Closed the regular reorganization outage window with the new use of parallelism for database unloads.
  • Automated REORG/Runstats/Backup activities and have the notifications sent to applications teams.
  • Monitored space fragmentation and reorganized tablespace and indexes.
  • Designed, created, scheduled and supported reorgs on fragmented database tables at key times in the various monthly processing schedules.
  • Created and documented appropriate jobs to support backup and recovery, database creation, automated reorg, and database maintenance.
  • Write automated scripts for DB health check, backup, restore/redirected restore, reorg, run stats etc.
  • Developed UNIX Korn Shell scripts to automate running RUNSTATS, REORG's, backups and restores.
  • Led maintenance operations to ensure optimal database performance, including Reorg, Rebind, and Load.
  • Worked on REORG utility to reorg the database, DBRM, Package and Plans.
  • Reduced used spaces of large tables by tackling fragmentation through reorg.
  • Archive and Reorganize JDE data using Arctools/Archive and ReorgWizard
  • Performed Run stats and Reorg Utilities.
  • Perform REORGs, RUNSTATS and backup/recovery.
  • Design and implement different utility modules of Load, Unload, Copy, Reorg, Runstats process.
  • Involved in reorg utility migration from CDB product to IBM reorg.
  • Performed Reorgchk, Reorg, Runs tats and rebind as and when necessary to eliminate the defragmentation.

Show More

4. AIX

high Demand
Here's how AIX is used in Database Administrator DB2 jobs:
  • Involved in the creation of a data warehouse on the AIX platform with DB2 Parallel Edition containing drug prescription benefit information.
  • Involved in Installation and configuration of DB2 clients for the customers and maintenance of DB2 server in AIX environment.
  • Maintain the 2TB UDB at AIX platform, IBM portal databases at Linux and application databases at Windows servers.
  • Design, Implement DB2 UDB on AIX databases for an online banking system DBA Tools: DB2 tools
  • Provided on-call coverage for a worldwide 7x24 online distributed OLTP application on an AIX platform.
  • Installed, configured and maintained IBM DB2 9.x on Linux, AIX and Windows.
  • Worked on Source retirement project to migrate applications from DB2 Mainframe to DB2 AIX.
  • Installed and configured DB2 v9 .7fp5 on Linux, AIX and Windows.
  • Worked on a data migration project from AIX to Linux system.
  • Provided DBA support for various applications on AIX and Linux.
  • Worked on migrating databases from AIX to Linux.
  • Set up DB2 UDB/AIX production and development environments.
  • Migrated DB2 UDB V9.7 FP 5 to DB2 DB V10.1 FP 0 on AIX, LINUX & UNIX.
  • Installed and configured DB2 v8, v9, V9.5, V.9.7on Linux, AIX and Windows.
  • Installed DB2 9.5 LUW for AIX and LINUX servers.
  • Performed database utility automation and am on the production on-call rotation for DB2 AIX-Z/OS, Sybase & SQL/Server
  • Installed, implemented Tivoli 3.7 with AIX and Windows.
  • Migrated DB2 UDB V8.2 to DB2 DB V9.7 on AIX 6.1 from 32 bit to 64 bit code.
  • Worked on Database migrations, upgradation and fixpack installations on AIX & LINUX servers.
  • Worked on DB2 V9.7 to V10 Migration from AIX to Linux Worked as DBA for SOX databases 24/7 Oncall support.

Show More

5. Linux

high Demand
Here's how Linux is used in Database Administrator DB2 jobs:
  • Apply vendor fix packs for database servers and clients (Windows, Linux and AIX).
  • Worked on installation of different versions of DB2 UDB on LINUX 4.1 & 3.1.
  • Install and configure DB2 in AIX or Linux environments.
  • Worked on migrating 5 mainframe DB2 databases to UDB/Linux.
  • Created LINUX shell scripts and utilize CRONTAB server scheduler.
  • Installed DB2 software on AIX, Linux and Windows.
  • Involved in scheduling the shell scripts on LINUX environments.
  • Determined Linux kernel changes needed to support V9.7.
  • provide operation and maintenance support for DB2 ZOS and UDB LINUX applications in a client/server environment.
  • Implement Responsibilities: Installed UDB DB2 v10.1/v9.5/9.x, DB2 Client on AIX/LINUX boxes.
  • Installed Fixpacks for DB2 9.7 for both AIX and LINUX.
  • Redirect Restoration of Database.Skills DB2 8.1, Linux

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. SQL

high Demand
Here's how SQL is used in Database Administrator DB2 jobs:
  • Conducted SQL reviews for performance optimization.
  • Worked with developers to perform table structure DDL change, data correction, SQL tuning, track the usage of indexes.
  • Used IBM Data Studio to execute tasks, edited data in tables; generated Interactive access plan diagrams for SQL scripts.
  • Received a recognition award for reducing the process time of a SQL query from one hour down to 5 minutes.
  • Applied the performance tuning tools and utilities for the SQL queries and stored procedures run efficiently.
  • Shell scripts with embedded SQL statements to pull out data from different tables for reporting purposes.
  • Developed SQL for the application group to use XPATH 2.0 concepts to access DB2 XML columns.
  • Provided DBA support to developer community, performance tuning SQL queries using Explain Plan Analysis.
  • Created/modified SQL scripts for customers, and apply security level for particular type of customer.
  • Provide expert assistance in database and SQL statement tuning to improve performance.
  • Reduced annual costs through analysis and tuning of SQL access paths.
  • Replicated data from DB2 to DB2 databases and SQL Server.
  • Supported numerous java based applications, JDBC and SQLJ.
  • Migrated historical operational data from SQL Server into DB2.
  • Analyzed SQLs, creating indexes to resolve performance issues; developed views and other DB2 objects depending on application group requirements.
  • Generated various performance reports like SQL base comparision report etc using OPM tool.
  • Worked with the application teams to tune the SQLs and DB.
  • Optimize SQL queries and analyze database performance issues Convert tablespaces to use Auto storage.
  • Helped application team for fine tune SQLs to reduce runtime.
  • Designed and developed interactive integrated team application web site using php, perl, Informix, MySQL, and Apache.

Show More

7. Runstats

high Demand
Here's how Runstats is used in Database Administrator DB2 jobs:
  • Created and scheduled automated REORG/RUNSTATS scripts to perform automatic maintenance activities on different environments depending on the system needs.
  • Configured the system for automated RUNSTATS, REORG, ONLINE BACKUP, REVERSE ENGINERING jobs using AUTOSYS and K shell scripts.
  • Worked on IBM Utilities like COPY, MODIFY, REORG, RUNSTATS, QUIESCE, REBIND etc.
  • Worked on db utilities like REORG, RUNSTATS, REORGCHK and REBINDS.
  • Put AutoSys job scheduling daily based for Backup, reverse engineering, size of table spaces, snapshot and runstats scripts.
  • Monitor the daily Re-org, Runstats, Copy jobs and in case of failure take corrective measures.
  • Use REORGCHK, Runstats and Update statistics for the system catalog tables.
  • Performed Image copy, Reorg, Runstats, Rebind, Modify, Recovery, and Load, and other maintenance activities.
  • Performed Scheduled maintenance on the databases such as Reorg and Runstats also in purging the older logs and backup images.
  • Automated the backups, Reorgs, Runstats, Space monitoring, monitoring the size of the table spaces, etc.
  • Perform administration tasks such as restore, backup, reorg, runstats, HADR stop / start etc.
  • Involved in day to day database administration tasks like running reorgs, runstats, import and export.
  • Prepare and maintaining BMC DASD jobs to preform image copy, reorg and runstats for database objects.
  • Create scripts for runstats and reorg of database to automate the process at certain period.
  • Schedule and perform Reorgs and Runstats to improve response time and accuracy of data.
  • Created scripts to automate Backups, Runstats, increasing file systems, Reorgchk.
  • Automated Runstats and Reorg Jobs within SAP GUI.
  • Maintained data using IBM DB2 utilities like Runstats, Reorgchk and Reorg.
  • Write Scripts for Monthly Reorg and runstats depending on reorgchk statistics.
  • Worked on IBM DB2 utilities like Runstats, Reorgchk and Reorg.

Show More

8. Recovery Procedures

high Demand
Here's how Recovery Procedures is used in Database Administrator DB2 jobs:
  • Performed DB2 application wide performance monitoring and tuning, developed application backup and recovery procedures, enhanced application security.
  • Automated disaster recovery procedures by Shell scripts that generated restore statements when backups were taken.
  • Perform restoration and data manipulation during recovery procedures.
  • Maintain database security and disaster recovery procedures.
  • Developed DB2 restart and backup/recovery procedures.
  • Provided scripts for load strategies, backup and recovery procedures and performance tuning to ensure the system was available 24/7.
  • Worked on Backup and recovery procedures for off-line and on-line Backup.
  • Recover database as part of the Backup and Recovery procedures.

Show More

9. Unix

high Demand
Here's how Unix is used in Database Administrator DB2 jobs:
  • Developed automated Backup and Restore UNIX script to take Full and Incremental backup and weekly and daily basis for each environment.
  • Designed, created, implemented, maintained, tuned and supported DB2/UDB databases on UNIX and z/OS.
  • Implemented Java application programs with CICS, Unix System Services, and MVS and Java JVM.
  • Experienced in UNIX work environment, file transfers, job scheduling and error handling.
  • Created databases and estimated needed space as well as SAN space for UNIX servers.
  • Requested space for file system and raw - devices to UNIX group.
  • Assisted Unix Administrators in configuration of P690 environment using AIX 5.2.
  • Migrated databases from V 8.2 to V 9.2 in Unix environment.
  • Moved databases from UNIX file system to raw disk devices.
  • Developed data refresh jobs which uses LOAD with UNIX Pipe.
  • Installed new DB2 subsystems on Unix, SAP based environments.
  • Experienced in UNIX shell scripting and troubleshooting.
  • Assisted with managing the Unix infrastructure.
  • Performed UNIX and Linux System administration.
  • Worked with various teams such as Architecture design, Network Support, Windows, UNIX and SAN to setup the clusters.
  • Installed, setup, upgraded and applied fixpacks on UNIX and Windows platforms.
  • Administered & Monitored the DB2/UDB databases and instances using Crontab and UNIX scripts.
  • Developed UNIX shell scripts and setting up cronjobs that automate database monitoring.
  • Maintained UNIX ksh scripts for database backup and monitoring.
  • Implemented interconnectivity between UNIX DB2 and zOS DB2 (both ways).

Show More

10. BMC

high Demand
Here's how BMC is used in Database Administrator DB2 jobs:
  • Installed mainframe and file server components, process schedulers, client-server databases, BMC software, and other related products.
  • Worked on DB2 Data Warehouse; Installed Patrol and BMC SmartDBA; Responsible for upgrades on DB2 across all nodes.
  • Used BMC ChangeManager and Quest Central for DB2 tools to administer and to modify the databases in different environments.
  • Used BMC Log Master to enhance transaction recovery, migrate data quickly, and audit data changes.
  • Performed hundreds of table/column changes and in DB2- most with BMC's Change Manager.
  • Assisted in pilot utilizing BMC Data Propagator and DB2 UDB on a Windows platform.
  • Analyze changes to application and database structure Tools: IBM Utilities BMC Utilities EPILOGUE SAS
  • Set up new databases and modified existing databases using BMC Catalog and Change Manager.
  • Created tables/indexes and promoted to various subsystems, including production using BMC change manager.
  • Used BMC software to create and modify DB2 objects.
  • Performed Initial Space estimation along with growth using BMC.
  • Created Database and associated objects using BMC.
  • Lead DB2-IMS BMC product deactivation project.
  • Work was carried out using IBM's DB2 Utilities, QMF and BMC Utility Suites.
  • Accomplished this with solid knowledge of DB2 and the BMC DB2 Tool Suite.
  • Generated SQL modules and installed BMC's Change Manager, Catalog Manager and Apptune utilities.
  • Provide Technical support and evaluation of online reorg's for both IBM and BMC tools.
  • Monitored DB2 using BMC Patrol, Visual Explain or Access plan and Tivoli Monitoring.
  • Conducted tuning and performance studies using the BMC dbxray product.
  • Involved in online monitoring using BMC Aptune for DB2.

Show More

11. Mainframe

high Demand
Here's how Mainframe is used in Database Administrator DB2 jobs:
  • Configured, maintained and monitored large complex DB2 database environment residing on multiple mainframe and distributed platforms.
  • Perform mainframe DB2 database administration and application support tasks.
  • Provided support for mainframe DB2 insurance applications databases.
  • Provided mainframe DB2 database design, tuning and Production support services to a variety of internal Amtrak customers.
  • Create and present architectural solutions of data flow from Mainframe to DB2 client servers using DB2 Connect product.
  • Worked in configuring Q-replication for cross platform and mainframe, handled the migration from SQL replication to Q-Replication.
  • Aided Business Analyst in the design of DB2 databases for mainframe, and intranet business applications.
  • Managed database maintenance process for the IBM DB2 mainframe batch billing and service order entry systems.
  • Project lead on migration of mainframe and web applications from one DB2 subsystem to another.
  • Performed logical and physical design for large (110+tables) IBM mainframe DB2 environment.
  • Installed and administered DB2 Connect to catalog databases on mainframe through gateway server.
  • Position Description: Works as DB2 DBA in supporting mainframe Z\OS applications.
  • Operated on an IBM 3090 mainframe environment with TSO/ISPF.
  • Provided mainframe DB2 DBA application support to ConAgra personnel.
  • Supported conversions to IBM mainframe environment across 10-state area.
  • Project size: Very large Mainframe Based Application.
  • Design and creation of DB2 databases, tables, tablespaces and indexes on the mainframe and Windows NT server.
  • Performed performance tuning and monitoring Running various DB2 utilities in Mainframe on DB2 10.
  • Participate in the Migration of database from mainframe AS400 to UDB AIX system.
  • Experience in scheduling Mainframe Jobs using Jobtrac.

Show More

12. Data Warehouse

high Demand
Here's how Data Warehouse is used in Database Administrator DB2 jobs:
  • Provided suggestions and recommendations for Data warehouse EEE logical and physical design; initiated discussions on sizing and data placement strategies.
  • Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Warehouse.
  • Monitored and administered 7TB corporate data warehouse (CDW); executed ETL processes to integrate and manage CDW data flow.
  • Provide primary DBA design and support services for establishing, upgrading and maintaining the DB2 UDB Data Warehouse environments.
  • Implement backup and recovery procedures for DB2 UDB Data Warehouse databases and test regularly in conjunction with Operations.
  • Created and maintain dimensional models in support of marketing and sales related data for Enterprise Data Warehouse solution.
  • Create, maintain and refresh required DB2 UDB Data Warehouse instances/databases for development, test and production environments.
  • Worked with ETL teams to develop the patterns for data movements and loading data into Data warehouse environments.
  • Replicated data from DB2 10.1 Pure scale from OLTP to Data warehouse using Q - Replication methods.
  • Completed creating JCL on MVS platform to UNLOAD/LOAD data from various resources into production Data Warehouse.
  • Use of software and locally developed tools to monitor DB2 UDB Data Warehouse databases.
  • Worked with system architects to design the data warehouse database and partition the tables.
  • Design and deploy a complete Enterprise Wide Information Data Warehouse Application.
  • Identify benchmark queries for data warehouse for stress testing needs.
  • Designed schemas and objects for managing data and generating reports in data warehouse for credit cards issued in ASIA region.
  • Worked on DB2 Data Warehouse Worked on end-to-end storage stack, including host servers and the software defined storage product.
  • Worked on space estimate and tablespace design to accommodate large amount of data in data warehouse environment.
  • Worked on DB2 Data Warehouse, Multi Partition Databases and ETL methods.
  • Monitor daily/weekly jobs and resolve if there is any failures Supported OLTP and Data Warehouse environments and supported PEGA application.
  • Designed data warehouse ure, data modeling & design including star schemas and data marts using data DB2 information integrator.

Show More

13. Hadr

high Demand
Here's how Hadr is used in Database Administrator DB2 jobs:
  • Implemented High Availability and Disaster Recovery Solution for Major Production servers using IBM DB2 HADR Solutions.
  • Plan and implement Fix pack upgrades in V9.7 {Rolling upgrade for HADR environments}.
  • Initiated plan to cut disaster recovery pipeline traffic by over 95% by utilizing HADR.
  • Experience in setting up and maintaining High availability disaster recovery (HADR).
  • Experience with DB2 HADR, offline transaction log shipping, data replication.
  • Installed and monitored Disaster Recovery boxes and HADR for critical databases.
  • Experience with setting up, supporting and troubleshooting HADR.
  • Involved in HADR set up.
  • Optimized very large databases for performance Participated in High Availability Disaster Recovery (HADR) solution for business continuity
  • Test HADR performance for production environments..
  • Implemented HADR, MQTs, table partitioning, backup, recovery, redirected restores, triggers and stored procedures.
  • Perform restore on different situation depending upon requirement Apply fix pack on HADR, HACMP environment and troubleshooting.
  • Fix pack installation, up-gradation of DB instances * Implemented the HADR and it's maintenance.
  • Converted over 100 DB2 databases to utilize HIGH Availability and Disaster Recovery (HADR).
  • Implemented TSA with HADR across Dev, QA, Pre-Prod & Production Servers.
  • Implemented HADR setup with Tivoli System Automation (TSA).
  • Worked in Migration, and Failover testing (HACMP/HADR).
  • Set up HADR for the production andperformance test environments.
  • Installed and configured SuSe Linux Upgraded DB2 from V9.5 to V9.7 on Linux Installed and configured DB2 V9.7 HADR environment.
  • Added space to tablespace containers to fix Operational Data Store HADR failover issues.

Show More

14. Z/OS

high Demand
Here's how Z/OS is used in Database Administrator DB2 jobs:
  • Maintained, implemented, tuned and upgraded DB2 Databases (Z/OS Data Sharing Environment) in SAP environment.
  • Project DB2 DBA Application Support in z/OS platform Customer ABN-AMRO Bank, Amsterdam, Holland.
  • Designed and built the FAST registration central database using DB2 on an IBM z/OS platform.
  • Experience Summary =================== => IBM Certified Database Administrator - DB2 DBA for z/OS.
  • Project DB2 DBA Application Support and Application Architect in z/OS platform Customer US Dept.
  • Support a web based procurement system with a DB2 for Z/OS back end.
  • Hired as a consultant to migrate IBM UDB DB2 databases from Z/OS to Windows
  • Supported Public Employees Insurance Agency (PEIA) applications on DB2 Z/OS databases.
  • Design and implement monitoring procedures using both z/OS and desktop solutions.
  • Provide 24x7 support for DB2 z/OS enterprise database systems.
  • Installed and configured test subsystem for DB2 z/OS.
  • Project DB2 DBA Application Support in z/OS platform.
  • Performed migration of DB2 z/OS to version 10.
  • Assisted in the upgrade of DB2 software from DB2 version 6 to DB2 UDB version 7.2 utilizing OS/390 and z/OS.
  • Trained DB2 z/OS staff in tuning DB2.
  • Created Subscription sets using Replication Centre to replicate the changes from DB2 on z/OS to staging tables in UNIX.
  • Created and monitored Peoplesoft transaction servers running under z/OS USS (Unix System Services).
  • Designed Miami Dade county DB2 z/OS disaster recovery plan.
  • Designed DB2 z/OS data warehouse for Foveon, a internet usage data analysis start-up.

Show More

15. DB2 LUW

average Demand
Here's how DB2 LUW is used in Database Administrator DB2 jobs:
  • Work in the DB2 LUW team in providing better technical solution for United Health in general and our customer in particular.
  • Pioneered a migration project plan for migrating the IBM DB2 LUW database from version 8.1 FixPak6 to version 9.1 FixPak2.
  • Used different DB2 LUW data movement utilities like db2move, db2look and db2batch etc.
  • Monitor DB2 LUW databases for space utilization and performance degradation and Tune as needed.
  • Involved in data migration from DB2 for OS/390 to DB2 LUW or vice versa and between Linux and AIX.
  • Monitor performance and proactively manage all databases.Environment: DB2 LUW v9.5/9.7 UNIX, Shell Scripting, Control Center.
  • Assisted Allegiant Airline modernization project; Database conversion from MYSQL to DB2 LUW.
  • Extracted Mainframe data using Datastage to DB2 LUW.
  • Determine need for DB2 LUW utilities (i.e.
  • Configured and automated RUNSTATS for updating statistics of the frequently used tables Determine need for DB2 LUW utilities (i.e.
  • Supported the upgrade of the Siebel CRM application to version 7.8 via support of DB2 LUW 8.2 database systems.

Show More

16. Production Environment

average Demand
Here's how Production Environment is used in Database Administrator DB2 jobs:
  • Developed database security strategy to provide access to large number of users in production environment.
  • Lead analyst for managing data storage and performance in production environment.
  • Export and Import and Load utilities for the setting up same references in Test Region as existing in the Production environment.
  • Designed logical and physical databases and database objects for DB2 UDB on Development, Test and Production environments.
  • Migrate and/or coordinate the migration of application systems from test (for quality assurance) to production environments.
  • Implemented and maintained the database security in development, testing, QA, and production environment.
  • Support production environments, configuration, testing, and performance tuning of all DB2 database environments.
  • Test and evaluate new software products in test regions and cut over to production environments.
  • Supported developers to write SQL statements and test them before running it in Production environment.
  • Provided DB2 support services in Staging and Production environments to the Operations DBA's.
  • Designed, implemented and administered DB2 UDB for development, test and production environments.
  • Worked on security strategy to provide access to the users in production environment.
  • Created, maintained and supported DB2 development, quality assurance and production environments.
  • Created and maintained instances and databases in development, test and production environments.
  • Supervised and managed 4 fulltime Oracle/SQL Server/DB2 Database Administrators and 2 contractors in development, quality control and production environments.
  • Administered and supported enterprise databases and 30 DB2/EE server-based applications across development, testing, and pre-production environments.
  • Implemented database auditing, data security and Remediate high-risk violation in production environment.
  • Provide estimates to the project team for the physical implementation of the design in QA test environment and Production environment 4.
  • Design and create DB2 objects in Development, TEST and Pre-production environments.
  • Co-ordinated and validated failover testing of databases in lower and Production environments.

Show More

17. Setup

average Demand
Here's how Setup is used in Database Administrator DB2 jobs:
  • Worked on High Availability Disaster Recovery setup for the databases.
  • Experience in Temporal tables Bi-directional replication setup.
  • Supported the State of Alabama's WLM goal setting, WLM environment setup for DB2 stored procedures, stored procedure design.
  • Installed, setup, configured and manage data replication using Oracle 10g Streams and DB2 UDB data propagator respectively.
  • Installed, setup, configured and manage federated systems using Oracle and DB2 UDB as data sources respectively.
  • Implemented replication setup between heterogeneous environments like OS/390 and AIX using both DJRA and Replication Center.
  • Involved in activities like interface setup between mainframe system and file transfer using FTP and XFB.
  • Design and setup system for federation using Wrappers, Servers, User-mapping and nick names.
  • Involved in production/development setup, configuration and support Reverse engineering, schema generation & Complete compare using Erwin tool.
  • Forward engineering to create the Data Definition Language (DDL) scripts to setup the database in development.
  • Used IBM Optimization Centre to setup Monitor profiles and tune complex SQL queries.
  • build new db2 database server, qrep setup and troubleshooting

Show More

18. Table Spaces

average Demand
Here's how Table Spaces is used in Database Administrator DB2 jobs:
  • Implemented automated backups, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold.
  • Planned, designed, implemented, and promoted the physical databases, table spaces, tables, views, Indexes.
  • Created and maintained UDB DDL for databases, table spaces, tables, views, triggers, and stored procedures.
  • Monitor DASHBOARD report for Missed copies, Objects size increase for Partitioned and Non Partitioned table spaces, etc.
  • Designed the database by creating separate buffer pools, table spaces, tables and other database objects.
  • Loaded, unloaded, recovered, reorganized and image copied table spaces.
  • Administered database, table and table spaces.
  • Create backups of table spaces.
  • Created DB2 instances, databases, buffer pools, table spaces, tables, and indexes.
  • Experience on creating the new Table Spaces (DMS).
  • Mainatained Databases, Table spaces, indexes, views, Stored Procedures, functions, triggers etc.
  • Maintained the disk volumes of system by compressing more than 4000 table spaces using Reorg software.
  • Involved in compressing the table spaces using reorg, which in turn saved disk volumes.

Show More

19. Capacity Planning

average Demand
Here's how Capacity Planning is used in Database Administrator DB2 jobs:
  • Involved in capacity planning and storage management along with the system administrator.
  • Designed and implemented Capacity planning strategy for UDB databases.
  • Performed capacity planning and performance tuning.
  • Designed, created and managed complex system of database monitoring tools used for capacity planning and performance tuning for OLTP databases.
  • Perform SAP architecture sizing and capacity planning to meet SAP enterprise deployment.
  • Performed Capacity planning and tracking table space and file systems.
  • Performed Capacity Planning work on all production and test servers.
  • Involved in capacity planning and decision making.
  • Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots.
  • Participated in the capacity planning of new Datawarehouse database and implemented the migration plan from Informix to DB2 UDB.
  • Devise strategy for Backups, recovery & fine-tuning Monitoring space utilizations, sizing, and capacity planning.

Show More

20. On-Call

average Demand
Here's how On-Call is used in Database Administrator DB2 jobs:
  • Review vendor support products and off-shift on-call responsibilities.
  • Provide on-call (24X7) support for all databases and document all the issues encountered when on-call.
  • Provided primary and secondary on-call support for DB2 nightly batch jobs, including backups.
  • Implemented the Lean process by sharing Lean queue responsibilities and providing on-call support.
  • Rotated on-call (beeper) support for DBA issues encountered by application teams.
  • Provide on-call support in adherence to specific business and customer Service Level Agreements.
  • Support in terms of on-call DBA for Weekly maintenance of all databases.
  • Provide 24X7 on-call support to troubleshoot issues with the Production schedule.
  • Provide after hours on-call support for deployments and critical database issues.
  • Supported on-call DBA responsibilities in UDB off-hour (24/7).
  • Provide DB2 production on-call support on a scheduled basis.
  • Provided on-call support and well exposed to 24x7 environments.
  • Provided 24x7 on-call support for the production databases.
  • Provided UAT and production 24x7 on-call support.
  • Participated in the On-Call rotation when needed.
  • Involved in 24x7 support and On-call support.
  • support on an on-call and as needed basis.

Show More

21. TSM

average Demand
Here's how TSM is used in Database Administrator DB2 jobs:
  • Design and implemented online and incremental database backup and disaster recovery plan using TSM.
  • Worked extensively with backups (Offline and online), restores, redirected restores and backups/Restore using TSM and table compression.
  • Used NFS File system for backups and User Exit for archival logging and TSM to archive the History.
  • Worked with the TSM team on backup and archive log issues on slow delayed performance or failed TSM.
  • Perform file system copy from production to non-production using TSM backup and recovering DB2 databases in non-production environment.
  • Requested TSM management class from the TSM administrator and configure Database parameters to use TSM management class.
  • Improved backup times using TSM disk from 4 hours to under 2 hours.
  • Lead the implementation of TSM log archive and database backup.
  • Schedule all automatic file system backup to TSM.
  • Configured the backup and recovery on TSM server.
  • Scheduled database changes, using ITSM tool.
  • Extract and verify logs from TSM server.
  • Performed backup and restore functions using TSM.
  • Worked with TSM and VERITAS net backups.
  • Optimize & maintain database performance and backup schedules using TSM, offline, online, incremental, redirected restores, SQLscripting.
  • Set up Tivoli Storage Manager Server - Installed TSM on AIX and Window NT.
  • Established offsite tape archiving processes and procedures - Added TSM LAN FREE backup methods.
  • Configured backups and logs to disk and Tivoli Storage Manager (TSM).
  • Set up DB2 Backup to Tivoli Storage manager (TSM) Responsible for physical and logical disk layout.
  • Putty, Citrix, TSM, Veritas NetBackup DataCenter

Show More

22. JCL

average Demand
Here's how JCL is used in Database Administrator DB2 jobs:
  • Provided ongoing technical assistance and education to application developers and business analysts for DB2, COBOL, JCL and SQL.
  • Set up all Image Copy JCL for all databases to create periodic backups for all DB2 tables.
  • Created Database Design documents, Data Dictionary, Backup, Copy and reorganization JCL streams.
  • Coded program to generate over 5,000 JCL and data files for the above processes.
  • Created JCL jobs for subscription management and monitoring.
  • Maintained JCL scheduling via Control-M. Documented production changes.
  • Created JCL for IMAGE COPY, UNLOAD DATABASE Recovery and BACKUP.
  • Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs.
  • Created JCL to take a BACKUP for the daily balancing dataset.
  • Coded JCL when necessary for data rollup and database backup.
  • Created JCL for IBM's Check, Load, Image Copy and Quiesce utilities.

Show More

23. Cics

average Demand
Here's how Cics is used in Database Administrator DB2 jobs:
  • Participate in database design, and implementation, performance tuning, optimization and day-to-day DB2/CICS/NATURAL/ADABAS/NDM application support.
  • Design and development of tools for the CICS and DB2 DBA support teams to make tasks more efficient.
  • Used various tools like DB2Move and Connecting and Disconnecting CICS and other services from DB2.
  • Support and troubleshoot Client-Server Application interfacing with Walker CICS System using VB5 and VC++6.
  • Developed online CICS listener programs to synchronize data transferred from MQ to DB2 tables.
  • Lead DBA on Financial applications, including MIS Billing and Customer Master CICS/Batch.
  • Provided Limited scope support for CICS Issues, File allocation and de-allocation to CICS region and for their transaction definition.
  • Design and development of an asynchronous TCP/IP interface between Walker CICS System and Legacy System running under Unisys.

Show More

24. DPF

average Demand
Here's how DPF is used in Database Administrator DB2 jobs:
  • Worked on migrating multiple Databases from 9.7 to 10.5.4 in new DPF architecture using redirect restore and Admin move utility.
  • Experienced in OLTP & OLAP database environments which include Single Partitioned and Multi-Partitioned Databases (DPF).
  • Implemented and deployed the company's largest database a 1.71 Terabyte DPF database with split image backup.
  • Experience on Database Partitioning Feature (DPF) for maintaining very large databases.
  • Migrated many databases from V9.1 FP5 to V9.7 FP3a (DPF), V9.7 FP8 to V10.1 (DPF).
  • Installed the DB2 EE and DPF v. 8.2 on AIX v.5.2.
  • Prod and dev support of UDB servers 8.2 in VCS and standalone environments, including DPF(EEE) system.
  • Supported cognos application on partitioned environment (DPF) with 8 physical partitions and 29 partitioned ware house environment.
  • Experience on Database Partitioning Feature (DPF) Performed all structural changes to DB2 databases.
  • Worked on HADR setup using TSA Worked knowledge on DPF database.
  • Maintain the productions database (DPF).
  • Supported DPF databases and worked with Hash partitioning, Range partitioning, MDCs, MQTs and Q replication.

Show More

25. DDL

average Demand
Here's how DDL is used in Database Administrator DB2 jobs:
  • Performed Physical Database Design, collaborating with architects in deciding the partitioning keys, DDL implementation, modification and design.
  • Involved in Database development includes developing DDL and database objects.
  • Developed all DDL, SQL as well as shell scripts for the NEON/IBM software product installation process.
  • Design DDL to install DB2 database objects such as tables and indexes for Order Management systems.
  • Generate DDL statements for database objects, move database objects from development to test environments.
  • Worked with DDL/DML/DCL whenever it's required right from Lower regions to Production.
  • Develop and execute appropriate Data Definition Language (DDL) to support project.
  • Carry out the execution of DDL scripts as provided by the customer.
  • Performed Test and Prod application upgrades including code drop and DDL manipulation.
  • Generated accurate DB2 DDL / SQL code to meet system specifications.
  • Extracted the DDL structure of the Database objects using db2look.
  • Ported MQSI product DDL and SQL to Japanese.
  • Base line DDL provided by data modeler.
  • Table development and construction DDL.
  • Ported all DB2 DDL and SQL code for UNIX to Windows and OS/390.
  • Maintained DDL, DML, and DCL.
  • Utilized Endevor to manage the migration of DDL and JCL to Corporate Database Support in Colorado Springs.
  • Generated and implemented DDL from the logical model using Erwin Data modelling.
  • Ported DDL and SQL from multiple platforms (Oracle, SQL Server, Sybase) to DB2.
  • Execute DCL, DDL, and DML on database objects using JCLs and SPUFI.

Show More

26. Cobol

average Demand
Here's how Cobol is used in Database Administrator DB2 jobs:
  • Implemented trigger and stored procedures (COBOL\PERL) and enforced business rules via checks and constraints.
  • Performed all DBA functions to maintain DB2 tables on mainframe and COBOL DB2 programs.
  • Created a number of proofs-of-concept in Cobol and .NET.

Show More

27. V97

average Demand

28. V95

average Demand

29. QA

average Demand
Here's how QA is used in Database Administrator DB2 jobs:
  • Deployed and supported DB2 UDB client's application databases in development, QA, Staging, and production environments.
  • Refresh PROD database to QA and UAT environment using Outage Minimized Refresh {OMR} procedure.
  • Implement development, QA, Test and production databases and tuning to support the architecture.
  • Backed up databases frequently depending upon the type like Prod, QA, and Test.
  • Experience in supporting multiple large scale development, QA and production database environments.
  • Configured and tested both software products in Engineering, test and QA servers.
  • Team supports all Production, Development & Test (QA) databases.
  • Redirect Restore to move application from Development, QA and Production.
  • Experience with Database refreshes from production to QA systems.
  • Support QA and DEV environments with refresh tasks.
  • Implemented a full-fledged development, QA, test and production DB2 UDB databases for PeopleSoft financials and portal databases.
  • Performed environment database restores/refresh on (Dev, QA, and staging) using production image.
  • Implemented DB2 Performance Expert monitoring tool on Dev, QA and Prod servers.
  • Project Test Environment Operations Project comprises of Database Administration (DBA) activity and QA support for GWM applications.

Show More

30. Websphere

low Demand
Here's how Websphere is used in Database Administrator DB2 jobs:
  • Fine-tuned and maintained DB2 for back end applications, and configured WebSphere applications' or IDMS connection to DB2 servers.
  • Design and implementation of ORDER flow process using the WebSphere and MQ series related tables.
  • Created new repository databases for WebSphere 4 servers.
  • Installed and configured WebSphere version 5.1 and version 6
  • Used Data Warehousing concepts and WebSphere.
  • Implemented Siebel applications/WebSphere MQ/Oracle DB2 on UNIX and Windows platforms.
  • Accomplished Websphere performance issues with BPM.
  • Used Weblogic 9.1 and Websphere to create PIA connections on the MBUSA intranet.

Show More

31. Maintenance Activities

low Demand
Here's how Maintenance Activities is used in Database Administrator DB2 jobs:
  • Perform weekly maintenance activities for databases.
  • Experience on DB2 Installation, Planning, Migration and Maintenance activities.
  • Utilized the below SAPGUI tools for Database Monitoring and Maintenance activities.

Show More

32. ETL

low Demand
Here's how ETL is used in Database Administrator DB2 jobs:
  • Worked on tuning database and Database manager configuration for optimum performance to support ETL applications.
  • Developed ETL routines using DB2 load, unload utilities, DB2 connect, (data warehousing) and imports/exports.
  • Experience working with ETL tools to extract DB2 data from ZOS to staging tables in distributed platform.
  • Created Database Triggers, Functions, and Stored procedures for ETL as critical elements for ETL.
  • Migrate, create, and modify Extract, Transformation and load (ETL) processes.
  • Performed data extractions, conversions and database loads (ETL).
  • Designed and created ETL Process flows and Data load process.
  • Supported ETL/Developers, off-shore resources, trouble-shooting, and tuning.
  • Maintained and modified Kettle ETL.
  • Used Data Stage as ETL tool.
  • Provide database size estimates at each stage of implementations and suggest solutions for optimizing ETL (Ab Initio) process.
  • Experimented with changing buffer pool and tablespace page size to improve time taken by ETL to build data marts.
  • Supported ETL team for load issues and did general performance tuning on running workflows and mapping.
  • Apply and troubleshoot ETL scripts to the data warehouse and Siebel databases.
  • Set up and manage ETL processing utilizing the Informatica tool.
  • Monitor and trouble shoot ETL jobs running on informatica.
  • Supported ETl team and worked in offshore model.
  • Designed and maintained Datastage ETL.
  • Monitored all production ETL (AB Initio) as well as reporting (Microstrategy) jobs 24X7.
  • Experimented with Indexes and employed Index Advisor to improve user report and speed ETL runtime.

Show More

33. Oltp

low Demand
Here's how Oltp is used in Database Administrator DB2 jobs:
  • Create and implement effective referential integrity rules for complex databases in OLTP environment.
  • Work closely with development team to review and analyze database requirements for OLTP, data warehousing and reporting & analysis applications.
  • Implemented Q - replication method to sync data from OLTP to Data warehousing environment.
  • Worked on highly OLTP system, that has more than 25k executions per second.
  • Involved in different scenarios of OLTP as well as DSS databases.
  • Created a complete server-side application to dynamically denormalize OLTP data into reporting tables.. Wrote and tuned number of UDB stored procs.

Show More

34. Solaris

low Demand
Here's how Solaris is used in Database Administrator DB2 jobs:
  • Performed migration from DB2 V7 to V8, from Solaris to AIX platforms.
  • Installed and configured all components of the 10g Application Server on Solaris environment.
  • Supported AIG Database administration during SAP migration from DB2 Solaris to DB2 z/OS data sharing parallel sysplex.

Show More

35. IMS

low Demand
Here's how IMS is used in Database Administrator DB2 jobs:
  • Participated in the Disaster Recovery process by bringing up all the IMS and DB2 regions in the new location.
  • Provided the day to day support and administration activities of DB2/IMS subsystems across various LPARS of Z/OS mainframe systems.
  • Provided full-time 24-hour technical support, development, and enhancements for all IMS prod and test systems.
  • Set up IMS Data capture Exit routine and help application in its usage and maintenance.
  • Experience in installing and applying Maintenance on IMS and DB2 systems using SMP/E tool.
  • Participate in an IMS to DB2 conversion project for the Agency group.
  • Provided DBA support for all IMS tools including BMC and UBS products.
  • Help applications teams in loading and unloading of data from DB2/IMS databases.
  • Perform the Analysis of IMS and DB2 batch job failures.
  • Project was to Move CIS information from IMS to DB2.
  • Create and modified DB2 and IMS databases as requested.
  • Assumed support role for legacy IMS databases.
  • Provide DB2 weekly REORG and IMS 24/7 on call support.
  • Provide support for the production abends which are related to DB2/IMS and maintain the on call log for each event.
  • Helped porting the core applications from IMS to DB2/OS390 and ensured Y2K compliant.
  • Supported oncall rotations for DB2, IMS.

Show More

36. V9

low Demand
Here's how V9 is used in Database Administrator DB2 jobs:
  • Supported upgrade from V8 to V9 for one client and planning for a V8 to V10 conversion for a second client.
  • Lead for DBRM to plan-package conversion and Upgrade of all plan-table groups to V9/V10 format.
  • Created new partitions for V9.5 Range partitioned tables using ATTACH PARTITION of ALTER TABLE Statement.
  • Upgraded database environment from DB2 UDB ESE v8.5 and v9.5 on AIX servers.
  • Implemented DDL and DML changes in the database using new features of V9.5/V9.7/V10.1.
  • Provide DB2 evaluation of DB2 v9.7 environment (AIX operating system).
  • Created V9.7 Locking event Monitors for analysis of Lock-waits and deadlocks.
  • Converted all SQL-compiled stored procedures to v9 native stored procedures.
  • Worked on a data migration projects from v9.7 to V10.
  • Applied various FixPacks to v8.x and v9.x database servers.
  • Up gradation of database from v9.5 fp10 to v9.7 fp7.
  • Support DB2 V8 and V9 on four sub systems.
  • Migrated from V8.2 to V9.5.
  • Migrated from V8.2 to V9.1 Explored new features of V9 and implemented the new features while migrating to the newer versions.
  • Researched new features of DB2 V9 that would help in a SAP Environment (zLinux).
  • Migrated from V8.2 to V9.1 Create and modify databases and database objects as per application requests.
  • Performed DB upgradation from V8 to V9.
  • Involved in the upgrade of CDB Reorg software to V9 and V10.
  • Involved in fixpack upgradation on client & DB servers on V9.
  • Converted many regular Tablespaces to V9.5 large Tablespaces.

Show More

37. DBM

low Demand
Here's how DBM is used in Database Administrator DB2 jobs:
  • Maintained and administered application database security in accordance with RDBMS and organizational approved standards and procedures.
  • Implemented backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system.
  • Provided consultation to application development teams on DBMS product technical issues, techniques and SQL review.
  • Developed and coded state of art techniques to improve performance at I/O and DBMS level.
  • Coordinated with system engineers to configure servers for DBMS product installation and complex database creation.
  • Tuned DBM, DB Configuration parameters and Registry variables for optimal database performance.
  • Maintained documentation on the DBMS aspect of the application.
  • Updated the DBM and DB configuration parameter.
  • Created and Monitored DBMS utilities.
  • Update DBM, DB and DB2 UDB set parameters.
  • Update DBM, DB and Db2set parameters.
  • Developed korn scripts to capture benchmarks for performance of database by changing the DB CFG and DBM CFG parameters.
  • Created a disaster recovery plan for my servers: Participated in conversion from Oracle to UDB RDBMS.
  • Tuned application queries, Databases and Systems for best performance using db and dbm parameters.
  • Tuned DBM configuration parameters and DB cfg parameters.

Show More

38. QMF

low Demand
Here's how QMF is used in Database Administrator DB2 jobs:
  • Educate staff on new applications including Microsoft SharePoint, IBM Data Studio, QMF for Windows, and DB2 Connect.
  • Worked extensively with database tools such as QMF and Platinum database analyzer.
  • Provided reports to managers and end users via QMF.

Show More

39. Event Monitors

low Demand
Here's how Event Monitors is used in Database Administrator DB2 jobs:
  • Decide database monitoring strategies using snapshots, event monitors.
  • Created event monitors, snapshots analyzing the event monitor data for effective database tuning.
  • Used DB2/UDB Snapshot and Event monitors to monitor the database for application performance.
  • Used tools viz., db2expln, db2trc , db2look, db2pd etc.., Create and setting up event monitors.

Show More

40. Dasd

low Demand
Here's how Dasd is used in Database Administrator DB2 jobs:
  • Performed periodic disk space checks and added DASD as needed to the sub-system storage groups.
  • Created new databases and monitored and corrected space (DASD) usage.
  • Coordinated with DASD team on disk and database design.
  • Monitor and adjust DASD and other resource utilization.
  • Space Estimation for DASD Requirements reports preparation.

Show More

41. Space Management

low Demand
Here's how Space Management is used in Database Administrator DB2 jobs:
  • Space management/User Management for the Databases.
  • Have worked on table space management and DB2 Storage optimization.
  • Table space creation and other database space management operations.
  • Involved in capacity planning and space management.
  • Space Management and database upgrades.
  • Maintained, monitored and performed troubleshooting of QREP subscriptions Involved in capacity planning and space management.
  • Planned and implemented space management, data movement, permissions / security..
  • Table space management -Adding, dropping, extending, reducing and resizing table space containers.
  • Space management of tablespace usage and attending to them whenever required.

Show More

42. Vsam

low Demand
Here's how Vsam is used in Database Administrator DB2 jobs:
  • Managed a team responsible for the physical design for the conversion of 30 trade databases from VSAM to OSAM and implemented.
  • Support district financial system conversion from VSAM to DB2.
  • Project: Migration from VSAM to DB2.
  • Develop SQL to replace VSAM I-O.
  • Provided PSB, DBD, VSAM control parms maintenace.

Show More

43. Toad

low Demand
Here's how Toad is used in Database Administrator DB2 jobs:
  • Performed database tuning using TOAD, Quest Central monitoring tool, Explain Plan and MAINVIEW.

Show More

44. Rexx

low Demand
Here's how Rexx is used in Database Administrator DB2 jobs:
  • Coded dynamic REXX-generated online table reorganization process based off of Real Time Statistics.
  • Developed many REXX/Batch utilities to support Application Time Facility (ATF) or TICTOC to Hourglass conversion project.
  • Developed around 20+ REXX utilities for the USAA client.
  • Create in-house written tools utilizing REXX and ISPF.
  • Developed many REXX utilities for this task.
  • Modified & created REXX and SAS programs.
  • Work required using REXX, SAS and DB2 DBA skills.
  • Created and maintained Rexx Execs which enabled application developers to manage the creation of DB2 Stored Procedures.
  • Worked extensively on REXX Tools Altering DB Objects.

Show More

45. Omegamon

low Demand
Here's how Omegamon is used in Database Administrator DB2 jobs:
  • Provide production subsystem monitoring using Omegamon (DB2PE), analyzing performance, accounting and statistic traces.
  • Installed and configured DB2 for Omegamon.
  • Use tools like RC Query, PSTRANS, DBA Xpert, and Omegamon.

Show More

46. CPU

low Demand
Here's how CPU is used in Database Administrator DB2 jobs:
  • Maintain database and instance configuration parameters, monitor SAN disk I/O performance, server memory, CPU usage and object placement.
  • Reduced CPU utilization to assist in the delay of a processor upgrade with substantial cost savings to the company.
  • Designed process to detect month-to-month CPU usage changes at the program level.
  • Monitor CPU, memory and Disk IO for Database servers.
  • Monitor CPU, memory and Disk IO for Database servers using NMON, TOPAS, TOP, db2top, db2pd.
  • Helped plan the optimum utilization of the CPUs and memory between the application and the database within the LPAR virtual environment.
  • Reduce CPU consumption by optimizing sql.

Show More

47. Buffer Pools

low Demand
Here's how Buffer Pools is used in Database Administrator DB2 jobs:
  • Explain and Snapshots, Buffer pools performance optimization, SQL performance evaluation, analysis, and optimization.
  • Manage DB2 buffer pools for table space scans and index based queries.
  • Set up DB2 UDB buffer pools and tablespaces proactive performance monitoring procedures using DB2 snapshots.

Show More

48. MVS

low Demand
Here's how MVS is used in Database Administrator DB2 jobs:
  • Created and maintained Federated links from LUW UNIX to MVS.
  • Monitor integrity and performance of the database using Profiler, tuning advisor, statistics, DMVs.

Show More

49. Physical Design

low Demand
Here's how Physical Design is used in Database Administrator DB2 jobs:
  • Provided support for complex databases including physical design, support of application testing, database availability, and query performance.
  • Worked with the applications staff to perform logical and physical designs of databases and objects.
  • Implemented and Maintained Physical Design with creating and maintaining Tablespaces, and database objects.
  • Provided physical design and implementation for Satyam's SAP Business Warehouse.

Show More

50. Image Copy

low Demand
Here's how Image Copy is used in Database Administrator DB2 jobs:
  • Build Unload and Load utilities jobs, to populate test databases with production data and using image copy.
  • Release DB2 House keeping jobs like reorg, image copy, runstats
  • Release DB2 utilities jobs like reorg, image copy, runstats ..etc Tuning of SQL queries for optimal performance.

Show More

20 Most Common Skill for a Database Administrator DB2

DB220.4%
Database18.7%
Reorg6.9%
AIX6.7%
Linux4.3%
SQL4.2%
Runstats4.2%
Recovery Procedures3.5%

Typical Skill-Sets Required For A Database Administrator DB2

RankSkillPercentage of ResumesPercentage
1
1
DB2
DB2
15%
15%
2
2
Database
Database
13.7%
13.7%
3
3
Reorg
Reorg
5.1%
5.1%
4
4
AIX
AIX
4.9%
4.9%
5
5
Linux
Linux
3.2%
3.2%
6
6
SQL
SQL
3.1%
3.1%
7
7
Runstats
Runstats
3.1%
3.1%
8
8
Recovery Procedures
Recovery Procedures
2.6%
2.6%
9
9
Unix
Unix
2.3%
2.3%
10
10
BMC
BMC
2.2%
2.2%
11
11
Mainframe
Mainframe
2.2%
2.2%
12
12
Data Warehouse
Data Warehouse
2%
2%
13
13
Hadr
Hadr
2%
2%
14
14
Z/OS
Z/OS
2%
2%
15
15
DB2 LUW
DB2 LUW
1.9%
1.9%
16
16
Production Environment
Production Environment
1.8%
1.8%
17
17
Setup
Setup
1.8%
1.8%
18
18
Table Spaces
Table Spaces
1.6%
1.6%
19
19
Capacity Planning
Capacity Planning
1.6%
1.6%
20
20
On-Call
On-Call
1.4%
1.4%
21
21
TSM
TSM
1.3%
1.3%
22
22
JCL
JCL
1.3%
1.3%
23
23
Cics
Cics
1.3%
1.3%
24
24
DPF
DPF
1.2%
1.2%
25
25
DDL
DDL
1.2%
1.2%
26
26
Cobol
Cobol
1.1%
1.1%
27
27
V97
V97
1.1%
1.1%
28
28
V95
V95
1%
1%
29
29
QA
QA
1%
1%
30
30
Websphere
Websphere
1%
1%
31
31
Maintenance Activities
Maintenance Activities
1%
1%
32
32
ETL
ETL
1%
1%
33
33
Oltp
Oltp
1%
1%
34
34
Solaris
Solaris
0.9%
0.9%
35
35
IMS
IMS
0.8%
0.8%
36
36
V9
V9
0.8%
0.8%
37
37
DBM
DBM
0.8%
0.8%
38
38
QMF
QMF
0.7%
0.7%
39
39
Event Monitors
Event Monitors
0.7%
0.7%
40
40
Dasd
Dasd
0.7%
0.7%
41
41
Space Management
Space Management
0.7%
0.7%
42
42
Vsam
Vsam
0.7%
0.7%
43
43
Toad
Toad
0.7%
0.7%
44
44
Rexx
Rexx
0.7%
0.7%
45
45
Omegamon
Omegamon
0.7%
0.7%
46
46
CPU
CPU
0.6%
0.6%
47
47
Buffer Pools
Buffer Pools
0.6%
0.6%
48
48
MVS
MVS
0.6%
0.6%
49
49
Physical Design
Physical Design
0.6%
0.6%
50
50
Image Copy
Image Copy
0.6%
0.6%

16,960 Database Administrator DB2 Jobs

Where do you want to work?