Senior Database Developer
We are looking for a Senior Database Developer to join a large-scale modernization initiative focused on SQL Server to Aurora PostgreSQL migration in a cloud-native environment.
You will work on transforming and optimizing complex enterprise database solutions using AI-driven modernization approaches and automation tools.
Our client is a globally recognized technology leader known for building innovative cloud and digital solutions at scale.
Responsibilities
- Migrate SQL Server database schemas to Amazon Aurora PostgreSQL, ensuring structural consistency, accurate data type mapping and proper handling of dependencies
- Convert stored procedures, functions, triggers and views from T-SQL to PL/pgSQL, addressing syntax and behavioral differences between the two systems
- Update application database interactions by adapting queries and the data access layer for seamless integration with Amazon Aurora PostgreSQL
- Use automation and AI-driven tools to accelerate migration, review generated results and refine outputs to ensure high quality
- Apply AWS migration and modernization solutions to support schema conversion, data migration and code updates
- Deploy migrated schemas, application code and data to non-production environments, with settings, security and connectivity configured according to best practices
- Validate migrated database objects and application integration by testing functionality, data integrity, performance and stability
Requirements
- Strong experience with Microsoft SQL Server (T-SQL), including stored procedures, functions, triggers, views and complex queries
- Advanced to expert knowledge of PostgreSQL
- Strong hands-on experience with Amazon Aurora PostgreSQL
- Proficiency with AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)
- Solid background in cross-platform database schema migration, especially from SQL Server to PostgreSQL
- Experience in database modernization testing, including compile validation, functional testing and performance benchmarking
Nice to have
- Experience with AWS Transform for .NET / SQL Server, including AI-driven migration workflows, validation and output refinement
- Familiarity with GenAI-assisted migration tools
- Experience with AWS Aurora configuration (parameter groups, replication, high availability, Performance Insights)
- Experience with Amazon CloudWatch for database monitoring and alerting
- Intermediate proficiency in Python for scripts and automation of migration tasks
- Experience with CI/CD processes for database deployments
- Familiarity with Kiro for AI-assisted code refinement workflows
