From emerging startups to established enterprises, Smarttie simplifies the AI & Data journey for businesses. Our dual expertise in strategic consulting and precision headhunting guarantees that the right plan meets the right talent. With our headquarters in Vancouver, Canada, and a state-of-the-art delivery center in Guadalajara, Mexico, we bridge talent and innovation, expertly guiding our partners through their AI and Data-driven evolution. We're not just about change; we're about transformative results that create enduring value. We’re looking for people to join the team who are as passionate as we are to help build cutting-edge platforms and projects.

SQL - OLTP Senior Developer

This role will be responsible for developing OTLP database solutions using Microsoft SQL Server. The successful candidate will have hands-on experience in a multitude of domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, database design, database development, database tuning, service delivery, incident tracking, and change management.


    • Executes design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders.
    • Architecting and managing various data models associated with Relational DBs (primarily MS SQL Server) and optionally NoSQL DBs (Azure Cosmos, MongoDB, Cassandra, etc.)
    • Design, implementation, and maintenance of database solutions, management of data access, and resolving database performance, capacity, and security issues.
    • Perform problem-solving of application issues and production errors, including high-level critical production issues that require immediate attention.
    • Design and code a high volume of SQL queries, stored procedures, and maintenance of SSIS packages
    • Provide technical documentation as needed.
    • Monitor and perform performance tuning on stored procedures and ETL jobs.
    • Designing and implementing performant data movement pipelines; and data migrations
    • Perform problem-solving of application issues and production errors, including high-level critical production issues that require immediate attention.
    • Determine the business needs for data reporting requirements.
    • Participate in an on-call support rotation and provide non-standard work-hour support.
    • Perform other duties as assigned.


    • Bachelor’s and/or master’s degree in computer science, Computer Engineering, or related field preferred
    • 8+ years of overall software development experience required.
    • 6+ years of hands-on experience with a heavy focus on ‘data engineering’ required.
    • 3+ years of experience focused on data modeling/DB design required.
    • Extensive knowledge of SQL Server including T-SQL, the writing of complex stored procedures, optimization for performance, and SSIS packages
    • Strong knowledge and experience in data modeling and relational database design
    • Demonstrated expertise in performance tuning in various DB environments with large volume and velocity of data.
    • Knowledge of SQL administration and monitoring
    • Strong understanding and experience of development methodologies (Agile and Scrum)
    • Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
    • Communication and professional skills and the ability to establish relationships across business units
    • Excellent written and spoken English.
    • Agile Methodologies
    • Remote: Only individuals currently residing in Mexico


    • Financial technology domain knowledge
    • Microsoft Azure Data Engineering-related development experience
    • Experience with .NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Javascript
    • Experience with NoSQL (Cosmos DB) and Kafka/Event-Streaming

    Benefits and Perks

    • Legal benefits
    • 100% Remote Work Scheme!
    • Additional days off after 3 months
    • Major Medical Expenses Insurance including direct family members
    • Funeral Expenses Insurance.
    • Loyalty bonus for an additional 15 days
    • Flexible working hours
    • 4% Savings Fund
    • Profit Sharing.
    • Training Programs
    • English classes
    • Work tool

    If you are interested, do not hesitate to apply through this platform by attaching your CV.