Software Eng (Dev) IV

Overview

We are seeking a highly skilled and experienced Senior Database Administrator (DBA) with deep expertise in Azure Managed Instance for PostgreSQL. The ideal candidate will possess a strong background in database architecture, performance tuning, and optimization. This role requires a thorough understanding of cloud-based database solutions, particularly within the Azure ecosystem. The Senior DBA will be responsible for the design, implementation, maintenance, and optimization of our PostgreSQL databases hosted on Azure Managed Instance. This position requires excellent problem-solving abilities, strong communication skills, and the ability to collaborate with cross-functional teams

Responsibilities

Database Architecture:

Design and implement highly available and scalable database architectures on Azure Managed Instance for PostgreSQL.
Collaborate with application and infrastructure teams to develop efficient database solutions that meet performance and scalability requirements.
Performance Tuning and Optimization:

Monitor and analyze database performance, identifying and resolving bottlenecks, and optimizing query performance.
Implement best practices for database performance tuning, indexing, and query optimization.

Backup and Recovery:

Develop and maintain backup and recovery strategies to ensure data integrity and availability.
Perform regular backups, validate recovery processes, and ensure disaster recovery plans are up-to-date.

Security and Compliance:

Implement security measures to protect sensitive data within the database environment.
Ensure compliance with industry standards and regulations related to data security.

Capacity Planning:

Monitor database growth and usage trends, forecasting capacity requirements, and planning for scaling.
Automation and Scripting:

Develop and maintain scripts for routine database maintenance, monitoring, and management tasks.
Implement automation to streamline repetitive processes and ensure consistency.

Collaboration:

Work closely with development teams to understand application requirements and provide database-related guidance.
Collaborate with DevOps and infrastructure teams to ensure smooth deployment and operation of database environments.

Documentation:

Create and maintain comprehensive documentation for database designs, configurations, and processes.

Qualifications

Bachelor's degree in Computer Science, Information Technology, or related field (Master's preferred).
Proven experience as a Database Administrator, with a focus on PostgreSQL and cloud-based environments, particularly Azure Managed Instance.
In-depth knowledge of database architecture, data modeling, and performance optimization techniques.
Strong expertise in SQL query optimization and performance tuning.
Experience with high availability, disaster recovery, and backup strategies for cloud databases.
Familiarity with security best practices and compliance standards in database management.
Proficiency in scripting languages (e.g., Python, PowerShell) for automation.
Excellent problem-solving skills and the ability to troubleshoot complex database issues.
Strong communication and collaboration skills to work effectively with cross-functional teams.
Relevant certifications in Azure and PostgreSQL are a plus.

If you are a passionate and driven Database Administrator with a solid background in Azure Managed Instance for PostgreSQL and a strong aptitude for database architecture, we encourage you to apply and join our dynamic team.
To apply, please submit your resume and a cover letter detailing your relevant experience and accomplishments in the field of database administration.
 

Keys to Success

• Building collaborative relationships
• Decision making
• Drive results
• Foster innovation
• Personal energy
• Self-leadership

#LI-KG1

#LI-CanadaRemote