Intermediate Infrastructure Oracle DBA
Sun Life
North York, Ontario
2d ago

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self.

You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights.

Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do.

Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description :

As an Oracle DBA within Data Management Services (DMS), your primary role will be as an Oracle Database Administrator supporting Canadian and US requirements.

We are looking for candidates with 3+ years of strong Oracle, PostgreSQL, Security and Optim experience.

What will you do?

  • Support a wide range of distributed and mainframe applications
  • Rotational on-call duties 7x24, including after-hour change and disaster recovery support (will require cell phone, laptop and guaranteed coverage from home)
  • Understand database architectures that supports business requirements
  • Define and execute on proof of concept initiatives
  • Lead / involvement in small and medium size infrastructure projects, and participate in projects throughout the entire project lifecycle, and define, manage and track project deliverables using defined technologies
  • What do you need to succeed?

    Oracle

  • Practical experience with current versions of Oracle Database
  • Knowledge of Operating System AIX, Linux and Windows including Unix scripting
  • Knowledge of Oracle Enterprise Manager or GRID Control, RMAN backup and recovery strategies
  • Knowledge of Oracle replication, mirroring, log shipping, maintenance plans and DR recovery strategies
  • Experience with and Embarcadero DBArtisan and Veritas clustering software
  • Strong PLSQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, and SQL tuning
  • Practical experience with database upgrade, database cloning, platform migration, installations and patching, monitoring and tuning using native Oracle or other third-party tools
  • Security

  • Strong understanding of database and data security principles and in particular Guardium Database Activity Monitoring (DAM), Guardium Data Encryption (GDE) and
  • Vulnerability Assessment (VA) infrastructure
  • Strong understanding of security frameworks, tools and methodologies
  • Strong understanding of functions and features of a major DBMS (Oracle DB, MS SQL Server etc.)
  • PostgreSQL

  • PostgreSQL Database experience supporting databases
  • Knowledge and hands-on experience with REPMGR, BARMAN and PG BOUNCER
  • Experience with PostgreSQL database administration, monitoring, troubleshooting, capacity planning, installation, patching, upgrading plus backup & recovery
  • Knowledge of PostgreSQL Database (11 and 12)
  • Experience in upgrading and migrating various versions of PostgreSQL database on different platforms
  • Experience in implementing and monitoring replication for high availability and disaster recovery scenarios
  • What’s in it for you?

  • Being part of our journey in developing the next greatest digital experience
  • Flexible Benefits from the day you join to meet the needs of you and your family
  • Wellness programs that support the three pillars of your health mental, physical and financial
  • An extensive support system for continual learning including company-run courses, access to online learning platforms, opportunity for rotations, etc.
  • A flexible work schedule, so long as it includes core working hours
  • Ability to receive Security clearance is required for this role minimum of 5 consecutive years of residency in Canada .
  • The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors.

    In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance.

    Certain sales focused roles have sales incentive plans based on individual or group sales results.

    Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues.

    We welcome applications from qualified individuals from all backgrounds.

    Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to .

    We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

    Salary Range :

    55,500 / 55 500 - 91,600 / 91 600

    Job Category :

    IT - Technology Services

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form