CIBC is looking to solve the problem of managing and administering databases and related applications on on-prem and Azure SQL Databases, ensuring performance, security, and troubleshooting.
Requirements
- 8+ years of experience in SQL Database Administration with relational database
- 1-2 years of experience on Azure SQL and knowledge of Azure Data Lake, Databricks, Data Factory
- Experience with backup strategies, replication, and DR solutions for SQL
- Monitoring and tuning MS SQL Server databases for optimum performance
- Deep knowledge of indexes, index management, statistics, performance tuning
- Microsoft Azure Certification is desired
- Basic PowerShell and Python knowledge or any other scripting language
Responsibilities
- deployment, migration, implementation, and administration of databases and support of all database environments and related applications on on-prem and Azure SQL Databases
- performance monitoring, security, troubleshooting, backups, error checks, and replication
- install, configure, maintain and patch SQL Servers, test backup/recovery, replication, failover, and disaster recovery
- deploy new database and code per change requests and provides troubleshooting and support including after-hours support
- Manage SQL Server Databases, Azure SQL databases, instances Backup and restore on-prem and Azure SQL databases
- Troubleshoot and resolve problems with production systems; escalates issues and facilitates resolution
- Automate common management tasks using PowerShell
Other
- Bachelor's Degree in Information Technology or equivalent is preferred
- Ability to work individually and collaboratively with peers
- Flexible and able to adapt to a rapidly changing environment
- Manage projects of varying length
- Responsible, highly dependable, organized
- This position does not offer visa sponsorship
