Database Administrator

Position: Database Administrator \- Senior

Location: Onsite /Toronto

Job ID#: RQ10268

Duration: 11 months

Responsibilities

1. Perform day\-to\-day operations, maintenance, and support, including:
   




• Database error/alert monitoring & troubleshooting
  


• Database logs review and troubleshooting
  


• Database backup/recovery jobs/tasks review
  


• Performance monitoring and tuning
  


• Storage and capacity planning and management
  


• Database objects management
  


• Database change management
  


• Security/auditing
  


• Identify security gaps and vulnerabilities, identify and implement mitigations (e.g., patches)
  


• Installing, configuring, patching work related to projects
  


• User and profile management
  




2. Create a Standard Operation Procedure (SOP) document to assist operational staff (non\-DBAs) in their duties regarding Oracle database environments.
   


3. Perform regular assessment of the existing Oracle databases/environments and make recommendations regarding:
   




• Maintenance and leading practices
  


• Changes required to address production issues (e.g., instability, poor performance) and risks
  


• Improvements to operational procedures (e.g., backup/restore) to align with standard methodology and industry best practices, considering the amount and criticality of the systems
  


• Recommendations for disaster recovery and non\-production environments
  


• Database upgrade options and approaches, informed by overall solution refresh plans and industry best practices
  




4. Implement approved recommendations as described above.
   


5. Provide guidance and outline best practices for incorporating future database requirements into the environment.
   


6. Contribute to a team culture of collaboration, excellence, and innovation.
   


7. Develop or inform the development of role descriptions for the development and sustainment of OPS/BPS Secure and PKI OIM.
   


8. Develop plans for knowledge and skills transfer to OPS employees, including activities or tests to demonstrate successful transfer and attainment of required skills.
   


9. Transfer knowledge to OPS employees.
   

Must Have

• 10+ years of experience in deploying and administering Oracle databases within an operations environment.
  


• 10+ years of experience in designing, developing, deploying, and sustaining large implementations based on the Oracle Database product.
  


• 5+ years of experience in supporting Oracle IAM suite database.
  


• 5+ years of DBA experience supporting Oracle databases for large mission‑critical enterprise solutions.
  

Skills

Experience and Skill Set Requirements

1. Sustainment of Large Database Systems: 40%

• 10+ years of experience in deploying and administering Oracle databases within an operations environment.
  


• 5+ years of experience in supporting Oracle IAM suite database.
  


• 5+ years of DBA experience supporting Oracle databases for large mission\-critical enterprise solutions.
  


• 10+ years of experience designing, making recommendations for, and implementing high availability database environments.
  


• Working knowledge of migration strategies for Oracle database versions 11g, 12c, and 19c.
  


• Experience with Oracle in Solaris 10 environments running on Sun Platforms, and RedHat Linux environment.
  

2. Solutions Leadership: 30%

• 10+ years of experience in designing, developing, deploying, and sustaining large implementations based on the Oracle Database product.
  


• Experience with ITIL processes such as Service Level Management, Problem Management, Change Management, Release Management, and Capacity Management.
  

3. Problem Management and Incident Management: 20%

• 10+ years of experience with triaging, analyzing, diagnosing (troubleshooting), evaluating options, and resolving database problems.
  

4. Quality Assurance: 10%

• 10+ years of experience with quality control and assurance methodologies and practices as applied to the implementation of databases with over 10,000 records.
  


• Experience with Change Management and Release Management as processes supporting the implementation of large applications.
  

About Symbiotic Digital.

Symbiotic Digital provides the IT Experts you need that solve problems and get things done.  See what the top 2% in their field can do for you.   (Symbiotic Digital is a division of Symbiotic Group Inc.)

We serve customers in two ways, we provide:

1.     Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results

2.     Recruitment: Find The Right People You Need

Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS\- Quality Management System Staff Development Model. We are a 100% Indigenous owned company.

Learn more online at https://www.symbioticgroup.com/home\-sd/.

Please submit your most recent resume to: [email protected]

View All Jobs online at:  https://www.symbioticgroup.com/view\-jobs/