Client: Major Bank

Hybrid: Tuesday and Thursday, Downtown Toronto

Contract length: 6 months to start, extendable, multi-year journey

AWS Cloud Developers are responsible for the implementation, configuration, maintenance and performance of both development within the AWS cloud environment and DBA responsibilities. Their main goal is to ensure the availability and consistent performance of various applications.

We are looking for an experienced ETL developer that is seasoned in both the AWS suite of development tools and as a SQL Server Developer to handle database creation and load activities! As AWS Cloud developer you will be responsible for the implementation, configuration, maintenance, and performance of the AWS cloud environment and the SQL server configurations within it

Duties and responsibilities

• Developing and implementing best practices for AWS applications.
• Create ETL jobs to ingest and move data within the AWS environment using Glue
• Automation scripting within the environment using either Glue or CloudWatch
• Manage SQL Server databases
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours

SQL Server Developer requirements and qualifications

• AWS Cloud Experience
• 2+ years experience with Cloud Services such as EMR, Lamba, Glue
• 5+ years experience with python and pyspark.
• 5 years of experience as a SQL Server developer or similar role, and familiar with T-SQL, SSIS, SSAS, SSRS, PowerShell, C# .NET.
• 3 years of experience with Performance Tuning and Optimization (PTO)
• 3 years of experience with backups, restores and recovery models
• 3 years of experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Exposure and understanding of DevOps/Continuous Integration (CI) tools and practices. This includes tools such as GIT and bitbucket.
• Strong expertise with one of the following: CDK or CloudFormation
• 3 years of experience with Windows server, including Active Directory
• Sense of ownership and pride in your performance and its impact on company's success
• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Strong communication, product model, need to speak on items with their business model, Operating in an agile model for this project, extra check if they have agile
• Banking experience ideal