We have the following full time position with our client in Mississauga, Canada
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