Database Administrator

We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.

At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.

To learn more about CIBC, please visit CIBC.com

Job Description:

We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.

At CIBC, we embrace your strengths and your ambitions so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.

To learn more about CIBC, please visit CIBC.com

What you will be doing

As a Database Administrator you will be responsible for deployment, migration, implementation, and administration of databases and support of all database environments and related applications on on-prem and Azure SQL Databases. Performs performance monitoring, security, troubleshooting, backups, error checks, and replication. Work directly with other teams to triage and troubleshoot on escalating issues.

Responsibilities:

• Install, configure, maintain and patch SQL Servers

• Manage SQL server databases, Azure SQL databases and Managed Instances

• Backup and restore on-prem and Azure SQL databases, Managed Instances

• Monitor SQL Agent jobs and respond to critical job notifications on failure

• Troubleshoot and resolves problems with production systems; escalates issues and facilitates resolution

• Automate common management tasks using PowerShell.

• Evaluates data access and security to ensure that electronic data resources are available to those who need access and protected

• Automates database Management tasks

• Creating documentation and maintenance plans, assigning monitoring threshold values

• Test backup/recovery, replication, failover, and disaster recovery

• Works collaboratively with the application support and development team including architects, developers to ensure project success

• Assists in project planning and management with clients and other staff members

• Deploy new database and code per change requests

• Provides troubleshooting and support including after-hours support

• Other duties as assigned

How will you succeed

If you are a SQL DBA with relational database experience in addition to the points below:

• 6+ years SQL DBA experience

• 1-2 years of Azure SQL experience

• Knowledge of Azure Data Lake/Data Factory

• Experience with backup strategies, replication, and DR solutions for SQL is a must

• Experience in monitoring and tuning MS SQL Server databases for optimum performance

• Knowledge of indexes, index management, statistics, performance tuning

• Familiarity with SQL Integration Services

• Knowledge of  Postgres and Oracle is plus

• Flexible and able to adapt to a rapidly changing environment and can manage projects of varying length

• Responsible, highly reliable, organized; able to work individually and collaboratively with peers

• Bachelor's Degree in Information Technology or equivalent experience

• Microsoft Azure Certification

• Basic PowerShell knowledge or any other scripting language is a huge plus.

What CIBC offers

At CIBC, our people are our greatest asset. You’ll become part of a diverse community that acknowledges everyone’s unique talents, and empowers teams to do what’s right for the client and to do it well. As part of our team, you will:

• Thrive: Benefit from an open and approachable culture that provides the flexibility and support you need to integrate your life at work and home.

• Connect: Work in a place where the right technology and infrastructure foster innovation, collaboration, and creativity.

• Develop: Grow your skills and career through our best-in-class onboarding experience, ongoing learning opportunities, individual development planning, and comprehensive product training.

• Prosper: Share in our collective success with a competitive salary, incentive pay, banking benefits, h