DB2 DBA at ExecRecruitment
Job details
Use AI to assess how you fit
About this role
Applicants must be legally authorized to work in the United States on a permanent, unrestricted basis and must not require employer-sponsored work visa sponsorship now or in the future. 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.
Required skills:
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...)
Originally posted on Himalayas