Senior Database Analyst

Job#: 1267026

Job Description:

Senior Database Analyst

Apex Systems is a global IT services provider, and our staffing practice has an opening for a Senior Database Analyst with expert level ORACLE knowledge, a strong Dynatrace background, and enterprise level infrastructure experience to place at our client, a Big Five Bank.

Client: Big Five Bank

Terms: Permanent Role.

Location: Currently 100% Remote, Post COVID, Downtown Toronto

Application Process: It is best to apply via the medium on which you are seeing this posting. If you encounter technical difficulties submitting your resume, please send a Word version of your resume to Cameron at clinke@apexsystems.com. Please reference Senior Database Analyst.

Key Accountabilities:

  • Monitors, 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.

Job Description:

  • 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 communities & 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 security.
  • Experience 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].
  •  

Key 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.
  • Verbal & written communication skills - In-depth.
  • Collaboration & 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 Experience.
  • Experience with database support including upgrades, migration, patching (security and bug fix), and hardening.
  • Oracle Golden Gate replication including bidirectional replication.
  • Practical 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:

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

Interview Process: Interviews will take place this in two rounds during the same week this month.

This a great opportunity to join a Big Five Bank and continue your career in the financial domain. Be a part of a great work environment with a very well-organized team and colleagues who will help you succeed.

This is a position that impacts the bank enterprise wide with great opportunity for career growth within the bank.

If you are not a 99% match to the above and want to be considered for other opportunities at our enterprise clients, register for our Talent Network where you can receive job alerts about new opportunities that match your interests.  

Click here to Register for our Talent Network   

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystems.com or 844-463-6178.

Employee Type:
FullTime

Location:
Toronto, ON, CA

Job Type:
Applications and Data Management

Date Posted:
July 4, 2022