Job Title: Database Administrator

Location: Ontario, Canada

Duration: Fulltime

Position Overview:

• We are seeking a highly skilled and experienced Database Administrator (DBA) to join our dynamic IT team.
• The ideal candidate will have extensive knowledge and hands-on experience with Oracle Databases (12c and 19c), as well as proficiency in other database systems such as PostgreSQL or MongoDB.
• Knowledge of AWS is a plus.
• The DBA will be responsible for database application support, troubleshooting, patching, performance tuning, and query optimization. Additionally, expertise in Oracle Enterprise Manager is essential.

Key Responsibilities:

Database Management:

• Install, configure, and maintain Oracle Databases (12c and 19c).

• Manage database instances, including creation, configuration, and monitoring.
• Ensure high availability, disaster recovery, and data integrity.

Database Application Support:

• Provide support for database applications, ensuring optimal performance and reliability.
• Collaborate with development teams to design and implement database solutions. Troubleshoot and resolve database-related issues promptly.

Performance Tuning:

• Perform system and query tuning to optimize database performance.

• Analyze and resolve performance bottlenecks.
• Implement best practices for database performance and scalability.

Patching and Upgrades:

• Apply patches and perform upgrades to database systems.
• Ensure compliance with security policies and standards.

• Plan and execute database migrations and version upgrades.

Monitoring and Maintenance:

• Utilize Oracle Enterprise Manager for database monitoring and management.
• Conduct regular health checks and performance assessments.
• Automate routine maintenance tasks to improve efficiency.

Cross-Platform Database Support:

• Provide support for additional database systems such as PostgreSQL or MongoDB.

• Ensure seamless integration and interoperability between different database platforms.
• Maintain documentation and standard operating procedures for multi-database environments.

AWS Knowledge (Preferred):

• Leverage AWS services for database hosting and management.
• Implement cloud-based database solutions and ensure their optimal performance.

• Stay updated with the latest AWS offerings and best practices.

Internal Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5 to 7 years of Proven experience as a Database Administrator with a focus on Oracle Databases (12c and 19c).
• Proficiency in Oracle Enterprise Manager.
• Working knowledge of PostgreSQL or MongoDB.
• Familiarity with AWS services is a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work in a fast-paced, dynamic environment.

Preferred Skills:

• Certification in Oracle Database Administration.

• Experience with database security and compliance.
• Knowledge of scripting languages (e.g., Python, Shell scripting) for automation.
• Familiarity with DevOps practices and tools.

Why Join Us:

• Opportunity to work with cutting-edge technologies and innovative projects.
• Collaborative and inclusive work environment.

• Competitive salary and benefits package.
• Professional development and growth opportunities.

Key Skills:

DBA, Oracle Databases (12c and 19c)., PostgreSQL or MongoDB, AWS, Python, Shell scripting, DevOps