Skip to Content
Search For Jobs

What's your expertise?

Where should we look?

Zip Code

25 Km

25 Km
50 Km
100 Km
500 Km
1000 Km
2500 Km

Job Type

All
Contract  (41)
Permanent  (4)

Category

All
Engineering  (1)
Finance  (3)
IT  (30)
Other Opportunity  (11)
Main Content

DB2 UDB Administrator (Remote)

Category:Contract
Location: toronto , Ontario m2n6k1
Posted:Mon, March 18, 2019
Salary:Up to CA$0.0 per hour
Apply for this Job

Role: DB2 UDB Administrator

Location: REMOTE

Term: 12 months


Database Administration is the process of administering to the physical aspects of the customer database. Physical administration would include the creation, modification, tuning, backing up and recovering of the database.
Candidate must have knowledge and experience performing DB2 UDB Physical database administration.
This includes the following:


DBMS product installation, maintenance and configuration
Space Management/Monitoring
- Perform database space management and monitoring.
Backup and Recovery
- Implement requirements for database backup and recovery requirements.
- Ensure that there are successful nightly recoverable backups of all databases.
Execute Job Database recovery procedures in case of either Hardware or Software problems.
Performance and Tuning
- Perform database reorgs, statistics and other applicable utilities to ensure proper database function and performance.
- Monitor and tune databases to ensure optimal performance based on database and operating statistics.
Problem Determination
- Perform problem determination and resolution.
- Investigate and fix any database system problems. Support to applications within scope.
Prepare change requests to migrate new and/or changed database objects into production.
Create and maintain database structures.
Migrate and install new/changed database objects to the database environment.
Assist with migration and/or load of application data into the database environment.
Security
- Maintain and implement database security based IBM and or client security policies.
Provide recommendations on application design guidelines for database access.
Provide & maintain jobs/scripts in support of maintaining the physical aspects for the databases and the database management systems.

Desired Experience

5+ years DB2 UDB Enterprise Server Edition and Advanced Enterprise Server Edition. Versions include V8, V9, V10 and V11 with all sub-levels and fix packs.
5+ years experience supporting DB2 with Database Partitioning feature (DPF) in DB2 AESE
5+ years experience working in server environments (Linux, Unix and Windows)
3+ years experience in after hours support work and participate in oncall rotation
Ability to speak French

Technical Skills

DB2 UDB Enterprise Server Edition and Advanced Enterprise Server Edition.
Versions include V8, V9 and V10, V11 will all sub-levels and fix packs.
DB2 DPF
TSM for back-up and restore
AIX (korn shell) and Windows (Perl) scripting experience
DB2 Connect
UDB client installation and support
Lotus Notes

Experis is an Equal Opportunity Employer (EOE/AA)

Apply for this Job