SQL DBA DATABASE ADMINISTRATORS + Sybase or Oracle

VTRAC Consulting Corporation

"Solutions for Growth"



Please e-mail your resume as an MS-WORD document in confidence.

Subject: SQL DBA DATABASE ADMINISTRATORS + Sybase or Oracle

Attention: jamied DeleteThis @vtrac.com or call (416) 366-2600 x 245

Position: SQL DBA DATABASE ADMINISTRATORS + Sybase or Oracle

Position Type: Permanent

Location: Toronto, ON

JOB DESCRIPTION:
Responsible for physical databases on specific database technologies; design
and implement back-up, recovery, archiving and conversion strategies.



MAJOR ACTIVITIES:

a.. Provide support to production and non-production databases for data
development / maintenance ensuring consistency and integration with existing
database infrastructure. Develop physical database models for database
management system.
b.. Manage database distribution, configuration, security and access
requirements. Design and develop physical databases.
c.. Lead and/or perform testing, reporting, capacity planning, performance
tuning, back-up and restores.
d.. Provide leadership and technical expertise to on-going problem
identification / resolution and root cause analysis process for database
environments.


REQUIREMENTS:

Technical Skills

a.. SQL
b.. Sybase
c.. Oracle 10g and 9i
d.. Data warehousing
e.. RAC cluster env.
f.. Performance Tuning
g.. Root Cause Analysis
h.. Prefers SQL DBA's with at least 2 years of experience with one of the
following databases (Sybase, Oracle or DB2)


EXTENSIVE WORK EXPERIENCE

a.. Written Communications--Ability to produce a variety of business
documents that demonstrate command of language, clarity of thought and
orderliness of presentation.
b.. Problem Solving--Knowledge of approaches, tools, techniques for
recognizing, anticipating, and resolving organizational, operational or
process problems.
c.. Oral Communications--Ability to express oneself and communicate with
others verbally; recognizing that verbal communication is more than just
language - it includes tone, style and structure.
d.. Managing Multiple Priorities--Ability to manage multiple concurrent
objectives, projects, groups or activities. Effective judgment in
prioritizing and time allocation.
e.. Information Management--Knowledge of organization's existing and
planned information.
f.. Interpersonal Relationships--Knowledge of approaches, tools and
techniques for working with individuals and groups in a constructive and
collaborative manner.
g.. Influencing--Ability to impact decisions within and outside own
organization.
h.. Decision Making and Critical Thinking--Knowledge of tools and
techniques for effective use of a broad range of factors, assumptions,
frameworks and perspectives when solving problems.
i.. Consulting--Knowledge of approaches, tools, techniques and roles and
responsibilities in providing technical or business guidance to clients
within and outside own area.
j.. Application Delivery Process--Knowledge of major tasks, deliverables,
formal methodologies and disciplines for delivering new or enhanced
applications.


JOB COMPLEXITIES/CHALLENGES:

a.. Analyzing available or random facts from various sources related to
database structure and application to develop a solution that addresses
problems or performance improvements.
b.. Tracking and understanding all production and testing environments for
their clients' data, structure, volumes, disk allocation, and performance.
c.. Predicting system performance and understanding impacts of databases,
applications, network and Operating System (O/S) layers.
d.. Bridging gaps between the architecture or a solution design and the
database applications relationships, which may be described only at a high
level.
e.. Understanding data modeling techniques, the application solution, and
data retrieval requirements in order to create the best physical database
solution.
f.. Keeping up with database industry standards, products, trends and
solutions to provide sufficient background and problem descriptions in order
to perform an efficient investigation to resolve problems or issues.
g.. Understanding changes in scope of a project or enhancement, the
relevant components that might be affected in current and future processes
and ensuring the proper management of risk for the planned changes.
h.. Data patching or "hot" production system fixes errors may affect
users, client data or cause-missed opportunities in marketing campaigns.






We thank all the candidates in advance. Only those candidates that are
selected for interview will be contacted. For other exciting opportunities,
please visit us at www.vtrac.com