Principal Infrastructure Operations Analyst (Oracle Exadata Dba)

The Bank Of New York Mellon Pittsburgh , PA 15201

Posted 2 months ago

As a global investments company, BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments, and safeguards nearly one-fifth of the world's financial assets. Every day, our Technology employees make this happen while also seeking out new ways to do it more efficiently and effectively.

As part of BNY Mellon's global Technology organization, you'll have the opportunity to engage with some of the best and brightest, technology, business, and financial minds to find new and better ways to exceed our clients' expectations and build the future of financial services. With more than 230 years of industry leading experience under our belts, you might even say that we are the original fintech.

Our Team

Operations and Shared Technology (OST) encompasses all Custody, Shared Service, and Operational Technologies, Sub Accounting, and alternative investment services division at the bank. As Part of the OST Infrastructure support team you will support all aspects of Database infrastructure. You will be required to tune and measure performance on an ongoing basis for over 300 applications.

In OST Production Services we are dedicated to ensuring that our technology environments are best in class. Our Production Services team runs the systems that keep BNY Mellon running. Their mission is to deliver a full IT service management lifecycle across all OST applications and infrastructure support with the purpose of providing a controlled, secure, and predictable production environment.

Our team members use their technical skills and business knowledge to bring forth solutions that will take our company into the future. If you are a collaborative continual learner with a global mindset and a desire to contribute to our company's top priorities, this is the place for you.

The Role

The Senior Oracle (Exadata) DBA primary responsibility is to ensure availability, stability, scalability and performance of database servers that supports BNY Mellon's Digital Platform and Applications.

Key Responsibilities:

  • Works with firm-wide engineering and architecture, and business/AD architects to drive solution standardization and reuse for Data Management Infrastructure Operations.

  • Provide secure, highly available, scalable database services that improve overall resiliency, functionality, and enable operational management optimization.

  • Troubleshoot new software systems at the cutting edge of distributed database technology, and deliver large scale systems that will have an impact on revenue growth on our business and competitive position.

  • Provide Oracle Exadata database administration handling database provisioning, patching, upgrade of all associated Exadata components including Clusterware, Storage cells, Infiniband switches and database instances

  • Strong experience with patching of Exadata components in rolling and non-rolling methods

  • Monitoring of Exadata appliance and Oracle database instances with Oracle Enterprise Manager

  • Configuration, failover and failback using Oracle Data guard for business continuity and Disaster Recovery requirements

  • Key Management for Oracle DB encryption, understanding and experience using Oracle TDE for encryption at rest providing data protection

  • Strong experience with migrating database servers from standalone instances to Oracle multi-tenancy in Oracle 12c and beyond

  • Implemented automation of operational tasks using Shell scripts/Perl/Python

  • Provide incident management, deployment management and business continuity requirements of database servers

  • Knowledge on ZDLRA and well versed with performing backups on ZDLRA

  • Should have strong knowledge of Database backup & Recovery practices adheres to organizational security standards.

  • Implementation of adequate levels of auditing& reviewing database audit logs

  • Well versed with installation and management of layered products on Oracle engineered systems

  • Proven track record for vulnerability remediation

  • Knowledge on products like Gaurdium, Qualys& Orion, Golden Gate

Principal Infrastructure Operations Analyst->> Designs, implements, integrates, and provides full support for complex software in a multi-tiered, multi-platform environment. Advises specialists on areas to focus installation and support efforts. Works with the Senior Principal to ensure operations are consistent with LOB and organization wide goals. Identifies and solves highly complex and critical systems related issues to meet the objectives for the corporation. Participates in software strategic planning and consulting on platform selection, version implementation, software product recommendation, and usage of enhanced functionality. Tracks installations, modifications, and support efforts to ensure goals are being met. Implements, integrates and provides support for middleware software in a multi-tiered, multi-platform environment, dealing with development projects that have a broad impact across the organization. Provides consulting expertise in identifying and solving highly-critical middleware issues and serves as a resource on middleware issues related to policies and standards that impact middleware specialist and application support staffs across the corporation. Communicates with internal and external system users to address concerns and make sure that technical issues are dealt with appropriately. Manages ticket queues and handles highly complex escalated issues. Analyzes repeat incident patterns to identify opportunities for cost reduction and productivity enhancements. Manages relationships with vendors and works with them to ensure efficient incident resolution. Contributes to the achievement of area objectives. Responsible for budget activity. Bachelor's degree in computer science or a related discipline, or equivalent work experience required, advanced degree preferred 10 - 12 years of related infrastructure experience required, experience in the securities or financial services industry is a plus.

Qualifications

Bachelor's degree in computer science or a related discipline, or equivalent work experience required, advanced degree preferred 10 - 12 years of related infrastructure experience required, experience in the securities or financial services industry is a plus.

  • Minimum of three (3) years of Exadata machine administration and associated database administration experience.

  • Experience with Exadata X6, X7, X8 and ZDLRA appliances is preferable.

  • Minimum of two (2) years of strong experience with Oracle Data Guard ensuring continued availability of standby database environment. Knowledge of Oracle MAA.

  • Advanced knowledge of IT infrastructure, with an understanding of UNIX/LINUX Operating systems, Storage and network administration.

  • Experience supporting and implementing advanced, strategic database management systems.

  • Demonstrated ability to drive Agile development and implement automated process to improve database system reliability.

  • Proven ability to provide high availability, operations supportability and scalability to a high volume, rapidly growing world class eCommerce business.

  • Direct experience in working within the database administration teams for large-scale enterprise that are highly scalable and reliable.

  • Technical acumen in implementation and support of the core database services that are highly reliable, flexible, scalable and cost effective.

  • Strong critical thinking, problem solving and communication skills.

  • Knowledge of other Database Technology, such as SQL Server, is preferred.

BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer.

Minorities/Females/Individuals With Disabilities/Protected Veterans.

Primary Location: United States-Pennsylvania-Pittsburgh

Internal Jobcode: 45196

Job: Information Technology

Organization: Operations & Shared Technology-HR13644

Requisition Number: 1917576


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Specialist Infrastructure Operations Analyst Support Analyst

The Bank Of New York Mellon

Posted 1 week ago

VIEW JOBS 1/14/2020 12:00:00 AM 2020-04-13T00:00 As a global investments company, BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments, and safeguards nearly one-fifth of the world's financial assets. Every day, our Technology employees make this happen while also seeking out new ways to do it more efficiently and effectively. As part of BNY Mellon's global Technology organization, you'll have the opportunity to engage with some of the best and brightest technology, business, and financial minds to find new and better ways to exceed our clients' expectations and build the future of financial services. With more than 230 years of industry leading experience under our belts, you might even say that we are the original fintech. Our Team Operations and Shared Tech (OST) owns the ecosystem through which BNY Mellon's products and services are delivered to our clients and our internal business operations teams. We provide Custody/Cash/Settlement services, run BNYM's digital platform (NEXEN) along with associated shared services, oversee the technology portfolio for Alternative Investments and Sub-Accounting products, and drive operational transformation through technology to make our clients and us more efficient. OST's world-class engineers build solutions with an 'empathy first' principle. We believe that our products and services are superior when we know our clients, users, and partners – and that the more embedded we are with them and the more we interact with them, the more empathy we exercise. The OST Production Services Team is dedicated to ensuring that our technology environments are best in class. Our Production Services team runs the systems that keep BNY Mellon running. Our mission is to deliver a full IT service management lifecycle across all run-the-bank applications and infrastructure support with the purpose of providing a controlled, secure, and predictable production environment. Our team members use their technical skills and business knowledge to bring forth solutions that will take our company into the future. If you are a collaborative continual learner with a global mindset and a desire to contribute to our company's top priorities, this is the place for you. The Role As a Support Analyst within our Client Lifecycle Management (CLM) Production Services team, you will be responsible for the maintenance, support, and operations of core software applications. This includes ensuring functionality of applications are aligned with the organization's priorities and enabling team is responsible for application support, incident, problem, change, and SCM. Our team will work closely with the application development organization on the implementation of changes to production and will be responsible for ongoing operations of the production applications. Key Responsibilities: * Individual is responsible for the Production Support, Deployment & Migration, and Maintenance for BNYM applications are aligned with the organizations. * Good Knowledge on UNIX / Linux / Windows/ Mainframe platforms, which includes verifying the availability infrastructure functionality. * Ability to analyze applications & databases hosted on the servers * Responsible for all Wellness Checks, and if any issues, serve as a primary driver to resolution. * Priority assessment, incident Investigation & diagnosis, execute Knowledge Base triage steps in standard operating procedure (SOP). * Ability to troubleshoot issues delving into root cause efforts and ability to handle disparate types of client inquiries. * Communication skills backed up with strong technical knowledge. * Self-motivated ability to do multi-tasking, where the individual has to handle multiple application requests from various sources. * Tooling experience with MoogSoft, CloudProber, AppDynamics, GIT, Jenkins, ServiceNow. * Ability to maintain service uptime and MTTM / MTTR targets as service level agreements. * Provide technical support for the applications, understanding their data flow and end user interfaces. Ability to perform deep dives into issues and have an ability to diagnose and resolve application and/or escalate to ensure optimal performance. Specialist Infrastructure Operations Analyst->> Designs, implements, integrates, and provides full support for software in a multi-tiered, multi-platform environment. Researches the appropriate system software to meet corporate standards and objectives for system performance. May allocate/coordinate work within a team/project. Formulates plans to meet system objectives for the corporation, works in all phases of system analysis, implementation measurement, and reporting. Oversees software installations and upgrades to operating systems and layered software packages. Analyzes user hardware and software needs and recommends upgrades or new purchases. Installs, configures, and develops middleware utility programs and related distributed system software on multiple mainframe/distributed hardware/software environments. Leads the middleware team in providing more complex on-site and on-call support through analysis and research. Collaborates and consults with application development teams to determine platform selection, efficient transaction design, and use. Communicates both formally and informally with customers and end users. Reviews new/modified file transmission requests submitted by all internal business partners at BNY Mellon. Contributes to the achievement of related teams' objectives. Bachelor's degree in computer science or a related discipline, or equivalent work experience required, advanced degree preferred, 6 - 8 years of related infrastructure experience required, experience in the securities or financial services industry is a plus. Qualifications Bachelor's degree in computer science or a related discipline, or equivalent work experience required, advanced degree preferred, 6 - 8 years of related infrastructure experience required, experience in the securities or financial services industry is a plus. * 5+ years of experience in IT Support, Incident, Problem, and Change Management * Broad technology experience including UNIX, Windows, and mainframe application development or support. * Experience in Information Technology Infrastructure Library (ITIL) Service Management foundations. * Experience supporting mission critical platforms, operation and applications. * Excellent communication skills BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer. Minorities/Females/Individuals With Disabilities/Protected Veterans. Primary Location: United States-Pennsylvania-Pittsburgh Internal Jobcode: 45142 Job: Information Technology Organization: Operations & Shared Technology-HR13644 Requisition Number: 2000211 The Bank Of New York Mellon Pittsburgh PA

Principal Infrastructure Operations Analyst (Oracle Exadata Dba)

The Bank Of New York Mellon