Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage and optimise databases in AWS Cloud, ensuring performance and security.
- Company: Join a leading tech company focused on innovative database solutions.
- Benefits: Enjoy remote work flexibility and competitive perks.
- Why this job: Be part of a dynamic team making a real impact in database management.
- Qualifications: 12+ years in IT, with 10+ years in database administration, especially PostgreSQL.
- Other info: Ideal for those with a passion for cloud technologies and database optimisation.
The predicted salary is between 43200 - 72000 £ per year.
The position will be based in Canada. This is a remote position.
Qualified candidates are being considered for openings within the Database Operations group. These candidates will possess a strong background in SQL Server, MySQL, and PostgreSQL database management and administration. The individual will partner with product support and DevOps CSM to keep databases secured, healthy, and up to date to meet SLAs. The position is part of the Database Operations group which focuses on managing, maintaining, and securing databases in the AWS Cloud.
This position requires extensive experience with MSSQL, MySQL, and PostgreSQL and experience with AWS Cloud services. The candidate is expected to manage SQL Server, MySQL, and PostgreSQL databases in the cloud. The candidate should be responsible for managing and maintaining databases in AWS Cloud. The candidate should have a solid understanding of RDS clusters, taking snapshots of RDS instances, monitoring database performance issues, and resolving them, and participating in on-call rotation as needed. Previous experience within Banking and Financial Services is preferred.
Key Responsibilities:- Install, upgrade, and manage database servers and schemas.
- Set and maintain enterprise database standards.
- Manage database access and develop processes for optimizing database security.
- Performance tuning of database systems, particularly RDS/Aurora PostgreSQL and MySQL.
- Create database backups and restore databases from backups.
- Plan capacity for database servers.
- Diagnose and troubleshoot database errors.
- Create and manage database reports, visualizations, and dashboards.
- Write complex PL/SQL, understand complex queries, and tune complex queries.
- Automate repeating database tasks.
- Be available for on-call support.
- Experience as a DBA with AWS Cloud databases MSSQL, Aurora/RDS PostgreSQL, and MySQL.
- Monitor database incidents queue and act based on priority.
- Implement and deploy database changes in Prod and QA environments.
- Monitor MSSQL, MySQL, and PostgreSQL database performance issues and resolve them.
- Interact with other DBA team members, product support team, and DevOps CSM, keeping them aware of critical issues at hand.
- Onsite team member to understand project requirements and goals.
- Report progress status to team manager on various database support tickets and other projects.
- Manage, maintain, and secure RDS Aurora PostgreSQL, MySQL, and MSSQL databases.
- Understand the PL SQL scripts provided in the change and be able to assess if scripts are not well performant or not correct.
- Troubleshoot and resolve SSRS issues.
- Proactive and take ownership of highly visible issues and projects.
- Establish partnerships with other teams and drive projects.
- Able to provide database-level technical leadership and mentor junior DBAs.
- Establish database support standards to help in the areas of database support with minimal interruptions.
- Bachelor’s degree in computer science or related field.
- 12+ years of IT industry experience.
- 10+ years of experience in database administration.
- 10+ years of experience in database administration and development roles in MSSQL, MySQL, and Amazon Aurora PostgreSQL.
- Experience with Linux and Windows Server environments.
- Extensive experience with database technologies (MySQL, MSSQL, PostgreSQL).
- Experience in AWS cloud services.
- Experience with cloud database infrastructure management and administration.
- Extensive experience in HA/DR in major enterprise database systems.
- Experience in troubleshooting performance issues from infrastructure and database engine.
- Experience working with clients and other department leads within the organization.
- Must have AWS Experience and Amazon Aurora PostgreSQL experience.
- Expert in writing and understanding complex PL/SQL queries.
- Experience in performance tuning and optimization of complex queries.
- Expert in PostgreSQL database engine internals.
- Experience in Datadog monitoring tool.
- Able to take ownership of critical issues related to databases and AWS services.
Sr Database Engineer (Postgresql expert) Remote Canada employer: Page Mechanical Group, Inc.
Contact Detail:
Page Mechanical Group, Inc. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Sr Database Engineer (Postgresql expert) Remote Canada
✨Tip Number 1
Make sure to highlight your extensive experience with PostgreSQL, MSSQL, and MySQL in any conversations or networking opportunities. Engage with professionals in the database community, especially those who work with AWS Cloud services, as they can provide valuable insights and connections.
✨Tip Number 2
Familiarise yourself with the latest trends and best practices in database management, particularly in AWS environments. Being able to discuss recent developments or tools like Datadog monitoring can set you apart during interviews or informal chats with our team.
✨Tip Number 3
Consider joining relevant online forums or groups focused on database administration and AWS. Engaging in discussions and sharing your knowledge can help you build a reputation in the field, making you a more attractive candidate for us.
✨Tip Number 4
If you have experience in the Banking and Financial Services sector, be ready to discuss specific projects or challenges you've faced. This industry knowledge is highly valued and can give you an edge when applying for this position with us.
We think you need these skills to ace Sr Database Engineer (Postgresql expert) Remote Canada
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your extensive experience with PostgreSQL, MSSQL, and MySQL. Include specific examples of database management and administration tasks you've successfully completed, especially in AWS Cloud environments.
Craft a Strong Cover Letter: In your cover letter, emphasise your 12+ years of IT experience and your expertise in database technologies. Mention any relevant experience in Banking and Financial Services, as this is preferred for the role.
Showcase Relevant Skills: Clearly outline your skills in performance tuning, troubleshooting, and managing RDS/Aurora databases. Use bullet points to make these skills stand out, and relate them directly to the job requirements.
Prepare for Technical Questions: Be ready to discuss your experience with complex PL/SQL queries and database performance issues. Prepare examples of how you've resolved critical database problems in the past, as this will demonstrate your technical leadership capabilities.
How to prepare for a job interview at Page Mechanical Group, Inc.
✨Showcase Your Database Expertise
Make sure to highlight your extensive experience with PostgreSQL, MySQL, and MSSQL during the interview. Be prepared to discuss specific projects where you managed databases in AWS Cloud, as well as any performance tuning or troubleshooting you've done.
✨Demonstrate Problem-Solving Skills
Prepare to share examples of how you've diagnosed and resolved database performance issues in the past. This could include discussing your approach to monitoring database incidents and how you prioritised tasks based on urgency.
✨Familiarise Yourself with AWS Services
Since this role requires a solid understanding of AWS Cloud services, brush up on your knowledge of RDS clusters and Aurora. Be ready to explain how you've used these services to manage and secure databases effectively.
✨Prepare for Technical Questions
Expect to be asked about complex PL/SQL queries and performance tuning techniques. Review your understanding of database internals and be ready to discuss how you've optimised queries in previous roles.
