|
|
 |
 |
| Job Title: |
DBA (Sybase) |
| Location: |
Scarborough, Ontario, Canada |
| Posted: |
7/14/2010 |
| Starting: |
ASAP |
| Type: |
Permanent |
| Dress Code: |
Business Casual |
| |
Job Description:
Department Overview: The Technology Response Management team, under Operations & Availability Management (OAM), provides escalated 2nd level production technical support for the majority of ITS managed technologies; and is accountable for day to day technology routines/maintenance in support of enhanced availability of the organization's services. There are 4 teams within Tech Response with specific and focused accountabilities. As a member of the Database Response team, you will be responsible for technical support for the production environment for all technologies managed by the team. Specific focus will be around the distributed Database Management Systems administrations, primarily distributed DB2, managing availability, data integrity, and security of the production environment. |
| |
Must Have Skills:
Job Description: The IT Database Administrator works closely with our ITS peers and the Incident Management team, and will be expected to demonstrate an understanding of all elements to successfully manage, tune, and resolve issues in complex systems within the bank’s distributed server based environment.
Qualifications/Skills/Experience:
-Mandatory qualifications include excellent communication (both written and oral) and interpersonal skills. Candidate must be organized, self motivated, as well as a team player and be able to participate in the knowledge transfer of information with peers and management. Mandatory technical skills include: -Minimum 5 years of DBA working experience building, deploying and administering distributed DB2 and Sybase database management system -Sound knowledge of database auditing, audit logging, creating benchmark for audit points -Experience with database security and database encryption -Sound knowledge of users access and database privileges -Experience with deploying database security patches and remediation of database vulnerabilities -Degree or Diploma in Computer Science or equivalent experience -Thorough working knowledge of the different versions of DB2 (8 & 9) on UNIX or Linux operating systems -Thorough working knowledge of the different versions of Sybase ASE (12.5 & 15) on UNIX or Linux operating systems -Experience applying DB2 and Sybase maintenance -Experience with diagnosing and tuning performance issues as they relate to DB2 and Sybase -Experience with database utilities and backup tools (Tivoli Storage Manager) -Experience with performing back up and recovery for both application tablespaces and catalogue tablespaces -Experience with UNIX shell scripting -Experience with Sybase Replication Server -Minimum 3 years experience with large Data Warehousing environments -Comfortable with working in a rapidly changing, technically complex environment -Proficiency with MS office product suite (Word, Excel PowerPoint etc.)
The following qualifications are considered as assets:
-Technical knowledge of legacy business applications -Experience with Storage Area Networks (SAN) -Familiarity with DBMS capacity management solutions -Familiarity with the CA-7 enterprise batch scheduling solution -Familiarity with ETL solutions -Familiarity with the other DBMS (Oracle, SQL, Essbase) |
|
|