Associate, Database Management

Jpmorgan Chase & Co. | Plano

Date listed

1 month ago

Employment Type

Full time

DESCRIPTION:

Duties: Responsible for building, monitoring, and maintaining Oracle engineered Exadata database machine and the databases hosted on servers. Review various performance related reports (exachk, awr, and addm) and provide best practices and performance improvement solutions. Troubleshoot both database and Exadata machine specific configuration/OS level production issues. Responsible for creating, patching, upgrading, and migrating databases. Gather hardware, system, and operating system requirements from Application Development (AD) teams for database deployments. Responsible for backup, restore and recover databases based on the requirements. Perform Exadata Image upgrades and patching twice a year in compliance with firm security policies. Coordinate with Oracle and replace faulty hardware devices and new Exadata machine initial configurations. Create and troubleshoot DR/standby database issues. Coordinate with AD teams to gather system requirements to create, migrate, and upgrade databases. Implement replication using technologies, such as Goldengate, between databases in uni-directional or bi-directional replication solutions. Troublehshoot Exadata database peformance tuning related, such as smart scan, storage index, and bloom filtering. Design large scale databases and help AD teams to tune SQL queries to utilize Exadata specific features, such as smartscan, storage indexes, and smart cache, to cacahe frequently accesed objects. Automate Exadata database related tasks, such as patching, upgrading, and capacity planning using Bash, Python and Perl scripting.

QUALIFICATIONS:

Minimum education required: Master's degree or equivalent in Computer Science, or related field.

Minimum experience required: 2 years of experience in Exadata database machine and Oracle database administration, or related experience.

Skills Required: Must have experience designing and creating new databases as per various Application Development (AD) team requirements. Must have experience creating, upgrading, cloning, applying patches and migration of databases. Must have experience with backup, restore and recover databases and troubleshooting. Must have experience documenting technical specific and project related activities. Must have experience generating and creating various performance and configuration related reports, including exachk, AWR, and ADDM reports, and providing solutions to improve performance of the database systems. Must have experience implementing and troubleshooting replication between databases using Goldengate solution. Must have experience building and troubleshooting DR solutions using Oracle standby databases/Goldengate replication solution. Must have experience troubleshooting and maintaining Exadata tasks related to cell node, DB node and IB switches. Must have experience with database logical modeling and physical modeling for OLAP (Online Analytical Processing) and OLTP (Online Transactional Processing) systems. Must have experience automating database system related tasks, including patching, installations and upgrades using Bash, Python, and Perl scripting. Must have experience creating, implementing, and monitoring using OEM and scripting using Bash, Python and Perl. Employer will accept any amount of professional experience with the required skills.JPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.

Equal Opportunity Employer/Disability/Veterans



Findwork Copyright © 2020

Newsletter


Let's simplify your job search. Receive your tailored set of opportunities today.

Subscribe to our Jobs