DB2 DBA
Intellibee, Inc.
United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source
Tech stack
Java (Programming Language)
Microsoft Windows
Adobe InDesign
Bash Shell
Unix
COBOL (Programming Language)
Databases
System Configuration
Data Security
IBM DB2
IBM InfoSphere DataStage
Linux
+15 more
Dimensional Modeling
Disaster Recovery
IBM Cognos Business Intelligence
Rexx (Programming Language)
Microsoft SQL Server
Open Database Connectivity
Performance Tuning
Standard Sql
Test Data
Extensible Markup Language (XML)
Z/OS
Scripting
Data Storage Management
Sysadmin
Sybase
Job description
Support administration of DB2 for z/OS, Linux and Windows.
Duties include:
- Performance Tuning - Work includes analysis of access patterns to determine indexing and buffering needs. Collaborate with a team made up of DBA, Sysprog, Sysadmin and Developers to identify performance challenges, devise corrective action, test and implement changes.
- Backup and Recovery - Create, test and deploy database backup and recovery processes using IBM utilities. Work with storage management and scheduling to assure that backups are placed in correct locations in processing to capture the data at the correct time and be certain the tapes are shipped to the offsite vault.
- Disaster Recovery - Design and test recovery of application databases at DR vendor hot site. Work with storage management to design an overall recovery objective for all DB2 databases that fits in with the system recovery plans.
- Data Modeling - Participate in DB modeling sessions. Be able to create logical and physical models. Represent the DB2 DBA team in design sessions with architects and developers. Responsible to make sure the data model conforms to shop standards and can be managed long term.
- DDL construction - Create DDL to define DB2 objects from written specifications or modeling tool output.
- Application Diagnostics - Assist applications programmers and data analyst solve data access problems.
- Change Control for DB2 Objects - Create processes for promoting DB2 Objects from development through test and finally into production environments.
- Design, code and test data maintenance processes for conversions, archiving and purging.
- Train staff on the use of DB2 and related software.
Requirements
- DB2 for z/OS (10+ years)
- DB2 on Linux, Unix or Windows (4+ years)
- Configuring DRDA/ODBC/JCBC connections (4+ years)
- Data modeling using ERWin or similar product
- Strong verbal communication and experience in consulting with senior business SMEs to elicit requirements
- Strong written, presentation and interpersonal skills.
Nice to have skills:
- Experience with SQL coding in Java
- Experience with SQL coding in COBOL
- An understanding of XML
- Dimensional Modeling
- Cognos BI
- InfoSphere Server DataStage
- SQL Server
- Sybase
- Scripting languages (Rexx, Bash, BATβ¦)
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