IBM Netezza Cloud Pak for Data and MS SQL Server Specialist

Develops and implements IT infrastructure & platform strategies for BMO. Develops strategic technology based on technical and business needs to support anticipated business strategies and organizational growth. Designs, builds / installs, tests, maintains, monitors and upgrades infrastructure such as computing platforms, servers and networks. Understands current and future technical platform hardware, operating system, security, and system services layers. Ensures reliable and secure computing and communications capabilities to run the business software while enabling the lowest operational cost/highest availability options. Performs capacity workload modeling and availability analysis for a variety of platforms and environments. Implements disaster recovery procedures and troubleshoots any network and connectivity issues in a timely manner, with minimal disruption to normal functioning. Works with stakeholders and recommends infrastructure solutions based on engineering requirements. Ensures that systems and infrastructure align with business value and are technically sound and well-integrated. Responds immediately to critical connectivity and access issues by evaluating solutions, coordinating recovery and ensuring resolution. On call and/or shift duty may be required. Recommends and implements solutions based on analysis of issues and implications for the business. Identifies emerging issues and trends to inform decision-making. Conducts independent analysis and assessment to resolve strategic issues. Builds effective relationships with internal/external Breaks down strategic problems, and analyses data and information to provide insights and recommendations. Performs capacity workload modeling and availability analysis for customer facing applications, systems and environments and recommends changes/enhancements for improving performance and reliability and promoting a seamless customer experience. Facilitates technical issue resolution across technical areas; includes hardware, software and connectivity problems. Leads/Conducts detailed design reviews in a constructive manner. Designs, develops, tests, implements and maintains computer/network systems developed internally and/or in conjunction with outside vendor. Designs/engineers system-operating capacity (such as bandwidth, disk space, storage, and CPU utilization) to ensure high availability and performance of end-user applications and systems. Ensures that infrastructure solutions are scalable, flexible, and supportable, are fully monitored and are as standardized and automated as possible. Works across teams to ensure IT system, network upgrades and service pack deployments are implemented with minimal impact to production operation. Accountable for overall system/technology performance; monitors production, outputs, and services to ensure that SLAs and other quality metrics are being met. Identifies and defines new process and/or system improvement opportunities. Evaluates and recommends emerging technologies to influence the design process. Identifies opportunities to strengthen the capability of the technology organization at BMO, such as: sharing expertise to promote technical development, mentoring employees, building communities of practice and networks across technology.

Qualifications

Qualifications: 5-7+ years of experience in MS SQL Server Administration & Netezza SQL Administration required i.e (MS SQL Clusters and SSIS Management functionalities - SQL Server release 2012, 2017 & 2019). Advanced knowledge of ETL process required (MS SQL SSIS release 2012,2017 & 2019). Netezza SQL Server/ Cloud Pak for Data System 11.2x/11.3x releases. Netezza Datawarehouse Administration in-depth knowledge. Writing/debugging SQL Scripts required. Writing/debugging SSIS Scripts required. Writing/debugging of UNIX shell scripts required. (Nice to have).

Salary

Salary: $70,000.00 - $150,000.00 Pay Type: Salaried 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.

Who we are

BMO is a leading bank driven by a single purpose: to Boldly Grow the Good in business and life. Everywhere we do business, we’re focused on building, investing and transforming how we work to drive performance and continue growing the good. We’re proud to be fueling growth and expanding possibilities for individuals, families and businesses. More than 12 million customers count on us for personal and commercial banking, wealth management and investment services. As the 8th largest bank in North America by assets, we provide personal and commercial banking, wealth management and investment services to more than 12 million customers. In Canada, the United States and across the globe, we’ll continue to build, invest and transform to drive performance that serves the good that grows.