Senior Database Engineer

Accommodations Plus International; Markham; On-site; CAD 110,000 - 150,000; Full time

Job summary

Accommodations Plus International seeks a Senior Database Engineer with 15-18 years’ experience specializing in Oracle and cloud solutions. This critical role involves architecting and optimizing high-availability databases, leading teams, and driving automation for enhanced performance and reliability.

Qualifications

• 15-18 years of hands-on experience in database engineering.
• Deep expertise in Oracle databases and cloud technologies.
• Proficient in PL/SQL and database automation tools.

Responsibilities

• Lead implementation and management of Oracle databases.
• Execute patching and upgrades for Oracle Grid Infrastructure.
• Analyze and resolve performance bottlenecks.

Skills

Oracle Database Engineering

Cloud Database Solutions

Performance Optimization

Problem-Solving

Analytical Troubleshooting

Job description

Job Title: Senior Database Engineer (Oracle & Cloud Focus)

Experience: 15-18 Years

Job Summary: We're looking for a highly skilled and seasoned Senior Database Engineer with deep expertise in Oracle Database Engineering and a strong command of cloud database solutions. With 15-18 years of hands-on experience, you'll be a critical, independent contributor responsible for architecting, implementing, and optimizing high-availability database systems across diverse engines. If you thrive on tackling complex database challenges and ensuring peak performance, we want to hear from you.

Key Responsibilities:

• Lead the implementation and management of Oracle Databases in RAC and Grid environments, providing at least 2 years of production support within your experience.
• Deploy and maintain Oracle Grid Infrastructure (19c or higher) on Linux platforms.
• Expertly configure and manage ASM Cluster Filesystem, including adding disks and adhering to best practices, ensuring seamless operational delivery.
• Execute grid infrastructure patching and upgrades.
• Utilize Oracle Database Resource Manager to optimize resource allocation and performance.
• Drive database automation using Ansible, scripting, and other modern tools.
• Configure and manage huge pages on Linux for maximum performance.
• Provide robust production support for high-availability databases, minimizing downtime during critical outages.
• Design, configure, and support Oracle Active Data Guard for disaster recovery and business continuity.
• Architect and implement sophisticated database replication solutions using Oracle GoldenGate and enhance security with Oracle Advanced Security Option.
• Perform in-depth application/database troubleshooting during outages, delivering effective solutions and detailed Root Cause Analyses (RCAs).
• Analyze and resolve performance bottlenecks using tools like AWS Performance Insights, focusing on critical metrics such as elapsed times and throughput.
• Optimize low-performing application queries and enhance overall database efficiency.
• Provide expert support for a range of database engines, including PostgreSQL (Aurora), NoSQL (DynamoDB), and MySQL.
• Demonstrate strong proficiency in PL/SQL for development and optimization.
• Proactively identify and optimize existing database queries for improved performance.
• Strategically assess and plan for scalable database growth, anticipating future business needs and architectural requirements.

Required Skills & Experience:

• Extensive hands-on experience with Oracle RAC and Oracle Grid Infrastructure (19c+).
• Proven expertise in ASM Cluster Filesystem management and operational best practices.
• Deep understanding and practical experience with Oracle Active Data Guard for high availability and disaster recovery.
• Mastery of database architecture, Oracle Advanced Security Option, and Oracle GoldenGate.
• Solid knowledge of cloud environments, particularly AWS and Oracle Cloud.
• Direct experience with AWS RDS infrastructure, including advanced use of Performance Insights.
• Exceptional skills in troubleshooting performance issues, query optimization, and resolving database bottlenecks.
• Familiarity with huge pages on Linux for performance tuning.

Key Competencies:

• Exceptional problem-solving and analytical troubleshooting skills.
• Superior communication and collaborative abilities.
• Demonstrated ability to manage critical database outages with minimal impact.
• Proactive mindset with a commitment to identifying and implementing database best practices.

Who We Are

API is the global leader for crew accommodation solutions, and we are changing the way businesses manage travel. Our technology platform streamlines the entire crew planning process, making day-to-day operations more efficient and elevating the crew layover experience. API’s proprietary technology, mobile solutions and our experienced team are positioned to offer our clients a complete, end-to-end platform that integrates seamlessly into their process. We are looking for dynamic, creative, and tech savvy individuals to join our team. If you are passionate about hard work, providing impeccable service, technology, and solutions to our clients then API may be a great fit for you!

Other Duties

Duties, responsibilities and activities may change at any time according to business needs.

The performance of additional responsibilities if you are designated as a Data Protection Champion (DPC), Senior Information Risk Owner (SIRO) or Information Assurance Accounting Officer (IAAO).

Work Environment

This position operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand, walk; use hands to finger, handle or feel; and reach with hands and arms.

AAP/EEO Statement

Accommodations Plus International is an Equal Opportunity Employer that does not discriminate on the basis of actual or perceived race, creed, color, religion, alienage or national origin, ancestry, citizenship status, age, disability or handicap, sex, marital status, veteran status, sexual orientation, genetic information, arrest record, or any other characteristic protected by applicable federal, state or local laws. Our management team is dedicated to this policy with respect to recruitment, hiring, placement, promotion, transfer, training, compensation, benefits, employee activities and general treatment during employment.