Development DBA (RDBMS/Oracle)

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. As part of our diverse tech team, you can architect, code and ship software that makes us an essential part of our customers’ digital lives. Here, you can work alongside talented engineers in an open, supportive, inclusive environment where your voice is valued, and you make your own decisions on what tech to use to solve challenging problems. American Express offers a range of opportunities to work with the latest technologies and encourages you to back the broader engineering community through open source. And because we understand the importance of keeping your skills fresh and relevant, we give you dedicated time to invest in your professional development. Find your place in technology of #TeamAmex. 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 Minimum Qualifications: Education & Experience: Good 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 at hand Tries innovative approaches when problem solving, seeking ideas, or suggestions from others as appropriate Carries out systematic and rational analysis to identify the root cause of problems Recognizes the importance of collaboration to achieve objectives Is clear when explaining ideas and concepts to others, communication is structured and easy to understand Leads multiple tasks optimally – progresses work in parallel Adapts to change quickly and easily Handles problems and acts on own initiative without being prompted Knows when to raise decisions and when to make on-the-spot decisions Knowledge/Skills: Able to understand and use data structures and associated components Basic understanding of Metadata Management and Database Management Able to understand and document business data requirements in complete, accurate, extensible and flexible logical data models using data modeling tools – ErStudio, ErWin Creates basic data models using the relevant tools and frameworks Basic understanding of XML and schema development/reuse, database concepts, database designs, Open Source, big data technology and NoSQL will be an added advantage Application of industry recognized methods, processes and standards Has understanding of the core tools used in the planning, analyzing, designing, building, testing, configuring and maintaining of assigned application(s) Able to participate in assigned team’s software delivery methodology (Agile, Scrum, Agile XP, Test-Driven Development, Waterfall, etc.) in support of data management and database development Familiar with infrastructure technologies and components like servers, jvms, databases, and networking concepts Technology Skills You’ll Use Every Day: Adaptive Communication Agile Practices Industry and Company Knowledge Organizational Change Technical Acuity Technology Industry Trends Game Changers: Adaptability Collaboration & Partnership Continuous Improvement Courage Curiosity Resourcefulness Servant Leadership Tenacity Role/Strengths You’ll Need: Technical Database Design Emerging Technologies Performance and Tuning System/Platform Domain Knowledge Functional Data Analysis Data Management Database Administration Leadership Analytical Thinking Consultancy Decision-Making Business Problem Solving We back our colleagues and their loved ones with benefits and programs that support their holistic well-being. That means we prioritize their physical, financial, and mental health through each stage of life. Benefits include: Competitive base salaries Bonus incentives Support for financial-well-being and retirement Comprehensive medical, dental, vision, life insurance, and disability benefits (depending on location) Flexible working model with hybrid, onsite or virtual arrangements depending on role and business need Generous paid parental leave policies (depending on your location) Free access to global on-site wellness centers staffed with nurses and doctors (depending on location) Free and confidential counseling support through our Healthy Minds program Career development and training opportunities Offer of employment with American Express is conditioned upon the successful completion of a background verification check, subject to applicable laws and regulations.