Senior Oracle Database Administrator

BGIS; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A leading provider of facility management and real estate services is seeking a Senior Oracle Database Administrator to manage and optimize Oracle databases across on-premises and cloud environments. This role involves providing technical leadership, ensuring optimal performance and reliability for mission-critical applications, and requires extensive experience in database operations, troubleshooting, and security practices.

Qualifications

• 7-10 years progressive Oracle DBA experience.
• Expert level knowledge of Oracle Database versions 19c – 23ai.
• Experience managing database systems on physical, virtual and cloud environments.

Responsibilities

• Manage all Oracle database instances, ensuring optimal availability and performance.
• Provide support for database applications, ensuring reliability.
• Perform system and query tuning to optimize database performance.

Skills

Database Management

Performance Tuning

Troubleshooting

SQL Tuning

Security Practices

Technical Writing

Customer Service

Education

Post-Secondary education in IT or related discipline

Tools

Oracle Database

Oracle Enterprise Manager

Azure

AWS

SQL

Job description

BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients’ businesses. Globally, we manage over 320 million square feet of client portfolios across 30,000+ locations in North America, Europe, Middle East, Australia and Asia. Further information is available at

SUMMARY

The Senior Oracle Database Administrator (DBA) will be responsible for managing and optimizing Oracle databases across on-premises and cloud environments for a global organization. This role requires extensive knowledge and practical experience in database operations, including installations, upgrades, migrations, high availability, monitoring, and troubleshooting.

The ideal candidate will provide technical leadership in areas such as database design and architecture, security, performance tuning, and capacity planning, ensuring optimal performance and reliability for mission-critical applications.

Proven track record in :

• Methodical troubleshooting of complex database performance and functionality issues
• Deep knowledge on tuning of SQL queries and other functions that place heavy load on the database
• Overall tuning and optimization of Oracle system performance for both on-premises and cloud-based deployments
• Providing detailed and well researched answers to CIO in a timely manner

This role demands a proactive approach to problem-solving, database optimization, and strategic planning, ensuring seamless database operations while aligning with business objectives.

KEY DUTIES & RESPONSIBILITIES

Database Management :

• Manage all Oracle database instances, including 24x7 operations of customer-critical database systems
• Proactively ensure optimal availability and performance of the database systems
• Create, implement and support on-premises and cloud-based database solutions
• Provide guidance on architecture, data modelling, database design and infrastructure
• Design and implement highly available, redundant database solutions
• Generate standard operating procedures for database operations in order to standardize all relevant database activities

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
• Undertake regular refreshing and / or cloning of production and / or non-production environments as required
• Support code or release deployment process

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 Security :

• Plan and support internal projects such as database patching, migrations and upgrades
• Accountable for database security and integrity
• Ensure compliance with security policies and standards
• Assist in designing backup, recovery and DR strategies
• Investigate and implement new features within continuous service improvements process
• Facilitate audit discoveries and remediation activities

Monitoring and Maintenance :

• Utilize and maintain SQL monitoring tools
• Conduct regular health checks and performance assessments
• Conduct capacity planning and growth projections
• Propose and develop automated solutions for routine database processes, tasks, and procedures to improve efficiency

Additional :

• Acts as the senior escalation point for all issues relating to Oracle
• Follow operational policies and processes that are compliant with ITIL standards
• Track projects and system incidents through to resolution via the IT ticket tracking system and the various IT Logs
• Maintain qualifications and continuous learning relevant to your role
• Other duties as assigned

KNOWLEDGE & SKILLS

• 7-10 years progressive Oracle DBA experience
• Post-Secondary education in IT or related discipline
• Expert level knowledge of Oracle Database versions 19c – 23ai
• Extensive hands-on experience in building and managing Oracle databases and related utilities and tools.
• Proven track record in troubleshooting complex database performance and functionality issues
• Deep knowledge on tuning SQL queries and other performance impacting functions
• Experience with Oracle Enterprise Manager (OEM)
• Experience with Oracle Real Application Clusters (RAC), Data Guard, RMAN, and ASM
• Experience with Oracle E-Business Suite (EBS R12), WebLogic, Concurrent Managers, and Workflow Management
• Experience designing, configuring and managing High Availability (HA) and Disaster Recovery (DR) database solutions
• Possess strong security practices with regards to authentication, authorization, compliance, and encryption
• Cross platform knowledge between Oracle databases and Oracle EBS, MS SQL MongoDB, and / or other
• Experience managing database systems on physical, virtual and cloud environments (Azure, AWS)
• Experience with cloud-based Oracle solutions (OCI, AWS RDS,
• Familiarity withWindows and Linux operating systems
• Knowledge of scripting languages (., Python, Shell scripting) for automation
• Good verbal and written communication skills (English)
• Ability to work effectively under pressure and manage multiple, concurrent and conflicting priorities and deadlines
• Ability to work both independently with minimal supervision and in a team environment
• Willingness to learn and adapt in a fast pace, dynamic environment
• Excellent customer service skills, with a clear understanding of customer impact and business requirement
• Technical writing including documentation of procedures

Licenses and / or Professional Accreditation

• Oracle Certified Professional (OCP) or Oracle Certified Expert (OCE) certification
• Certificate in one or more additional database systems (. MongoDB, MySQL, MariaDB, PostgreSQL, Snowflake) – Preferred
• MS Azure SQL certifications – Preferred
• ITIL Foundation - Preferred

At BGIS we believe that diversity and inclusion is a key business driver, such that we never lose sight of its importance as it is woven into the fabric of our organization. We are committed to maintaining a barrier-free recruitment process by providing equal employment opportunities through recruiting and retention of individuals of all backgrounds. We recognize that promoting diversity is an essential component of our continuing pursuit for organizational success!

BGIS is an equal opportunity employer and we welcome you to apply for a position with us! If you require accommodation during the recruitment process, please contact us at . Upon request for accommodation, we will consult with the applicant in question and provide, or arrange for the provision of, a suitable accommodation in a manner that takes into account the applicant’s accessibility needs due to disability.

LI-HG

LI-Hybrid

Create a job alert for this search

We Care About Your Privacy

We and our 1 partners store and access personal data, like browsing data or unique identifiers, on your device. Selecting I Accept enables tracking technologies to support the purposes shown under we and our partners process data to provide. Selecting Reject All or withdrawing your consent will disable them. If trackers are disabled, some content and ads you see may not be as relevant to you. You can resurface this menu to change your choices or withdraw consent at any time by clicking the Show Purposes link on the bottom of the webpage [or the floating icon on the bottom-left of the webpage, if applicable]. Your choices will have effect within our Website. For more details, refer to our Privacy Policy.