Senior Database Engineer

Company: American International Group
Location: Charlotte
Posted on: May 20, 2025

Job Description:

At AIG, we are reimagining the way we help customers to manage risk. Join us as a Senior Database Engineer to play your part in that transformation. It's an opportunity to grow your skills and experience as a valued member of the team.Make your mark in Information TechnologyAt AIG, technology is at the heart of everything we do, from underwriting risks to processing claims. The Information Technology team equips our colleagues with the latest tools to complete their work efficiently and with the highest standards of excellence. The team is responsible for shielding the company's systems from security risks, while designing technology strategies that enable AIG's businesses to achieve their goals. AIG's Information Technology functions include enterprise architecture, software and systems engineering, cybersecurity, and technology risk and compliance.How you will create an impact

• Support the X9 to X11 Exadata upgrade from application engineering perspective including capacity planning for platform migrations and generating metrics reports.
• Conduct performance tuning and query optimization across large datasets, supporting Oracle and Snowflake environments for data warehousing, reporting, and advanced analytics.
• Help implement and optimize databases for GenAI models, including support for vectorized search, data pipelines, and AI-ready datasets.
• Lead database modernization effort, including Oracle to PostgreSQL Aurora migrations, working with application owners to plan and refactor schemas, SP logic, and integrations.
• Optimize database systems for performance, scalability, and cost-efficiency across large-scale, multi-terabyte insurance datasets.
• Provide deep expertise in AWS database services, including RDS, Aurora PostgreSQL, and native AWS monitoring and performance tuning tools.
• Evaluate new technologies to guide and support cost cutting related to software and infrastructure initiatives.
• Implement data controls and governance aligned with our industry regulations and internal risk frameworks.
• Partner with infrastructure teams to automate environment provisioning and monitoring using modern tooling such as Splunk.
• Mentor junior engineers and contribute to building a resilient, high-performing database engineering function.What you'll need to succeedMust-Have Skills:
  • 5+ years of experience in enterprise database engineering, preferably within insurance or financial services.
  • Expertise in Oracle databases (11g through 23ai), with deep knowledge of Exadata and ExaCC infrastructure, and experience participating in large-scale Exadata upgrades.
  • Hands-on experience with Snowflake, including administration, security, and compute optimization.
  • Advanced SQL and PL/SQL skills with focus on performance, scalability, and automation.
  • Hands-on experience with AWS database services, including Aurora PostgreSQL, RDS, and migration tooling (e.g., DMS and SCT).
  • Proven success in migrating Oracle databases to PostgreSQL Aurora, including assessment, translation, and performance validation.
  • Knowledge of encryption standards, data privacy, and compliance (e.g., SOX).
  • Strong documentation, communication, and cross-functional collaboration skills.Nice to Have:
    • Familiarity with AWShybrid cloud architectures.
    • Exposure to Python, Terraform, or other automation tools.
    • Background in vector databases or AI-enhanced search systems.
    • High level familiarity of insurance data domains such as policy, claims, risk, underwriting, reinsurance, and regulatory reporting.Ready to prove your potential? We would love to hear from you.For positions based in Jersey City, NJ, the base salary range is $96,000-$129,000 and the position is eligible for a bonus in accordance with the terms of the applicable incentive plan. In addition, we're proud to offer a range of competitive benefits, a summary of which can be viewed here: 2025 Benefits Summary#LI-CN1At AIG, we value in-person collaboration as a vital part of our culture, which is why we ask our team members to be primarily in the office. This approach helps us work together effectively and create a supportive, connected environment for our team and clients alike.Enjoy benefits that take care of what mattersAt AIG, our people are our greatest asset. We know how important it is to protect and invest in what's most important to you. That is why we created our Total Rewards Program, a comprehensive benefits package that extends beyond time spent at work to offer benefits focused on your health, wellbeing and financial security-as well as your professional development-to bring peace of mind to you and your family.Reimagining insurance to make a bigger difference to the worldAmerican International Group, Inc. (AIG) is a global leader in commercial and personal insurance solutions; we are one of the world's most far-reaching property casualty networks. It is an exciting time to join us - across our operations, we are thinking in new and innovative ways to deliver ever-better solutions to our customers. At AIG, you can go further to support individuals, businesses, and communities, helping them to manage risk, respond to times of uncertainty and discover new potential. We invest in our largest asset, our people, through continuous learning and development, in a culture that celebrates everyone for who they are and what they want to become.Welcome to a culture of inclusionWe're committed to creating a culture that truly respects and celebrates each other's talents, backgrounds, cultures, opinions and goals. We foster a culture of inclusion and belonging through learning, cultural awareness activities and Employee Resource Groups (ERGs). With global chapters, ERGs are a cornerstone for our culture of inclusion. The talent of our people is one of AIG's greatest assets, and we are honored that our drive for positive change has been recognized by numerous recent awards and accreditations.AIG provides equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories.AIG is committed to working with and providing reasonable accommodations to job applicants and employees with disabilities. If you believe you need a reasonable accommodation, please send an email to candidatecare@aig.com .Functional Area:At AIG, we are reimagining the way we help customers to manage risk. Join us as a Senior Database Engineer to play your part in that transformation. It's an opportunity to grow your skills and experience as a valued member of the team.Make your mark in Information TechnologyAt AIG, technology is at the heart of everything we do, from underwriting risks to processing claims. The Information Technology team equips our colleagues with the latest tools to complete their work efficiently and with the highest standards of excellence. The team is responsible for shielding the company's systems from security risks, while designing technology strategies that enable AIG's businesses to achieve their goals. AIG's Information Technology functions include enterprise architecture, software and systems engineering, cybersecurity, and technology risk and compliance.How you will create an impact
      • Support the X9 to X11 Exadata upgrade from application engineering perspective including capacity planning for platform migrations and generating metrics reports.
      • Conduct performance tuning and query optimization across large datasets, supporting Oracle and Snowflake environments for data warehousing, reporting, and advanced analytics.
      • Help implement and optimize databases for GenAI models, including support for vectorized search, data pipelines, and AI-ready datasets.
      • Lead database modernization effort, including Oracle to PostgreSQL Aurora migrations, working with application owners to plan and refactor schemas, SP logic, and integrations.
      • Optimize database systems for performance, scalability, and cost-efficiency across large-scale, multi-terabyte insurance datasets.
      • Provide deep expertise in AWS database services, including RDS, Aurora PostgreSQL, and native AWS monitoring and performance tuning tools.
      • Evaluate new technologies to guide and support cost cutting related to software and infrastructure initiatives.
      • Implement data controls and governance aligned with our industry regulations and internal risk frameworks.
      • Partner with infrastructure teams to automate environment provisioning and monitoring using modern tooling such as Splunk.
      • Mentor junior engineers and contribute to building a resilient, high-performing database engineering function.What you'll need to succeedMust-Have Skills:
        • 5+ years of experience in enterprise database engineering, preferably within insurance or financial services.
        • Expertise in Oracle databases (11g through 23ai), with deep knowledge of Exadata and ExaCC infrastructure, and experience participating in large-scale Exadata upgrades.
        • Hands-on experience with Snowflake, including administration, security, and compute optimization.
        • Advanced SQL and PL/SQL skills with focus on performance, scalability, and automation.
        • Hands-on experience with AWS database services, including Aurora PostgreSQL, RDS, and migration tooling (e.g., DMS and SCT).
        • Proven success in migrating Oracle databases to PostgreSQL Aurora, including assessment, translation, and performance validation.
        • Knowledge of encryption standards, data privacy, and compliance (e.g., SOX).
        • Strong documentation, communication, and cross-functional collaboration skills.Nice to Have:
          • Familiarity with AWShybrid cloud architectures.
          • Exposure to Python, Terraform, or other automation tools.
          • Background in vector databases or AI-enhanced search systems.
          • High level familiarity of insurance data domains such as policy, claims, risk, underwriting, reinsurance, and regulatory reporting.Ready to prove your potential? We would love to hear from you.For positions based in Jersey City, NJ, the base salary range is $96,000-$129,000 and the position is eligible for a bonus in accordance with the terms of the applicable incentive plan. In addition, we're proud to offer a range of competitive benefits, a summary of which can be viewed here: 2025 Benefits Summary#LI-CN1#DataEngineeringAt AIG, we value in-person collaboration as a vital part of our culture, which is why we ask our team members to be primarily in the office. This approach helps us work together effectively and create a supportive, connected environment for our team and clients alike.Enjoy benefits that take care of what mattersAt AIG, our people are our greatest asset. We know how important it is to protect and invest in what's most important to you. That is why we created our Total Rewards Program, a comprehensive benefits package that extends beyond time spent at work to offer benefits focused on your health, wellbeing and financial security-as well as your professional development-to bring peace of mind to you and your family.Reimagining insurance to make a bigger difference to the worldAmerican International Group, Inc. (AIG) is a global leader in commercial and personal insurance solutions; we are one of the world's most far-reaching property casualty networks. It is an exciting time to join us - across our operations, we are thinking in new and innovative ways to deliver ever-better solutions to our customers. At AIG, you can go further to support individuals, businesses, and communities, helping them to manage risk, respond to times of uncertainty and discover new potential. We invest in our largest asset, our people, through continuous learning and development, in a culture that celebrates everyone for who they are and what they want to become.Welcome to a culture of inclusionWe're committed to creating a culture that truly respects and celebrates each other's talents, backgrounds, cultures, opinions and goals. We foster a culture of inclusion and belonging through learning, cultural awareness activities and Employee Resource Groups (ERGs). With global chapters, ERGs are a cornerstone for our culture of inclusion. The talent of our people is one of AIG's greatest assets, and we are honored that our drive for positive change has been recognized by numerous recent awards and accreditations.AIG provides equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories.AIG is committed to working with and providing reasonable accommodations to job applicants and employees with disabilities. If you believe you need a reasonable accommodation, please send an email to candidatecare@aig.com .Functional Area:IT - Information TechnologyAIG PC Global Services, Inc.As a global risk leader with deep industry expertise and innovative solutions to smartly manage risk, AIG enables our clients' growth in ways they never thought possible.We also do the same for our colleagues, because we know our people are our greatest strength - the source of every insight, every idea and every innovation. When we're working as one team to do what's right for our colleagues and our communities, we can achieve excellence together. We encourage colleagues to give back to the causes they care most about, supporting these efforts through our Volunteer Time Off and Matching Grants Programs.
            #J-18808-Ljbffr

Keywords: American International Group, Huntersville , Senior Database Engineer, Engineering , Charlotte, North Carolina