MySQL Forums
Forum List  »  IBM DB2

DB2 Database Administrator - Permanent - Canada
Posted by: R Mehtani
Date: August 18, 2006 08:13AM

Our client is a leading Financial company and we have the following full time position:

DB2 DBA
Location: Mississauga

Reporting to the manager of Infrastructure Management, this is a team member who is providing database support in DB2 and related technologies. The role is responsible for ensuring the effective operations support, production build-out and continuous improvement of client's database support and services environment.

Major Activities:

1. Participate in the design, engineering, configuration, testing, and performance tuning of all database management systems (DBMS).
-Evaluate and recommend the acquisition of database and data management solutions to meet changing business requirements and to continuously optimize the business application environment.
-Coordinate, execute, and oversee ongoing maintenance and upgrades for all DBMS's with internal teams and external service providers
-Provide rigorous testing for new DBMS releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load (ETL) strategies, high availability strategies, disaster recovery, and other application design strategies.
-Provide project oversight for large-scale complex database application changes and implementation

2. Provide technical leadership in the Unix and Wintel based application environments working with the client Application Teams and other stakeholders as necessary
-Provides consulting services to application development teams to understand the client's DBMS standards and system infrastructure to optimize application performance attributes prior to production implementation.
-Continuously develop and improve client's standards for software tools and system design
-Employ client's standards and industry best practices when designing and implementing new solutions.

3. Actively provide leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database environments:

4. Support production environments, configuration, testing, and performance tuning of all DB2 and related database environments.
- Verify the database support requests and execute them in timely manner as the business SLA's.
- Coordinate and oversee ongoing maintenance and upgrades for all DB2 and related databases with internal teams and external service providers
- Manage the production, deployment & maintenance of DB2 and related databases
- Provide expertise around optimizing performance and ensuring high-availability.
- Provide consulting services to application teams and possess good understanding of client's DBMS standards and system infrastructure.
- Provide rigorous testing for new DB2 server releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load (ETL) strategies, high availability strategies, disaster recovery, and other application design strategies.
- Managing problem/project tickets queue and maintaining communication with business
team members.
- Consult with problem/project ticket owners in resolving issues and executing scripts as per the requirements.
- Continuously monitor the request queue and prioritize tickets in the queue as per the guidelines from the management.
- Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.

Requirements:
Minimum 5 years experience in administering, testing, and support of midrange and large-scale DB2 environment. Proven experience in supporting high availability architectures.

Proven expert knowledge of:
- DB2 Administration
- Detailed knowledge of general Unix, Windows and Network utilities

Desirable skills:
- NetIQ, HP Openview
- Automated cross platform work/job schedulers
- Ethernet networking
- TCP/IP network Protocol and functions/utilities (e.g. ping/traceroute)
- DNS/DHCP Knowledge
- Windows NT/2000 Server
- MS Office (97 & 2000) and Internet Explorer
- MS Outlook
- STK SAN technology

Working experience and familiarity with the following technologies:
- Support, administer and maintain DB2 environments running on Unix platforms.
- Veritas NetBackup
- Windows NT & 2000
- Sun Solaris 2.6, 2.8, & 2.9
- Database Management Utilities
- MS Clustering in Win2k/3k server environment
- High Availability Solutions
- Strong familiarity with Local Area and Wide Area network topology
- FTP, TFTP, Traceroute, Ping

Assets:
- Db2 & Sybase
- Veritas NetBackup For Oracle
- HP UX
- Business Intelligence Tools
- DBArtisan
- Cognos
- Enterprise Modeling Tools
- ERWIN
- Veritas Cluster Server Manager
- Geo-clustering
- Middleware
- Informatica

Please send resume to:

Rohini
rmehtani@beveretc.com
416-695-7525 ext: 229

Options: ReplyQuote


Subject
Views
Written By
Posted
DB2 Database Administrator - Permanent - Canada
6519
August 18, 2006 08:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.