Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage and optimise databases in AWS Cloud, ensuring security and performance.
- 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 an impact in the banking sector.
- Qualifications: 12+ years in IT, with 10+ years in database administration and AWS experience.
- Other info: Opportunity to mentor junior DBAs and lead critical projects.
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
Familiarise yourself with AWS Cloud services, especially RDS and Aurora PostgreSQL. Understanding how to manage and optimise these services will give you a significant edge during interviews.
✨Tip Number 2
Brush up on your PL/SQL skills and be prepared to discuss complex queries you've written or optimised in the past. Being able to demonstrate your expertise in this area can set you apart from other candidates.
✨Tip Number 3
Network with professionals in the database management field, particularly those with experience in banking and financial services. They may provide insights or referrals that could help you land the job.
✨Tip Number 4
Prepare for potential technical assessments by practising troubleshooting common database performance issues. Being able to quickly diagnose and resolve problems will showcase your hands-on experience and problem-solving skills.
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, MySQL, and MSSQL. 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 projects or roles that demonstrate your ability to manage and secure databases effectively.
Showcase Relevant Skills: Clearly list your skills related to performance tuning, troubleshooting, and database security. Highlight your experience with PL/SQL and any tools like Datadog that you have used for monitoring database performance.
Prepare for Technical Questions: Be ready to discuss your technical knowledge in detail during the interview process. Prepare to explain complex queries you've written, how you've optimised database performance, and your experience with AWS services.
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 this will demonstrate your hands-on knowledge and ability to meet the company's needs.
✨Prepare for Technical Questions
Expect technical questions related to database performance tuning, RDS clusters, and PL/SQL queries. Brush up on your understanding of complex queries and be ready to explain how you've optimised them in past roles. This will show your depth of knowledge and problem-solving skills.
✨Demonstrate Your Team Collaboration Skills
Since the role involves working closely with product support and DevOps teams, be ready to share examples of how you've successfully collaborated with other departments. Highlight any experiences where you took ownership of critical issues and drove projects to completion.
✨Ask Insightful Questions
Prepare thoughtful questions about the company's database operations and their approach to cloud services. This not only shows your interest in the role but also gives you a chance to assess if the company aligns with your career goals and values.
