drjobs Data Architect Modeller Intermediate 9252-1615

Data Architect Modeller Intermediate 9252-1615

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Toronto - Canada

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

HM Note: This hybrid contract role is three 3 days in office. Candidates resume must include first and last name.

Description
Responsibilities
Develops and implements the data architecture for application development in a complex and distributed environment including the determination of the flow and distribution of data the location of databases and data access methods.


Skills
Experience and Skill Set Requirements

Technical Skills 30:
  • Experience creating physical database designs and operates and experience administering database management systems (DBMS) including database optimization capacity planning installation and migration database design performance tuning backup and recovery
  • Experience cloud environments especially Azure
  • Extensive hands on experience in Azure SQL Database experience proficiency in TSQL understanding of SQL maintenance and audit user and permissions management performance management and tuning
  • Hands on experience with the following technologies certifications are an asset: Azure Data Factories Databricks Azure Synapse Azure SQL Cosmos DB Oracle DBMS along with Big Data/Data Lake/Hadoop experience
  • Hands on experience and nbsp;with SSIS SSRS Talend Informatica etc.
  • Hands on experience and nbsp;working with NoSQL databases and formats (JSON xml)

Experience 30:
  • Experience in one or more programming languages
  • Experience with custom build cloud development and microservices based architecture
  • Experience with data migrations
  • Experience in the use of information retrieval packages and proficiency with query languages
  • Experience in monitoring and enforcing database rules
  • Experience in Incident Change and Configuration Management procedures
  • Experience with one or more communications protocols
  • Experience with distributed data systems
  • Experience with middleware and gateways
  • Experience with researching and implementing cyber security vulnerability remediation
  • Knowledge and understanding of Information Management principles concepts policies and practices
  • Extensive experience in production Database Administration Maintenance Optimization
  • Subject matter expert in database design of the data warehouse or data marts.
  • Experience and expert knowledge in technology and/or application required including installation configuration maintenance upgrade (technology stack) and cloning
  • Experience in designing/developing an automated data distribution mechanisms
  • Knowledge and understanding of objectoriented analysis and design techniques.
  • Experience in developing enterprise architecture deliverables (e.g. models) based
  • Knowledge and understanding of Information Management principles concepts policies and practices
  • Experience in impact analysis implementation planning and implementation of technology or suite specific patches maintenance packs and releases and technology stack patch sets and releases
  • Experience in technical design planning and implementation of specific technology or suite
  • Experience with database administration and working with vendors

Communication Skills 10
  • Strong communication skills to prepare documentation including but not limited to: solution documentation user manuals reports reviews assessments and nbsp;
  • Ability to present ideas and suggestions clearly and effectively and in a userfriendly manner; maintain a high level of customer service to both internal and external clients
  • Ability to communicate technical designs and development in clear and understandable manner

Must Have:
  • Experience creating physical database designs and operates and experience administering database management systems (DBMS) including database optimization capacity planning installation and migration database design performance tuning backup and recovery
  • Experience cloud environments especially Azure
  • Extensive hands on experience in Azure SQL Database experience proficiency in TSQL understanding of SQL maintenance and audit user and permissions management performance management and tuning
  • Hands on experience with the following technologies certifications are an asset: Azure Data Factories Databricks Azure Synapse Azure SQL Cosmos DB Oracle DBMS along with Big Data/Data Lake/Hadoop experience

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.