Senior Oracle DBA -REMOTE - Jobs in Toronto

Job Description

Address: VIRTUAL(R)59 - HomeRes - ON - BMOJob Family Group:TechnologyMonitors, restores service, changes, supports, and handles day-to-day activities 7/24/365 required to run the mission critical systems for the company ensuring business service levels are met and environments are managed. Monitors and ensures service restoration of infrastructure, applications (online and offline), and security, while meeting service level agreements. Provides the Help/Service Desk support, as well as coordinates and facilitates Incident Management, deploys changes to the production environment, and engages 3rd party providers contracted to the Bank during an incident. Provides immediate response to production program or system problems. Participates in testing cycles to ensure the ability to deploy and operability of infrastructure and applications. Deploys, implements, provisions applications and infrastructure per deployment plans and infrastructure build guides.

• Provides technical expertise and oversight on the production floor, understanding the full process requirements (compliance, equipment, regulatory) in order to best understand and resolve production issues.Manages complexity across business value, technology and interaction models.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.Establishes deep relationships at all levels within IT and business units, to effectively collaborate in business strategy.Monitors and tracks performance, and addresses any issues.Breaks down strategic problems, and analyses data and information to provide insights and recommendations.Participates in both internal and external regulatory inspections.Works with other operations personnel to develop and implement the counter-measures necessary to improve production and equipment reliability as well as the compliance posture of the team.Provides end to end technology support including computer, applications, network and storage, and root-cause analysis etc.Provides initial triage, investigation and ensures fast turnaround times on issue/incident resolution.Monitors technical infrastructure, applications and/or business transactions through automated systems and instrumentation across the environment.Provides inbound call assistance to end-users for application, technical, and IMACD needs leveraging the knowledge base and/or run books available.Collaborates and engages with the appropriate areas across the bank.Develops or helps to develop the knowledge assets required for the operation.Promotes adherence to standards and industry best practices.Develops an understanding of organizational interactions and complexity to engage with the appropriate matrix areas.Identifies opportunities to strengthen the operational capability, such as: sharing expertise to promote technical development, mentoring employees, building communities of practice and networks across technology.Stays abreast of industry technical and business trends through participation in professional associations, practice communitiesamp; individual learning.Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.Provides specialized consulting, analytical and technical support.Exercises judgment to identify, diagnose, and solve problems within given rules.Works independently and regularly handles non-routine situations.Broader work or accountabilities may be assigned as needed.Experience with physical database designs, operation and administration of database management system, including database optimization, performance tuning, backup and recovery, partitioning, compression, and securityExperience with database support including upgrades, migration, patching (security and bug fix), and hardening. Capacity planning and data conversion in a large operation with multiple environments.Strong understanding of project deployment cycle, and end-to-end project deployment, including technical documentation.Database monitoring tool (OEM, Dynatrace... etc.) and enforcing database rules and alerts]

Qualifications:

• Typically 4-7 years of work experience in IT or business environment and/or BS/BA or MBA/MS in computer science, engineering, information systems, math or business.Understanding of Information Technology operating processes used for systems to ensure effective delivery including but not limited to IT Operations mandatory operating standards for monitoring, logging, and alerting.Knowledge of support and operations practice, concepts, and technology obtained through formal training and/or work experience.Technical and/or business functional knowledge of systems, tools, timing, and dependencies.Deep knowledge and technical proficiency gained through extensive education and business experience.Verbalamp; written communication skills - In-depth.Collaborationamp; team skills - In-depth.Analytical and problem solving skills - In-depth.Influence skills - In-depth.Data driven decision making - In-depth

Must Have:

• 7+ Years Oracle 12c/18c/19c Database RAC, ASM, standby Data Guard, RMAN backup/recovery and Admin ExperienceExperience with database support including upgrades, migration, patching (security and bug fix), and hardening.Oracle Golden Gate replication including bidirectional replicationPractical experience in pro-active and reactive database performance tuning.Experience in performance analysis using several tools Statspack, SQL tracing, AWR, ASH report etc

Nice to Have:

• Experience with PostgreSQL architecture, database design, administration, and related technologies.Experience with automation and scripting skills using Korn/Bourne shell scriptingGeneral IT Audit experience is a plusAWS cloud environment.

We #39;re here to helpAt 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 #39;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 #39;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 #39;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.