Database Architect (SQL Server)

With Moneris in Toronto - CA

More jobs from Moneris

Posted on August 13, 2019

About this job

Job type: Full-time
Experience level: Mid-Level, Senior, Lead
Role: System Administrator
Industry: eCommerce, Financial Services, Financial Technology
Company size: 1k–5k people
Company type: Private


database, sql-server, database-design, architecture, high-availability, sysadmin

Job description

Please apply through the following link:

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 environments

  • 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

Apply here