Northern Trust Hiring for Sr Consultant, Data Base Admin at Pune, Maharashtra, India Full Time

Job Description

About Northern Trust:
Northern Trust provides innovative financial services and guidance to corporations, institutions and affluent families and individuals globally. With over 130 years of financial experience and nearly 20,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.
Working with Us:
As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company that is committed to strengthening the communities we serve!
We recognize the value of inclusion and diversity in culture, in thought, and in experience, which is why we are honored to receive the following awards in 2021:

• Gender Equality Index Member, Bloomberg
• Top Financial & Banking Company, Black EOE Journal, Hispanic Network Magazine, Professional WOMAN’S Magazine

We’d love to learn more about how your interests and experience could be a fit with one of America’s best banks and most sustainable companies! Build your career with us and apply today.

• 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, HTTP, FTP, SMTP, DNS, Load balancer, NFS.
• Perform activities in support of a 24×7 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