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.
Responsibilities
- 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.
Qualifications
- 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
Pluses:
- 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.