Position at Moneris Solutions Corporation
The Database Architect as a member of Database Services team will be responsible to provide hands-on, technical leadership and oversight on the architecture and design of Moneris Database Systems to ensure scalability, reliability and operational efficiency are in place to support the business needs.
You will be accountable to :
Provide technical leadership for the architecture, design and operational support of Moneris Database Systems and its associated technologies to meet requirements of High Availability, consistent performance, scalability and security
Lead and participate in initiatives with the Business, Applications and Technology Infrastructure teams to design and deploy Database environments hosting core in-house transactional payment processing and 3rd party vendor systems
Continuously asses and identify inefficiencies and gaps in current Database technology portfolio and recommend solutions.
Lead the evaluation and recommendation on emerging technologies in support of increasing cost effectiveness and systems flexibility to meet business needs
Design, plan and lead the implementations of solutions using Database technologies and its functional capabilities based on business requirements while effectively integrating into existing Database Infrastructure, smoothly transition knowledge of the solutions to the members of Database Services team for deployment and operation
Establish and support the enforcement of technology standards, processes and policies related to Database Services functional area.
Develop database architectural strategies at the modelling, design and implementation stages to address business and industry requirements
Provide technology mentorship and support for escalated incidents and problems to Database Services team members. Assist with the development, documentation, communication and enforcement of policies for standardizing Database software configurations and usage as necessary
Your experience includes :
Bachelor’s degree in Computer Science / IT or a related field of study and / or 10+ years of equivalent IT working experience
Microsoft Certifications and / or other vendor certifications
10 or more years of experience in Database Systems architecture, design, development and implementations in medium or large enterprise mission critical 24 / 7 environment
Highly skilled and proficient in Microsoft SQL Server DBA discipline. Extensive experience in logical and physical Database Systems design
Strong background and experience with High Availability, Business Continuity and Disaster Recovery capabilities of Microsoft SQL Server including Always-On Availability Groups, Mirroring, Log Shipping, Clustering
Experience with Microsoft BI and Analytical core components : SSAS, SSRS, SSIS, R-Services, DTS
Hadoop, MySQL and other relational and non-relational database systems experience is an asset
Solid knowledge of Networking, Operating Systems, Storage concepts and experience operating Database Servers in virtual, physical and cloud based environments
Sound knowledge of current IT standards, process engineering approaches and data management practices
Excellent presentation and communication skills with the ability to interact with customers with accuracy and professionalism
Exceptional analytical ability to assess the business and technology to facilitate problem solving and collaboration