Senior Database Analyst - PostgreSQL Cloud DBA - Hybrid

Data 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 tuning, and database recovery. The Database Administrator will provide DBA services to a portfolio of applications across lines of business and across the whole RBC enterprise.

What will you do?

• 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.
• Working 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.
• Working closely with application teams on Database design and DDL deployments to non-prod and production environments.
• Evaluating and testing new database features, documenting and presenting to team.
• Coordinating with multiple teams on projects.

What do you need to succeed?

Must-have

• 5+ years of experience in PostgreSQL.

• Experience in Cloud database support.

• Intensive understanding on database security, maintenance, backup/recovery, integrity, service tier, volume test and deployment process.

• Good understanding on 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

Whats in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• 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 building close relationships with clients

• Access to a variety of job opportunities across business and geographies

#LI-HYBRID

#LI-POST

Job Skills

Amazon Relational Database Service (RDS), Database Auditing, Database Backup, Database Design, Database Encryption, Database Maintenance, Database Monitoring, Database Performance Tuning, Database Recovery, Database Scalability, Database Security, Disaster Recovery (DR), MariaDB, Microsoft Azure, Microsoft SQL Server, MySQL, PostgreSQL

Additional Job Details

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTOTORONTOCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2024-07-262024-09-27