Database Analyst

Toronto, ON M5V 3C6

Posted: 11/15/2018 Category: Data Analyst/Modeller Job Number: 13413

Our client is a very high-profile, enterprise-class Public-Sector organization, located in downtown Toronto, with close proximity to Union Station and the TTC/Subway and other public transit.

Position: Database Analyst

Duration: 12  months

Location: Downtown Toronto

Qualifications and Experience:
  • 10 years of experience in information management with a focus on design and modelling of database systems, database administration, and data integration and synchronization
  • 3 years of experience in designing conceptual, logical, and physical data models (CDM/LDM/PDM)
  • 5 years of experience as a professional Oracle DBA with a deep understanding of data storage, encryption, partitioning, replication, backup, recovery, system monitoring and logging, performance tuning, and RAC
  • 3 years of experience designing and developing data integration solutions using package software such as Informatica, Oracle Streams or GoldenGate
  • Deep understanding of different types of Oracle database objects including tables / views / materialized views, indexes, partitioning, keys, stored functions / procedures and packages
  • Experience in data conversion, data cleansing, data masking, de-identification and encryption methodologies
  • Experience with data privacy and security management, database performance design best practises
  • Experience in modern software development methodologies and processes such as Agile, CI/CD and DevOps
  • Experience with or knowledge of AWS environments, AWS RDS, AWS Aurora, and NoSQL such as Hadoop, MongoDB, DynamoDB, as asset
  • Excellent organizational, interpersonal, problem  solving, verbal and written communication skills with  a strong focus on customer service
  • BS in Computer Science, Information Management, Software Engineering, STEM major, or related discipline or equivalent experience

Technical Capabilities:
  • Data Modelling techniques and tools such as ERwin, ER/Studio, PowerDesigner
  • Oracle, MySQL, SQL Server; SQL, SQL: 2011, PL/SQL, T-SQL
  • Data integrations using tools such as Informatica, Oracle Streams or GoldenGate
  • Unix/Linux, Shell scripting, SAN storage
  • MongoDB, Hadoop, AWS, AWS RDB, AWS Aurora, RedShift, DynamoDB

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.