JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of > $2 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.
Global Technology Infrastructure (GTI) is the technology infrastructure organization for the firm, delivering a wide range of products and services, and partnering with all lines of business to provide high quality service delivery, exceptional project execution and financially disciplined approaches and processes in the most cost effective manner. The objective of GTI is to balance both business alignment and the centralized delivery of core products and services. GTI is designed to address the unique infrastructure needs of specific lines of business and the demand to leverage economies of scale across the firm.
GTI-Infrastructure Development (GID) is focused on developing and delivering services that integrate software solutions with infrastructure in innovative, cost effective and efficient ways. The GID team provides services for use by business-aligned application delivery organizations, across all layers of the software stack, which may include application interface services, productivity and collaboration tools, and data integration solutions.
In the role of ORACLE Database Management Analyst , you will be responsible for providing Application DBA support. You will participate in database design meetings and project meetings. You will be responsible for documenting new and existing database applications, creating entity relationship diagrams and data dictionaries. You will be responsible for optimizing query performance and index utilization. In this position, you will listen to, understand and articulate the business value and impact of advanced technical and non-technical concepts in both written and oral formats to customers, peers and/or management in a one-on-one or team context. You will be need to seek management assistance when required to make decisions or communicate across organizational boundaries, and need to understand when to escalate issues. In this role, you will be involved in anticipating problem troubleshooting scenarios and will analyze ways in which to avoid the problem completely or greatly mitigate its risk.
The ideal candidate will be capable of documenting small-to medium scale projects with minimal supervision, and may be involved in developing and delivering presentations. Capable of routinely making effective and timely decisions in alignment with departmental direction based on sound business knowledge and the ability to solicit input from internal and external sources, including the ability to investigate and weigh best practices from other corporations, analyze input and use sound judgment. Capable of doing whatever it takes to support the tactical and strategic goals of the team and larger organization. Is recognized as a positive and motivational force on the team and negotiates skillfully in difficult situations with both internal and external groups.
Key Responsibilities shall include but not be limited to:
* Partner with AD team on all database activity
* Implement and maintain the database design
* Create database objects (tables, indexes etc)
* Assist developers with database activities
* Monitor application jobs
* Document Database
* Use tool to reverse engineer existing databases
* Database Performance tuning.
* Documenting processes and procedures as assigned by management
* Enforcing Oracle Services and server configuration standard
* Ensuring all managed servers meet or exceed JPMCCSIRT standards (ESM & WESC). Responsible for server Oracle application upgrades.
Requirements
· 10 years of hands-on Oracle implementation, upgrade & support and database administration experience on
· 5 years Oracle RAC experience Oracle 10g, Oracle 11g R2
· 5 years Oracle Enterprise Manager
· 5 Active DataGuard
· Administration experience with OLTP databases in excess of 200gb
Scripting experience shell, Perl
· Database & Data Modeling design; ETL - Database Warehouse Architecture and Design
· Working knowledge of EMC SAN Frame Replication(SRDF) or Other External Data Replication Toolsets
· Team player, able to negotiate skillfully in difficult situations with both internal and external groups
· Capable of dissecting complex situations and refocusing on the most critical technology tasks
· Capable of developing small intra-team program and leading small to medium projects
· Ability to understand and articulate the business value and impact of advanced technical and non-technical concepts
Exposure to graph database ie "Neo 4J" would be added advantage
Qualifications
The ideal candidate will be capable of documenting small-to medium scale projects with minimal supervision, and may be involved in developing and delivering presentations. Capable of routinely making effective and timely decisions in alignment with departmental direction based on sound business knowledge and the ability to solicit input from internal and external sources, including the ability to investigate and weigh best practices from other corporations, analyze input and use sound judgment. Capable of doing whatever it takes to support the tactical and strategic goals of the team and larger organization. Is recognized as a positive and motivational force on the team and negotiates skillfully in difficult situations with both internal and external groups.
**Job:** **Applications Development*
**Organization:** **CORPORATE SECTOR*
**Title:** *Agile Oracle DB Developer*
**Location:** *IN-KA-Bangalore East-Prestige Technology Park / 86855*
**Requisition ID:** *160045629*