Data Engineer II

Key Responsibilities 

• Work closely with Product & Development teams to define, analyse and capture business needs 
• Documents data requirements and maintains data models to ensure seamless integration into existing data architectures
• Manages data assets as per the enterprise standards, guidelines and policies
• Documents processing requirements inclusive of data and transaction volumes, scalability, security and performance requirements
• Creates and maintains detailed information about the data being stored in the database
• Understands the database requirements and translate into physical database design.
• Follows data placement procedures and re-use of existing databases when possible
• Builds and enhances database design and infrastructure required to support the Business portfolio
• Performs database design review and supports database testing
• Provides production environment support for database systems and processes
• Communicates and works collaboratively with business and product teams to support changes and implementation
• Work on assigned database features for ongoing sprints and manage database requirements based on industry trends, new technologies, known defects, and issues
• Partner with delivery architects and engineers to design optional data tier solutions to meet platform objectives and goals
• Function as an active member in an agile team through consistent development practices (tools, components, and documentation)
• Identify opportunities to adopt innovative technologies

Education & Technology core competencies

• Bachelor’s Degree in computer science, computer engineering, or related field required, advanced degree preferred.
• 6+ years of database development experience in a professional environment and/or comparable experience.
• Hands-on experience handling database development activities using NoSQL Databases such as Couchbase, Cassandra, MongoDB databases as well as Relational Databases like PostgreSQL, Oracle, SQLServer covering activities including capacity planning, schema design & implementation, backup and recovery, performance tuning etc
• Monitor the performance and health of the DB servers and troubleshoot DB system failures.
• Good to have experience in Automation using any programming language and/or Ansible for Infrastructure use cases like Upgrade , Patching etc
• Practical experience with Data Architecture to translate business data requirements into data models (Conceptual, logical, physical) and using data modeling tools.
• Extensive experience in Linux based DB performance monitoring by using system tools, security setup, troubleshooting and performance tuning as necessary to ensure optimum performance, patching of Linux based DB servers on regular schedule
• Experience in one of the public cloud platforms like AWS, GCP, and Azure preferred.
• Supporting and maintaining the logging, messaging, automation tools like Splunk, Grafana, Jenkins
• Eager to learn new technologies in short time span.
• Experience in change management, Incident management, RFC, Problem management & RCA

Key Responsibilities 

• Work closely with Product & Development teams to define, analyse and capture business needs 
• Documents data requirements and maintains data models to ensure seamless integration into existing data architectures
• Manages data assets as per the enterprise standards, guidelines and policies
• Documents Data processing requirements inclusive of data and transaction volumes, scalability, security and performance requirements
• Creates and maintains detailed information about the data being stored in the database 
• Understands the database requirements and translate into physical database design.
• Follows data placement procedures to identify best database product for the given requirements and re-use of existing databases when possible
• Builds and enhances database design and infrastructure required to support the Business portfolio
• Performs database design review and supports database testing
• Provides production environment support for database systems and processes
• Communicates and works collaboratively with business and product teams to support DB changes and implementation
• Work on assigned database features for ongoing sprints and manage database requirements based on industry trends, new technologies, known defects, and issues
• Partner with delivery architects and engineers to design optimal data tier solutions to meet platform objectives and goals
• Function as an active member in an agile team through consistent development practices (tools, components, and documentation)
• Identify opportunities to adopt innovative technologies

Education & Technology core competencies

• Bachelor’s Degree in computer science, computer engineering, or related field required, advanced degree preferred.
• 6+ years of database architecture & administration experience in a professional environment and/or comparable experience.
• Hands-on experience handling database administration activities including capacity planning, schema design & implementation, backup and recovery, testing, performance tuning, troubleshooting etc for
• NoSQL Databases such as Couchbase, Cassandra, MongoDB databases
• Relational Databases like PostgreSQL, Oracle, SQLServer
• Monitor the performance and health of the DB servers and troubleshoot DB system failures.
• Good to have experience in Automation using any programming language and/or Ansible for Infrastructure use cases like Upgrade, Patching etc
• Practical experience with Data Architecture to translate business data requirements into data models (Conceptual, Logical, Physical) and using data modeling tools.
• Extensive experience in Linux based DB performance monitoring by using system tools, security setup, troubleshooting and performance tuning as necessary to ensure optimum performance, patching of Linux based DB servers on regular schedule
• Experience in one of the public cloud platforms like AWS, GCP, and Azure preferred.
• Ability to use DB CI/CD to deploy Schema changes, log aggregation tools like Splunk etc for troubleshooting
• Demonstrated experience in learning new Database technologies in a short time span.
• Experience in change management, Incident management, RFC, Problem management & RCA

Compliance Language

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

American Express is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law.  

Offer of employment with American Express is conditioned upon the successful completion of a background verification check, subject to applicable laws and regulations.