Database Administrator
Share
Job Location:
Monthly Salary:
Posted on:
12 hours ago
Vacancies:
1 Vacancy
Job Summary
Operational Ownership (70%)
- Act as the technical owner for enterprise database platforms (on-premises and cloud) including day-to-day administration monitoring and troubleshooting.
- Manage and optimize databases across legacy and modern technologies (e.g. SQL Server Raven DB Cosmos MySQL/PostgreSQL Azure SQL AWS RDS Progress etc.).
- Ensure high availability performance and capacity through proactive monitoring tuning and maintenance (indexing statistics partitioning resource governance etc.).
- Design implement and regularly test backup and recovery strategies including disaster recovery and failover procedures.
- Maintain strong security and compliance posture: user access management roles and permissions data encryption auditing and alignment with corporate and regulatory requirements.
- Perform and coordinate regular maintenance activities such as patching upgrades and vulnerability remediation with minimal impact to business operations.
- Provide tier-3 support for complex incidents and production issues including participation in an on-call rotation where required.
Project & Engineering Work (30%)
- Participate in infrastructure and application projects: new system implementations database refactoring consolidations and modernization initiatives.
- Collaborate with solution architects developers and business analysts to design scalable and resilient database solutions that meet functional and non-functional requirements.
- Lead or support migration efforts from legacy platforms to modern environments (e.g. on-prem to cloud version upgrades re-platforming and re-architecture).
- Contribute to the standardization and automation of database operations (e.g. Infrastructure as Code CI/CD integration configuration management scripting).
- Produce and maintain clear documentation: runbooks topology diagrams DR procedures standards and operational guidelines.
Qualifications :
Required Qualifications & Experience
- 10 years of progressive experience as a Database Administrator in medium to large enterprise environments.
- Proven experience managing mission-critical 24/7 environments with strict SLAs.
- Strong knowledge of performance tuning & optimization (execution plans indexes waits locking/blocking).
- Strong knowledge of high availability and disaster recovery (Always On clustering log shipping replication etc.).
- Strong knowledge of backup restore and DR strategy design and execution.
- Experience with security hardening and least privilege access control.
- Experience with cloud database services (Azure AWS) and hybrid architecture.
- Proficiency in scripting and automation (PowerShell Bash Python T-SQL/PL-SQL etc.).
- Familiarity with DevOps practices CI/CD pipelines and Infrastructure as Code (e.g. ARM/Bicep Terraform Ansible) is an asset.
- Post-secondary degree or diploma in Computer Science Information Technology or equivalent experience.
Personal Attributes & Soft Skills
- Continuous learner who actively keeps up with new database technologies patterns and best practices while respecting the realities of legacy systems.
- Self-starter with strong initiative; able to identify issues propose solutions and execute with minimal supervision.
- Demonstrated accountability and ownership you treat the environment as if it were your own.
- Strong analytical and problem-solving skills especially under pressure during critical incidents.
- Excellent communication skills able to translate complex technical topics into clear language for non-technical stakeholders.
- Collaborative mindset; comfortable working with cross-functional teams including infrastructure security development and business units.
- Organized and disciplined with good documentation habits and attention to detail.
Language & Work Environment
- Fully bilingual in English and French (spoken and written).
- Comfortable working in a hybrid model combining remote work with on-site presence as needed for operational and project activities.
- Willingness to participate in off-hours maintenance windows and an on-call rotation for critical systems support.
Additional Information :
Additional Information
- Competitive salary and other benefits;
- Group insurance and RRSP program;
- Company-wide events throughout the year (barbecue Christmas party etc.);
- Free on-site gym;
- Two on-site cafeterias (subsidized meal program available);
- Dynamic and rewarding work environment - work on high-impact and meaningful projects while having fun!
Remote Work :
No
Employment Type :
Full-time
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About Company
American Iron & Metal (AIM) American Iron & Metal (AIM) is a family-owned, Canada-based company founded in 1936. Since that day, AIM has grown to be recognized as one of the Worlds most sophisticated metal recyclers, specializing in the recovery and recycling of scrap metal by-produc ... View more
