Postgresql

P1
C3 STS Experience 4+ years of hands-on database development and migration experience 2+ years of experience with PostgreSQL database systems 2+ years of experience with AWS cloud services Experience with database performance tuning and optimization Skills Strong SQL skills in both SQL Server and PostgreSQL Hands-on experience with AWS DMS and database migration tools Proficiency in database performance tuning and optimization Knowledge of Aurora PostgreSQL features and capabilities Scripting skills (Python, PowerShell, Shell scripting) Experience with database monitoring tools (pgAdmin, CloudWatch) Design comprehensive database migration strategy and roadmap from MSSQL to Aurora PostgreSQL Execute AWS SCT for automated conversion of database objects Perform manual conversion of complex stored procedures, functions, and packages Migrate tables, indexes, constraints, and other database objects Optimize converted objects for Aurora PostgreSQL performance Document conversion challenges and resolutions Configure and execute AWS DMS for data migration activities Monitor data replication and synchronization processes Perform data validation and integrity checks Handle incremental data loads and change data capture Troubleshoot migration issues and performance bottlenecks Tune PostgreSQL queries and stored procedures for optimal performance Implement Aurora-specific optimizations and features Configure connection pooling and resource management Optimize database parameters and configurations Create and maintain database monitoring and alerting Good To Have Skills Experience with containerization and Kubernetes migration strategies Knowledge of disaster recovery and backup migration strategies Familiarity with hybrid cloud architectures and connectivity solutions Experience with automated testing and validation frameworks VMware or Hyper-V certifications (Preferred) AWS Certified Migration Specialty (Preferred)