DescriptionPosition: Senior Oracle + SQL Database Administrator
Position Overview:
Position Overview
Company Overview:
With more than 1,300 clients and 1.6 million users, Intelex Technologies, ULC is a global leader in environmental, health, safety and quality (EHSQ) management software. Since 1992 its scalable, web-based platform and applications have helped clients across all industries improve business performance, mitigate organization-wide risk, and ensure sustained compliance with internationally accepted standards (e.g., ISO 9001, ISO 14001, ISO 45001 and OHSAS 18001) and regulatory requirements. Intelex is one of North America’s fastest-growing tech companies who has recently been recognized as a Great Place to Work for over 7 years, Best Workplace in Technology, Best Workplace for Millennials and Canadian HR Team for fewer than 500 employees and has been recipient of Waterstone’s Most Admired Corporate Cultures award, and Deloitte’s Best Managed Companies award. For more information, visit https://www.intelex.com/careers or see what our employees are saying by following our #ProudIntelexian hashtag.
Fortive acquired Intelex in 2019.
As a Senior Database Administrator (DBA) at Intelex Technologies, you will play a critical role in managing and optimizing our MS SQL Server, Oracle, and PostgreSQL database environments. You will be responsible for the design, implementation, performance tuning, high availability, and security of our database infrastructure across cloud and on-premises deployments. Working within the DevOps & DataOps team, you will collaborate with developers, cloud engineers, and SREs to ensure seamless database operations supporting our mission-critical applications.
Responsibilities and Deliverables
Database Administration & Architecture
- Design, implement, and optimize databases across MS SQL Server, Oracle, and PostgreSQL environments.
- Participate in architecture/design reviews, ensuring database structures align with application needs and performance goals.
- Define and maintain best practices for schema design, indexing strategies, and query optimization.
Performance Tuning & Scalability
- Conduct proactive query tuning, execution plan analysis, and indexing strategies to optimize database performance.
- Monitor, troubleshoot, and resolve performance bottlenecks across MS SQL Server, Oracle, and PostgreSQL.
- Implement partitioning, replication, and caching to improve data access and efficiency.
High Availability, Replication & Disaster Recovery
- Design and implement HA/DR solutions for all supported databases, including MS Clustering, Oracle Data Guard, PostgreSQL Streaming Replication, and Always On Availability Groups.
- Perform capacity planning and ensure proper backup and recovery strategies are in place.
- Automate and test failover and recovery processes to minimize downtime.
Security & Compliance
- Implement role-based access control (RBAC), encryption, auditing, and compliance policies across all database environments.
- Ensure adherence to SOC 2, ISO 27001, GDPR, and HIPAA security standards.
- Collaborate with security teams to identify and mitigate vulnerabilities.
DevOps, CI/CD, & Automation
- Integrate database changes into CI/CD pipelines, ensuring automated schema migrations and rollbacks.
- Use Terraform or other IaC tools for database provisioning and configuration management.
- Automate routine maintenance tasks, monitoring, and alerting using New Relic and PagerDuty or similar.
Cloud & Data Technologies
- Manage cloud-based database solutions such as Azure SQL, Amazon RDS, Aurora, Oracle Cloud, and PostgreSQL on AWS/Azure.
- Work with NoSQL solutions like MongoDB when needed.
- Support data warehousing and analytics solutions (e.g., Snowflake, Redshift, SSAS).
Incident Response & On-Call Support
- Provide on-call support for database-related production incidents on a rotational basis.
- Conduct root cause analysis and implement long-term fixes for database-related issues.
Organizational Alignment
This is a highly collaborative role requiring close interactions with:
- DevOps & SRE teams to improve database scalability and monitoring.
- Developers to ensure efficient database designs and optimize queries.
- Cloud & Security teams to maintain compliance and security best practices.
Qualifications & Skills Required:
- 8+ years of experience managing MS SQL Server, Oracle, and PostgreSQL in enterprise environments.
- Expertise in database performance tuning, query optimization, and execution plan analysis.
- Strong experience with replication, clustering, and high-availability configurations.
- Hands-on experience with cloud databases in AWS or Azure (RDS, Azure SQL, Oracle Cloud, etc.).
- Solid experience with backup strategies, disaster recovery planning, and failover testing.
- Proficiency in T-SQL, PL/SQL, and PostgreSQL SQL scripting.
- Experience automating database tasks using PowerShell, Python, or Bash.
Preferred:
- Experience with containerized database deployments like Docker, or K8s.
- Knowledge of Kafka, AMQP, or event-driven architectures for handling high-volume transactions.
- Familiarity with Oracle Data Guard, GoldenGate, PostgreSQL Logical Replication, and Always On Availability Groups.
- Experience working in DevOps/SRE environments with CI/CD for database deployments.
- Exposure to big data technologies and analytical platforms.
- Certifications such as Oracle DBA Certified Professional, Microsoft Certified: Azure Database Administrator Associate, or AWS Certified Database – Specialty.
Education & Other Requirements
- Bachelor's or Master's degree in Computer Science, Data Engineering, or equivalent experience.
- This role requires a satisfactory Criminal Background Check and Public Safety Verification.
Why Join Intelex Technologies?
- Work with cutting-edge database technologies in a fast-paced, DevOps-driven environment.
- Make an impact by supporting critical EHS applications that improve workplace safety.
- Flexible remote work options and opportunities for professional growth.
- Collaborate with top-tier cloud, DevOps, and security experts to drive innovation.