DB2 System Database Administrator Job in Florencevillebristol, NB - Adecco
Français

Adecco jobs for you

Share this job

Bookmark and Share


Job Summary
DB2 System Database Administrator
Location: Florencevillebristol, NB Category: Information Technology
Status: Direct Hire Reference: ca_en_3_016563_7848
Posted: June 17,2016 Salary: N/A

Print image email image
Apply Now

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 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 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.
? This position requires after hours support work and also participation in an on-call rotation.

APCCA




Canada




NEW BRUNSWICK




FLORENCEVILLE




No Travel




Professional




Associate's Degree/College Diploma




No





*Fluent French and English (written and spoken) is required for support of a French language client

*Daily onsite presence in Florenceville/Saint John, New Brunswick required

*5+ years DB2 UDB Enterprise Server Edition and Advanced Enterprise Server Edition. Versions include V8, V9 and V10, will all sub-levels and fix packs.

*5+ years Experience supporting DB2 on clustered server systems, including HADR & HACMP (Power HA) systems

*3+ year experience supporting Partitioned database environments

*3+ years experience in after hours support work and participate in on-call rotation








Legal Working Status





*10+ years DB2 UDB Enterprise Server Edition and Advanced Enterprise Server Edition.

*Versions include V8, V9 and V10, will all sub-levels and fix packs.

*10+ years Experience supporting DB2 on clustered server systems

*3+ years Infosphere Change Data Capture and SQL / Q Replication experience






Bachelor's Degree



Print image email image
Apply Now

**Note: Accommodation will be provided in all parts of the hiring process as required under Adecco’s Employment Accommodation policy. Applicants will need to make their needs known in advance to their Adecco representative.**