Senior Oracle Database Administrator

BGIS; Markham; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a Senior Oracle Database Administrator to manage and optimize Oracle databases across diverse environments. This pivotal role involves ensuring high availability, performance tuning, and strategic planning for mission-critical applications. The ideal candidate will have extensive experience in database operations, including installations, upgrades, and migrations. Join a dynamic team dedicated to innovation and excellence, where your expertise will directly contribute to the success of global operations. If you thrive in a fast-paced environment and are passionate about database management, this opportunity is perfect for you.

Benefits

Flexible Work Hours

Health and Dental Benefits

Professional Development Opportunities

Remote Work Options

Employee Assistance Program

Retirement Savings Plan

Diversity and Inclusion Initiatives

Qualifications

• 7-10 years of progressive Oracle DBA experience.
• Expert knowledge of Oracle Database versions 19c – 23ai.
• Strong troubleshooting skills for complex database issues.

Responsibilities

• Manage Oracle database instances, ensuring optimal performance.
• Collaborate with teams to design and implement database solutions.
• Conduct regular health checks and performance assessments.

Skills

Oracle Database Management

SQL Query Tuning

Database Security Practices

Performance Optimization

Disaster Recovery Planning

Cloud Database Management

Scripting (Python, Shell)

Technical Documentation

Education

Post-Secondary Education in IT

Oracle Certified Professional (OCP)

Tools

Oracle Enterprise Manager

Oracle Real Application Clusters (RAC)

Oracle Data Guard

Oracle E-Business Suite

AWS RDS

Azure

Job description

Who We Are

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 www.bgis.com

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, etc.)
• Familiarity withWindows and Linux operating systems
• Knowledge of scripting languages (e.g., 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 (e.g. 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 askHR . 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