Job Description |
A Bank in Downtown Toronto (WFH) is seeking Database Administrator - 3 for a contract of 6 Months.
Story Behind the Need
• Project Summary : You will be responsible for the analysis, design, technical administration, performance tuning and support of the database environment, supporting applications and development efforts.
Deliverables: The bank is migrating one of their CARDs systems by a certain time, and we need to facilitate and support the migration for data warehousing.
Job Responsibilities:
• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• You will partner with the Engineering team and Operations team to deliver a high-quality product by designing databases, provide support and administration on a multi-platform environment (DB2 LUW with DPF, MS SQL Server, IIAS).
• You will be responsible for database architecture, data integrity, database turning and development.
• You will manage DB2, IIAS, and SQL server databases including loading, maintaining and auditing data, and managing access permissions to databases up to the field level.
• You will write database documentation including data standards, procedures, data models, data flow diagrams, etc.
This includes designing and implementing database security standards.
• You will develop and maintain ongoing performance trend reporting as necessary, while adhering to organizational policies, processes and procedures.
• You will create and implement scripts and programs for maintenance tasks; plan and implement upgrades as required; design and implement policies and procedures for disaster recovery and data archiving to ensure integrity of data by performing periodic DR testing.
• You will work with developers to create and optimize database views and query statements; and develop scripts to migrate database from one version to the next.
• You will improve database efficiency by identifying current inefficiencies, including stored procedures and execution time and implement efficiency improvements.
• You will provide after hours on call support.
• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
• Actively pursues effective and efficient operations of his/her respective areas in accordance with Bank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
• Champions a high performance environment and contributes to an inclusive work environment.
|