Description
Amazon Leo is seeking an experienced Senior Database Engineer to lead the design, implementation, administration, and optimization of our Microsoft SQL Server and PostgreSQL database environments supporting Siemens Teamcenter PLM and related platform services.
As a Senior Database Engineer, you will collaborate across PLM Application, Infrastructure, and Integration teams to improve database performance, reliability, and scalability. You will ensure the database architecture is performant, highly available, and observable as the platform scales.
Key responsibilities include:
Supporting MS SQL Server and PostgreSQL database solutions for Teamcenter PLM and adjacent platform services across development, test, and production environments; Performing day-to-day DBA responsibilities including database provisioning, user and role management, access control, capacity planning, patching, and health monitoring across both MS SQL Server and PostgreSQL environments; Developing and implementing database migration strategies for Teamcenter upgrades, PostgreSQL adoption initiatives, and performance optimization as the platform scales to support additional product lines and integrations; Designing and optimizing database schemas, stored procedures, functions, and queries across MS SQL Server and PostgreSQL, ensuring consistency and performance across both platforms; Establishing best practices for MS SQL Server and PostgreSQL administration, backup/recovery, replication, and high availability in the context of Teamcenter's data model and enterprise integrations.
A day in the life includes analyzing query performance metrics, designing schema improvements to enhance system reliability, or working with application teams to troubleshoot database connectivity issues. You'll participate in infrastructure planning sessions, mentor colleagues on database best practices, and contribute to documentation that helps the broader organization understand our database strategy.