Technical Specialist - DBA, CIBC
Toronto, ON, CANADA
Posted Dec 29, 2010 1 Position(s)
Business Unit Description:
Technology: responsible for the delivery of technology in support of all CIBC businesses and customers. Directly aligns to CIBC's businesses, with a technology team for each business. Delivers world class solutions in support of business strategies, through a combination of in-house systems development and working with leading technology partners. This group also manages CIBC's core computing facilities, telecommunications and networks globally.
Technology Operations: responsible for the day-to-day operational management of the Technology organization, focusing on an integrated approach to operations, service delivery, planning and the processes supporting CIBC. TO is also responsible for enterprise services such as email, Telecom, Disaster Recovery, Network Servers, Availability, Change Management and partnership with Hewlett Packard (HP).
Relevant Job Criteria:
- There is one regular full time position available
- Days required to work: Monday to Sunday (Day & Evening Shifts). There are 4 required shifts: Morning, Evening, Day, and On-Call shifts:
-Morning Shift: 6.00am to 2.00pm
-Evening Shift: 1.00pm to 9.00pm
-Day Shift: 9.00am to 5.00pm
On-Call shift: 9pm to 6am
PURPOSE OF JOB:
Monitor and resolve incidents related to CIBC databases, infrastructure systems and applications (Mainly MS SQL, nice to have: Sybase, DB2 and Oracle).
o Initiate corrective action across system and infrastructure application errors
o Lead and/or provide subject matter expertise in production and non-production databases for data development, maintenance ensuring consistency & integration with existing database infrastructure.
o Manage database distribution, configuration, security, and access requirements.
o Lead reporting, performance/capacity planning, performance tuning, back up and restore.
o Provide leadership & technical expertise to ongoing problem identification/resolution & root cause analysis process form database environments.
o Log and document production incidents; identify recurring problems and recommend preventative measures.
o Answer calls from application support groups or system engineers; identify problems, resolve or escalate as appropriate.
o Interact with systems programming, server, database and network support staff to maintain a responsive and available infrastructure for the applications.
-3 -5 years of recent production database administration of MS SQL SERVER DB and hands -on experience of SQL Cluster or replication.
-3-5 years Information Technology infrastructure performance analysis AND performance tuning
-2-4 years of experience in a structured operations 24 X 7 data center environment, ASP/ISP or Network Operations Centre (NOC) environment. The candidate will have proven experience in system monitoring and technical support of technical infrastructure as well as working with multiple technical support teams.
-Previous experience and working knowledge of systems management disciplines and operations tools (automation, scheduling, monitoring, problem, change, configuration management etc.)
o Managing Multiple Priorities--Ability to manage multiple concurrent objectives, projects, groups or activities. Effective judgment in prioritizing and time allocation.
o Hardware Infrastructure--Familiarity with hardware technology and the global, regional and local hardware architecture.
o Systems Software Infrastructure--Knowledge of the existing and planned software technology and the global, regional and local software architecture and infrastructure components.
o Core Application Systems--Knowledge of major production application systems used for delivery of services to internal and external clients.
o Customer Service Management--Knowledge of tools and techniques for maintaining an environment where all understand, and are committed to, providing excellent service to internal and external customers.
o Problem Solving--Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems.
o Oral communication - ability to express oneself with other verbally; recognize that verbal communication is more than just language - it includes tone, style and structure.
o Interpersonal relationships - knowledge of approaches, tools & techniques for working with individuals & groups in a constructive and collaborative manner.
o Competence in Problem and Change Management, with a clear understanding of the customer impact and business requirement.
o Works well under pressure and time constraints and can prioritize competing priorities appropriately.
o Willingness to work overtime as required.
-Experience in financial services industry is highly desired.
o Share knowledge and expertise with those that presently exist among the Command Centre and Solution Centre staff.
o Ability to coordinate efforts across division boundaries where necessary to resolve problems
o Actively manage trends to ensure consistent, measurable service within documented tolerances and Service Levels
o Strong attention to detail and quick follow up for production problems
o Excellent communication skills, both verbal and written; listening skills
o Strong customer service and interpersonal skills.
Subject Matter Expertise:
o Technical Troubleshooting--Knowledge of approaches, tools and techniques for anticipating, recognizing, and resolving technical database problems.
o Peers, internal service providers, middle management, and vendors.
-Familiar with Oracle, Sybase, DB2 databases will be a plus
-Exposure to other Unix based OS would be an asset
- Working knowledge of Service Center, HP OpenView,
o Analyzing and investigating potential problems as described on incident management tickets to determine root cause, take the necessary action or escalate when necessary.
o Analyzing and ensuring information on request for change tickets are clear prior to execution, closing the ticket with details of actions upon completion.
o Tracking & understanding all production & testing environments for their clients data structure, volumes, disk allocation & performance.
o Receiving critical alerts, which could be generic and caused by several factors; this requires in-depth analysis to determine the root cause in order to resolve the problems.
o Troubleshooting technical problems in the absence to documented procedures.
o Assessing the impact of errors/problems based on timing and situation to determine the most appropriate decision and course of action.
o Monitoring drives to ensure it does not reach a critical level and create outages, and determining whether or not to escalate.
o Mistakes and oversight may result in financial loss, customer dissatisfaction and additional strain on resources.
PHYSICAL DEMANDS/WORKING CONDITIONS:
- Long periods of sitting and looking at computer terminal/console, shift work.
- Ability to work in a 7x24 global monitoring environment
- Ability to work in a continuously changing and dynamic environment
- Continuous learning and knowledge sharing
- Ability to work in shift rotations
- Teamwork & Partnering
- Building Trust
- Forward & strategic thinking
- Strong problem determination and resolution skills
- Ability to engage across division boundaries where necessary to resolve problems; ability to understand holistic view of complex infrastructure ecosystems
- Process oriented in change, incident and problem management disciplines (ITIL)
- Detail oriented
- Self directed / starting
- Agile / Adaptable
- Great relationship building traits
Location of Position(s) :