Database Administrator / Architect

Job Title :         Database Administrator / Architect

Location :

Type :               Contract

Our client is currently seeking an experienced Database Administrator / Architect to work out of their Toronto office.

Role :

As a member of the Enterprise Architecture team within Information Services, the Data Base Administrator / Architect is responsible for defining and maintaining enterprise-wide Dbases, data architecture and data governance in order to expand the company’s use of data as a strategic enabler of corporate goals and objectives.   The DBA / Architect participates in annual strategic planning contributing to the architectural roadmap of the organization. The DBA / Architect will also participate in Project initiatives to provide subject matter expertise as part of design, evaluation, selection and implementation activities.

The DBA / Architect will be required to perform the following tasks as part of role :

§   Design and deploy data architecture

• §   Identify improvements to existing databases by determining users' information requirements and system performance and functional requirements;

§   Implement enterprise data architecture and data management processes, procedures

§   Produce and review data architecture related models, documents and other deliverables

§   Develops and implements security procedures for the database, including access and user account management

§   Develops and coordinates backup, disaster recovery and virus protection procedures.

Qualifications :

§   A minimum of 5 years experience in designing and deploying data architectures (data architecture, data modeling, physical database design, database administration and data warehouses) for business application

§   Experience with business requirements analysis, entity relationship planning, database design, reporting structures, etc.

§   Experience with data modeling tools / techniques and data manipulation languages (Erwin, PL-SQL, XML, etc.).

§   Direct experience in implementing enterprise data architecture and data management processes, procedures, and decision support.

§   Demonstrated expertise with repository creation, and data and information system life cycle methodologies.

§   Experience producing and reviewing data architecture related models, documents and other deliverables.

§   Demonstrated ability to enforce adherence and process improvement to standards.

§   Strong understanding of RDBMS databases such SQL Server and Oracle

§   Understanding of Master Data Management concepts

§   A strong understanding of data-related industry trends, laws and best practice

§   Background in full lifecycle implementation or COTS and / or in-house systems development in the role of developer, analyst or database administrator.

§   Excellent knowledge of Microsoft Office Suite including Word, Excel, and PowerPoint.

§   Working knowledge of Visio, ARIS or other modeling tools desirable.

§   Experience with Business Intelligence, Data Warehouse, Operational Data Stores, Dimensional Modeling skills an asset

§   Financial sector experience (preferably in banking) is considered an asset.

§   Strong interpersonal, written, and oral communication skills.

§   Highly self-motivated and directed, able to manage multiple initiatives, driven by separate senior stakeholders simultaneously.

§   Proven analytical, conceptual and problem-solving abilities.

§   Experience working in a team-oriented, collaborative environment.

§   Able to interact with both Senior IS and Senior Business executives appropriately.

Education / Training :

§   University, college or technical degree in information technology. Alternatively, extensive proven track record in the primary position disciplines within the Financial Sector environment.

Licenses / Certificates :

§   Technical Designations are valued, but not required.

§   ITIL Foundations V3 desirable.