Data Engineer Ii - Oracle Data Services

You Lead the Way. We’ve Got Your Back.

With the right backing, people and businesses have the power to progress in incredible ways. When you join Team Amex, you become part of a global and diverse community of colleagues with an unwavering commitment to back our customers, communities and each other. Here, you’ll learn and grow as we help you create a career journey that’s unique and meaningful to you with benefits, programs, and flexibility that support you personally and professionally.

At American Express, you’ll be recognized for your contributions, leadership, and impact—every colleague has the opportunity to share in the company’s success. Together, we’ll win as a team, striving to uphold our company values and powerful backing promise to provide the world’s best customer experience every day. And we’ll do it with the utmost integrity, and in an environment where everyone is seen, heard and feels like they belong.

Join Team Amex and let's lead the way together.

How will you make an impact in this role?

Focus:

Contributes to crafting, developing, trouble shooting, debugging, evaluating, modifying, deploying and documenting all data components (data architecture, logical and physical data models, database objects and database administration) that meet the needs of customer-facing applications, business applications, and/or internal end user applications. 

Organizational Context:

Entry-level position.  Member of a data management and database development team reporting to a Senior Data Engineer, Engineering Director or Director of Technical Delivery.

How will you make an impact in this role?

• Reviews data requirements / data stories and corresponding data sources and data architecture 
• Documents data requirements / data stories and maintains data models to ensure flawless integration into existing data architectures 
• Supports management of data assets as per the enterprise standards, guidelines and policies 
• Reviews and understands the processing requirements inclusive of data and transaction volumes, scalability, security and performance requirements 
• Assists in building and improving the database design and infrastructure required to support the Business portfolio 
• Assists in performing database design review and supports database testing 
• Provides production environment support for database systems and processes 
• Communicates and works closely with business and product teams to support changes and implementation 
• Function as an active member if an agile team through consistent development practices (tools, components, and documentation) 
• Finds opportunities to adopt innovative technologies 
• Takes part in reviews of own work or with colleagues 
• Work on prioritized/assigned features for ongoing sprints 

Range of Impact/Influence:

• Accountable for team completing work you’re leading and work you are doing as agreed upon
• Accountable to team for delivery of quality work

Do you see data or a better way to improve business and lives?   Today, there’s a business advantage hiding in plain sight, and you’ll find it in data. Our Data Engineers know how to use the latest technology to design, evaluate, debug and manage the data that leads to better decisions, a stronger company, and higher customer satisfaction. So if you’re not intimidated by the data explosion, engineer your career here.   More than the data on what you’ll be doing.   There’s no end to the data that’s created every day and the opportunities you find here. But these are just some of your responsibilities: - Document data requirements/data stories and maintain data models - Support the management of data assets according to enterprise standards, guidelines and policies - Help build and enhance the database design that supports our business portfolio - Work collaboratively with business and product teams - Identify opportunities to adopt innovative technologies

Qualifications

Education & Experience:

Up to 5 years of software development experience in a professional environment and/or comparable experience such as: 

• Understanding of Agile or other rapid application development methods 
• Exposure to design and development on Oracle or more database management systems (e.g. PostgreSQL, Cassandra) as appropriate 
• Exposure Oracle data model design for high critical OLTP applications
• Performance tuning & monitoring using OEM & custom shell scripts
• Understanding to newer app frameworks and their interactions with Databases
• Expert on Oracle RAC configuration and tuning
• Understanding and experience on Application continuity.
• Expert on Oracle Capacity planning & resource management.
• Understanding on Exadata appliance.
• Expert on Goldengate configuration and support
• Dataguard setup and tuning
• Knowledge on RMAN
• Connection pool manager knowledge ( Hikari & UCP)
• Good understanding and Technical knowledge of DBMS products and ecosystem – e.g. storage formats, access algorithms, data management processes, administration, data maintenance, replication, high availability, encryption, etc.” 
• General knowledge of distributed (multi-tiered) systems, algorithms, and relational & non-relational databases 
• Bachelor’s Degree in computer science, computer science engineering, or related field required; advanced degree preferred

High Performance Behaviors:

• Recognizes opportunities to adopt innovative technologies to enable business capabilities
• Able to challenge the status quo and drive innovation by generating creative ideas and solutions
• Keeps up-to-date on current research and technology in the industry
• Understands technical aspects of the job and uses appropriate technology for the situation a