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:
1. Manage and optimize production databases (SQL Server, PostgreSQL) including performance tuning, indexing, and query optimization.
2. Design schemas, write stored procedures, and assist developers with efficient data access patterns.
3. Monitor database health and implement proactive alerts, backups, and disaster recovery strategies.
4. Support cloud deployments in Azure and AWS, including managed services and containerized databases.
5. Collaborate with developers on API calls, migrations, and data modeling for new features.
6. Define and enforce data security policies including encryption, access control, and auditing.
7. Ensure compliance with PIPEDA, GDPR, and NIST -88 standards for data governance and retention/destruction.
8. Drive improvements in database automation, DevOps practices, and CI/CD pipelines.
9. Provide guidance on architecture decisions that impact scalability and data integrity
Must have:
10. Prior experience as a Database Administrator
11. Expertise in SQL Server and PostgreSQL, including advanced performance tuning.
12. Solid understanding of data architecture, schema design, and query optimization.
13. Experience with ORMs (e.g., Entity Framework Core) and supporting developer workflows.
14. Familiarity with cloud database services in Azure and AWS.
15. Strong knowledge of data security, encryption, and compliance requirements (PIPEDA, GDPR, NIST -88).
16. Experience with DevOps practices including database migrations, automation, and CI/CD integration.
Nice to have:
17. Ownership mindset, comfortable being the primary authority for databases within the team