Senior Database Administrator - Oracle RDBMS
Parexel.com
Remote
Ontario
Full Time
When our values align, there's no limit to what we can achieve.
At Parexel, we all share the same goal - to improve the world's health. From clinical trials to regulatory, consulting, and market access, every clinical development solution we provide is underpinned by something special - a deep conviction in what we do.
Each of us, no matter what we do at Parexel, contributes to the development of a therapy that ultimately will benefit a patient. We take our work personally, we do it with empathy and we're committed to making a difference.
- Key Accountabilities
- Database Administration and Maintenance
- Install, configure, upgrade, and patch supported database systems (Oracle 10g–19c, PostgreSQL, or MS SQL Server)
- Perform database and schema refresh operations using native tools (e.g., Oracle exp/imp, Expdp/Impdp; pgdump/pgrestore; SQL Server backup/restore)
- Implement database change orders according to established schedules and procedures
- Monitor database performance and availability using platform-specific tools (e.g., Oracle Enterprise Manager, pgAdmin, SSMS)
- Document database policies, procedures, and standards for organizational complianceBackup, Recovery, and Performance Management
- Execute backup, restore, and recovery operations using RMAN (Oracle), pgBackRest/Barman (PostgreSQL), or native SQL Server tools
- Perform SQL tuning and indexing strategies to optimize query performance
- Utilize performance monitoring tools such as AWR/ADDM (Oracle), pgstatstatements (PostgreSQL), or SQL Profiler (SQL Server)
- Troubleshoot database and performance issues to minimize system downtime
- Maintain and support standby or high-availability configurations for disaster recoveryInfrastructure Support and Collaboration
- Administer platform-specific technologies such as Oracle ASM/RAC, PostgreSQL replication, or SQL Server Always On Availability Groups
- Perform basic system administration tasks on UNIX/Linux (Oracle/PostgreSQL) or Windows Server (SQL Server)
- Coordinate with system administrators, network teams, and backup teams as required
- Participate in project meetings to provide database perspective and technical input
- Support clinical research applications through reliable and secure database infrastructureSystem Integration and Technical Support
- Collaborate with IT teams to ensure seamless integration of database systems with enterprise applications
- Provide technical expertise for database-related aspects of system implementations and migrations
- Maintain database security and access controls in accordance with organizational policies
- Support application teams with database connectivity and performance issues
- Ensure database systems meet availability and compliance requirements for clinical research operations Skills
- Proficiency in one of the following: Oracle RDBMS (10g–19c), PostgreSQL, or MS SQL Server
- Experience with monitoring and management tools relevant to the supported platform
- Knowledge of backup and recovery procedures using platform-specific tools
- Expertise in SQL tuning, indexing, and performance optimization
- Familiarity with high-availability and disaster recovery technologies
- Basic UNIX/Linux or Windows Server administration skills depending on platform
- Strong analytical and troubleshooting abilities
- Clear written and verbal communication skills
- Ability to work collaboratively with cross-functional teams
- Strong attention to detail and documentation practices
- Time management and prioritization capabilities
- Ability to work under pressure during system outages
- Customer service orientation when supporting internal users Knowledge and Experience
- 7–10 years of experience in database administration for one of the following: Oracle, PostgreSQL, or MS SQL Server
- Experience with installation, upgrade, patching, and migration processes
- Hands-on experience with backup and recovery operations
- Demonstrated experience in SQL performance tuning and optimization
- Experience working in high-availability and disaster recovery environments
- Knowledge of database refresh and migration procedures
- Experience coordinating with system administration and network teams
- Familiarity with operating systems relevant to the supported platform Education
- Bachelor’s degree in Computer Science, Information Technology, or related field preferred
- Relevant certifications such as Oracle Certified Professional (OCP), PostgreSQL certification, or Microsoft SQL Server certifications preferred
- Implement database change orders according to established schedules and procedures
- Monitor database performance and availability using platform-specific tools (e.g., Oracle Enterprise Manager, pgAdmin, SSMS)
- Document database policies, procedures, and standards for organizational complianceBackup, Recovery, and Performance Management
- Perform SQL tuning and indexing strategies to optimize query performance
- Utilize performance monitoring tools such as AWR/ADDM (Oracle), pgstatstatements (PostgreSQL), or SQL Profiler (SQL Server)
- Troubleshoot database and performance issues to minimize system downtime
- Maintain and support standby or high-availability configurations for disaster recoveryInfrastructure Support and Collaboration
- Perform basic system administration tasks on UNIX/Linux (Oracle/PostgreSQL) or Windows Server (SQL Server)
- Coordinate with system administrators, network teams, and backup teams as required
- Participate in project meetings to provide database perspective and technical input
- Support clinical research applications through reliable and secure database infrastructureSystem Integration and Technical Support
- Collaborate with IT teams to ensure seamless integration of database systems with enterprise applications
- Provide technical expertise for database-related aspects of system implementations and migrations
- Maintain database security and access controls in accordance with organizational policies
- Support application teams with database connectivity and performance issues
- Ensure database systems meet availability and compliance requirements for clinical research operations Skills
- Proficiency in one of the following: Oracle RDBMS (10g–19c), PostgreSQL, or MS SQL Server
- Experience with monitoring and management tools relevant to the supported platform
- Knowledge of backup and recovery procedures using platform-specific tools
- Expertise in SQL tuning, indexing, and performance optimization
- Familiarity with high-availability and disaster recovery technologies
- Basic UNIX/Linux or Windows Server administration skills depending on platform
- Strong analytical and troubleshooting abilities
- Clear written and verbal communication skills
- Ability to work collaboratively with cross-functional teams
- Strong attention to detail and documentation practices
- Time management and prioritization capabilities
- Ability to work under pressure during system outages
- Customer service orientation when supporting internal users Knowledge and Experience
- Experience with installation, upgrade, patching, and migration processes
- Hands-on experience with backup and recovery operations
- Demonstrated experience in SQL performance tuning and optimization
- Experience working in high-availability and disaster recovery environments
- Knowledge of database refresh and migration procedures
- Experience coordinating with system administration and network teams
- Familiarity with operating systems relevant to the supported platform Education
- Bachelor’s degree in Computer Science, Information Technology, or related field preferred
