Canada DBA Job




Database Administrator, Citibank Canada, CITIGROUP FUND SERVICES CANADA INC

Toronto, ON, CANADA
Posted Feb 1, 2011 1 Position(s)

Citi is one of the most successful financial services companies in the world, operating in more than 100 countries and servicing over 200 million customer accounts. It's a place where clients want to do business and employees want to build their futures.


This Database Administrator (DBA) role is to support existing and future Sybase and MS SQL based applications.

Duties to include:

·         Performing database design, database maintenance, technical support,
supporting on-going application development, installation and upgrades of     
Sybase/SQL applications, daily database operational tasks that would include
configurations, performance, backup, recovery, disaster recovery scenarios and
manage data in a secure, reliable and highly available system environment

·         Responsibility for the design, modeling, engineering, research and development 
of databases and related technologies

·         Database administration in accordance to Citigroup policies and industry
standards for database security management, ensuring the compliance with 
audit requirements, enforcing change control processes and database duty

·         Active involvement in SDLC, closely collaborate with users, application support
teams and business managers to collect user requirements and provide
technical solution of database architecture and design, assist programmers to
develop logical data model and implement physical database layout

·         Proactive monitoring of databases, providing 24/7 database support, ensuring
high levels of system availability, following escalation procedures to report to
business users and the management

·         Maintaining up-to-date database design and modeling documentation, 
installation and COB recovery procedures and other database documentation:
database inventory list, Citibank Level 3 documents and Risk Control Self
Assessment (RCSA) documents

·         Performing quarterly DB self assessments and following RCSA process

·         Reporting to DBA manager and functional reporting to Project Managers in
ongoing application development projects

·         Assisting in the technical evaluation of new database versions and features.

·         Acting in accordance to Citigroup Shared Responsibilities to clients, each other
and franchise to provide the highest level of customer service



Applicant DBA will have:

·         Expert knowledge of Sybase 15.x RDBMS, Sybase RS, MS SQL 2005/2008

·         Expert knowledge of SQL, stored procedures, JAVA/XML, UNIX administration and
shell scripting on both IBM, Sun, and HP Unix platforms

·         Excellent troubleshooting skills, hands-on expert knowledge of Sybase performance
analysis tools, troubleshooting and DB problem analysis

·         Extensive experience in a database management environment especially combining 
on-line and batch data processing

·         Extensive knowledge of database modeling, design, relational database and data
warehousing concepts

·         Knowledge of various valued-added software tools to provide effective support such
as DBArtisan, HP ITO, Autosys, Erwin, Clear Case

·         Require excellent written, communication and interpersonal skills

·         Experience with risk management and related financial management practices in a 
financial services organization

·         Experience to work in highly demanding environment and ability to schedule multiple
assigned tasks efficiently with little assistance from management

·         Sybase and/or MS SQL certifications is an asset



·         This job requires 5 - 10 years of prior experience and solid understanding of various 
database technologies and broad experience in database modeling, design, 
deployment, troubleshooting and technical support.

·         Excellent understanding of client-server architecture, relational database concepts
and design as well as programming skills to model, design, build and manage the
diverse and complex database systems on multiple platforms: IBM AIX/Sun

·         5+ years hands on Database Modeling Tools experience

·         A firm understanding of the development life cycle including the analytical skills
necessary to satisfy testing documentation, and Change Management requirements

·         Writing and optimizing code in SQL and Unix scripting

·         Experience configuring and maintaining highly scalable environments

·         Additional knowledge of JAVA/XML and banking and accounting business is a
definite plus.

·         Experience with Sybase clustering is definite asset

·         Hands on experience with Oracle 10g/11g is definite asset

·         Knowledge in Sybase and MS SQL Backup/Recovery Methodologies and Strategies 
is definite asset



To apply for this position please go to (Job # 11003391)

Last updated on February 20, 2011