We are seeking an Intermediate Database Administrator to manage the physical design, administration, and optimization of enterprise database management systems (DBMS). This role requires a technical expert capable of handling the end-to-end database lifecycle—from initial data architecture and dimensional modeling to performance tuning, capacity planning, and security remediation. You will act as a subject matter expert in the design of data warehouses and data marts, ensuring data integrity while supporting mission-critical infrastructure upgrades and sustainment activities.
...
Pay Rate: $373.38- $412.06/Diem
Advantages
- Architectural Ownership: Take the lead on designing new data architectures for enterprise-scale projects.
- Specialized Domain Knowledge: Deepen your expertise in Data Warehousing and complex Dimensional Modeling.
- Security Integration: Gain experience in proactive cyber security vulnerability remediation within a highly regulated environment.
- Collaborative Impact: Work within a multidisciplinary cluster environment, supporting critical infrastructure that impacts broad user groups.
Responsibilities
- Database Administration & Operations: Install, migrate, and administer DBMS. Manage database optimization, backup/recovery, and capacity planning.
- Data Architecture & Design: Create physical database designs and data architectures for new databases, specifically focusing on Data Warehousing and Data Mart structures.
- Query & Performance Tuning: Utilize expert-level SQL to write complex scripts, perform data joins/transformations, and conduct deep performance tuning to ensure high-speed information retrieval.
- Data Standards & Governance: Research, develop, and implement data standardization documentation. Monitor and enforce database rules to ensure consistency and security.
- Cyber Security: Research and implement vulnerability remediations to protect data assets against emerging threats.
- Sustainment & Support: Support release cycles, time-sensitive infrastructure upgrades, and urgent technical priorities within a distributed cluster environment.
- Dimensional Modeling: Design and implement Dimensional Data Models (Star/Snowflake schemas) to support business intelligence and analytics requirements.
Qualifications
- Proven experience with one or more major database technologies (e.g., Oracle, SQL Server, PostgreSQL).
- Proficiency in writing and optimizing complex SQL scripts.
- Hands-on experience cleaning, transforming, and joining large datasets.
- Subject Matter Expert in the database design of data warehouses or data marts.
- Direct experience designing data architecture for new databases from the ground up.
- Strong background in Dimensional Data Modeling.
- Experience creating and applying data standards across an organization.
- Demonstrated ability to develop comprehensive documentation on data standardization and requirements.
- Previous experience in a large-scale public sector organization of equivalent complexity is an asset.
Summary
If you are an Database Administrator with a passion for high-performance data architecture and the technical depth to manage complex data warehouse environments, we encourage you to apply today!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
We are seeking an Intermediate Database Administrator to manage the physical design, administration, and optimization of enterprise database management systems (DBMS). This role requires a technical expert capable of handling the end-to-end database lifecycle—from initial data architecture and dimensional modeling to performance tuning, capacity planning, and security remediation. You will act as a subject matter expert in the design of data warehouses and data marts, ensuring data integrity while supporting mission-critical infrastructure upgrades and sustainment activities.
Pay Rate: $373.38- $412.06/Diem
Advantages
- Architectural Ownership: Take the lead on designing new data architectures for enterprise-scale projects.
- Specialized Domain Knowledge: Deepen your expertise in Data Warehousing and complex Dimensional Modeling.
- Security Integration: Gain experience in proactive cyber security vulnerability remediation within a highly regulated environment.
- Collaborative Impact: Work within a multidisciplinary cluster environment, supporting critical infrastructure that impacts broad user groups.
Responsibilities
...
- Database Administration & Operations: Install, migrate, and administer DBMS. Manage database optimization, backup/recovery, and capacity planning.
- Data Architecture & Design: Create physical database designs and data architectures for new databases, specifically focusing on Data Warehousing and Data Mart structures.
- Query & Performance Tuning: Utilize expert-level SQL to write complex scripts, perform data joins/transformations, and conduct deep performance tuning to ensure high-speed information retrieval.
- Data Standards & Governance: Research, develop, and implement data standardization documentation. Monitor and enforce database rules to ensure consistency and security.
- Cyber Security: Research and implement vulnerability remediations to protect data assets against emerging threats.
- Sustainment & Support: Support release cycles, time-sensitive infrastructure upgrades, and urgent technical priorities within a distributed cluster environment.
- Dimensional Modeling: Design and implement Dimensional Data Models (Star/Snowflake schemas) to support business intelligence and analytics requirements.
Qualifications
- Proven experience with one or more major database technologies (e.g., Oracle, SQL Server, PostgreSQL).
- Proficiency in writing and optimizing complex SQL scripts.
- Hands-on experience cleaning, transforming, and joining large datasets.
- Subject Matter Expert in the database design of data warehouses or data marts.
- Direct experience designing data architecture for new databases from the ground up.
- Strong background in Dimensional Data Modeling.
- Experience creating and applying data standards across an organization.
- Demonstrated ability to develop comprehensive documentation on data standardization and requirements.
- Previous experience in a large-scale public sector organization of equivalent complexity is an asset.
Summary
If you are an Database Administrator with a passion for high-performance data architecture and the technical depth to manage complex data warehouse environments, we encourage you to apply today!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
