logo

JobNob

Your Career. Our Passion.

Lead Oracle Database Administrator


Northern Trust


Location

Pimpri | India


Job description

About Northern Trust:

Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world’s most successful individuals, families and institutions by remaining true to our enduring principles of service, expertise and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

The DBA will be responsible for Project DBA tasks. This will include upgrades of Oracle RDBMS versions 11g/12c to the latest Oracle 19c RDBMS release utilizing multi-tenant container/pluggable RDBMs on Oracle Engineered Systems (Exadata).

The Project DBA will work within the TIPMO (Project Management Office) process using Northern Trusts PMLC methodology. In this role, the Oracle DBA will design, build, test, and deploy quality database solutions that are consistent with PMLC project objectives and NTRS technology architecture standards and best practices.

The Oracle DBA, as part of a project team, will execute all database tasks from design phase to deployment phase utilizing their expertise to direct design, make configuration suggestions, and implement database solutions that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability.

The DBA will actively collaborate with the GDP Engineering team to develop standards and guidelines to guide database infrastructure strategy. Responsibilities and Required Skills

Experience with management of Oracle Databases: Experience with Oracle 11g, 12c, 19c, Oracle RAC and Oracle Data Guard Experience with Oracle Multitenant (Containers and Pluggable databases), in addition to it’s features such as Hybrid Columnar Compression Knowledge of Oracle engineered (Exadata) hardware platforms, networking, storage and subsystems. Experience with Oracle Enterprise Manager (OEM) Experience with Installation/Upgrade/Patching of database software and related Exadata tasks. Experience with backup/recovery design, DR implementation, monitoring implementation, performance tuning and optimization. Experience with storage management, provisioning, and optimization. Experience with software and firmware maintenance of all Exadata components, including OS, grid, database, storage cells, and Infiniband. Deep experience with the Linux operating system and shell scripting. Good understanding of fundamental technologies like TCP/IP, FTP, SMTP, DNS, Load balancer, NFS. Perform activities in support of a 24x7 global support model for all environments.

Experience working within a project management processes:

Partner with business, technical, and application partners to discuss the project requirements and to help plan and develop solutions for he Oracle Database architecture. Ability to plan and complete projects based on high-level requirements with minimal or no guidance. Methodical and accurate while delivering tasks, working within project deadlines. Systematic approach to identifying issues and pursuing paths to resolution. Experience installing and building new solutions or improving existing applications. Ability to foresee relevant issues and assist in proposing possible solutions, Performance and Tuning expertise a must, root cause analysis in a Firecall situation. Lead upgrades and migration of Oracle legacy software versions (Lifecycle). Participate in the design, configuration and implementation of secure and scalable enterprise Oracle 19c RDBMs. Management of multiple schemas/databases through system development, User Acceptance testing and production environment. Plan, coordinate and implement security measures (Encryption) to safeguard information against accidental or unauthorized damage, modification or disclosure. Develop and execute data migration strategies for VLDB, review and improve lifecycle upgrade processes, contribute to project best practices for Engineered Systems (Exadata). Communicate and educate Application teams regarding Oracle RAC, the Exadata platform and the process of rolling maintenance plans for engineered systems. Troubleshoot and resolve issues affecting Oracle 19c projects which may impact go-live dates.

COMPETENCIES

Ability to cope in a technically complex and fast-changing environment, and to respond calmly and rationally to changing priorities in a deadline-driven situation. Strong planning and organizing skills including the ability to manage several work streams simultaneously. Ability to think strategically and evaluate options in the short, medium and long term. Good communication skills with a capacity to present, discuss and explain issues coherently and logically both in writing and verbally. Clear decision-making ability with the facility to judge complex situations and assess when to escalate issues. Ability to balance conflicting and changing demands through prioritization and a pragmatic approach. Good team player, self-motivated and able to work on own initiative. Additional Skills a Plus Experience with Golden Gate and the migration of very large databases Experience with Delphix Knowledge of Oracle In Memory database Encryption technologies and experience a plus Understanding and execution of the IT processes of Incident Management (Service Now), Problem Management, Change Management, and Configuration Management. Qualifications Minimum of 10 years of experience in administrating medium to large databases in complex enterprise environments BS in Computer Science or equivalent experience Database experience from either working in a support organization or project team. Deep experience in working on large database clusters

Working with Us:

As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.

We’d love to learn more about how your interests and experience could be a fit with one of the world’s most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater

Reasonable accommodation

Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at [email protected].

We hope you’re excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people. Apply today and talk to us about your flexible working requirements and together we can achieve greater.


Job tags



Salary

All rights reserved