Senior Database Developer
New
Poland (Remote)Full-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Languages
- En B2
- Required Skills
- PostgreSQLPythonMicrosoft SQL ServerGenerative AI
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
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
View Full Description & ApplyYou'll be redirected to the employer's site
