Database Administrator
- Ottawa, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Experience
- Minimum 3-5 years of demonstrated hands-on Oracle database administration experience in mission-critical enterprise environments a must.
- Posting language
- English
- Posted
Original job description
The name Sotera Health was inspired by Soteria, the Greek goddess of safety, and reflects the Company’s unwavering commitment to its mission, Safeguarding Global Health®.
Sotera Health Company is a leading global provider of mission-critical sterilization and lab testing and advisory services for the healthcare industry. With a combined tenure across our businesses of nearly 200 years and our industry recognized scientific and technological expertise, we help to ensure the safety of millions of patients and healthcare practitioners around the world every year.
Across our 64 facilities worldwide, we have over 3,000 employees who are dedicated to safety and quality. We are a trusted partner to more than 5,800 customers in over 50 countries, including more than 40 of the top 50 medical device companies and 9 of the top 10 pharmaceutical companies.
Reporting to the Manager of Database Services and Application, the Database Administrator role is responsible for managing Oracle and SQL server databases, ensuring their availability, performance, security, and reliability. Key responsibilities include database upgrades, patching, backups, recovery, and disaster recovery. The role also supports Oracle E-Business Suite (EBS), responsible for the EBS application tier in administration, maintenance, patching, cloning and upgrade. Collaboration with technical teams, participation in change management, and production support are essential aspects of the position.
Key Responsibilities
- Administer, maintain, monitor and support Oracle databases and SQL server databases, to ensure high availability, performance, security, and reliability of business-critical applications.
- Perform database configuration, upgrades, patching, backup, recovery, cloning, and migration activities for databases.
- Monitor database performance and proactively identify, troubleshoot, and resolve database-related issues, bottlenecks, and incidents. Optimize database performance through SQL tuning, execution plan analysis, indexing strategies, and capacity planning.
- Perform database backup and recovery, configure and design high availability, and disaster recovery solutions using Oracle technologies such as RMAN and Data Guard.
- Implement and maintain database security controls, including encryption (TDE), auditing, privileged access management, and compliance with organizational and regulatory requirements.
- Develop and maintain Linux/PowerShell scripts to automate database administration tasks, monitoring, backup processes, performance reporting, and routine system maintenance.
- Support and maintain transactional replication and performance tuning activities in SQL server environments.
- Support Oracle E-Business Suite (EBS) application tier, including cloning, patching, and environment maintenance activities, where applicable.
- Collaborate with application development, and infrastructure teams to design, deploy, and optimize database solutions that meet business and technical requirements.
- Participate in change management, release management, and production support processes, including after-hours support and incident response when required.
- Communicate effectively with technical and non-technical stakeholders, providing status updates, technical guidance, and recommendations on database-related matters.
Qualifications
- Minimum 3-5 years of demonstrated hands-on Oracle database administration experience in mission-critical enterprise environments a must.
- 3-5 years of hands-on database experience supporting Microsoft SQL Server environments, including administration, monitoring, backup and recovery, transactional replication and performance optimization.
- Demonstrated experience with Oracle database installation, configuration, upgrades, patching, backup and recovery, data guard, performance tuning, encryption and troubleshooting.
- Experience in administering Oracle database in Oracle Cloud infrastructure (OCI) an asset.
- Demonstrated experience with Linux/Unix operating systems and scripting for automation and operational support.
- Experience in Oracle E-Business Suite (EBS) database administration, including patching, cloning, and administration
- Strong communication and interpersonal skills, with the ability to collaborate effectively with application teams, infrastructure teams, vendors, and business stakeholders.
Skills and Competencies
- Strong knowledge of database administration principles, including tuning, encryption, backup and recovery, high availability, and disaster recovery solutions.
- Proficient in PowerShell, Shell, or other scripting languages to automate routine administrative tasks and improve operational efficiency. Hands-on experience working with Linux/Unix is required.
- Excellent analytical and problem-solving skills, with the ability to perform root cause analysis, troubleshoot complex technical issues, and implement effective long-term corrective actions.
- Demonstrated ability to manage multiple priorities and meet deadlines in a fast-paced, dynamic environment.
- Strong verbal and written communication skills, with the ability to effectively communicate technical concepts to both technical and non-technical audiences.
- Proven ability to work both independently and collaboratively within cross-functional teams while supporting critical production systems and business operations.
- Commitment to continuous learning and staying current with emerging technologies, industry best practices.
Additional Requirements
Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent combination of education and experience.
Oracle Certified Professional (OCP), Microsoft SQL Server/Azure Database certification, or equivalent professional certification is considered an asset.
Security and Reliability Background Check clearance is required.
Sotera Health goes to market through its three best-in-class businesses – Sterigenics®, Nordion® and Nelson Labs®. Sterigenics is a leading global provider of outsourced terminal sterilization and irradiation services for the medical device, pharmaceutical, food safety and advanced applications markets. Nordion is the leading global provider of Co-60 and gamma irradiators, which are key components to the gamma sterilization process. Nelson Labs is a global leader in outsourced microbiological and analytical chemistry testing and advisory services for the medical device and pharmaceutical industries.
More about this job
Responsibilities
The Database Administrator is responsible for managing, monitoring, and maintaining Oracle and SQL Server databases to ensure high availability, performance, and security. This role also supports the Oracle E-Business Suite application tier and collaborates with technical teams on database upgrades, patching, and disaster recovery.
Requirements
Candidates must have 3-5 years of hands-on experience with Oracle and Microsoft SQL Server database administration in enterprise environments. A bachelor's degree in Computer Science or a related field is required, along with proficiency in Linux/Unix and scripting for automation.
Skills
- Oracle Database Administration
- Microsoft SQL Server
- Oracle E-Business Suite
- Linux
- Unix
- PowerShell
- Shell Scripting
- Performance Tuning
- Backup and Recovery
- Disaster Recovery
- High Availability
- Data Guard
- RMAN
- Database Security
- Encryption
- Change Management
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Healthcare
- Engineering
Keywords
- Oracle
- SQL Server
- Database Administrator
- Oracle E-Business Suite
- EBS
- Linux
- Unix
- PowerShell
- Shell Scripting
- RMAN
- Data Guard
- TDE
- Encryption
- Performance Tuning
- Disaster Recovery
- High Availability
- Automation
- OCI
- Oracle Cloud Infrastructure
- Change Management
- Production Support
- Database Migration
- Capacity Planning
- SQL Tuning
- Auditing
- Privileged Access Management
- OCP
- Healthcare Industry
- System Maintenance