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
