Senior Database Administrator & Data Modeler

Apex Systems; Toronto; On-site; CAD 110,000 - 160,000; Full time

Benefits offered by this job

null

Job summary

Apex Systems seeks an experienced Senior Database Administrator & Data Modeler to lead a critical rewrite of a legacy system for a major financial client. You will analyze existing databases, design new auditable data models, and implement robust data controls while ensuring regulatory compliance.

You will collaborate with business stakeholders in an Agile environment, mentoring the team and leveraging SSIS, SSRS, Tableau, and the .NET stack to deliver scalable, high-performance data solutions.

Qualifications

• Bachelor's degree in computer science, IT, or related field.
• 8-10 years of SQL Server DBA, data modeling, and management experience in large-scale financial projects.
• Extensive experience with data migration, ETL (SSIS), and data integration services.
• Proficiency with SSRS and Tableau for reporting and visualization.
• Strong data analysis, data quality, and data modeling skills.
• Experience with test automation tools for SQL databases.
• Proficiency with Microsoft .NET stack: C#, ASP.NET, MVC, Web API.
• Knowledge of Code/DevSecOps practices in an Agile environment.
• Cloud database familiarity is a plus.

Responsibilities

• Analyze existing database architecture and legacy data models to design improved structures.
• Collaborate with stakeholders to translate business requirements into scalable database solutions.
• Design and implement new data models with performance and auditability in mind.
• Lead development of schemas, tables, procedures, and data controls for data integrity and compliance.
• Implement regulatory and security controls across the data platform.
• Iterate on data models throughout the lifecycle with cross-functional teams using Agile tools.
• Mentor developers on best data modeling practices.
• Work with Jira, Confluence, and Gliffy for documentation and workflow management.

Skills

SQL Server DBA

Data modeling

ETL

Data analysis

Regulatory compliance

DevSecOps

C#

.NET stack

Mentoring

Auditable data controls

Education

Bachelor's degree in computer science or related field

Tools

SSIS

SSRS

Tableau

Jira

Confluence

Gliffy

Microsoft .NET

Job description

Summary: We are in search of an experienced Senior Database Administrator & Data Modeler to spearhead a critical new development project involving the rewrite of a legacy system for a prominent financial client. This role demands expertise in analyzing existing databases, deciphering complex logic, and crafting new, performance-driven data models aligned with evolving business needs. The ideal candidate will play a pivotal role in ensuring the creation of robust, auditable, and compliant data controls within the system.

Responsibilities

• Conduct in-depth analysis of the existing database architecture, decipher complex logic, and understand legacy data models.
• Collaborate closely with business stakeholders to elicit, understand, and translate evolving business requirements into effective and scalable database solutions.
• Design and create new data models aligned with iterative business needs, ensuring optimal performance and adherence to best practices.
• Lead the development of database schemas, tables, procedures, and controls to ensure data integrity, performance, and auditability.
• Implement rigorous data controls, ensuring compliance with regulatory standards and internal security policies.
• Work iteratively, adapting, and refining data models based on evolving business requirements throughout the development lifecycle.
• Provide mentorship and guidance to the development team, ensuring alignment with best data modeling practices.
• Collaborate effectively with cross-functional teams in an Agile environment, utilizing tools like Jira, Confluence, and Gliffy for documentation and workflows.

Requirements

• Bachelor's degree in computer science, Information Technology, or related field.
• 8-10 years of extensive experience in SQL Server DBA, data modeling, and management, focusing on large-scale development projects, particularly in financial environments.
• Expertise in:
  • Data migration, ETL (Extract Transform Load), and integration services, including SSIS.
  • Reporting services like SSRS and Tableau for visualization/report creation.
  • Data analysis, data quality, and proficient data modeling.
  • Test automation tools and techniques for SQL databases.
  • Microsoft Full Stack technologies: .NET, C#, ASP.NET, MVC, and Web API.
  • Control-M is a plus.
• Proven record of accomplishment in:
  • Designing and implementing high-performance, auditable data models aligned with evolving business needs.
  • Understanding and implementing data controls, regulatory compliance, and security measures in financial systems.
• Advantageous:
  • Familiarity with cloud databases and full-stack technologies (such as .NET, C#).
• Excellent analytical, problem-solving, and proactive communication skills, coupled with a collaborative approach.
• Strong organizational and time management skills.
• Ability to work in a high-pressure, deadline-driven environment.
• Demonstrated experience in applying DevSecOps best practices within an Agile software development environment.

This role presents a unique opportunity for a seasoned Database Administrator & Data Modeler to lead a critical project in redefining a legacy system for our esteemed financial client, ensuring the creation of robust, performant, and compliant database solutions aligned with evolving business needs.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [e-mail] or 844-463-6178Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex Benefits Overview

In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.