Database Developer and Administrator (On-Prem & Cloud)

Address:

This is a hybrid role is based out of Toronto that reports directly to the Senior Manager-PM Development.  This opportunity is open only to US citizens and authorized residents living in the Chicago area.

This person will Install, configure, and maintain SQL Server databases (on-premises and cloud) across production, staging, and development environments. They will manage and implement database security policies to protect sensitive data.

Duties:

• Perform regular database audits to identify any irregularities or potential security breaches.

• Design and maintain database schemas and create SQL scripts for table creation and data manipulation.

• Work closely with developers and engineers using SWS CloudWatch to improve application performance and solve database-related issues.

• Apply database patches and remediate vulnerabilities identified by enterprise scanning tools.

• Experience facilitating the deployment of database client connectivity tools.

• Ensure high availability, performance tuning, and optimization of SQL Server databases. 

• Work closely with application developers and DevOps teams to integrate RDS with cloud-based applications. 

• Analyze and recommend cost optimization strategies for RDS instances.

• Stay updated with the latest AWS RDS features and SQL Server advancements.

Requirements

• Typically, 5+ years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.

• Strong understanding of Windows Server Administration and Active Directory integration.

• Oracle DBA experience

• Linux Administration experience

• Ansible DevOps experience

• Bachelor’s degree in Computer Science, Information Technology, or a related field.\

• 5+ years of experience as an MS SQL Server DBA, with 2+ years in AWS RDS for SQL Server

• Expertise in MS SQL Server 2016/2019/2022 and related technologies.

• Strong expertise in Amazon RDS for SQL Server administration, monitoring, and automation

• Strong knowledge of SQL Server high availability (HA) and disaster recovery (DR) strategies.

• Experience with database monitoring tools such as SQL Profiler, Extended Events, and Performance Monitor.

• Hands-on experience with indexing, partitioning, and performance tuning techniques.

• Proficiency in T-SQL programming, query optimization, and stored procedure development.

• Experience with CI/CD pipelines for database deployment in AWS environments.

• Strong problem-solving skills and the ability to work in a fast-paced, cloud-driven environment.

• Verbal & written communication skills - In-depth.

• Collaboration & team skills - In-depth.

• Analytical and problem-solving skills - In-depth.

• Influence skills - In-depth.

• Data driven decision making - In-depth.

• Highly motivated to learn & research, share knowledge & ideas.    

The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards

About Us

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/ca/en.

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.