Sr. Database Administrator to support take ownership of database environment across SQL Server and PostgreSQL

Our valued client is looking for a Sr. Database Administrator to support take ownership of database environment across SQL Server and PostgreSQL.

This is a permanent position that combines operational responsibilities (maintenance, monitoring, backups, performance tuning) with development-oriented work (schema design, stored procedures, supporting developers)

Tasks include:

• Manage and optimize production databases (SQL Server, PostgreSQL) including performance tuning, indexing, and query optimization.
• Design schemas, write stored procedures, and assist developers with efficient data access patterns.
• Monitor database health and implement proactive alerts, backups, and disaster recovery strategies.
• Support cloud deployments in Azure and AWS, including managed services and containerized databases.
• Collaborate with developers on API calls, migrations, and data modeling for new features.
• Define and enforce data security policies including encryption, access control, and auditing.
• Ensure compliance with PIPEDA, GDPR, and NIST 800-88 standards for data governance and retention/destruction.
• Drive improvements in database automation, DevOps practices, and CI/CD pipelines.
• Provide guidance on architecture decisions that impact scalability and data integrity

Must have:

• Prior experience as a Database Administrator
• Expertise in SQL Server and PostgreSQL, including advanced performance tuning.
• Solid understanding of data architecture, schema design, and query optimization.
• Experience with ORMs (e.g., Entity Framework Core) and supporting developer workflows.
• Familiarity with cloud database services in Azure and AWS.
• Strong knowledge of data security, encryption, and compliance requirements (PIPEDA, GDPR, NIST 800-88).
• Experience with DevOps practices including database migrations, automation, and CI/CD integration.

Nice to have:

• Ownership mindset, comfortable being the primary authority for databases within the team