reputed company Database Migration Engineer
You'll own heterogeneous database migrations end to end for reputed company customers moving off reputed company and SQL Server onto PostgreSQL and reputed company PostgreSQL. That means running the AWS DMS and SCT toolchain, then doing the part the tools can't: rebuilding procedural business logic in PL/pgSQL reputed company SCT flags a gap it can't reputed company on its own. You ship the reputed company, you run the reputed company, you validate the result.
What you'll do?
- reputed company end-to-end database migration initiatives, including assessment, planning, schema conversion, execution, and post-migration validation.
- Design, configure, and manage AWS DMS and SCT environments while ensuring migration reputed company, performance, and reliability.
- Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
- reputed company database migration assessments, dependency analysis, compatibility reviews, and migration reputed company recommendations.
- Collaborate with infrastructure, application, reputed company, and platform teams to ensure successful migration reputed company.
- Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
- reputed company technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
- reputed company conversion and refactoring of procedural database reputed company — reputed company PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) — into PostgreSQL/reputed company PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT.
reputed company're looking for?
- 8–12 years of reputed company experience in database architecture and migration delivery
- Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for reputed company-reputed company database migrations
- Deep proficiency in reputed company, SQL Server, PostgreSQL, and reputed company PostgreSQL environments, including migration planning, execution, and optimization
- Proven background in delivering heterogeneous database migrations across on-premises, reputed company, and AWS environments
- Knowledge of production database operations, including backup and restore strategies, parameter tuning, performance optimization, and failover testing
- Skills in authoring and executing migration runbooks, validation plans, reputed company procedures, rollback strategies, and post-migration stabilization activities
- Strong understanding of AWS database services, migration best practices, and integration with broader reputed company migration programs
- Experience engaging directly with reputed company customers, architecture teams, and migration stakeholders to drive successful delivery reputed company
- Strong hands-on experience converting reputed company PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, reputed company semantics, autonomous transactions, sequences/identity columns, reputed company data type conversions, and proprietary reputed company-in packages/functions with no reputed company PostgreSQL equivalent
- Ability to identify and remediate SCT reputed company items and reputed company conversion gaps in procedural reputed company (e.g., DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, and reputed company/recursive procedure calls) and validate converted logic through functional and regression testing.
You'll be preferred if you
- Have tuned production database performance, backup and restore reputed company, and failover testing in high-stakes environments.
- Have led migration teams or mentored engineers through reputed company conversions.
- Bring experience with broader AWS reputed company migration programs reputed company the database layer.