Senior Database Analyst - PostgreSQL Cloud DBA - Hybrid
RBC
Toronto, ON-
Number of positions available : 1
- Salary To be discussed
- Published on August 26th, 2024
-
Starting date : 1 position to fill as soon as possible
Description
Job Summary
Job Description
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, PostgreSQLAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Inclusion and Equal Opportunity Employment
At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.
Join our Talent Community
Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.
Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.
Requirements
undetermined
undetermined
undetermined
undetermined
Other RBC's offers that may interest you
- Job posting | Planificateur(rice) financier(ère) relationnel(le) | Rimouski,QC
- Job posting | | Planificateur(rice) Financier(ère), Planification en placements et retraite | Thetford-Mines,QC
- Job posting | 2024 Summer Student Opportunities Technology & Operations - Software Developer (Calgary), 8 Months | Calgary,AB