at CIBC in Chicago, Illinois, United States
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 (https://www.cibc.com/en/about-cibc.html)
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. The role works on complex issues involving one or more technical areas, mentoring employees in database management and ensuring consistency and integration with existing database infrastructure. The role troubleshoots complex issues for all levels, analyzing data from various sources related to database structure and application to develop solutions that address problems or performance improvements. Continuously learning to grow your technical knowledge.
At CIBC, we enable the work environment most optimal for you to thrive in your role. You’ll have the flexibility to manage your work activities within a hybrid work arrangement where you’ll spend 2-3 days per week on-site at downtown Chicago while other days may be remote.
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 You’ll Succeed
+ Relationship Building - build strong relationships with business partners.
+ Hands On Database Management Skills - Develop technical specifications, high level/detailed design, testing strategies, and implementation plans from business requirements.
+ Collaboration - Partner with security, engineering and product teams to define database solutions to meet our customer needs.
Who you are
+ You can demonstrate experience by having 8+ years of relevant experience in SQL Database management. 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.
+ You have 2-3 years experience working with major cloud vendors (Azure, AWS etc.).
+ Knowledge of Azure Data Lake/Data Factory/SQL Integration Services.
+ Knowledge of Postgres and Oracle is plus.
+ Microsoft Azure Certification.
+ Basic PowerShell knowledge or any other scripting language is a huge plus.
+ You are a strong problem solver , highly reliable, organized and able to work in a fast-paced environment with delivery focus and able to work individually and collaboratively with peers.
+ You are an excellent communicator who is comfortable engaging stakeholders, both verbally and written.
+ You have a Bachelor’s degree in Information Technology or equivalent experience.
California residents – your privacy rights regarding your actual or prospective employment (https://us.cibc.com/en/about-us/california-consumer-privacy-act-employment.html)
What CIBC Offers
At CIBC, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential. We aspire to give you a career, rather than just a paycheck.
+ We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a benefits program*, a vacation offering, wellbeing support, and MomentMakers, our social, points-based recognition program.
+ Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients.
+ We cultivate a culture where you can express your ambition through initiatives like Purpose Day; a paid day off dedicated for you to use to invest in your growth and development.
*Subject to plan and program terms and conditions
What you need to know
+ CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. If you need accommodation, please contact Mailbox.careers-carrieres@cibc.com
+ You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit.
+ We may ask you to complete an attribute-based assessment and other skills tests (such as simulation, coding, MS Office). Our goal for the application process is to get to know more about you, all that you have to offer, and give you the opportunity to learn more about us.
Job Location
IL-70 W Madison St, 10th Fl
Employment Type
Regular
Weekly Hours
40
Skills
Microsoft Azure, Microsoft Azure Administration, Microsoft SQL Server, Relational Database Management System (RDBMS), SQL Databases
At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them. Our ability to create value for all CIBC stakeholders is driven by a business culture based on common values: Trust, Teamwork and Accountability.
Working with CIBC makes you a part of a work environment committed to our clients, employees and communities – a place where you can excel.
Every day, our 44,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us.