The Senior Database Engineer is responsible for implementing, managing, and optimizing Oracle databases in a RAC environment, ensuring high availability and performance. Key duties include automating database tasks, troubleshooting issues, and supporting multiple database engines like PostgreSQL and MySQL, while also planning for scalable growth in database architecture.
We are seeking a highly skilled and experienced Senior Database Engineer with a strong background in Oracle Database Engineering and cloud database solutions. The ideal candidate should have 15-18 years of hands-on experience, the ability to work independently, and expertise in database architecture, high availability, and performance optimization across multiple database engines.
Key Responsibilities:
- Implement and manage Oracle Databases in a RAC / or Grid environment, with at least 2 years of production support.
- Deploy and maintain Oracle Grid Infrastructure (release 19 or higher) on Linux environments.
- Configure and manage ASM Cluster Filesystem and ensure successful operational delivery, including adding new disks to ASM disk groups and following best practices.
- Perform grid infrastructure patching and upgrades as required.
- Utilize Oracle Database Resource Manager for efficient resource allocation and optimization.
- Automate database tasks using Ansible, scripting, and other automation tools.
- Configure and manage huge pages on Linux for performance optimization.
- Provide production support for high-availability databases, ensuring minimal downtime.
- Configure and support Oracle Active Data Guard for disaster recovery and high availability.
- Design and implement database architecture and replication using Oracle Golden Gate and Oracle Advanced Security Option.
- Perform application/database troubleshooting during outages and provide solutions and root cause analysis (RCA).
- Analyze performance issues using AWS Performance Insights and identify/eliminate database bottlenecks, such as top elapsed times and throughput limitations.
- Optimize low-performance application queries and overall database performance.
- Support multiple database engines, including PostgreSQL (Aurora), NoSQL (DynamoDB), and MySQL.
- Strong in PL-SQL .
- Strong in identifying and optimizing the exiting database queries.
- Assess and plan for scalable growth with current and possible future database architectures and systems to meet future business needs.
Required Skills & Experience:
- Strong experience with Oracle RAC and Oracle Grid Infrastructure (19c or higher).
- Expertise in ASM Cluster Filesystem management and operational best practices.
- Experience with Oracle Active Data Guard for high availability and disaster recovery.
- Proficiency in database architecture, Oracle Advanced Security Option, and Oracle Golden Gate.
- Knowledge of cloud environments, specifically AWS and Oracle Cloud.
- Experience working with RDS infrastructure in AWS, including Performance Insights.
- Proficiency in troubleshooting performance issues, query optimization, and resolving database bottlenecks.
- Familiarity with huge pages on Linux.
Key Competencies:
- Strong problem-solving and troubleshooting skills.
- Excellent communication and collaboration skills.
- Ability to handle critical database outages with minimal downtime.
- Proactive in identifying and implementing best practices.
Top Skills
Oracle
Pl-Sql
Similar Jobs
Automotive • Retail
As a Senior Database Engineer, you will design and develop database solutions, create and maintain schema objects, perform root cause analysis for defects, and handle SQL database administration and performance tuning. You'll also evaluate 3rd party solutions and maintain CI/CD processes for data applications. Additionally, engage in code reviews and collaborate with other teams to implement technical solutions.
Top Skills:
C#SQL
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Database Engineer III in the Data Services team, you will maintain and automate database systems, focusing on technologies like Cassandra, ElasticSearch, and Kafka, while developing infrastructure services for a full devops model and troubleshooting production issues in collaboration with teams.
Top Skills:
AWSCassandraElasticsearchKafkaMySQLPostgresRubyZookeeper
Payments
The Senior Database Development Engineer will lead database projects, optimizing and configuring database software, coding SQL queries, and working with various teams. Responsibilities include monitoring query performance, automating tasks, and contributing to documentation.
Top Skills:
Azure Cosmos DbAzure Database For PostgresqlIbm Db2
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
