Join our team as a Senior Data Architect to lead the design and implementation of robust data architectures in complex, distributed environments. You'll be instrumental in determining data flow, distribution, and access methods, ensuring optimal performance and scalability. With extensive experience in Azure cloud environments, you'll leverage tools like Azure SQL, Data Factories, Databricks, and Synapse to build and manage efficient data solutions. Your role will encompass database optimization, capacity planning, and performance tuning, along with hands-on work with NoSQL databases and big data technologies. Collaborate with cross-functional teams to drive data migrations, enforce database rules, and implement cyber security measures. Ideal candidates will have a strong background in DBMS administration, proficiency in T-SQL, and experience with tools like SSIS and Informatica. This hybrid role offers a dynamic work environment, combining onsite collaboration with remote flexibilityDescription
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 T-SQL, 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 with SSIS, SSRS, Talend, Informatica etc.
Hands on experience 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 object-oriented 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
Ability to present ideas and suggestions clearly and effectively and in a user-friendly 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
Supplier Comments
Max submission: 1 (one)
Hybrid: 3 Days onsite / 2 days remote
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 T-SQL, 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
Not Ready to Apply?
Join our talent pool and we'll reach out when a job
fits your skills.