Oracle Database Administrator

at  Manulife

We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and meaningfully challenged, we all thrive. Discover how you can grow your career, make impact and drive real change with our Winning Team today.

THE OPPORTUNITY

Manulife is a seeking a results-oriented Oracle Database Administrator committed and self-motivated with exceptional technical skills in Oracle Exadata(x6) and Oracle 19c databases to join our team. The team is responsible to analyze, troubleshoot, develop, and maintain complex backend databases in support of multiple business applications.

MUST HAVE KNOWLEDGE IN:

• 5+ years’ experience in Oracle database as an Administrator managing production environments
• Oracle 12c/19c on Exadata, Linux & Unix environments
• Clusterware, ASM, RAC
• Database hardening and security standards like TDE, SSL/TCPS and auditing, access control and authentication.
• Database backups and recovery techniques using RMAN
• Oracle Dataguard, physical standby and active Dataguard
• Performance tuning and Query Optimization
• Oracle upgrade and patching experience
• OEM upgrade and patching
• Develop reports and metrics using OEM.
• Automation skills such as Ansible and Terraform, Python

EXPERT KNOWLEDGE IN:

• Scripting skills (Perl & Bash), SQL/PLSQL
• Database monitoring tools and technologies (OEM, Foglight, New Relic, etc.)
• Experience in working with Oracle Platinum support
• ITIL process
• Adherence to good Database Design principles
• Multiple Unix environments, including Linux and IBM AIX platforms
• Oracle Tools: OEM, Grid Control, RAC RMAN, ASM, Data Pump, Oracle partitioning, SQLLoader, HA, transportable tablespace management, Virtual Private Database, SQL tuning Advisor, Explain plans, SQL trace, TKPROOF, materialized views, oracle streams, AWR, ASH, Data-Guard, RMAN active duplications, Flashback, ADDM, Resource Manager, DBCA, DBUA, Dbms Redefinition, SQLNet, ODBC, Packages / Procedures / Functions.

Nice to have Knowledge in :

• Databases: DB2 LUW/ZOS, Postgre SQL, & Mongo DB
• Integration to AIOps tool, Moogsoft
• Azure cloud platform solutions
• CI/CD pipeline.

EXPERIENCE IN:

• Agile and DevOps principles, test-driven development, continuous integration, and other approaches to accelerate the delivery of new features
• Skilled to collaborate and build relationships with Manulife business and risk partners
• Data driven decision making skills
• Having the ability to quickly pivot to newer technologies as required
• Attends advanced training sessions and is certified on multiple domains of expertise
• Good working and background knowledge of area of practice
• Ability to adopt and change with Manulife corporate culture
• Good organizational and problem-solving abilities that enable you to manage through creative abrasion
• Good verbal and written communication; able to effectively articulate technical vision, possibilities, and outcomes
• Able to achieve most tasks using own judgement
• Can lead smaller groups where required
• Good analytical skills, copes with complex situations through deliberate analysis and planning

QUALIFICATIONS

• BSC Information Systems / Computer Science, or equivalent

ROLES & RESPONSIBILITIES:

• Works closely with IT project managers, programmers, architects, developers.
• Development, management, implementation, and maintenance of back-ups & recovery procedures
• Planning, oversight, Development, testing and execution of Disaster recovery processes
• Reviewing and tuning Oracle and technology-specify database coding technologies (PL/SQL, isql, etc.)
• Development, implementation, and management of shell and sql scripts used for process automation and streamlining
• Plan, oversee, Develop, implement, and maintain security, compliance, database hardening and encryption standards, audit and access control frameworks and management of related documentation
• Plan, oversee, Develop, implement, and maintain database setup, installation, configuration, monitoring and maintenance, as well as management of related documentation
• Participate in on-call support rotation including after-hours/weekend duties.
• Liaise with development team in the full development life cycle of database applications
• Lead role in database and server patching and currency initiatives
• Performance tuning and ensure high availability of infrastructure, including operating system and storage subsystem