Senior Database Analyst

1 week ago

Toronto, Ontario, Canada Royal Bank of Canada Full time

Job Title: PostgreSQL Database Administrator

Company: RBC

RBC is a leading financial institution that thrives on innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work.

Job Summary

The Data and Analytics (DNA) team at RBC is seeking a highly skilled PostgreSQL Database Administrator to oversee the creation and maintenance of database and transaction processing environments for application testing, pre-production verification, and production operation. As a key member of our team, you will provide technical support for transaction processing, data access, performance tuning, and database recovery.

Key Responsibilities

  • PostgreSQL SME on user access control, backup/recovery, database deployment, database maintenance, database monitoring/alerting, job scheduling/automation, and database performance tuning.
  • Provide DBA support in PostgreSQL for both public Cloud, private Cloud, and on-premises environments.
  • Work in database support initiatives on private cloud PostgreSQL, DBaaS (database as a service) PostgreSQL, Azure/AWS PostgreSQL.
  • Setup/configuration and troubleshooting of database backup/recovery, database monitoring, database performance tuning, Security, and other problem diagnosis.
  • Monitor database performance during volume test and provide query analysis after the test.
  • Work closely with application teams on Database design and DDL deployments to non-prod and production environments.
  • Evaluate and test new database features, document, and present to the team.
  • Coordinate with multiple teams on projects.

Requirements

  • 5+ years of experience in PostgreSQL.
  • Experience in Cloud database support.
  • Intensive understanding of database security, maintenance, backup/recovery, integrity, service tier, volume test, and deployment process.
  • Good understanding of database provision automation, DBAAS, GitHub, Azure Kubernetes, and deployment automation.
  • Great communication and coordination skills (verbal/written); documentation.
  • Able to work after-hours when needed and take on-call shift.

Nice-to-Have

  • Experience with Azure/AWS PostgreSQL, Azure/AWS SQL Server, or Azure/AWS MySQL.
  • Experience in GitHub, DBAAS pipeline, or Kubernetes automation.
  • Experience with availability zones, HA, DR solutions in the Cloud.
  • Experience in automation and scheduling of database maintenance and other database tasks.

