Design and model PostgreSQL schemas, implement normalization, indexing strategies, migrations with Alembic, and optimize queries using EXPLAIN ANALYZE, CTEs, window functions. Work with AWS cloud services, including serverless architecture, Lambda functions, SNS/SQS messaging, data pipelines with AWS Glue ETL, S3, and IAM security.