What We Offer

  • A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
  • Leaders who support your development through coaching and managing opportunities.
  • Ability to make a difference and lasting impact.
  • Work in a dynamic, collaborative, progressive, and high-performing team.
  • A world-class training program in financial services.
  • Flexible work/life balance options.
  • Opportunities to do challenging work.
  • Opportunities to take on progressively greater accountabilities.
  • Opportunities to build close relationships with clients.
  • Access to a variety of job opportunities across business and geographies.

  • Database Analyst

    2 weeks ago

    Toronto, Ontario, Canada 13583821 CANADA INC. Full time

    About the RoleWe are seeking a highly skilled Database Analyst to join our team at 13583821 CANADA INC. as a permanent employee. The successful candidate will work 30 hours per week and will be required to communicate in English.Key ResponsibilitiesData Collection and AnalysisThe Database Analyst will be responsible for collecting data to identify areas for...

  • Database Analyst

    6 hours ago

    Toronto, Ontario, Canada SunCan Communications Corporation Full time

    Job Title: Database AnalystWe are seeking a skilled Database Analyst to join our team at SunCan Communications Corporation. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our company's database systems.Key Responsibilities:Collect and analyze data to identify areas for improvement within our IT...

  • Database Analyst

    9 hours ago

    Toronto, Ontario, Canada SunCan Communications Corporation Full time

    Job Title: Database AnalystWe are seeking a skilled Database Analyst to join our team at SunCan Communications Corporation. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our company's database systems.Key Responsibilities:Collect and analyze data to identify areas for improvement within our IT...

  • Database Systems Analyst

    6 days ago

    Toronto, Ontario, Canada Vyoma Global Inc. Full time

    About the RoleWe are seeking a highly skilled Database Systems Analyst to join our team at Vyoma Global Inc. as a key member of our IT department.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our organization's IT infrastructure.Develop and implement a strategic blueprint for deploying databases within our...

  • Database Systems Analyst

    6 days ago

    Toronto, Ontario, Canada Vyoma Global Inc. Full time

    About the RoleWe are seeking a highly skilled Database Systems Analyst to join our team at Vyoma Global Inc. as a key member of our IT department.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our organization's IT infrastructure.Develop and implement a strategic blueprint for deploying databases within our...

  • Database Analyst

    8 hours ago

    Toronto, Ontario, Canada Nimbus Distro Full time

    About the RoleWe are seeking a highly skilled Database Analyst to join our team at Nimbus Distro. As a key member of our data management team, you will be responsible for designing, developing, and maintaining our databases to ensure efficient data storage and retrieval.Key ResponsibilitiesDesign and develop database systems to meet business...

  • Database Analyst

    5 hours ago

    Toronto, Ontario, Canada Nimbus Distro Full time

    About the RoleWe are seeking a highly skilled Database Analyst to join our team at Nimbus Distro. As a key member of our data management team, you will be responsible for designing, developing, and maintaining our databases to ensure efficient data storage and retrieval.Key ResponsibilitiesDesign and develop database systems to meet business...

  • Database Analyst, Special Processing Support

    6 days ago

    Toronto, Ontario, Canada Scotiabank Full time

    About ScotiabankScotiabank is a leading bank in the Americas, committed to helping our customers, their families, and their communities achieve success through a broad range of advice, products, and services.Job SummaryWe are seeking a highly skilled Senior Technical Analyst to join our Global Transaction Banking team. As a Senior Technical Analyst, you will...

  • Database Analyst, Special Processing Support

    1 week ago

    Toronto, Ontario, Canada Scotiabank Full time

    About ScotiabankScotiabank is a leading bank in the Americas, committed to helping our customers, their families, and their communities achieve success through a broad range of advice, products, and services.Job SummaryWe are seeking a highly skilled Senior Technical Analyst to join our Global Transaction Banking team. As a Senior Technical Analyst, you will...

  • Database Systems Analyst

    1 week ago

    Toronto, Ontario, Canada SunCan Communications Corporation Full time

    About the RoleWe are seeking a highly skilled Database Systems Analyst to join our team at SunCan Communications Corporation. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our company's database systems.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT...

  • Database Analyst

    2 weeks ago

    Toronto, Ontario, Canada Nimbus Distro Full time

    About the RoleWe are seeking a highly skilled Database Analyst to join our team at Nimbus Distro. As a key member of our data science team, you will be responsible for designing, developing, and maintaining our databases to ensure efficient data management and analysis.Key ResponsibilitiesDatabase Design and DevelopmentDevelop strategic deployment blueprints...

  • Database Systems Analyst

    2 weeks ago

    Toronto, Ontario, Canada SunCan Communications Corporation Full time

    Job SummaryWe are seeking a highly skilled Database Systems Analyst to join our team at SunCan Communications Corporation. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key ResponsibilitiesDatabase Design and Development: Design and...

  • Senior Database Analyst

    3 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryData and Analytics (DNA) team is looking for a PostgreSQL Database Administrator. The DBA will oversee the creation and maintenance of database & transaction processing environments for application testing, pre-Production verification, and production operation. You will provide technical support for transaction processing, data access, performance...

  • Database Systems Analyst

    5 days ago

    Toronto, Ontario, Canada SunCan Communications Corporation Full time

    About the RoleWe are seeking a highly skilled Database Systems Analyst to join our team at SunCan Communications Corporation. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our company's database systems.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT...

  • Database Systems Analyst

    5 days ago

    Toronto, Ontario, Canada SunCan Communications Corporation Full time

    About the RoleWe are seeking a highly skilled Database Systems Analyst to join our team at SunCan Communications Corporation. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our company's database systems.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT...

  • Senior Reinsurance Analyst

    1 week ago

    Toronto, Ontario, Canada RGA Reinsurance Company Full time

    Senior Reinsurance Analyst Job Title: Senior Reinsurance Analyst Company Overview: TAI is a leading provider of life reinsurance solutions in North America, offering a complete software solution for life companies to self-report their reinsurance information. As a Senior Reinsurance Analyst, you will play a key role in providing high-quality outsourcing...

  • Senior Database Analyst

    5 hours ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryRoyal Bank of Canada is seeking a highly skilled PostgreSQL Database Administrator to join our Data and Analytics team. As a key member of our team, you will be responsible for overseeing the creation and maintenance of database and transaction processing environments for application testing, pre-production verification, and production...

  • Database Systems Analyst

    3 days ago

    Toronto, Ontario, Canada Vyoma Global Inc. Full time

    About the RoleWe are seeking a highly skilled Database Systems Analyst to join our team at Vyoma Global Inc. as a key member of our IT department.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our organization's IT infrastructure.Develop and implement a strategic blueprint for database deployment and management.Design,...

  • Database Systems Analyst

    3 days ago

    Toronto, Ontario, Canada Vyoma Global Inc. Full time

    About the RoleWe are seeking a highly skilled Database Systems Analyst to join our team at Vyoma Global Inc. as a key member of our IT department.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our organization's IT infrastructure.Develop and implement a strategic blueprint for database deployment and management.Design,...

  • Senior Database Administrator

    6 hours ago

    Toronto, Ontario, Canada CB Canada Full time

    {"Job Title": "Senior SQL DBA", "Job Description": "Job SummaryCB Canada is seeking a highly skilled Senior SQL DBA to join our team. As a key member of our database administration team, you will be responsible for ensuring the availability and performance of our critical enterprise applications.Key ResponsibilitiesDesign and implement high-availability...